Chariot polyvalent à plateaux

SELECT rc.id AS ref_TC, rc.label AS Libelle,(SELECT pra.value FROM product_reference_attribute pra INNER JOIN product_attribute pa ON pa.id = pra.product_attribute_id INNER JOIN attribute a ON a.id = pa.attribute_id WHERE pra.product_reference_id = rc.id AND a.name = 'Dimensions ( L x l x H ) mm' LIMIT 1) AS `Dimensions_(_L_x_l_x_H_)_mm`,(SELECT pra.value FROM product_reference_attribute pra INNER JOIN product_attribute pa ON pa.id = pra.product_attribute_id INNER JOIN attribute a ON a.id = pa.attribute_id WHERE pra.product_reference_id = rc.id AND a.name = 'Capacité ( kg)' LIMIT 1) AS `Capacité_(_kg)`,(SELECT pra.value FROM product_reference_attribute pra INNER JOIN product_attribute pa ON pa.id = pra.product_attribute_id INNER JOIN attribute a ON a.id = pa.attribute_id WHERE pra.product_reference_id = rc.id AND a.name = 'Modèle' LIMIT 1) AS `Modèle`, rc.price AS Prix_HT FROM references_content rc INNER JOIN advertisers ad ON ad.id = rc.sup_id WHERE rc.idProduct = '11743423' AND rc.deleted = 0 AND rc.vpc = 1 AND rc.accessory!='1' ORDER BY rc.classement ASC