Links

SELECT COUNT(links.link_url) as count, MIN(links.edit_date) as oldest_date, MAX(links.edit_date) as newest_date FROM yacs_links AS links , yacs_articles AS articles WHERE ((links.anchor_type LIKE 'article') AND (links.anchor_id = articles.id)) AND (articles.active='Y') AND 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-07-05 08:09:50')) AND (links.edit_id > 0)
29: File './challengeddf/yacs_links.MYD' not found (Errcode: 2)

SELECT links.* FROM yacs_links AS links , yacs_articles AS articles WHERE ((links.anchor_type LIKE 'article') AND (links.anchor_id = articles.id)) AND (articles.active='Y') AND 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-07-05 08:09:50')) AND (links.edit_id > 0) ORDER BY links.edit_date DESC, links.title LIMIT 0,50
29: File './challengeddf/yacs_links.MYD' not found (Errcode: 2)

SELECT * FROM yacs_links AS links GROUP BY links.link_url ORDER BY links.hits DESC, links.title LIMIT 0,7
29: File './challengeddf/yacs_links.MYD' not found (Errcode: 2)

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