People

SELECT COUNT(*) as count, MIN(users.edit_date) as oldest_date, MAX(users.edit_date) as newest_date FROM yacs_users AS users WHERE users.active='Y'
1146: Table 'challengeddf.yacs_users' doesn't exist

SELECT * FROM yacs_users AS users WHERE (users.active='Y') ORDER BY users.posts DESC, users.edit_date DESC LIMIT 0,20
1146: Table 'challengeddf.yacs_users' doesn't exist

SELECT * FROM yacs_users AS users WHERE (users.active='Y') AND (click_date > '2025-05-12 13:01:12') ORDER BY users.click_date DESC, users.nick_name LIMIT 0,7
1146: Table 'challengeddf.yacs_users' doesn't exist

SELECT * FROM yacs_users AS users WHERE users.active='Y' ORDER BY users.create_date DESC, users.nick_name LIMIT 0,7
1146: Table 'challengeddf.yacs_users' doesn't exist

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