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 'tommy,tommy atkins,absolute,anonymous,antisocial,behind closed doors,buck privat' 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!=55316 AND dictionaryenglish.english='Private' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55316 AND dictionaryenglish.english='Individual' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55316 AND dictionaryenglish.english='One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55316 AND dictionaryenglish.english='tommy,tommy atkins,absolute,anonymous,antisocial,behind closed doors,buck private,certain,clandestine,closet,common soldier,concealed,concrete,confidential,confidentially,covert,covertly,deep-seated,defined,definite,detailed,determinate,different,discreet,distinct,distinguished,enlisted man,esoteric,especial,exceptional,exclusive,express,extraordinary,fixed,furtively,genitalia,genitals,grunt,hermitical,hidden,hush-hush,hushed,idiosyncratic,immanent,implanted,implicit,in camera,in private,in secret,inaccessible,inalienable,incognito,individual,indwelling,infantryman,infixed,ingrained,inherent,inmost,inner,innermost,inside,interior,internal,intimate,intrinsic,inward,inwrought,irreducible,isolated,minute,noncommissioned officer,not for publication,noteworthy,off the record,on the sly,own,particular,peculiar,personal,personally,precise,private first class,privately,privileged,privy,reclusive,reserved,resident,respective,restricted,restrictive,reticent,retired,retiring,secluded,seclusive,secret,secretively,secretly,sequestered,several,sex organs,singular,sneakily,sneaking,sneakingly,solipsistic,solitary,special,specific,sub rosa,subjective,surreptitious,surreptitiously,top secret,unalienable,unchallengeable,uncommunicative,undisclosed,unofficial,unquestionable,unsociable,unsocial,withdrawn') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=55316 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: 102151