Pulvérisateur quad d'engrais

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 a.name = 'Capacité (L)' AND pra.value <> '' AND EXISTS (SELECT 1 FROM product_reference_attribute pra2 WHERE pra2.product_reference_id = rc.id AND pra2.value IS NOT NULL AND pra2.value <> '') LIMIT 1) AS `Capacité_(L)`,(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 a.name = 'Pompe' AND pra.value <> '' AND EXISTS (SELECT 1 FROM product_reference_attribute pra2 WHERE pra2.product_reference_id = rc.id AND pra2.value IS NOT NULL AND pra2.value <> '') LIMIT 1) AS `Pompe`,(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 a.name = 'Dimensions (L x l x H) mm' AND pra.value <> '' AND EXISTS (SELECT 1 FROM product_reference_attribute pra2 WHERE pra2.product_reference_id = rc.id AND pra2.value IS NOT NULL AND pra2.value <> '') LIMIT 1) AS `Dimensions_(L_x_l_x_H)_mm`, rc.price AS Prix_HT FROM references_content rc INNER JOIN advertisers ad ON ad.id = rc.sup_id WHERE rc.idProduct = '672248' AND rc.deleted = 0 AND rc.vpc = 1 AND rc.accessory!='1' ORDER BY rc.classement ASC