Agnès Rambaud - agnès

(SELECT articles.id FROM yacs_articles AS articles WHERE articles.owner_id = 1 AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2020-07-16 04:48:55') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2020-07-16 04:48:55'))) UNION (SELECT articles.id FROM yacs_articles AS articles WHERE articles.id IN (99, 98, 97, 96, 95, 93, 92, 91, 89, 87, 84, 83, 82, 81, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70, 69, 67, 66, 65, 64, 63, 61, 60, 59, 58, 55, 54, 53, 50, 49, 45, 27, 26, 25, 24, 23, 22, 21, 20, 19, 18, 8, 7, 6, 5, 4, 3, 2, 9, 10, 11, 12, 13, 14, 15, 16, 17, 1) AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2020-07-16 04:48:55') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2020-07-16 04:48:55'))) UNION (SELECT articles.id FROM ((SELECT CONCAT('section:', sections.id) AS target FROM (yacs_members AS members, yacs_sections AS sections) WHERE (members.member = 'user:1') AND (members.anchor LIKE 'section:%') AND (sections.id = SUBSTRING(members.anchor, 9)) ORDER BY sections.edit_date DESC, sections.title LIMIT 0, 1000) UNION (SELECT CONCAT('section:', sections.id) AS target FROM (SELECT CONCAT('section:', sections.id) AS target FROM (yacs_members AS members, yacs_sections AS sections) WHERE (members.member = 'user:1') AND (members.anchor LIKE 'section:%') AND (sections.id = SUBSTRING(members.anchor, 9)) ORDER BY sections.edit_date DESC, sections.title LIMIT 0, 1000) AS anchors, yacs_sections AS sections WHERE (sections.anchor = anchors.target) AND (sections.options LIKE '%forward_notifications%') ORDER BY sections.edit_date DESC, sections.title LIMIT 0, 1000)) AS anchors, yacs_articles AS articles WHERE (articles.anchor = anchors.target) AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2020-07-16 04:48:55') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2020-07-16 04:48:55'))) UNION (SELECT articles.id FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 9) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'user:1') AND (members.anchor LIKE 'article:%')) AS ids, yacs_articles AS articles WHERE (articles.id = ids.target) AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2020-07-16 04:48:55') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2020-07-16 04:48:55')))
1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

(SELECT articles.* FROM yacs_articles AS articles WHERE articles.owner_id = 1 AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2020-07-16 04:48:55') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2020-07-16 04:48:55'))) UNION (SELECT articles.* FROM yacs_articles AS articles WHERE articles.id IN (99, 98, 97, 96, 95, 93, 92, 91, 89, 87, 84, 83, 82, 81, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70, 69, 67, 66, 65, 64, 63, 61, 60, 59, 58, 55, 54, 53, 50, 49, 45, 27, 26, 25, 24, 23, 22, 21, 20, 19, 18, 8, 7, 6, 5, 4, 3, 2, 9, 10, 11, 12, 13, 14, 15, 16, 17, 1) AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2020-07-16 04:48:55') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2020-07-16 04:48:55'))) UNION (SELECT articles.* FROM ((SELECT CONCAT('section:', sections.id) AS target FROM (yacs_members AS members, yacs_sections AS sections) WHERE (members.member = 'user:1') AND (members.anchor LIKE 'section:%') AND (sections.id = SUBSTRING(members.anchor, 9)) ORDER BY sections.edit_date DESC, sections.title LIMIT 0, 1000) UNION (SELECT CONCAT('section:', sections.id) AS target FROM (SELECT CONCAT('section:', sections.id) AS target FROM (yacs_members AS members, yacs_sections AS sections) WHERE (members.member = 'user:1') AND (members.anchor LIKE 'section:%') AND (sections.id = SUBSTRING(members.anchor, 9)) ORDER BY sections.edit_date DESC, sections.title LIMIT 0, 1000) AS anchors, yacs_sections AS sections WHERE (sections.anchor = anchors.target) AND (sections.options LIKE '%forward_notifications%') ORDER BY sections.edit_date DESC, sections.title LIMIT 0, 1000)) AS anchors, yacs_articles AS articles WHERE (articles.anchor = anchors.target) AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2020-07-16 04:48:55') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2020-07-16 04:48:55'))) UNION (SELECT articles.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 9) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'user:1') AND (members.anchor LIKE 'article:%')) AS ids, yacs_articles AS articles WHERE (articles.id = ids.target) AND (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2020-07-16 04:48:55') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2020-07-16 04:48:55'))) ORDER BY edit_date DESC, title LIMIT 0,20
1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='