Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT SQL_NO_CACHE p.*, product_shop.*, pl.* , m.`name` AS manufacturer_name, s.`name` AS supplier_name
- FROM `ps_product` p
- INNER JOIN ps_product_shop product_shop
- ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
- LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 )
- LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
- LEFT JOIN `ps_supplier` s ON (s.`id_supplier` = p.`id_supplier`)
- WHERE pl.`id_lang` = 4 AND product_shop.`visibility` IN ("both", "catalog")
- ORDER BY pl.`name` ASC LIMIT 1,5000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement