| Line 171... |
Line 171... |
| 171 |
$idsTags = $this->getIdsDerniersVotesImage();
|
171 |
$idsTags = $this->getIdsDerniersVotesImage();
|
| 172 |
if (!empty($idsTags)) {
|
172 |
if (!empty($idsTags)) {
|
| 173 |
$idsTagsConcat = implode(', ', $idsTags);
|
173 |
$idsTagsConcat = implode(', ', $idsTags);
|
| 174 |
$requete = 'SELECT DISTINCT id_tag, tag, date, '.
|
174 |
$requete = 'SELECT DISTINCT id_tag, tag, date, '.
|
| 175 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, di.id_image, '.
|
175 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, di.id_image, '.
|
| 176 |
' duo.prenom AS auteur_prenom, duo.nom AS auteur_nom, '.
|
176 |
' duo.prenom AS auteur_prenom, duo.nom AS auteur_nom, duo.courriel AS auteur_courriel, '.
|
| 177 |
' du.prenom AS tagueur_prenom, du.nom AS tagueur_nom '.
|
177 |
' du.prenom AS tagueur_prenom, du.nom AS tagueur_nom, du.courriel AS tagueur_courriel '.
|
| 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 '.
|