Line 185... |
Line 185... |
185 |
'FROM '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
|
185 |
'FROM '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
|
186 |
'INNER JOIN del_image di '.
|
186 |
'INNER JOIN del_image di '.
|
187 |
'ON doi.id_image = di.id_image '.
|
187 |
'ON doi.id_image = di.id_image '.
|
188 |
'INNER JOIN del_observation dob '.
|
188 |
'INNER JOIN del_observation dob '.
|
189 |
'ON doi.id_observation = dob.id_observation '.
|
189 |
'ON doi.id_observation = dob.id_observation '.
|
190 |
'INNER JOIN del_utilisateur du '.
|
190 |
'LEFT JOIN del_utilisateur du '.
|
191 |
'ON du.id_utilisateur = di.ce_utilisateur '.
|
191 |
'ON du.id_utilisateur = di.ce_utilisateur '.
|
192 |
'LEFT JOIN del_image_vote dvote '.
|
192 |
'LEFT JOIN del_image_vote dvote '.
|
193 |
'ON doi.id_image = dvote.ce_image '.
|
193 |
'ON doi.id_image = dvote.ce_image '.
|
194 |
($this->parametres['masque.protocole'] != null ? 'AND dvote.ce_protocole = '.$this->parametres['masque.protocole'].' ' : ' ');
|
194 |
($this->parametres['masque.protocole'] != null ? 'AND dvote.ce_protocole = '.$this->parametres['masque.protocole'].' ' : ' ');
|
195 |
$requeteLiaisons .= 'GROUP BY dvote.ce_image '.
|
195 |
$requeteLiaisons .= 'GROUP BY dvote.ce_image '.
|