SITE DES NOTICES TECHNIQUES V2.5



SITE DES NOTICES TECHNIQUES V2.5




Retour à la page d'accueil
Erreur SQL
Requête : SELECT p.*, t.traduction as libelle, n.idnotice as idnotice, f.id as fid, t1.traduction as famille, sf.id as sfid, t2.traduction as sousfamille FROM ntc_produits AS p INNER JOIN `ntc_familles` f ON f.id = p.idfamille LEFT JOIN `ntc_traductions` t1 ON t1.iditem = f.id AND t1.type="famille" INNER JOIN `ntc_sousfamilles` sf ON sf.id = p.idsousfamille LEFT JOIN `ntc_traductions` t2 ON t2.iditem = sf.id AND t2.type="sousfamille" LEFT JOIN `ntc_notices` n ON p.id = n.idproduit LEFT JOIN `ntc_traductions` t ON t.iditem = p.id AND t.type="produit" INNER JOIN `ntc_notices_files` ntf ON (ntf.notice_id = n.idnotice OR ntf.notice_parentid = n.idnotice) AND t1.idlangue = 1 AND t2.idlangue = 1 WHERE p.idfamille = 29 AND p.idsousfamille in (5,69) AND t.idlangue = 1 GROUP BY p.reference_com ORDER BY libelle%20desc
Erreur : Unknown column '20desc' in 'order clause'