44,7 → 44,7 |
unset($criteres['dir']); |
|
$debut = ($debut < 0) ? 0 : $debut; |
$requete_recherche_images = 'SELECT * '; |
$requete_recherche_images = 'SELECT ci.* '; |
|
if ($this->doitJoindreTableObs($criteres)) { |
$requete_recherche_images .= $this->fabriquerRequeteJointureObs(); |
105,12 → 105,12 |
|
private function fabriquerRequeteJointureObs() { |
|
$requete_jointure_observations = 'FROM cel_obs_images coi '. |
'INNER JOIN cel_obs co '. |
$requete_jointure_observations = 'FROM cel_images ci '. |
'LEFT JOIN cel_obs_images coi '. |
'ON coi.id_image = ci.id_image '. |
'LEFT JOIN cel_obs co '. |
'ON coi.id_observation = co.id_observation '. |
'INNER JOIN cel_images ci '. |
'ON coi.id_image = ci.id_image '. |
'WHERE co.ce_utilisateur = ci.ce_utilisateur '; |
'WHERE 1 '; |
|
return $requete_jointure_observations; |
} |