SELECT * , AS pkt_id, 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 = 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' GROUP BY pkt_main.type ORDER BY ASC

Promoções por Destino