An Error Was Encountered
Error Number: 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 'ORDER BY `company` asc' at line 6
SELECT DISTINCT * FROM (`mod_directory_categories_lookup`) JOIN `mod_sub_categories_lookup` ON mod_directory_categories_lookup.bus_id = mod_sub_categories_lookup.bus_id JOIN `mod_directory` ON mod_directory_categories_lookup.bus_id = mod_directory.id WHERE `site_id` = 236 AND live = 1 AND mod_id = 27 AND mod_directory_categories_lookup.cat_id = 11 AND mod_sub_categories_lookup.cat_id = 11 AND mod_sub_categories_lookup.sub_cat_id = ORDER BY `company` asc