/branches/v1.5-carbone/services/modules/0.1/syndication/Tags.php |
---|
169,7 → 169,7 |
private function getDerniersVotesImage() { |
$idsTags = $this->getIdsDerniersVotesImage(); |
$idsTagsConcat = implode(', ', $idsTags); |
$requete = 'SELECT id_tag, tag, date, '. |
$requete = 'SELECT DISTINCT id_tag, tag, date, '. |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, di.id_image, '. |
' duo.prenom AS auteur_prenom, duo.nom AS auteur_nom, duo.courriel AS auteur_courriel, '. |
' du.prenom AS tagueur_prenom, du.nom AS tagueur_nom, du.courriel AS tagueur_courriel '. |
/branches/v1.5-carbone/services/modules/0.1/syndication/Votes.php |
---|
160,7 → 160,7 |
private function getDerniersVotesImage() { |
$idsVotes = $this->getIdsDerniersVotesImage(); |
$idsVotesConcat = implode(', ', $idsVotes); |
$requete = 'SELECT id_vote, ce_image, valeur, divo.date AS date_vote, '. |
$requete = 'SELECT DISTINCT id_vote, ce_image, valeur, divo.date AS date_vote, '. |
' duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, '. |
' duv.prenom AS votant_prenom, duv.nom AS votant_nom, '. |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, dip.intitule '. |