| New file |
|---|
| 0,0 → 1,14 |
|---|
| [ |
| { |
| "titre": "observations dont la date d'observation est postérieure à la date de transmission", |
| "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" |
| }, |
| { |
| "titre": "observations dont la clef étrangère de l'utilisateur est nulle ou vide", |
| "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" |
| }, |
| { |
| "titre": "observations non localisées", |
| "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" |
| } |
| ] |