JUSTICE: un sens unique?
SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'section:42') 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-21 18:13:00')) 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 articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:42') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2024-11-21 18:13:00') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2024-11-21 18:13:00'))) ORDER BY rank, edit_date DESC, title 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 ', edit_date DESC, title LIMIT 0,50' at line 1
SELECT sections.* FROM yacs_sections AS sections WHERE (sections.anchor LIKE 'section:42') AND (sections.active='Y') AND (sections.index_map = 'Y') AND ((sections.activation_date is NULL) OR (sections.activation_date <= '2024-11-21 18:13:00')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2024-11-21 18:13:00')) 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
N'y a t'il que les riches, les puissants, le gouvernement quoi, qui ait des droits?
"Pour passer du capitalisme au communisme, ce n'est pas difficile, il suffit de nationaliser et de mettre les patrons en prison. Tandis qu'en sens inverse, passer du communisme au capitalisme, c'est plus compliqué. C'est comme la soupe de poisson, on peut obtenir de la soupe à partir des poissons, mais après, impossible d'obtenir des poissons à partir de la soupe."
Lech Walesa
http://www.electrospirit.net/forum/viewtopic.php?pid=1369