Query Error


MySQL Error  : Query Error
Query        : SELECT x.*, COUNT(z.com_id) as comments FROM book_data x LEFT JOIN book_com z ON (x.id=z.id) WHERE x.accepted='1' AND x.id = 17145 AND x.missionaryid =  GROUP BY x.id ORDER BY x.id DESC LIMIT 0, 1
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 x.id ORDER BY x.id DESC LIMIT 0, 1' at line 1
Requested URI: http://www.missionsite.net/scripts/lazarusgb/index.php?permalink=true&entry=17145
Date         : Fri, October 24, 2014 05:43:37
IP           : 54.237.184.242
Browser      : CCBot/2.0 (http://commoncrawl.org/faq/)
Referer      : 
PHP Version  : 5.3.29
OS           : Linux
Server       : Apache/2.2.22
Server Name  : www.missionsite.net