| Line 171... |
Line 171... |
| 171 |
' ON divo.ce_image = di.id_image '.
|
171 |
' ON divo.ce_image = di.id_image '.
|
| 172 |
' INNER JOIN del_observation AS do '.
|
172 |
' INNER JOIN del_observation AS do '.
|
| 173 |
' ON di.ce_observation = do.id_observation '.
|
173 |
' ON di.ce_observation = do.id_observation '.
|
| 174 |
' INNER JOIN del_image_protocole AS dip '.
|
174 |
' INNER JOIN del_image_protocole AS dip '.
|
| 175 |
' ON ce_protocole = id_protocole '.
|
175 |
' ON ce_protocole = id_protocole '.
|
| 176 |
' LEFT JOIN del_utilisateur AS duo '.
|
176 |
' LEFT JOIN del_utilisateur_infos AS duo '.
|
| 177 |
' ON do.ce_utilisateur = duo.id_utilisateur '.
|
177 |
' ON do.ce_utilisateur = duo.id_utilisateur '.
|
| 178 |
' LEFT JOIN del_utilisateur AS duv '.
|
178 |
' LEFT JOIN del_utilisateur_infos AS duv '.
|
| 179 |
' ON if((CHAR_LENGTH(divo.ce_utilisateur) <> 32),CAST(divo.ce_utilisateur AS unsigned),0) '.
|
179 |
' ON if((CHAR_LENGTH(divo.ce_utilisateur) <> 32),CAST(divo.ce_utilisateur AS unsigned),0) '.
|
| 180 |
' = duv.id_utilisateur '.
|
180 |
' = duv.id_utilisateur '.
|
| 181 |
"WHERE id_vote IN ($idsVotesConcat) ".
|
181 |
"WHERE id_vote IN ($idsVotesConcat) ".
|
| 182 |
'ORDER BY divo.date DESC '.
|
182 |
'ORDER BY divo.date DESC '.
|
| 183 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().
|
183 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().
|