Live codes

SELECT COUNT(members.id) as importance, categories.* FROM yacs_members AS members, yacs_categories AS categories WHERE (members.anchor LIKE 'category:%') 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-19 06:07:43')) AND (categories.nick_name NOT LIKE 'week%') AND (categories.nick_name NOT LIKE 'hebdomadaire') AND (categories.nick_name NOT LIKE 'month%') AND (categories.nick_name NOT LIKE 'mensuel')) AND (categories.id = SUBSTRING(members.anchor, 10)) GROUP BY members.anchor ORDER BY importance DESC, title, edit_date DESC LIMIT 0,20
29: File './challengeddf/yacs_categories.MYD' not found (Errcode: 2)

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-19 06:07:43') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-19 06:07:43')) ORDER BY articles.publish_date DESC, articles.title LIMIT 0,7
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-19 06:07:43') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-19 06:07:43')) ORDER BY articles.publish_date DESC, articles.title LIMIT 0,20
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-19 06:07:43') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-19 06:07:43')) ORDER BY articles.hits DESC, articles.title LIMIT 0,7
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-19 06:07:43') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-19 06:07:43')) ORDER BY articles.edit_date DESC, articles.title LIMIT 0,7
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-19 06:07:43') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-19 06:07:43')) ORDER BY articles.edit_date DESC, articles.title LIMIT 0,12
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-19 06:07:43') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-05-19 06:07:43')) ORDER BY rating_sum DESC, articles.publish_date DESC, articles.title LIMIT 0,7
1146: Table 'challengeddf.yacs_articles' doesn't exist

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

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-19 06:07:43')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2025-05-19 06:07:43')) ORDER BY sections.rank, sections.title, sections.edit_date DESC LIMIT 0,12
1146: Table 'challengeddf.yacs_sections' doesn't exist

SELECT categories.* FROM yacs_categories AS categories WHERE (categories.anchor='' OR categories.anchor is NULL) 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-19 06:07:43'))) ORDER BY categories.rank, categories.title, categories.edit_date DESC LIMIT 0,12
29: File './challengeddf/yacs_categories.MYD' not found (Errcode: 2)

SELECT dates.date_stamp as date_stamp, articles.* FROM yacs_dates as dates, yacs_articles AS articles WHERE ((dates.anchor_type LIKE 'article') AND (dates.anchor_id = articles.id)) AND (dates.date_stamp LIKE '2025-05-%') AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2025-05-19 06:07:43') ORDER BY dates.date_stamp LIMIT 1000
1146: Table 'challengeddf.yacs_articles' doesn't exist

Use the configuration panel for web services to enter your Google API key.

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-19 06:07:43')))) 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-19 06:07:43')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2025-05-19 06:07:43')) ORDER BY sections.rank, sections.title, sections.edit_date DESC LIMIT 0,15
1146: Table 'challengeddf.yacs_sections' doesn't exist