Как получить все созданные товары?

Question

[Mykola Ivashchuk]

Нужно получить все товары ( как в каталоге в админке). Нашел как получать только активные товары.

Answer 1

[Mykola Ivashchuk]

SELECT a.*, b.* , m.name AS manufacturer_name, s.name AS supplier_name
            FROM ps_product a 
            LEFT JOIN ps_product_lang b ON (b.id_product = a.id_product AND b.id_lang = 4 AND b.id_shop = 1) 
            LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = a.id_manufacturer)
            LEFT JOIN ps_supplier s ON (s.id_supplier = a.id_supplier)
            LEFT JOIN ps_stock_available sav ON (sav.id_product = a.id_product AND sav.id_product_attribute = 0 AND sav.id_shop = 1 AND sav.id_shop_group = 0 ) 
            JOIN ps_product_shop sa ON (a.id_product = sa.id_product AND sa.id_shop = a.id_shop_default) 
            LEFT JOIN ps_category_lang cl ON (sa.id_category_default = cl.id_category AND b.id_lang = cl.id_lang AND cl.id_shop = a.id_shop_default) 
            LEFT JOIN ps_shop shop ON (shop.id_shop = a.id_shop_default) 
            LEFT JOIN ps_image_shop image_shop ON (image_shop.id_product = a.id_product AND image_shop.cover = 1 AND image_shop.id_shop = a.id_shop_default) 
            LEFT JOIN ps_image i ON (i.id_image = image_shop.id_image) LEFT JOIN ps_product_download pd ON (pd.id_product = a.id_product AND pd.active = 1) 
            WHERE 1 ORDER BY a.id_product ASC