Alla Produkter

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 'limit 20' at line 1
in:
[SELECT DISTINCT p.products_type, p.products_id,p.products_part_number, pd.products_name,pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, p.master_categories_id, m.manufacturers_id FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) left join products_to_categories p2c on p.products_id = p2c.products_id left join products_description pd on p.products_id = pd.products_id join products_attributes p2a on p.products_id = p2a.products_id join products_options po on p2a.options_id = po.products_options_id join products_options_values pov on p2a.options_values_id = pov.products_options_values_id WHERE p.products_status = 1 AND (p.products_date_available IS NULL OR p.products_date_available <= current_date) AND pd.language_id = 12 AND ( false OR p2a.options_values_id = 102 OR p2a.options_values_id = 105 OR p2a.options_values_id = 106) GROUP BY p.products_id order by limit 20]