30,10 → 30,11 |
|
// Construction de la requête |
$requete = (($this->distinct) ? 'SELECT DISTINCT ' : 'SELECT '). |
' ccapu.*, cpu.* '. |
' ccapu.*, cpu.*, cs.* '. |
'FROM coel_collection_a_publication AS ccapu '. |
' LEFT JOIN coel_meta_historique_ligne ON (ccapu_ce_meta = cmhl_id_historique_ligne) '. |
' LEFT JOIN coel_publication AS cpu ON (ccapu_id_publication = cpu_id_publication) '. |
' LEFT JOIN coel_structure AS cs ON (cs_id_structure = cpu_ce_truk_editeur) '. |
((count($p) != 0) ? 'WHERE ' : ''). |
(isset($p['id_collection']) ? "AND ccapu_id_collection = {$p['id_collection']} " : ''). |
(isset($p['source']) ? "AND ccapu_source = {$p['source']} " : ''). |
41,6 → 42,7 |
$requete = str_replace('WHERE AND', 'WHERE', $requete); |
$requeteCount = $requete; |
$requete .= "LIMIT $this->start, $this->limit "; |
|
//echo $requete;exit; |
// Récupération des résultats |
try { |