Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1232 Rev 1233
Line 105... Line 105...
105 
	/**
 105 
	/**
106 
	 * Retrouver les derniers votes image
 106 
	 * Retrouver les derniers votes image
107 
	 * */
 107 
	 * */
108 
	private function getDerniersVotesImage() {
 108 
	private function getDerniersVotesImage() {
Line 109... Line 109...
109
109
110 
		$requete =  'SELECT id_tag, tag, date, nom, prenom, nom_sel, id_image '.
 110 
		$requete =  'SELECT DISTINCT id_tag, tag, date, nom, prenom, nom_sel, id_image '.
111 
					'FROM del_image_tag '.
 111 
					'FROM del_image_tag '.
112 
					'LEFT JOIN del_utilisateur ON ce_utilisateur = id_utilisateur '.
 112 
					'LEFT JOIN del_utilisateur ON ce_utilisateur = id_utilisateur '.
113 
					'INNER JOIN del_obs_image doi ON ce_image = id_image '.
 113 
					'INNER JOIN del_obs_image doi ON ce_image = id_image '.
114 
					'INNER JOIN del_observation do ON doi.id_observation = do.id_observation '.
 114 
					'INNER JOIN del_observation do ON doi.id_observation = do.id_observation '.