| /trunk/services/modules/0.1/syndication/Tags.php |
|---|
| 180,9 → 180,9 |
| ' ON ce_image = id_image '. |
| ' INNER JOIN del_observation AS do '. |
| ' ON di.ce_observation = do.id_observation '. |
| ' LEFT JOIN del_utilisateur AS duo '. |
| ' LEFT JOIN del_utilisateur_infos AS duo '. |
| ' ON do.ce_utilisateur = duo.id_utilisateur '. |
| ' LEFT JOIN del_utilisateur AS du '. |
| ' LEFT JOIN del_utilisateur_infos AS du '. |
| ' ON if((CHAR_LENGTH(dit.ce_utilisateur) <> 32),CAST(dit.ce_utilisateur AS unsigned),0) '. |
| ' = du.id_utilisateur '. |
| 'WHERE actif = 1 '. |
| /trunk/services/modules/0.1/syndication/Votes.php |
|---|
| 173,9 → 173,9 |
| ' ON di.ce_observation = do.id_observation '. |
| ' INNER JOIN del_image_protocole AS dip '. |
| ' ON ce_protocole = id_protocole '. |
| ' LEFT JOIN del_utilisateur AS duo '. |
| ' LEFT JOIN del_utilisateur_infos AS duo '. |
| ' ON do.ce_utilisateur = duo.id_utilisateur '. |
| ' LEFT JOIN del_utilisateur AS duv '. |
| ' LEFT JOIN del_utilisateur_infos AS duv '. |
| ' ON if((CHAR_LENGTH(divo.ce_utilisateur) <> 32),CAST(divo.ce_utilisateur AS unsigned),0) '. |
| ' = duv.id_utilisateur '. |
| "WHERE id_vote IN ($idsVotesConcat) ". |
| /trunk/services/modules/0.1/syndication/Commentaires.php |
|---|
| 167,12 → 167,10 |
| $requete = 'SELECT DISTINCT dc.*, '. |
| ' dob.id_observation AS dob_id_observation, dob.ce_zone_geo AS dob_ce_zone_geo, '. |
| ' dob.zone_geo AS dob_zone_geo, dob.date_observation AS dob_date_observation, dob.nom_sel AS dob_nom_sel, '. |
| ' duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, duo.courriel AS observateur_courriel '. |
| ' dob.prenom_utilisateur AS observateur_prenom, dob.nom_utilisateur AS observateur_nom, dob.courriel_utilisateur AS observateur_courriel '. |
| 'FROM del_commentaire AS dc '. |
| ' INNER JOIN del_observation AS dob '. |
| ' ON dob.id_observation = dc.ce_observation '. |
| ' LEFT JOIN del_utilisateur AS duo '. |
| ' ON dob.ce_utilisateur = duo.id_utilisateur '. |
| "WHERE id_commentaire IN ($idsCommentairesconcat) ". |
| 'ORDER BY dc.date DESC '. |
| 'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '. |