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(); |