Free delivery on all Australian orders for a limited time!

1064 - 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 ') GROUP BY m.manufacturers_id ORDER BY m.sort_order ASC' at line 21

SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturers_description, m.manufacturers_logo,m.date_added,m.last_modified, m.manufacturers_head_keywords_tag, m.manufacturers_head_desc_tag, m.manufacturers_head_title_tag,m.manufacturers_status, m.features_status FROM manufacturers m, manufacturers_info mi, products p, categories c, products_to_categories p2c WHERE p.products_id = p2c.products_id AND m.manufacturers_status=1 AND p.products_status =1 AND mi.languages_id='1' AND m. manufacturers_id=mi.manufacturers_id AND p. manufacturers_id=m.manufacturers_id AND c.categories_id = p2c.categories_id AND c.categories_id in (0,492,524,518,497,500,505,507,473,496,498,501,522,508,509,520,474,488,489,490,499,510,513,515,475,495,521,511,512,514,517,493,) GROUP BY m.manufacturers_id ORDER BY m.sort_order ASC