1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| SELECT pop.promo, pop.price, p2c.categories_id, cd.categories_name, c.parent_id, pd.products_id, pd.products_name, p.products_ref, p.products_price, s.specials_new_products_price, couleur.products_options_values_id, couleur.products_options_values_name AS couleur,taille.products_options_values_name AS taille, pa.options_values_price, (
pa.options_values_price + p.products_price ) AS final_price, (pa.options_values_price + s.specials_new_products_price ) AS final_price_promo
FROM products_stock ps, products_description pd LEFT JOIN specials s USING(products_id), products_options_values couleur, products_options_values taille, products_attributes pa, products p, products_to_categories p2c, categories c, categories_description cd, products_options_price pop
WHERE pd.products_id = ps.products_id
AND pd.products_id = pa.products_id
AND pd.products_id = p.products_id
AND p2c.products_id = pd.products_id
AND p2c.categories_id = c.categories_id
AND cd.categories_id = c.categories_id
AND c.categories_id <> 64
AND c.parent_id = 1
AND p.products_status <> 0
AND pop.products_id = pd.products_id
AND pop.couleur_id = couleur.products_options_values_id
AND pop.taille_id = taille.products_options_values_id
AND SUBSTRING( ps.products_stock_attributes FROM 3 FOR 2 ) = couleur.products_options_values_id
AND SUBSTRING( ps.products_stock_attributes FROM 8 FOR 2 ) = taille.products_options_values_id
AND pa.options_values_id = taille.products_options_values_id
GROUP BY pd.products_id,couleur
ORDER BY p2c.categories_id, pd.products_name, couleur.products_options_values_id, taille.products_options_values_id |
Partager