Warning: Undefined array key 1 in /var/www/parfumcenter.hu/web/system/Functions.php on line 144

Fatal error: Uncaught Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p.type_id != 3 AND p.brand_id = NULL AND p.status_id = ? GROUP BY p.id' at line 10 query: SELECT p.id, p.type_id, dp.type AS discount_type, dp.value AS discount_value, FORMAT(pp.price_gross,0, "hu_HU") AS min_price, CONCAT("{",GROUP_CONCAT(DISTINCT '"',att.name,'"',":",'"',atv.value,'"'),"}") AS attributes, CONCAT("https://www.parfumcenter.hu/data/images/products/",p.id,"/thumbnail/",pi.filename) AS image, CONCAT("https://www.parfumcenter.hu/",_pd.url) AS url FROM products p LEFT JOIN product_attributes pat on pat.product_id = p.id LEFT JOIN attribute_values atv on atv.id = pat.attribute_value_id LEFT JOIN attributes att on att.id = atv.attribute_id LEFT JOIN _pages_dynamic _pd on _pd.content_id = p.id AND _pd.content_type = 1 LEFT JOIN product_images pi on pi.product_id = p.id AND pi.main = 1 LEFT JOIN discount_product dp on dp.product_id = p.id AND DATE(dp.valid_from) <= "2022-01-27" AND DATE(dp.valid_until) >= "2022-01-27" LEFT JOIN product_prices pp on pp.product_group_id = p.id AND pp.pricelist_id = 1 AND pp.price_gross = IF (p.type_id = "2", (SELECT MIN(price_gross) FROM product_prices WHERE product_group_id = p.id AND pricelist_id = 1 AND product_id != product_group_id), (SELECT MIN(price_gross) FROM product_prices WHERE product_group_id = p.id AND pricelist_id = 1)) WHERE p.id != AND p.type_id != 3 AND p.brand_id = NULL AND p.status_id = ? GROUP BY p.id in /var/www/parfumcenter.hu/web/libraries/MysqliDb/MysqliDb.php:2014 Stack trace: #0 /var/www/parfumcenter.hu/web/libraries/MysqliDb/MysqliDb.php(1602): MysqliDb->_prepareQuery() #1 /var/www/parfumcenter.hu/web/libraries/MysqliDb/MysqliDb.php(751): MysqliDb->_buildQuery() #2 /var/www/parfumcenter.hu/web/system/Shop_functions.php(207): MysqliDb->get() #3 /var/www/parfumcenter.hu/web/modules/product/model/model.php(6): getData() #4 /var/www/parfumcenter.hu/web/system/Router.php(234): require('...') #5 /var/www/parfumcenter.hu/web/index.php(55): require('...') #6 {main} thrown in /var/www/parfumcenter.hu/web/libraries/MysqliDb/MysqliDb.php on line 2014