108,7 → 108,7 |
$depart = $this->navigation->getDepart(); |
$limite = $this->navigation->getLimite(); |
|
$requete = 'SELECT SQL_CALC_FOUND_ROWS di.id_image '. |
$requete = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS di.id_image '. |
'FROM del_image AS di '. |
' LEFT JOIN del_image_stat AS ds ON (di.id_image = ds.ce_image) '. |
"$whereClause ". |
142,7 → 142,7 |
private function chargerInfos() { |
$idImgsConcat = implode(',', $this->idsImagesOrdonnees); |
|
$requete = 'SELECT SQL_CALC_FOUND_ROWS '. |
$requete = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS '. |
'di.id_image, di.mots_cles_texte AS mots_cles_texte_image, '. |
'do.id_observation, nom_referentiel, nom_ret, '. |
'nom_ret_nn, nt, famille, ce_zone_geo, zone_geo, date_observation, '. |