Subversion Repositories eFlore/Applications.del

Compare Revisions

Ignore whitespace Rev 1232 → Rev 1233

/trunk/services/modules/0.1/syndication/SyndicationVotesParProtocole.php
107,12 → 107,12
* */
private function getDerniersVotesImage() {
$requete = 'SELECT id_vote, prenom, nom, nom_sel, intitule, ce_image, valeur, do.id_observation as del_obs, divo.date as date_vote '.
$requete = 'SELECT DISTINCT id_vote, prenom, nom, nom_sel, intitule, ce_image, valeur, dob.id_observation as del_obs, divo.date as date_vote '.
' FROM `del_image_vote` divo '.
' INNER JOIN del_obs_image doi ON divo.ce_image = doi.id_image '.
' INNER JOIN del_observation dob ON dob.id_observation = doi.id_observation '.
' INNER JOIN del_image_protocole ON ce_protocole = id_protocole '.
' INNER JOIN del_obs_image doi ON ce_image = id_image '.
' INNER JOIN del_observation do ON do.id_observation = doi.id_observation '.
' INNER JOIN del_utilisateur ON do.ce_utilisateur = id_utilisateur '.
' INNER JOIN del_utilisateur ON dob.ce_utilisateur = id_utilisateur '.
$this->chargerClauseWhere()." ".
' ORDER BY divo.date DESC '.
' LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();