Réalités ABUSEURS le protecteur du citoyen dénonce Les années 1980-1989 Année 1982-1983 régie de l'assurance automobile du Québec
2.4.1.1.2. Le Bureau médical
SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'section:859') 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-20 03:45:53')) 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:859') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2024-11-20 03:45:53'))) ORDER BY rank, publish_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 ', publish_date DESC, title LIMIT 0,50' at line 1
SELECT sections.* FROM yacs_sections AS sections WHERE (sections.anchor LIKE 'section:859') AND (sections.active='Y') AND (sections.index_map = 'Y') AND ((sections.activation_date is NULL) OR (sections.activation_date <= '2024-11-20 03:45:53')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2024-11-20 03:45:53')) 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
On constate ici encore de nombreux délais qu'une plus grande diligence parviendrait à réduire. Certes, les dossiers sont nombreux qui aboutissent au Bureau médical: leur nombre varie de 1800 à 2000 par mois. Le service vise à réduire ce nombre à 1500 et ainsi ramener à une semaine le séjour moyen d'un dossier au Bureau médical. Il est actuellement de deux semai-nes, ce qui n'est pas si mal, mais il ne s'agit hélas que d'une moyenne. Certains dossiers restent en sus-pens beaucoup plus longtemps. En voici quelques exemples.