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:24
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] => ssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
[1] => OK
[2] => OK
[3] => 2025-09-28
[4] => 446
[5] => 1761
[6] => 1769
[7] => 1770
[8] => 1779
[9] => 1780
[10] => 1783
[11] => 1788
[12] => 1794
[13] => 1795
[14] => 1796
[15] => 1799
[16] => 1803
[17] => 1841
[18] => 1852
[19] => 1865
[20] => 1873
[21] => 1876
[22] => 2169
[23] => 2385
[24] => 2609
[25] => 3087
[26] => 3113
[27] => 3229
[28] => 3232
[29] => 3241
[30] => 3250
[31] => 3254
[32] => 3255
[33] => 3817
[34] => 3820
[35] => 3822
[36] => 3825
[37] => 3826
[38] => 3827
[39] => 3829
[40] => 4836
[41] => 4837
[42] => 4887
[43] => 4888
[44] => 4889
[45] => 4890
[46] => 4901
[47] => 4906
[48] => 4908
[49] => 4909
[50] => 4910
[51] => 4911
[52] => 4925
[53] => 4928
[54] => 4933
[55] => 4934
[56] => 4949
[57] => 4950
[58] => 4951
[59] => 4964
[60] => 4965
[61] => 4967
[62] => 4969
[63] => 4970
[64] => 4991
[65] => 5029
[66] => 5047
[67] => 5049
[68] => 5050
[69] => 5051
[70] => 5057
[71] => 5061
[72] => 5068
[73] => 5074
[74] => 5075
[75] => 5076
[76] => 5176
[77] => 5258
[78] => 5346
[79] => 5347
[80] => 5434
[81] => 5435
[82] => 5786
[83] => 5787
[84] => 6063
[85] => 6157
[86] => 6158
[87] => 6159
[88] => 6198
)