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 'Destroy Thoroughly' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary,' 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!=42452 AND dictionaryenglish.english='Pulverize' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=42452 AND dictionaryenglish.english='Ruin' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=42452 AND dictionaryenglish.english='Destroy Someone' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=42452 AND dictionaryenglish.english='Ruin Someone Completely\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=42452 AND dictionaryenglish.english='Destroy Thoroughly' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=42452 AND dictionaryenglish.english='abrade,annihilate,atomize,bang,baste,batter,beat,bray,break into pieces,break to pieces,break up,brecciate,buck,buffet,cleave,comminute,contriturate,crash,crumb,crumble,crunch,crush,cut to pieces,decimate,demolish,destroy,devastate,diffuse,disassemble,disintegrate,dismantle,disperse,disrupt,drub,dynamite,fission,flail,flap,flour,fragment,grain,granulate,granulize,grate,grind,grind to powder,hammer,knock,lambaste,larrup,levigate,make mincemeat of,mash,maul,mill,mince,mull,paste,patter,pelt,pestle,pick to pieces,pommel,pound,powder,pull in pieces,pull to pieces,pummel,rap,reduce to powder,reduce to rubble,rend,rub out,ruin,scatter,scrunch,shard,shatter,shiver,shred,sledgehammer,smash,smash up,smatter,spank,splinter,split,squash,squish,sunder,take apart,tear apart,tear down,tear to pieces,tear to shreds,tear to tatters,thrash,thresh,thump,total,triturate,unbuild,undo,unmake,wallop,whip,wrack up,wreck') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=42452 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: 81059


Go Back ⇒
Go Home ⇒