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 deal.id' at line 1

SELECT deal.* from tbl_deal_category_relation as cat,tbl_deals as deal WHERE TIMESTAMPDIFF(HOUR,NOW(),FROM_UNIXTIME(deal.end_date)) < 10 AND TIMESTAMPDIFF(HOUR,NOW(),FROM_UNIXTIME(deal.end_date)) >= 0 AND deal.status=1 AND deal.id=cat.deal_id AND cat.category_id = group by deal.id

Filename: models/Dealsmodel.php

Line Number: 422