Lyne Mandeville - lili
SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'user:702') AND (members.anchor LIKE 'category:%')) AS ids, yacs_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-11-23 19:04:06')) ORDER BY rank, title, edit_date DESC LIMIT 0,7
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,7' at line 1
Opinion sur TAQ
Initié par Carmen Fréchette le 29 mai 2019 à 19:20 GMT, modifié par Carmen Fréchette le 1er juin 2019 à 09:40 GMT, avec Isabelle Ledger, Jean Desy, Charles Nadeau, Lyne Mandeville
- Opinion guy de procedures TAQ.jpg - Par Carmen Fréchette le 29 mai 2019 à 20:17 GMT
- Opinion guy de procedures TAQ 0001.jpg - Par Carmen Fréchette le 29 mai 2019 à 19:23 GMT
- Opinion guy de procedures TAQ 0002.jpg - Par Carmen Fréchette le 29 mai 2019 à 19:23 GMT
Lyne Mandeville