Subversion Repositories eFlore/Applications.del

Rev

Rev 1744 | Rev 1751 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1744 Rev 1746
Line 89... Line 89...
89 
					"	FROM del_commentaire AS dc, del_observation AS dob".
 89 
					"	FROM del_commentaire AS dc, del_observation AS dob".
90 
					"	WHERE dc.nom_sel = dob.nom_sel ".
 90 
					"	WHERE dc.nom_sel = dob.nom_sel ".
91 
					"		AND dc.ce_utilisateur = dob.ce_utilisateur ".
 91 
					"		AND dc.ce_utilisateur = dob.ce_utilisateur ".
92 
					"		AND dc.ce_observation = dob.id_observation ".
 92 
					"		AND dc.ce_observation = dob.id_observation ".
93 
					") ".
 93 
					") ".
94 
					"AND TO_DAYS($date) - TO_DAYS(dc.date) <= 1 ".
 94 
					"AND TO_DAYS($date) - TO_DAYS(dc.date) IN (0, 1) ".
95 
				") ".
 95 
				") ".
96 
				"AND do.ce_utilisateur NOT IN ".
 96 
				"AND do.ce_utilisateur NOT IN ".
97 
					"( ".
 97 
					"( ".
98 
					"	SELECT id_utilisateur ".
 98 
					"	SELECT id_utilisateur ".
99 
					"	FROM del_utilisateur_infos ".
 99 
					"	FROM del_utilisateur_infos ".