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 = 19478 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=19478
Date         : Wed, June 19, 2013 07:32:17
IP           : 184.73.7.143
Browser      : CCBot/2.0
Referer      : 
PHP Version  : 5.4.11
OS           : Linux
Server       : Apache
Server Name  : www.missionsite.net