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' ORDER BY pkt_main.desde ASC

Promoções por Preço

Preço de 3.000 € a 4.000 €