Jurisprudences
SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'section:17') 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-27 12:21:29')) 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:17') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND (articles.publish_date < '2024-11-27 12:21:29') AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2024-11-27 12:21:29'))) ORDER BY rank, 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 ', title LIMIT 0,50' at line 1
SELECT sections.* FROM yacs_sections AS sections WHERE (sections.anchor LIKE 'section:17') AND (sections.active='Y') AND (sections.index_map = 'Y') AND ((sections.activation_date is NULL) OR (sections.activation_date <= '2024-11-27 12:21:29')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2024-11-27 12:21:29')) 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
2019 la saaq et les citoyens....
2017: au niveau du Canada:
Assurance-emploi: le système d’appel annule plus de décisions qu’avant Guillaume Bourgault-Côté En s’appuyant sur des données qui indiquent que près de la moitié des utilisateurs obtiennent gain de cause après une contestation, le Comité chômage...
Liste de jurisprudences contre la SAAQ
résumé (non exhaustif car mon interprétation) de décisions du tribunal administratif du Québec, de la cour supérieure ou la cour d'appel
source pour les jurisprudence gratuite: http://www.jugements.qc.ca ou http://www.canlii.org/recherche.html certaines jurisprudences venant de ces deux sites sont disponible en téléchargement ici... il y a aussi : http://legisquebec.gouv.qc.ca/fr/content/decision