Database: optr_cosmos
Script: /var/www/vhosts/optitravel.net/httpdocs/optitravel/online/www/layout46/produtos.php on line 22
Trace: /var/www/vhosts/optitravel.net/httpdocs/optitravel/online/www/layout46/functions/func_portal.php on line 650 -> /var/www/vhosts/optitravel.net/httpdocs/optitravel/online/www/layout46/produtos.php on line 22
Mysql Error:

Error No.: 0
Backoffice User:
Date: 28-09-2025 22:39:25
Command: EXECUTE
Parameter 1:
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)

Parameter 2:
Array
(
    [0] => ssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
    [1] => OK
    [2] => OK
    [3] => 2025-09-28
    [4] => 1761
    [5] => 1763
    [6] => 1767
    [7] => 1769
    [8] => 1770
    [9] => 1779
    [10] => 1793
    [11] => 1794
    [12] => 1795
    [13] => 1796
    [14] => 1806
    [15] => 1815
    [16] => 1822
    [17] => 1823
    [18] => 1824
    [19] => 1826
    [20] => 1829
    [21] => 1832
    [22] => 1833
    [23] => 1837
    [24] => 1841
    [25] => 1848
    [26] => 1852
    [27] => 1864
    [28] => 1865
    [29] => 1873
    [30] => 1885
    [31] => 1916
    [32] => 1920
    [33] => 1962
    [34] => 2102
    [35] => 2107
    [36] => 2169
    [37] => 2179
    [38] => 2182
    [39] => 2206
    [40] => 2356
    [41] => 2385
    [42] => 2461
    [43] => 2491
    [44] => 2497
    [45] => 2504
    [46] => 2542
    [47] => 2578
    [48] => 2597
    [49] => 2609
    [50] => 2610
    [51] => 2700
    [52] => 2876
    [53] => 2963
    [54] => 3087
    [55] => 3102
    [56] => 3103
    [57] => 3105
    [58] => 3107
    [59] => 3110
    [60] => 3113
    [61] => 3119
    [62] => 3120
    [63] => 3212
    [64] => 3241
    [65] => 3789
    [66] => 3792
    [67] => 3793
    [68] => 3794
    [69] => 3797
    [70] => 3798
    [71] => 3812
    [72] => 3813
    [73] => 3814
    [74] => 3815
    [75] => 3816
    [76] => 3828
    [77] => 3829
    [78] => 3830
    [79] => 3832
    [80] => 3833
    [81] => 4890
    [82] => 4939
    [83] => 4973
    [84] => 4974
    [85] => 4976
    [86] => 4978
    [87] => 4987
    [88] => 4988
    [89] => 4991
    [90] => 4992
    [91] => 5041
    [92] => 5058
    [93] => 5059
    [94] => 5060
    [95] => 5069
    [96] => 5070
    [97] => 5083
    [98] => 5176
    [99] => 5177
    [100] => 5346
    [101] => 5347
    [102] => 5786
    [103] => 5787
    [104] => 5970
    [105] => 6063
    [106] => 6165
)