SQL 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 'va hospital,asylum,base hospital,clinic,community hospital,convalescent home,con' at line 1
SELECT candidates.dictionary AS id, COUNT(DISTINCT candidates.deid) AS total, IF(dictionary.level>0,1,0) AS haslevel, dictionarysynonyms.dictionary AS ds FROM (SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47751 AND dictionaryenglish.english='Hospital' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47751 AND dictionaryenglish.english='Clinic' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47751 AND dictionaryenglish.english='Doctor\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47751 AND dictionaryenglish.english='va hospital,asylum,base hospital,clinic,community hospital,convalescent home,convalescent hospital,dispensary,evacuation hospital,field hospital,general hospital,home,infirmary,inpatient clinic,maison de sante,mental hospital,nursing home,osteopathic hospital,outpatient clinic,policlinic,polyclinic,private hospital,proprietary hospital,public hospital,rest home,sanatorium,sanitarium,sick bay,sickbed,sickroom,special hospital,station hospital,surgical hospital,teaching hospital,veterans hospital,voluntary hospital,ward,well-baby clinic') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=47751 AND dictionarysynonyms.synonym=candidates.dictionary WHERE (dictionarysynonyms.ismatch IS NULL OR dictionarysynonyms.ismatch=1) GROUP BY candidates.dictionary ORDER BY ismatch DESC, total DESC, haslevel DESC, dictionary.level LIMIT 40
Error Table ID: 84856