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 'Royal Seal' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, diction' 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!=60140 AND dictionaryenglish.english='Destroy' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='To Destroy' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Ruin' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Eliminate' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Kill' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Diminution' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Decrease' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Lessening' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Cutting Off' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='King\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Royal Seal' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='State Seal' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Summarizing' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='Gathering' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60140 AND dictionaryenglish.english='abolish,abuse,afflict,aggrieve,annihilate,annul,assault,atomize,attack,baffle,balk,barbarize,batter,beat,beat all hollow,beat hollow,befoul,bereave of life,best,bewitch,blast,blight,botch,brave,break down,break up,bring to ruin,brutalize,burn,butcher,cancel out,carry away,carry off,carry on,challenge,checkmate,chloroform,circumvent,condemn,confound,confront,confute,consume,contradict,contravene,corrupt,counter,counteract,countermand,counterwork,cripple,cross,crucify,crush,curse,cut down,cut off,damage,damn,dash,deal destruction,decapitate,decimate,defeat,defile,defy,demolish,deny,deprave,depredate,deprive of life,desolate,despoil,devastate,devitalize,devour,disable,disadvantage,discomfit,disconcert,discountenance,dish,dismantle,dispatch,dispose of,disprove,disrupt,disserve,dissolve,distress,do a mischief,do away with,do evil,do for,do ill,do in,do to death,do wrong,do wrong by,doom,drub,dynamite,elude,end,enfeeble,engorge,envenom,eradicate,execute,exhaust,exterminate,extinguish,extirpate,finish,finish off,fix,flummox,foil,frustrate,get into trouble,go on,gobble,gobble up,gut,gut with fire,hammer,harass,harm,havoc,hex,hide,hors de combat,hurt,immolate,impair,incinerate,infect,injure,interfere with,jinx,kill,knock the chocks,lambaste,lather,launch into eternity,lay in ruins,lay waste,lick,liquidate,loot,lynch,make away with,maltreat,mangle,mar,martyr,martyrize,maul,menace,mistreat,molest,mug,mutilate,negate,neutralize,nonplus,nullify,outclass,outdo,outfight,outgeneral,outmaneuver,outpoint,outrage,outrun,outsail,outshine,overthrow,overturn,perplex,persecute,pillage,play havoc with,play hob with,poison,pollute,prejudice,pull down,pulverize,purge,put,put away,put down,put to death,put to sleep,quench,rage,ramp,rampage,rant,rape,ravage,rave,raze,refute,remove from life,reverse,riot,roar,rub out,rubble,ruin,ruinate,sabotage,sack,sacrifice,savage,scathe,scotch,settle,shatter,shipwreck,shoot,skin,skin alive,slaughter,slay,smash,sow chaos,spike,spoil,starve,stonewall,stop,storm,stump,swallow up,taint,take life,take off,tear,tear around,tear down,terminate,terrorize,thrash,threaten,throw into disorder,thwart,torment,torture,trash,trim,triumph over,trounce,unbuild,undermine,undo,unleash destruction,unleash the hurricane,unmake,upheave,upset,vandalize,vaporize,violate,waste,weaken,whip,wipe,wipe out,worst,wound,wrack,wreak havoc,wreak havoc on,wreck,wrong') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=60140 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: 83118


Go Back ⇒
Go Home ⇒