1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| SELECT DISTINCT "produit" type_req,
p.id_product id_product,
0 id_product_attribute,
p.price prix_vente,
p.wholesale_price prix_achat,
p.reference reference,
p.weight weight,
p.quantity quantity,
p.date_upd date_upd,
pl.name name,
pl.description_short description,
tr.name tax_rule
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_lang=1)LEFT JOIN ps_tax_rules_group tr ON (p.id_tax_rules_group = tr.id_tax_rules_group)
WHERE p.id_product >= 526 AND p.id_product <= 526
UNION
SELECT "declinaison" type_req,
pa.id_product id_product,
pa.id_product_attribute id_product_attribute,
pa.price + p.price prix_vente,
pa.wholesale_price prix_achat,
p.reference reference,
pa.weight + p.weight weight,
pa.quantity quantity,
p.date_upd date_upd,
pl.name name,
pl.description_short description,
tr.name tax_rule
FROM ps_product_attribute pa
JOIN ps_product p ON (p.id_product=pa.id_product)
LEFT JOIN ps_product_lang pl ON (pl.id_product=pa.id_product AND pl.id_lang=1) LEFT JOINps_tax_rules_group tr ON (p.id_tax_rules_group = tr.id_tax_rules_group)
WHERE p.id_product >= 526 AND p.id_product <= 526 ORDER BY 1 |
Partager