Database: optr_quadrante
Script: /var/www/vhosts/optitravel.net/public_html/optitravel/online/www/layout16/pkt_dynamic/circuitos.php on line 22
Trace: /var/www/vhosts/optitravel.net/public_html/optitravel/online/www/layout16/functions/func_portal.php on line 379 -> /var/www/vhosts/optitravel.net/public_html/optitravel/online/www/layout16/pkt_dynamic/circuitos.php on line 22
Mysql Error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?pkt_id=)GROUP BY pkt.id
			ORDER BY pkt.show_ordem ASC 
-- /var/www/vhosts/...' at line 77

Error No.: 1064
Backoffice User:
Date: 07-12-2024 15:27:48
Command: EXECUTE
Parameter 1:
SELECT 
			  pkt.id,
			  pkt.code,
			  pkt.name,
			  pkt.description,
			  pkt.status,
			  pkt.status_b2b,
			  pkt.status_public,
			  pkt.data1,
			  pkt.data2,
			  pkt.type AS brochura,
			  pkt.prod_type,
			  pkt.desde,
			  pkt.market,
			  pkt.nights,
			  pkt.cat,
			  pkt.days_duration,
			  pkt.subcat,
			  static_continents.description AS continent_pkt,
			  static_countries.description AS country_pkt,
			  pkt_main_dyn.date_model,
              static_item_info.description AS `static_info_description`,
              static_images.picture AS image,
              static_images.storage_id,
              static_images.storage_folder,
              business_areas.description AS ba_description,
              static_main_cat.description AS smc_description,
              func_pkt_price_from_v1 (pkt.id) AS minimo 
			FROM
			  pkt_main AS pkt
			LEFT JOIN 
              static_countries ON static_countries.id = pkt.country
			LEFT JOIN
              static_continents ON static_continents.id = pkt.continent
			LEFT JOIN 
              pkt_main_dyn ON pkt_main_dyn.pkt_id = pkt.id
            LEFT JOIN static_item_info 
				ON pkt.id = static_item_info.related 
				    AND static_item_info.entity = 'PKT' 
				    AND static_item_info.category LIKE 'Desc%'
            LEFT JOIN business_areas 
				ON business_areas.id = pkt.business_area 
            LEFT JOIN static_main_cat 
				ON static_main_cat.code = pkt.type 
            LEFT JOIN static_images
                ON static_images.entity = 'PKT' 
                    AND static_images.related_id = pkt.id 
                    AND static_images.main_pic = 'YES'
            
            
			WHERE 1=1     
                AND (
						pkt.type LIKE '%' 
						OR pkt.code IN 
						(SELECT 
						  prod_code 
						FROM
						  products_catalog 
						WHERE products_catalog.prod_code = pkt.code 
						  AND products_catalog.prod_type LIKE '%' 
						  AND products_catalog.status = 'A')
					  ) 
				 AND cat LIKE '%%%' 
                  -- AND pkt.status = 'OK' 
                 AND pkt.status_b2b = 'OK'
                 AND (
                    pkt.`prod_type` = 'STATIC' 
                    OR pkt.`prod_type` = 'STATIC_MSC' 
                    OR pkt.`prod_type` = 'STATIC_CRZ' 
                    OR pkt.`prod_type` = '' 
                    OR pkt.prod_type = 'DYNAMIC'
                 )     
                 AND pkt.data2 >= '2024-12-07' 
                 -- AND pkt.prod_type='DYNAMIC' 
			     -- AND pkt.status_public = 'OK' 
			     AND pkt.status='OK' 
AND pkt.type IN (USACIRCproduto.php?pkt_id=)GROUP BY pkt.id
			ORDER BY pkt.show_ordem ASC 
-- /var/www/vhosts/optitravel.net/public_html/optitravel/online/www/layout16/pkt_dynamic/circuitos.php - getProductList (22) >> /var/www/vhosts/optitravel.net/public_html/optitravel/online/www/layout16/functions/func_portal.php - Execute (379)

Parameter 2: