| 269,8 → 269,8 |
|---|
| ce_zone_geo, zone_geo, lieudit, station, milieu, nom_referentiel, |
| date_observation, o.mots_cles_texte, o.commentaire, |
| o.date_creation, o.date_modification, o.date_transmission, certitude |
| FROM tb_cel.cel_obs AS o INNER JOIN tb_cel.cel_images AS i ON (o.id_observation = i.ce_observation) |
| WHERE o.transmission = '1' ; |
| FROM tb_cel.cel_obs AS o WHERE o.id_observation IN (SELECT i.ce_observation FROM tb_cel.cel_images i) |
| AND o.transmission = '1'; |
| |
| -- ----------------------------------------------------- |
| -- View `del_images` |