All pages

SELECT COUNT(*) as count, MIN(articles.edit_date) as oldest_date, MAX(articles.edit_date) as newest_date FROM yacs_articles AS articles, yacs_sections AS sections WHERE ((articles.anchor_type LIKE 'section') AND (articles.anchor_id = sections.id)) AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-05-12 09:35:22') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-12 09:35:22')) AND ((sections.home_panel = "main") OR (sections.home_panel = "none")) AND (sections.index_map = "Y") AND (articles.home_panel = "main")
1146: Table 'challengeddf.yacs_articles' doesn't exist

SELECT articles.* FROM yacs_articles AS articles WHERE ((articles.active='Y')) AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-05-12 09:35:22') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-12 09:35:22')) ORDER BY articles.publish_date DESC, articles.title LIMIT 0,50
1146: Table 'challengeddf.yacs_articles' doesn't exist

SELECT * FROM yacs_categories AS categories WHERE ((categories.display LIKE 'article: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:35:22')))) 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:35:22')))) 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:35:22')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2025-05-12 09:35:22')) ORDER BY sections.rank, sections.title, sections.edit_date DESC LIMIT 0,15
1146: Table 'challengeddf.yacs_sections' doesn't exist