187,8 → 187,8 |
$requete = 'SELECT DISTINCT dc.id_commentaire '. |
'FROM del_commentaire AS dc '. |
' INNER JOIN del_observation AS dob ON (dc.ce_observation = dob.id_observation) '. |
' LEFT JOIN del_utilisateur AS duo ON (dob.ce_utilisateur = duo.id_utilisateur) '. |
'WHERE proposition_initiale != 1 '. |
'AND dc.date >= DATE_ADD(CURDATE(), INTERVAL -7 DAY) '. |
($clauseWhere != '' ? "AND $clauseWhere " : ''). |
'ORDER BY dc.date DESC '. |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '. |