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] => ssssssssssssssssssssssssss
    [1] => OK
    [2] => OK
    [3] => 2025-09-28
    [4] => 1764
    [5] => 1780
    [6] => 1783
    [7] => 1788
    [8] => 1803
    [9] => 2129
    [10] => 3229
    [11] => 3248
    [12] => 3249
    [13] => 3250
    [14] => 3251
    [15] => 3254
    [16] => 3825
    [17] => 3826
    [18] => 4950
    [19] => 4964
    [20] => 4965
    [21] => 5047
    [22] => 5049
    [23] => 5050
    [24] => 5051
    [25] => 5057
    [26] => 5076
)