| Line 160... |
Line 160... |
| 160 |
$requete = 'SELECT DISTINCT id_vote, ce_image, valeur, divo.date AS date_vote, '.
|
160 |
$requete = 'SELECT DISTINCT id_vote, ce_image, valeur, divo.date AS date_vote, '.
|
| 161 |
' duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, '.
|
161 |
' duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, '.
|
| 162 |
' duv.prenom AS votant_prenom, duv.nom AS votant_nom, '.
|
162 |
' duv.prenom AS votant_prenom, duv.nom AS votant_nom, '.
|
| 163 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, dip.intitule '.
|
163 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, dip.intitule '.
|
| 164 |
'FROM del_image_vote AS divo '.
|
164 |
'FROM del_image_vote AS divo '.
|
| 165 |
' INNER JOIN del_obs_image AS doi '.
|
165 |
' INNER JOIN del_image AS di '.
|
| 166 |
' ON divo.ce_image = doi.id_image '.
|
166 |
' ON divo.ce_image = di.id_image '.
|
| 167 |
' INNER JOIN del_observation AS do '.
|
167 |
' INNER JOIN del_observation AS do '.
|
| 168 |
' ON do.id_observation = doi.id_observation '.
|
168 |
' ON di.ce_observation = do.id_observation '.
|
| 169 |
' INNER JOIN del_image_protocole AS dip '.
|
169 |
' INNER JOIN del_image_protocole AS dip '.
|
| 170 |
' ON ce_protocole = id_protocole '.
|
170 |
' ON ce_protocole = id_protocole '.
|
| 171 |
' LEFT JOIN del_utilisateur AS duo '.
|
171 |
' LEFT JOIN del_utilisateur AS duo '.
|
| 172 |
' ON do.ce_utilisateur = duo.id_utilisateur '.
|
172 |
' ON do.ce_utilisateur = duo.id_utilisateur '.
|
| 173 |
' LEFT JOIN del_utilisateur AS duv '.
|
173 |
' LEFT JOIN del_utilisateur AS duv '.
|