Files

SELECT COUNT(*) as count, MIN(files.edit_date) as oldest_date, MAX(files.edit_date) as newest_date, SUM(file_size) as total_size FROM yacs_files AS files WHERE (files.active='Y' OR files.active='X')
1146: Table 'challengeddf.yacs_files' doesn't exist

SELECT files.* FROM yacs_articles AS articles LEFT JOIN yacs_files AS files ON ((files.anchor_type LIKE 'article') AND (files.anchor_id = articles.id)) WHERE NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-12 09:37:00')) AND (files.active='Y' OR files.active='X') ORDER BY files.edit_date DESC, files.title LIMIT 0,50
1146: Table 'challengeddf.yacs_articles' doesn't exist

SELECT * FROM yacs_files AS files LEFT JOIN yacs_articles AS articles ON ((files.anchor_type LIKE 'article') AND (files.anchor_id = articles.id)) WHERE NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-12 09:37:00')) AND (files.active='Y' OR files.active='X') ORDER BY files.hits DESC, files.title LIMIT 0,7
1146: Table 'challengeddf.yacs_files' doesn't exist

SELECT * FROM yacs_categories AS categories WHERE ((categories.display LIKE 'file:index') AND ((categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2025-05-12 09:37:00')))) ORDER BY categories.rank, categories.edit_date DESC, categories.title LIMIT 0,7
29: File './challengeddf/yacs_categories.MYD' not found (Errcode: 2)

SELECT * FROM yacs_articles WHERE (nick_name LIKE 'menu') OR (handle LIKE 'menu') ORDER BY publish_date DESC LIMIT 1
1146: Table 'challengeddf.yacs_articles' doesn't exist

SELECT * FROM yacs_sections AS sections WHERE (sections.nick_name LIKE 'navigation_boxes') ORDER BY edit_date DESC LIMIT 1
1146: Table 'challengeddf.yacs_sections' doesn't exist

SELECT * FROM yacs_categories AS categories WHERE ((categories.display LIKE 'site:all') AND ((categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2025-05-12 09:37:00')))) ORDER BY categories.rank, categories.edit_date DESC, categories.title LIMIT 0,15
29: File './challengeddf/yacs_categories.MYD' not found (Errcode: 2)

SELECT sections.* FROM yacs_sections AS sections WHERE (sections.anchor='' OR sections.anchor IS NULL) AND (sections.active='Y') AND (sections.index_panel LIKE 'main') AND ((sections.index_map IS NULL) OR (sections.index_map != 'N')) AND ((sections.activation_date is NULL) OR (sections.activation_date <= '2025-05-12 09:37:00')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2025-05-12 09:37:00')) ORDER BY sections.rank, sections.title, sections.edit_date DESC LIMIT 0,15
1146: Table 'challengeddf.yacs_sections' doesn't exist