Error No: 0 - MySQL error 1064: 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 ') ) ...' at line 57
Query:
SELECT DISTINCT a.artikli_pk ,a.home_pk ,a.sif_artikel ,a.ean ,a.base_code ,COALESCE(ml.title ,a.title, '') AS title ,COALESCE(ml.artikel ,a.artikel, '') AS artikel ,COALESCE(ml.artikel_2 ,a.artikel_2, '') AS artikel_2 ,COALESCE(concat_ws(' ',a.avtor_ime,a.avtor_priimek), '') AS avtor ,COALESCE(ml.grid_description ,a.grid_description, '') AS grid_description ,COALESCE(ml.opis_kratko ,a.opis_kratko, '') AS opis_kratko ,a.novost ,a.zaloga ,IFNULL(a.stock_type, 0) AS stock_type ,a.stock_incoming ,IFNULL(ml.stock_add_info, a.stock_add_info) AS stock_add_info ,IFNULL(a.stock_control, 0) AS stock_control ,ifnull(a.dobava,0) AS dobava ,a.delivery ,a.akcija ,(CASE ml.visible WHEN 1 then a.visible ELSE 0 END) AS visible ,COALESCE(ml.em,a.em,'') AS em ,COALESCE(ml.price_unit,a.price_unit,'') AS price_unit ,COALESCE(ml.price_unit_dealer_1,a.price_unit_dealer_1,'') AS price_unit_dealer_1 ,a.add_to_cart_type ,a.product_data_group_pk ,ifnull(a.min_quantity,1) AS min_quantity ,ifnull(a.max_quantity,'') AS max_quantity ,ifnull(a.step,1) AS step , 1 relevance ,(SELECT count(*) FROM web_artikli_certificates ac WHERE ac.artikli_pk = a.artikli_pk) certificates ,a.trademarks_pk ,a.product_type ,COALESCE(a.list_view, '') list_view ,COALESCE(a.detail_view, '') detail_view ,(SELECT IFNULL(NULLIF(cenik.cena_akcija,0),cena) FROM web_artikli_cenik cenik WHERE cenik.artikli_pk = a.artikli_pk AND cenik.datum_od <= '2026-04-15' AND cenik.price_levels_pk = 1 ORDER BY cenik.datum_od desc LIMIT 1) cena,1000000 razvrsti FROM web_artikli a LEFT JOIN web_artikli_ml ml ON (ml.artikli_pk = a.artikli_pk AND ml.lang='en') ,web_user_favorites p WHERE ((a.artikli_pk = p.artikli_pk AND p.users_pk = ) ) AND a.visible = 1 AND COALESCE(ml.visible, 1) = 1 AND (IFNULL(a.stock_control, 0) in (0, 2) OR (IFNULL(a.stock_control, 0) = 1 AND COALESCE(a.zaloga, 9999) > 0) ) ORDER BY razvrsti,artikel,artikel_2,sif_artikel LIMIT 0,48
#0 /home/stitchwitchtm/public_html/app/classes/database.php(1403): MySQLDB->fMyQuery('SELECT DISTINCT...')
#1 /home/stitchwitchtm/public_html/app/content/ecommerce/class.ecommerce.content.php(1608): MySQLDB->query('SELECT DISTINCT...')
#2 /home/stitchwitchtm/public_html/app/content/ecommerce/class.ecommerce.content.php(1616): clEcommerceContent->products_list_query(false)
#3 /home/stitchwitchtm/public_html/app/content/ecommerce/class.ecommerce.content.php(1629): clEcommerceContent->products_list_result_set(false)
#4 /home/stitchwitchtm/public_html/app/content/ecommerce/class.ecommerce.content.php(2013): clEcommerceContent->product_list('033-001', false, false)
#5 /home/stitchwitchtm/public_html/app/content/ecommerce/class.ecommerce.content.php(679): clEcommerceContent->pPageTypeProducts()
#6 /home/stitchwitchtm/public_html/app/content/class.content.php(814): clEcommerceContent->pPageContentEcommerce()
#7 /home/stitchwitchtm/public_html/app/content/index.php(282): clContent->pPageContent()
#8 /home/stitchwitchtm/public_html/app/content/index_switch.php(43): include('/home/stitchwit...')
#9 /home/stitchwitchtm/public_html/index.php(37): include('/home/stitchwit...')
#10 {main}