| Line 78... |
Line 78... |
| 78 |
' date_observation, nom_ret, nom_sel, '.
|
78 |
' date_observation, nom_ret, nom_sel, '.
|
| 79 |
' ce_zone_geo, zone_geo, lieudit, station '.
|
79 |
' ce_zone_geo, zone_geo, lieudit, station '.
|
| 80 |
'FROM del_observation AS do '.
|
80 |
'FROM del_observation AS do '.
|
| 81 |
'WHERE do.ce_utilisateur != 0 '.
|
81 |
'WHERE do.ce_utilisateur != 0 '.
|
| 82 |
' AND do.ce_utilisateur IS NOT NULL '.
|
82 |
' AND do.ce_utilisateur IS NOT NULL '.
|
| 83 |
' AND (do.mots_cles_texte LIKE "%aDeterminer%" '.
|
83 |
" AND (do.mots_cles_texte LIKE '%aDeterminer%' ".
|
| - |
|
84 |
" OR (do.certitude = 'aDeterminer' OR do.certitude = 'A déterminer' OR do.certitude = 'douteux') ".
|
| 84 |
' OR nom_sel IS NULL OR nom_sel = "" '.
|
85 |
" OR nom_sel IS NULL OR nom_sel = '' ".
|
| 85 |
' OR nom_ret IS NULL OR nom_ret = "") '.
|
86 |
" OR nom_ret IS NULL OR nom_ret = '') ".
|
| 86 |
' AND ('.
|
87 |
' AND ('.
|
| 87 |
" TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ".
|
88 |
" TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ".
|
| 88 |
" OR TO_DAYS($date) - TO_DAYS(do.date_creation) IN (0, 1) ".
|
89 |
" OR TO_DAYS($date) - TO_DAYS(do.date_creation) IN (0, 1) ".
|
| 89 |
" OR TO_DAYS($date) - TO_DAYS(do.date_modification) IN (0, 1) ".
|
90 |
" OR TO_DAYS($date) - TO_DAYS(do.date_modification) IN (0, 1) ".
|
| 90 |
' ) '.
|
91 |
' ) '.
|