139,17 → 139,15 |
$limite = @min(intval($this->parametres['navigation.limite']), 1000); |
$limite = $limite ? $limite : 10; // 0 => 10 |
|
$whereClause = count($where) > 0 ? 'WHERE '.implode(' AND ', $where) : ''; |
|
$requeteLiaisons = sprintf( |
'SELECT SQL_CALC_FOUND_ROWS %s ce_protocole, moyenne, nb_votes, nb_tags' |
// IF(LENGTH()) workaround pour la jointure sur tela_annuaire depuis un hash md5 casté |
. ' FROM v_del_image di LEFT JOIN del_utilisateur du ON du.id_utilisateur = IF(LENGTH(di.ce_utilisateur) > 5, 0, di.ce_utilisateur)' |
. ' LEFT JOIN del_image_stat ds ON di.id_image = ds.ce_image' |
. ' %s GROUP BY id_image ORDER BY moyenne LIMIT %d,%d -- %s:%d', |
. ' WHERE %s GROUP BY id_image /* car plusieurs image pour obs, see PHP */ ORDER BY moyenne LIMIT %d, %d -- %s:%d', |
|
implode(', ',$champs), |
$whereClause, |
implode(' AND ', $where), |
intval(@$this->parametres['navigation.depart']), |
$limite, |
__FILE__, __LINE__); |