Fatal error: mysqli error: [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 'and (md.date BETWEEN '2010-07-05' AND '2010-07-11') GROUP BY urd.manager_id ' at line 3] in EXECUTE("SELECT urd.manager_id AS manager_id,SUM(urd.score) AS scores , u.fname AS fname, u.lname AS lname ,(SELECT teamname FROM teams WHERE manager_id=urd.manager_id) AS teamname,(SELECT id FROM teams WHERE manager_id=urd.manager_id) AS tid FROM `user_rank_daily` urd INNER JOIN fantasy_ifc_live.users u ON urd.manager_id = u.user_id WHERE urd.score >=1 and and (md.date BETWEEN '2010-07-05' AND '2010-07-11') GROUP BY urd.manager_id ORDER BY scores DESC LIMIT 6") in /home/ifl/public_html/football/application/components/NADOdb/NADOdb.php on line 1401