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] => sssssssssssssssssssssssss
    [1] => OK
    [2] => OK
    [3] => 2025-09-28
    [4] => 1833
    [5] => 1848
    [6] => 1920
    [7] => 1932
    [8] => 1935
    [9] => 2179
    [10] => 2206
    [11] => 2385
    [12] => 2461
    [13] => 2491
    [14] => 2497
    [15] => 2504
    [16] => 2542
    [17] => 2553
    [18] => 3087
    [19] => 4940
    [20] => 4974
    [21] => 4987
    [22] => 5059
    [23] => 5070
    [24] => 5083
    [25] => 6063
)