Reward point query

Error: 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 'DATE(cr.date_added) >= '2013-01-16'DATE(cr.date_added) <= '2013-01-16' GROUP BY ' at line 1
Error No: 1064
SELECT cr.customer_id, CONCAT(c.firstname, ' ', c.lastname) AS customer, c.email, cgd.name AS customer_group, c.status, SUM(cr.points) AS points, COUNT(o.order_id) AS orders, SUM(o.total) AS total FROM customer_reward cr LEFT JOIN `customer` c ON (cr.customer_id = c.customer_id) LEFT JOIN customer_group_description cgd ON (c.customer_group_id = cgd.customer_group_id) LEFT JOIN `order` o ON (cr.order_id = o.order_id) WHERE cgd.language_id = '1'DATE(cr.date_added) >= '2013-01-16'DATE(cr.date_added) <= '2013-01-16' GROUP BY cr.customer_id ORDER BY points DESC LIMIT 0,20 in /home/sbitinfo/public_html/ecommarce/system/database/mysql.php on line 49


in opencart while im searching reward point for customer its giving me this error no.1064.


so please give me solution.

Thank You in advance.

I'm getting the same issue, anyone found a fix for this?

I found the solution here
http://forum.opencart.com/viewtopic.php ... 1&p=376443