Line 167... |
Line 167... |
167 |
* Retrouver les derniers votes image
|
167 |
* Retrouver les derniers votes image
|
168 |
* */
|
168 |
* */
|
169 |
private function getDerniersVotesImage() {
|
169 |
private function getDerniersVotesImage() {
|
170 |
$idsTags = $this->getIdsDerniersVotesImage();
|
170 |
$idsTags = $this->getIdsDerniersVotesImage();
|
171 |
$idsTagsConcat = implode(', ', $idsTags);
|
171 |
$idsTagsConcat = implode(', ', $idsTags);
|
172 |
$requete = 'SELECT id_tag, tag, date, '.
|
172 |
$requete = 'SELECT DISTINCT id_tag, tag, date, '.
|
173 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, di.id_image, '.
|
173 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, di.id_image, '.
|
174 |
' duo.prenom AS auteur_prenom, duo.nom AS auteur_nom, duo.courriel AS auteur_courriel, '.
|
174 |
' duo.prenom AS auteur_prenom, duo.nom AS auteur_nom, duo.courriel AS auteur_courriel, '.
|
175 |
' du.prenom AS tagueur_prenom, du.nom AS tagueur_nom, du.courriel AS tagueur_courriel '.
|
175 |
' du.prenom AS tagueur_prenom, du.nom AS tagueur_nom, du.courriel AS tagueur_courriel '.
|
176 |
'FROM del_image_tag AS dit '.
|
176 |
'FROM del_image_tag AS dit '.
|
177 |
' INNER JOIN del_image AS di '.
|
177 |
' INNER JOIN del_image AS di '.
|