Subversion Repositories eFlore/Applications.del

Rev

Rev 1307 | Rev 1318 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1307 Rev 1309
Line 236... Line 236...
236 
			'FROM del_commentaire AS dc '.
 236 
			'FROM del_commentaire AS dc '.
237 
			'	INNER JOIN del_observation AS dob '.
 237 
			'	INNER JOIN del_observation AS dob '.
238 
			'		ON dob.id_observation = dc.ce_observation '.
 238 
			'		ON dob.id_observation = dc.ce_observation '.
239 
			'	LEFT JOIN del_utilisateur AS duo '.
 239 
			'	LEFT JOIN del_utilisateur AS duo '.
240 
			'		ON dob.ce_utilisateur = duo.id_utilisateur '.
 240 
			'		ON dob.ce_utilisateur = duo.id_utilisateur '.
241 
			'WHERE ((dob.ce_utilisateur = dc.ce_utilisateur AND dob.nom_sel != dc.nom_sel) '.
 241 
			'WHERE proposition_initiale != 1 '.
242 
			'	OR (dob.ce_utilisateur != dc.ce_utilisateur)) '.// Evite d'afficher les proposition initiale
 - 
 
243 
			$this->chargerClauseWhere().' '.
 242 
			$this->chargerClauseWhere().' '.
244 
			'ORDER BY dc.date DESC '.
 243 
			'ORDER BY dc.date DESC '.
245 
			'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' ';
 244 
			'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' ';
Line 246... Line 245...
246 
 
 245