select distinct d.*, a.*, 0 as DATA_RANG,to_char(d.DATA_DATEPDEB, 'DD/MM/YYYY') as DATA_DATE_PDEB,to_char(d.DATA_DATEPFIN, 'DD/MM/YYYY') as DATA_DATE_PFIN,to_char(d.DATA_DATEDEB, 'DD/MM/YYYY') as DATA_DATE_DEB,to_char(d.DATA_DATEFIN, 'DD/MM/YYYY') as DATA_DATE_FIN,to_char(d.DATA_DATEDEB, 'HH24:MI') as DATA_HEURE_DEB,to_char(d.DATA_DATEFIN, 'HH24:MI') as DATA_HEURE_FIN,to_char(d.DATA_DATEMAJ, 'DD/MM/YYYY') as DATA_DATE_MAJ,to_char(d.DATA_DATECREA, 'DD/MM/YYYY') as DATA_DATE_CREA,to_char(d.DATA_DATEPARUTION, 'DD/MM/YYYY') as DATA_DATE_PARUTION,'1.0' as VERSION_NUMERO from V_GEDIT_ACTU_DATA d   inner join SIT_APPLI a on d.APPLI_ID=a.APPLI_ID where d.APPLI_ID=11   and d.USER_ID=2 and d.RIGHT_ID>0  and d.DATA_VALIDEPUB=1 and (d.DATA_DATEPDEB <= (now() - interval '-1 hour' + interval '-1 hour') or d.DATA_DATEPDEB is null) and (d.DATA_DATEPFIN >= (now() - interval '-1 hour' + interval '-1 hour') or d.DATA_DATEPFIN is null) and d.DATA_NEW=1 and (d.DATA_DATEPDEB <= (now() - interval '-1 hour' + interval '-1 hour') or d.DATA_DATEPDEB is null) and (d.DATA_DATEPFIN >= (now() - interval '-1 hour' + interval '-1 hour') or d.DATA_DATEPFIN is null) order by d.DATA_RANG, DATA_DATEPDEB desc, DATA_DATEPFIN desc, DATA_TITRE_FR
La Loire, de la Maine à la mer
Observations et suivis environnementaux

Débit de la Loire à Montjean s/L

100

Coefficient de marée

Webcam : l'estuaire en direct

select distinct d.*, a.*, 0 as DATA_RANG,to_char(d.DATA_DATEPDEB, 'DD/MM/YYYY') as DATA_DATE_PDEB,to_char(d.DATA_DATEPFIN, 'DD/MM/YYYY') as DATA_DATE_PFIN,to_char(d.DATA_DATEDEB, 'DD/MM/YYYY') as DATA_DATE_DEB,to_char(d.DATA_DATEFIN, 'DD/MM/YYYY') as DATA_DATE_FIN,to_char(d.DATA_DATEDEB, 'HH24:MI') as DATA_HEURE_DEB,to_char(d.DATA_DATEFIN, 'HH24:MI') as DATA_HEURE_FIN,to_char(d.DATA_DATEMAJ, 'DD/MM/YYYY') as DATA_DATE_MAJ,to_char(d.DATA_DATECREA, 'DD/MM/YYYY') as DATA_DATE_CREA,to_char(d.DATA_DATEPARUTION, 'DD/MM/YYYY') as DATA_DATE_PARUTION,'1.0' as VERSION_NUMERO from V_GEDIT_ACTU_DATA d   inner join SIT_APPLI a on d.APPLI_ID=a.APPLI_ID where d.APPLI_ID=27   and d.USER_ID=2 and d.RIGHT_ID>0  and d.DATA_VALIDEPUB=1 order by d.DATA_RANG, DATA_DATEPDEB desc, DATA_DATEPFIN desc, DATA_TITRE_FR