SELECT 
				pkt_main.id, 
				pkt_main.code,
				  pkt_main.name,
				  pkt_main.description,
				  pkt_main.status,
				  pkt_main.status_b2b,
				  pkt_main.status_public,
				  pkt_main.data1,
				  pkt_main.data2,
				  pkt_main.type AS brochura,
				  pkt_main.prod_type,
				  pkt_main.desde,
				  pkt_main.market,
				  pkt_main.nights,
				  pkt_main.cat,
				  pkt_main.days_duration,
				  pkt_main.subcat,
				  pkt_main.tags,
				  pkt_main.prod_type,
				  static_continents.description AS continent_pkt,
				  static_countries.description AS country_pkt,
				  pkt_main_extra_fields.`value` as brand,
				  optr_dyn_cats.name_pt AS cat_pt,
				  optr_dyn_cats.name_eng AS cat_eng
				  
		FROM pkt_main 
		LEFT JOIN static_countries ON static_countries.id = pkt_main.country
		LEFT JOIN static_continents ON static_continents.id = pkt_main.continent	
		LEFT JOIN optr_dyn_cats_assoc_detail ON optr_dyn_cats_assoc_detail.pkt_id = pkt_main.id
			LEFT JOIN optr_dyn_cats_assoc ON optr_dyn_cats_assoc.pkt_id = pkt_main.id
			LEFT JOIN optr_dyn_cats ON optr_dyn_cats.id = optr_dyn_cats_assoc_detail.cat_id
		LEFT JOIN pkt_main_extra_fields ON pkt_main_extra_fields.pkt_id = pkt_main.id AND pkt_main_extra_fields.field_name = 'brand'
		
		WHERE pkt_main.status_b2b = ? 
			AND pkt_main.status_public = ? 
			AND pkt_main.data2 >= ? 
			 
AND pkt_main.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
			
		GROUP BY pkt_main.id
		ORDER BY desde,pkt_main.show_ordem ASC LIMIT 0,18446744073709551615
-- /var/www/vhosts/optitravel.net/httpdocs/optitravel/online/www/layout46/produtos.php - getProductList (22) >> /var/www/vhosts/optitravel.net/httpdocs/optitravel/online/www/layout46/functions/func_portal.php - SelectLimit (650)

Array
(
    [0] => sssssssssssssssssssssssssssss
    [1] => OK
    [2] => OK
    [3] => 2025-09-28
    [4] => 1793
    [5] => 1806
    [6] => 1822
    [7] => 1823
    [8] => 1824
    [9] => 1864
    [10] => 2610
    [11] => 2686
    [12] => 3102
    [13] => 3103
    [14] => 3107
    [15] => 3119
    [16] => 3789
    [17] => 3792
    [18] => 3793
    [19] => 3794
    [20] => 3814
    [21] => 3815
    [22] => 3816
    [23] => 4973
    [24] => 4992
    [25] => 5027
    [26] => 5177
    [27] => 5970
    [28] => 6064
    [29] => 6165
)