1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SELECT p.reference,pl.name as nom,
ROUND((SELECT ((p.`price` * IF(19.6,((100 + (19.6))/100),1) - IF(`reduction_from` = `reduction_to`, IF(`reduction_price` > 0, `reduction_price`, (p.`price` * IF(19.6,((100 + (19.6))/100),1) * `reduction_percent` / 100)),0))+pa.price) FROM product_attribute pa WHERE pa.id_product_attribute =pac.id_product_attribute AND pac.id_attribute =31) ,2) as prixA,
ROUND((SELECT ((p.`price` * IF(19.6,((100 + (19.6))/100),1) - IF(`reduction_from` = `reduction_to`, IF(`reduction_price` > 0, `reduction_price`, (p.`price` * IF(19.6,((100 + (19.6))/100),1) * `reduction_percent` / 100)),0))+pa.price) FROM product_attribute pa WHERE pa.id_product_attribute =pac.id_product_attribute AND pac.id_attribute =32) ,2) as prixB,
ROUND((SELECT ((p.`price` * IF(19.6,((100 + (19.6))/100),1) - IF(`reduction_from` = `reduction_to`, IF(`reduction_price` > 0, `reduction_price`, (p.`price` * IF(19.6,((100 + (19.6))/100),1) * `reduction_percent` / 100)),0))+pa.price) FROM product_attribute pa WHERE pa.id_product_attribute =pac.id_product_attribute AND pac.id_attribute =33) ,2) as prixC,
(SELECT pa.quantity FROM product_attribute pa WHERE pa.id_product_attribute =pac.id_product_attribute AND pac.id_attribute =31) as QteA,
(SELECT pa.quantity FROM product_attribute pa WHERE pa.id_product_attribute =pac.id_product_attribute AND pac.id_attribute =32) as QteB,
(SELECT pa.quantity FROM product_attribute pa WHERE pa.id_product_attribute =pac.id_product_attribute AND pac.id_attribute =33) as QteC
FROM `product_attribute` pa
LEFT JOIN product_lang pl ON (pa.id_product = pl.id_product)
LEFT JOIN product p ON (p.id_product = pl.id_product)
LEFT JOIN `product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `attribute_lang` al ON a.`id_attribute` = al.`id_attribute`
LEFT JOIN `attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group`
WHERE pa.`id_product` IN (SELECT p.id_product
FROM product p
WHERE al.id_lang =2 AND p.id_product !=6381754 AND p.id_product !=6381756 AND p.id_product !=6043485
GROUP BY p.id_product)
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
AND pl.`id_lang` = 2
ORDER BY pa.`id_product_attribute` |
Partager