Fatal error: Uncaught exception 'Exception' with message '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 ') then 2 else 1 end) + (1 + rel.rlv) ) as relevance, rel.rlv, mp' at line 2<br />Error No: 1064<br />select distinct p.product_id, pd.name, max(2 / (case p.price >= 35.0000 when 0 then (35.0000 / p.price) else (p.price / 35.0000) end) * (case when category_id in () then 2 else 1 end) + (1 + rel.rlv) ) as relevance, rel.rlv, mp.seller_id, mp.product_status, mp.product_approved, p.quantity as quantity from oc_product p inner join oc_product_description pd on p.product_id = pd.product_id inner join oc_product_to_category pc on p.product_id = pc.product_id JOIN oc_ms_product mp on p.product_id = mp.product_id inner join (SELECT product_id, MATCH(name, des in /home/chopnico/public_html/system/library/db/mysqli.php on line 40