80,9 → 80,10 |
'FROM del_observation AS do '. |
'WHERE do.ce_utilisateur != 0 '. |
' AND do.ce_utilisateur IS NOT NULL '. |
' AND (do.mots_cles_texte LIKE "%aDeterminer%" '. |
' OR nom_sel IS NULL OR nom_sel = "" '. |
' OR nom_ret IS NULL OR nom_ret = "") '. |
" AND (do.mots_cles_texte LIKE '%aDeterminer%' ". |
" OR (do.certitude = 'aDeterminer' OR do.certitude = 'A déterminer' OR do.certitude = 'douteux') ". |
" OR nom_sel IS NULL OR nom_sel = '' ". |
" OR nom_ret IS NULL OR nom_ret = '') ". |
' AND ('. |
" TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ". |
" OR TO_DAYS($date) - TO_DAYS(do.date_creation) IN (0, 1) ". |