| /trunk/services/modules/0.1/observations/ListeObservations.php |
|---|
| 428,7 → 428,7 |
| 'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob'). |
| 'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi'). |
| 'ON doi.id_observation = dob.id_observation '. |
| 'INNER JOIN del_utilisateur du '. |
| 'LEFT JOIN del_utilisateur du '. |
| 'ON du.id_utilisateur = dob.ce_utilisateur '. |
| 'INNER JOIN del_image di '. |
| 'ON di.id_image = doi.id_image '; |
| /trunk/services/modules/0.1/syndication/SyndicationVotesParProtocole.php |
|---|
| 112,7 → 112,7 |
| ' 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_utilisateur ON dob.ce_utilisateur = id_utilisateur '. |
| ' LEFT JOIN del_utilisateur ON dob.ce_utilisateur = id_utilisateur '. |
| $this->chargerClauseWhere()." ". |
| ' ORDER BY divo.date DESC '. |
| ' LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite(); |
| /trunk/services/modules/0.1/determinations/ListeImagesDeterminationsProbables.php |
|---|
| 187,7 → 187,7 |
| 'ON doi.id_image = di.id_image '. |
| 'INNER JOIN del_observation dob '. |
| 'ON doi.id_observation = dob.id_observation '. |
| 'INNER JOIN del_utilisateur du '. |
| 'LEFT JOIN del_utilisateur du '. |
| 'ON du.id_utilisateur = di.ce_utilisateur '. |
| 'LEFT JOIN del_image_vote dvote '. |
| 'ON doi.id_image = dvote.ce_image '. |