Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1922 Rev 2157
Line 178... Line 178...
178 
					'FROM del_image_tag AS dit '.
 178 
					'FROM del_image_tag AS dit '.
179 
					'	INNER JOIN del_image AS di '.
 179 
					'	INNER JOIN del_image AS di '.
180 
					'		ON ce_image = id_image '.
 180 
					'		ON ce_image = id_image '.
181 
					'	INNER JOIN del_observation AS do '.
 181 
					'	INNER JOIN del_observation AS do '.
182 
					'			ON di.ce_observation = do.id_observation '.
 182 
					'			ON di.ce_observation = do.id_observation '.
183 
					'	LEFT JOIN del_utilisateur AS duo '.
 183 
					'	LEFT JOIN del_utilisateur_infos AS duo '.
184 
					'		ON do.ce_utilisateur = duo.id_utilisateur '.
 184 
					'		ON do.ce_utilisateur = duo.id_utilisateur '.
185 
					'	LEFT JOIN del_utilisateur AS du '.
 185 
					'	LEFT JOIN del_utilisateur_infos AS du '.
186 
					'		ON if((CHAR_LENGTH(dit.ce_utilisateur) <> 32),CAST(dit.ce_utilisateur AS unsigned),0) '.
 186 
					'		ON if((CHAR_LENGTH(dit.ce_utilisateur) <> 32),CAST(dit.ce_utilisateur AS unsigned),0) '.
187 
					'			= du.id_utilisateur '.
 187 
					'			= du.id_utilisateur '.
188 
					'WHERE actif = 1 '.
 188 
					'WHERE actif = 1 '.
189 
					"	AND id_tag IN ($idsTagsConcat) ".
 189 
					"	AND id_tag IN ($idsTagsConcat) ".
190 
					'ORDER BY date DESC '.
 190 
					'ORDER BY date DESC '.