Subversion Repositories eFlore/Applications.del

Rev

Rev 1924 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1924 Rev 2156
Line 145... Line 145...
145 
		$requete = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS '.
 145 
		$requete = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS '.
146 
			'di.id_image, di.mots_cles_texte AS mots_cles_texte_image, '.
 146 
			'di.id_image, di.mots_cles_texte AS mots_cles_texte_image, '.
147 
			'do.id_observation, nom_referentiel, nom_ret, '.
 147 
			'do.id_observation, nom_referentiel, nom_ret, '.
148 
			'nom_ret_nn, nt, famille, ce_zone_geo, zone_geo, date_observation, '.
 148 
			'nom_ret_nn, nt, famille, ce_zone_geo, zone_geo, date_observation, '.
149 
			'do.ce_utilisateur, do.nom_utilisateur, do.prenom_utilisateur, '.
 149 
			'do.ce_utilisateur, do.nom_utilisateur, do.prenom_utilisateur, '.
150 
			'du.prenom, du.nom '.
 150 
			'di.prenom_utilisateur as prenom, di.nom_utilisateur as nom '. // retrocompatibilité redondance cheloute
151 
			'FROM del_image AS di '.
 151 
			'FROM del_image AS di '.
152 
			'	INNER JOIN del_observation AS do ON (di.ce_observation = do.id_observation) '.
 152 
			'	INNER JOIN del_observation AS do ON (di.ce_observation = do.id_observation) '.
153 
			'	LEFT JOIN del_utilisateur AS du ON (di.ce_utilisateur = du.id_utilisateur) '.
 - 
 
154 
			'	LEFT JOIN del_image_stat AS ds ON (di.id_image = ds.ce_image) '.
 153 
			'	LEFT JOIN del_image_stat AS ds ON (di.id_image = ds.ce_image) '.
155 
			"WHERE di.id_image IN ($idImgsConcat) ".
 154 
			"WHERE di.id_image IN ($idImgsConcat) ".
156 
			'ORDER BY moyenne DESC, id_image DESC '.
 155 
			'ORDER BY moyenne DESC, id_image DESC '.
157 
			' -- '.__FILE__.' : '.__LINE__;
 156 
			' -- '.__FILE__.' : '.__LINE__;
158 
		//Debug::printr($requete);
 157 
		//Debug::printr($requete);