A Database Error Occurred

Error Number: 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 'GROUP BY `c1`.`category_id` ORDER BY `c1`.`category_title` asc, `c1`.`categor...' at line 7

SELECT `c1`.*, `c2`.`category_title` as pcategory, `file`.`file_path` FROM (`category` c1) LEFT JOIN `category` c2 ON `c2`.`category_id`=`c1`.`parent_category_id` LEFT JOIN `file` ON `file`.`file_id`=`c1`.`disply_img` WHERE `c1`.`enabled` = '1' AND `c1`.`category_for` = GROUP BY `c1`.`category_id` ORDER BY `c1`.`category_title` asc, `c1`.`category_id` desc

Filename: /home/vasanaat/public_html/models/category_model.php

Line Number: 17