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