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 'LIMIT 0,5' at line 4
SELECT DISTINCT p.productID as productID, p.name_ru AS name, p.Price, p.list_price, p.slug FROM SC_products as p left join SC_products as p2 on p2.productID=23323 left join SC_product_options_values as pov on p.productID=pov.productID where LIMIT 0,5