Kuest, la tienda deportiva más grande de México

SELECT SQL_NO_CACHE p.*, IFNULL(stock.quantity, 0) AS quantity, pl.name, pl.link_rewrite, image_shop.id_image id_image FROM ps_product p LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN ps_category categ ON (p.id_category_default = categ.id_category and categ.id_parent =5142 and categ.active=1 ) LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang = 2 AND pl.id_shop = 1 ) LEFT JOIN ps_product_slider_vertical pst ON pst.id_product = p.id_product JOIN ps_category_product cprod ON p.id_product = cprod.id_product LEFT JOIN ps_image_shop image_shop ON (image_shop.id_product = p.id_product AND image_shop.cover=1 AND image_shop.id_shop=1) WHERE stock.quantity>0 and p.active=1 AND p.date_add >= DATE_SUB(NOW(), INTERVAL 30 DAY) group by p.id_product ORDER BY p.id_product desc LIMIT 0, 100

Eventos & Comunidad