A Database Error Occurred

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 'group by p.pro_code' at line 1

SELECT p.* , p1.*,l.total_like FROM cl_product AS p LEFT JOIN product_images AS p1 ON p1.`item_code`=p.`pro_code` LEFT JOIN cl_like AS l ON l.pro_code = p.pro_code WHERE p.`is_deleted`='1' AND p.`status`='1' AND p.selling_status='Approved' AND pro_cat= group by p.pro_code

Filename: /home/suitup/public_html/models/public_model.php

Line Number: 198