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 'cain,aborticide,apache,assassin,assassination,assassinator,blood,bloodletter,blo' 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!=61510 AND dictionaryenglish.english='Homicide' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=61510 AND dictionaryenglish.english='Annihilate' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=61510 AND dictionaryenglish.english='Destroy' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=61510 AND dictionaryenglish.english='Exterminate' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=61510 AND dictionaryenglish.english='Perish' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=61510 AND dictionaryenglish.english='Lose One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=61510 AND dictionaryenglish.english='cain,aborticide,apache,assassin,assassination,assassinator,blood,bloodletter,bloodshedder,bloody murder,bravo,bumping-off,burker,butcher,button man,cannibal,cutthroat,desperado,elimination,eradicator,executioner,exterminator,foul play,fratricide,fungicide,garroter,genocide,germicide,gorilla,gun,gunman,gunsel,hatchet man,head-hunter,herbicide,hit man,homicidal maniac,infanticide,insecticide,killer,killing,liquidation,man-eater,man-killer,manslaughter,manslayer,massacrer,matador,matricide,microbicide,murder,murderer,parricide,patricide,pesticide,poison,poisoner,purge,purging,regicide,removal,rodenticide,slaughterer,slayer,sororicide,strangler,suicide,thug,thuggee,thuggery,thuggism,torpedo,trigger man,uxoricide,vermicide') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=61510 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: 81867