Open menu

Tooted

SELECT *, a.ID as ID, b.NAME, sum(d.level) as stockTotal, d.level as stock FROM go_products a LEFT JOIN go_products_desc b ON a.ID = b.PRODUCT_ID LEFT JOIN go_products_to_cats c ON a.ID = c.PRODUCT_ID LEFT JOIN go_products_stocklevel d ON a.ID = d.product_id WHERE (b.LANG_ID = 1 OR b.LANG_ID IS NULL) AND a.STATUS = "public" AND show_in_web = "yes" GROUP BY a.ID ORDER BY CREATED_DATE desc
Leiti 0 vastet

kuva korraga: 12 / 24 / 30 / 60 /