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
)