Accueil

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY a.num_tome' at line 12
Impossible d'effectuer la requête SELECT DISTINCT s.copyright,couverture_big,UPPER(MID(s.nom_serie,1,1)) as alphabet,DATE_FORMAT(depot_legal,'%m/%Y') as depot_legal_format,a.id_editeur,a.note_originalite,a.note_scenario,a.note_illustration,a._cache_nb_avis,a.asin,a.resume,IFNULL(u.pseudo_user,u.login) as pseudo_user,u.login,DATE(a.date_creation) as date_creation,tc.lib_type_couverture,f.lib_format,f.id_format,c.lib_collection,e.nom_editeur,pb.lib_public,pb.id_public,a.nb_page,a._cache_moyenne,a.num_tome,a.nom_tome as nom_complet,a.depot_legal,CASE WHEN s.wildcard_dns IS NOT NULL THEN CONCAT('http://',s.wildcard_dns,'.coinbd.com',a.url_rewrite) ELSE a.url_rewrite END as url_rewrite_album,p.espace,a.couverture,a.planche,a.id_album,a.vignette,a.id_serie,CASE WHEN s.wildcard_dns IS NOT NULL THEN CONCAT('http://',s.wildcard_dns,'.coinbd.com',s.url_rewrite) ELSE s.url_rewrite END as url_rewrite_serie,s.nom_serie as nom_complet_serie,s.particule,a.isbn10,a.isbn13,a._cache_amazon_xml,a.id_user,a.id_format,a.id_type_couverture,lib_ss_categorie,lib_categorie,s.id_categorie,s.id_ss_categorie,id_editeur_vo,e2.nom_editeur as nom_editeur_vo FROM album a INNER JOIN serie s ON s.id_serie = a.id_serie LEFT JOIN ldv_categorie on s.id_categorie = ldv_categorie.id_categorie LEFT JOIN ldv_ss_categorie on s.id_ss_categorie = ldv_ss_categorie.id_ss_categorie LEFT JOIN particule p on p.particule=s.particule LEFT JOIN ldv_public pb on s.id_public = pb.id_public INNER JOIN editeur e on a.id_editeur=e.id_editeur LEFT JOIN editeur e2 on a.id_editeur_vo=e2.id_editeur LEFT JOIN ldv_collection c on a.id_collection=c.id_collection LEFT JOIN ldv_format f on f.id_format = a.id_format LEFT JOIN ldv_type_couverture tc on tc.id_type_couverture = a.id_type_couverture INNER JOIN user u on u.id_user=a.id_user WHERE s.actif="1" AND a.actif="1" AND a.id_album IN () ORDER BY a.num_tome