| 670,9 → 670,8 |
|---|
| ' FROM del_obs_image doi '. |
| ' INNER JOIN del_image di ON doi.id_image = di.id_image '. |
| ' INNER JOIN del_observation dob ON dob.id_observation = doi.id_observation '. |
| ' LEFT JOIN del_image_vote divo ON doi.id_image = divo.ce_image '; |
| |
| ; |
| ' LEFT JOIN del_image_vote divo ON doi.id_image = divo.ce_image '. |
| ' AND ce_protocole = '.$protocole.' '; |
| |
| // Et si on a cherché par tag ? |
| if (isset($this->parametres['masque.tag'])) { |
| 685,6 → 684,7 |
|---|
| ' ORDER by total_votes '.$this->directionTri .', doi.id_observation '.$this->directionTri.' '. |
| $this->gestionBdd->getLimitSql(); |
| |
| |
| $resultatsVotes = $this->bdd->recupererTous($requeteVotes); |
| $tabVotes = array(); |
| foreach ($resultatsVotes as $vote) { |
| 727,7 → 727,6 |
|---|
| foreach ($resultatstags as $tag) { |
| $tabtags[] = $tag['id_image']; |
| } |
| |
| $strtags = empty($tabtags) ? "''" : implode(',', $tabtags); |
| |
| |