MySQL error in file: /catalog.php at line 427

Error Number: 1064

The Error returned was:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and `price` >= '0' and `price` <= '999999' and (`color`>=0) and (`manufacturer' at line 1

SQL query:

SELECT `id`, `url`, `name`, `price`, `foto`, `sale`, `time`, `tovar_day`, `tovar_week`, `discount`, `category_id`, `podcategory_id`, `color`, `modules`, `product_length`, `product_length_2`, `product_width`, `product_width_2`, `product_width_3`, `product_width_4`, `product_height`, `product_height_2`, `manufacturer_id`, `index_color` FROM dle_products WHERE `status` = '0' and () and `price` >= '0' and `price` <= '999999' and (`color`>=0) and (`manufacturer_id`>0) and `product_width` >= '0' and `product_width` <= '999999' and `product_height` >= '0' and `product_height` <= '999999' and `product_length` >= '0' and `product_length` <= '999999' and (`material`>=0) ORDER BY sale desc LIMIT 20