| Line 165... |
Line 165... |
| 165 |
if (!empty($idsCommentaires)) {
|
165 |
if (!empty($idsCommentaires)) {
|
| 166 |
$idsCommentairesconcat = implode(', ', $idsCommentaires);
|
166 |
$idsCommentairesconcat = implode(', ', $idsCommentaires);
|
| 167 |
$requete = 'SELECT DISTINCT dc.*, '.
|
167 |
$requete = 'SELECT DISTINCT dc.*, '.
|
| 168 |
' dob.id_observation AS dob_id_observation, dob.ce_zone_geo AS dob_ce_zone_geo, '.
|
168 |
' dob.id_observation AS dob_id_observation, dob.ce_zone_geo AS dob_ce_zone_geo, '.
|
| 169 |
' dob.zone_geo AS dob_zone_geo, dob.date_observation AS dob_date_observation, dob.nom_sel AS dob_nom_sel, '.
|
169 |
' dob.zone_geo AS dob_zone_geo, dob.date_observation AS dob_date_observation, dob.nom_sel AS dob_nom_sel, '.
|
| 170 |
' dob.prenom_utilisateur AS observateur_prenom, dob.nom_utilisateur AS observateur_nom '.
|
170 |
' dob.prenom_utilisateur AS observateur_prenom, dob.nom_utilisateur AS observateur_nom, dob.courriel_utilisateur AS observateur_courriel '.
|
| 171 |
'FROM del_commentaire AS dc '.
|
171 |
'FROM del_commentaire AS dc '.
|
| 172 |
' INNER JOIN del_observation AS dob '.
|
172 |
' INNER JOIN del_observation AS dob '.
|
| 173 |
' ON dob.id_observation = dc.ce_observation '.
|
173 |
' ON dob.id_observation = dc.ce_observation '.
|
| 174 |
"WHERE id_commentaire IN ($idsCommentairesconcat) ".
|
174 |
"WHERE id_commentaire IN ($idsCommentairesconcat) ".
|
| 175 |
'ORDER BY dc.date DESC '.
|
175 |
'ORDER BY dc.date DESC '.
|