test agenda

SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM jar_members AS members WHERE (members.member LIKE 'section:91') AND (members.anchor LIKE 'category:%')) AS ids, jar_categories AS categories WHERE (categories.id = ids.target) AND (categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2024-04-24 17:22:28')) ORDER BY rank, title, edit_date DESC LIMIT 0,40
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', title, edit_date DESC LIMIT 0,40' at line 1

SELECT dates.date_stamp as date_stamp, articles.* FROM jar_dates as dates, jar_articles AS articles WHERE ((dates.anchor_type LIKE 'article') AND (dates.anchor_id = articles.id)) AND (dates.date_stamp < '%2024-%04-%24') AND (articles.anchor LIKE 'section:91') AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2024-04-24 17:22:28') ORDER BY dates.date_stamp DESC LIMIT 0,50
1525: Incorrect DATETIME value: '%2024-%04-%24'

SELECT dates.date_stamp as date_stamp, articles.id as id, articles.title as title, articles.nick_name as nick_name, articles.active, articles.edit_date, articles.publish_date, articles.introduction, articles.thumbnail_url, articles.anchor FROM jar_dates as dates, jar_articles AS articles WHERE ((dates.anchor_type LIKE 'article') AND (dates.anchor_id = articles.id)) AND (dates.date_stamp >= '%2024-%04-01') AND (articles.anchor LIKE 'section:91') AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2024-04-24 17:22:28') ORDER BY dates.date_stamp LIMIT 0,500
1525: Incorrect DATETIME value: '%2024-%04-01'

SELECT sections.* FROM jar_sections AS sections WHERE (sections.anchor LIKE 'section:91') AND (sections.active='Y') AND (sections.index_map = 'Y') AND ((sections.activation_date is NULL) OR (sections.activation_date <= '2024-04-24 17:22:28')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2024-04-24 17:22:28')) ORDER BY rank, title, edit_date DESC LIMIT 0,50
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', title, edit_date DESC LIMIT 0,50' at line 1