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 19

SELECT DISTINCT p.products_id, p.products_ei_myynnissa, p.products_quantity, p.products_date_available, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id), products_description pd LEFT JOIN products_to_categories p2c USING (products_id) LEFT JOIN categories c USING (categories_id), products_filter f WHERE p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = '8' AND p.products_carrot = 0 AND find_in_set('0', products_hide_from_groups) = 0 AND find_in_set('0', categories_hide_from_groups) = 0 and p.products_id = f.products_id and (f.options_values_id = '6' AND f.options_id = 0) ORDER BY p.products_date_added DESC, pd.products_name limit 0,