2954 |
mathias |
1 |
[
|
|
|
2 |
{
|
|
|
3 |
"titre": "observations dont la date d'observation est postérieure à la date de transmission",
|
|
|
4 |
"sql": "SELECT count(*) as nombre, CONCAT(YEAR(GREATEST(date_transmission, date_observation)), '-', LPAD(MONTH(GREATEST(date_transmission, date_observation)), 2, 0)) periode FROM cel_obs WHERE date_transmission < date_observation GROUP BY periode ORDER BY periode asc"
|
|
|
5 |
},
|
|
|
6 |
{
|
|
|
7 |
"titre": "observations dont la clef étrangère de l'utilisateur est nulle ou vide",
|
|
|
8 |
"sql": "SELECT count(*) as nombre, CONCAT(YEAR(GREATEST(date_transmission, date_observation)), '-', LPAD(MONTH(GREATEST(date_transmission, date_observation)), 2, 0)) periode FROM cel_obs WHERE ce_utilisateur IS NULL OR ce_utilisateur = '' GROUP BY periode ORDER BY periode asc"
|
|
|
9 |
},
|
|
|
10 |
{
|
|
|
11 |
"titre": "observations non localisées",
|
|
|
12 |
"sql": "SELECT count(*) as nombre, CONCAT(YEAR(GREATEST(date_transmission, date_observation)), '-', LPAD(MONTH(GREATEST(date_transmission, date_observation)), 2, 0)) periode FROM cel_obs WHERE (ce_zone_geo IS NULL OR ce_zone_geo = '') AND (zone_geo = '' OR zone_geo IS NULL) AND (latitude = '' OR latitude IS NULL) AND (longitude = '' OR longitude IS NULL) GROUP BY periode ORDER BY periode asc"
|
|
|
13 |
}
|
|
|
14 |
]
|