Répartition des médecins omnipraticiens
SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'article:1013') 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-19 05:38:52')) 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
selon la région administrative et selon le sexe (au 31 décembre 2007)
RÉGION ADMINISTRATIVE OMNIPRATICIENS |
01 Bas-Saint-Laurent
|
130
|
149
|
279
|
2,9
|
02 Saguenay—Lac-Saint-Jean
|
134
|
185
|
319
|
3,3
|
03 Québec
|
502
|
606
|
1 108
|
11,6
|
04 Mauricie—Bois-Francs
|
110
|
188
|
298
|
3,1
|
05 Estrie
|
203
|
245
|
448
|
4,7
|
06 Montréal
|
1 087
|
1 444
|
2 531
|
26,5
|
07 Outaouais
|
150
|
204
|
354
|
3,7
|
08 Abitibi—Témiscamingue
|
103
|
97
|
200
|
2,1
|
09 Côte-Nord
|
61
|
74
|
135
|
1,4
|
10 Nord du Québec
|
38
|
34
|
72
|
0,8
|
11 Gaspésie—Îles-de-la-Madeleine
|
68
|
103
|
171
|
1,8
|
12 Chaudière—Appalaches
|
173
|
251
|
424
|
4,4
|
13 Laval
|
157
|
196
|
353
|
3,7
|
14 Lanaudière
|
185
|
206
|
391
|
4,1
|
15 Laurentides
|
215
|
295
|
510
|
5,3
|
16 Montérégie
|
664
|
711
|
1 375
|
14,4
|
17 Centre-du-Québec
|
82
|
112
|
194
|
2,0
|
Total Québec |
4 062 |
5 100 |
9 162 |
95,9 |
Hors du Québec |
134 |
253 |
387 |
4,1 |
Total général |
4 196
|
5 353
|
9 549
|
100,0
|