SELECT * , pkt_main.id AS pkt_id, pkt_main.name AS pkt_name, pkt_main.desde AS desde, static_main_cat.subcat_id AS id_image, static_main_cat.subcat as subcategoria FROM products_catalog LEFT JOIN static_main_cat ON static_main_cat.code = products_catalog.prod_type LEFT JOIN pkt_main ON pkt_main.code = products_catalog.prod_code LEFT JOIN static_images ON static_images.related_id = pkt_main.id WHERE products_catalog.prod_type LIKE '%PRO' AND products_catalog.status = 'A' AND pkt_main.status= 'OK' AND static_images.entity = 'PKT' AND static_images.main_pic = 'YES' ORDER BY pkt_main.desde ASC

Promoções por Preço