SELECT p.id, pf.idFamily, pfr.descc, pfr.unavailable, aa.category AS adv_cat, pfr.delai_livraison AS delivery_time, aa.delai_livraison AS delivery_timeADV, aa.id AS idAdvertiser, p.price AS typePrice, rc.id AS ref_idtc, (IFNULL(rc.price, p.price) REGEXP '^[1-9]{1}[0-9]*((\.|,)[0-9]+){0,1}$') AS hasPrice, IFNULL(rc.price + rc.ecotax, p.price) AS price, aa.display_logo, aa.logo, (IFNULL(rc.price, p.price) REGEXP '^[1-9]{1}[0-9]*((\.|,)[0-9]+){0,1}$' AND aa.category = ?) AS saleable, (p.as_estimate + aa.as_estimate) AS product_as_estimate, (SELECT COUNT(idProduct) FROM references_content WHERE idProduct = p.id) AS nb_refs, fr.ref_name FROM products p INNER JOIN products_fr pfr ON p.id = pfr.id AND pfr.active = 1 AND pfr.deleted != 1 INNER JOIN advertisers aa ON pfr.idAdvertiser = aa.id INNER JOIN products_families pf ON pf.idProduct = pfr.id INNER JOIN families_fr fr ON pf.id = pf.idFamily LEFT JOIN references_content rc ON p.id = rc.idProduct AND rc.classement = 1 AND rc.vpc = 1 AND rc.deleted = 0 WHERE pfr.id = ?Erreur de préparation de requête : Unknown column 'pf.id' in 'on clause'