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 'abandon,afflatus,afire,aflame,aggressiveness,agitate,aim at,air,air-dry,alight,a' 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!=30360 AND dictionaryenglish.english='Fire' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=30360 AND dictionaryenglish.english='Angry' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=30360 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!=30360 AND dictionaryenglish.english='abandon,afflatus,afire,aflame,aggressiveness,agitate,aim at,air,air-dry,alight,anhydrate,animate,animating spirit,animation,animus,annoy,antiaircraft fire,ardency,ardent,ardor,arouse,aroused,atom,atomic particles,awake,awaken,ax,axe,backfire,bake,balefire,bang,bank,barbecue,barrage,baste,beacon,beacon fire,begin,blanch,blast,blast away,blast off,blaze,blaze up,blazing,blitz,blot,blow out,blow the coals,blow up,boil,bombard,bombardment,bonfire,boot,boot out,bounce,bowl,braise,break,brew,broadside,broil,brown,brush,brute matter,building block,bump,burn,burning,burning ghat,burning pain,burst,bust,calenture,call forth,call up,campfire,can,candle,cannon,cannonade,cashier,cast,cast at,catapult,chafe,charge,charring,cheerful fire,chemical element,childbed fever,chuck,chuck at,chunk,cock,coddle,combustion,commence,commence firing,commitment,committedness,component,conflagrate,conflagration,constituent,continued fever,cook,corposant,cozy fire,crackling fire,crematory,cross fire,cure,curry,curtain fire,dart,dash,death fire,dedication,defrock,degrade,dehumidify,dehydrate,delay,delirium,demote,deplume,depose,deprive,desiccate,detonate,devil,devotedness,devotion,devoutness,direct fire,disbar,discharge,disemploy,dismiss,displace,displume,dive in,divine afflatus,do,do to perfection,drain,drive,drop,drum out,dry,dry fire,dynamize,eager,eagerness,earnestness,earth,eclat,ecstasy,eject,elan,electric light bulb,electric-heat,electrify,element,elementary particle,elementary unit,embue,energize,energy,enfilade,enkindle,enliven,enlivenment,enrage,enterprise,enthuse,enthusiasm,enthusiastic,eruptive fever,evaporate,exalt,excite,excited,excitement,exhilarate,exhilaration,expel,explode,exsiccate,faith,faithfulness,fall to,fan,fan the fire,fan the flame,febricity,febrility,feed,feed the fire,feeling,fell,fen fire,ferment,fervency,fervent,fervid,fervidness,fervor,fever,fever heat,fever of excitement,feverishness,fidelity,fieriness,file fire,fire a volley,fire at,fire of demolition,fire off,fire up,fire upon,firepower,fireworks,firing,flack,flak,flame,flame up,flaming,flare,flare up,flashing point,flicker,flickering flame,fling,fling at,flip,flush,foment,forest fire,fork,fox fire,frenzy,fricassee,frizz,frizzle,fry,fulminate,fundamental particle,funeral pyre,furlough,furor,fury,fusillade,galvanize,gas-heat,genius,get to,get-up-and-go,ginger,give the ax,give the gate,glare,glaze,glim,glow,go ahead,go off,griddle,grill,ground fire,gun,gun for,gunfight,gunfire,gunplay,gusto,hang fire,head into,heart,hearten,heartiness,heat,heat up,heatedness,heave,heave at,hectic,hectic fever,hectic flush,heighten,high-angle fire,hit,holocaust,horizontal fire,hot,hot up,hot-air-heat,hot-blooded,hot-water-heat,hurl,hurl against,hurl at,hurrah,hurtle,hyle,hyperpyrexia,hyperthermia,hypostasis,ignis fatuus,ignite,ignition,illuminant,illuminator,imbue,impassion,impassionedness,incandescent body,incense,incite,infect,infection,inferno,inflame,inform,infuriate,infuse,infusion,ingle,initiative,inject,inoculate,insolate,inspiration,inspire,inspired,inspirit,instigate,intense,intensify,intensity,intentness,interdiction fire,intermittent fever,invigorate,jazz up,jerk,jump off,key up,kick,kick off,kick out,kick upstairs,kiln,kindle,lambent flame,lamp,lance,lantern,lather up,launch,lay off,let fly,let fly at,let go,let off,let out,light,light bulb,light source,light the fuse,light up,liveliness,liven,load,lob,loyalty,luminant,luminary,machine-gun fire,madden,make redundant,marshfire,match,material,material world,materiality,matter,mold,molecule,monad,moon,mortar,mortar fire,motivate,move,moving spirit,mull,mummify,musketry,natural world,nature,nettle,on fire,open fire,open up on,oust,oven-bake,overexcite,overheat,pan,pan-broil,parboil,parch,pass,passion,passionate,passionateness,peg,pelt,pension off,pep,pep up,pepper,percussion fire,perk up,physical world,pick off,pique,piss and vinegar,pistol,pistol fire,pitch,pitch in,pitchfork,pizzazz,play with fire,plenum,plug,plunge into,poach,poop,pop at,pot,potshoot,potshot,prairie fire,preheat,prepare,prepare food,prime,project,propel,protein fever,provoke,puerperal fever,punch,push,put,put the shot,put up to,pyre,pyrexia,quicken,raging fire,rake,raking fire,rally,rapid fire,read out of,recook,reheat,rekindle,relapsing fever,release,relight,relish,relume,remittent,remittent fever,replace,resolution,retire,ricochet fire,riddle,rifle fire,roast,rouse,rub,rut,sack,salvo,saute,savor,scallop,scorch,scorching,sea of flames,sear,searing,send off,separate forcibly,seriousness,serve,set about,set astir,set fire to,set in,set off,set on,set on fire,set out,set sail,set to,sexual excitement,shape,sheet of fire,shell,shellfire,shirr,shoot,shoot at,shoot down,shoot-out,shooting,shrivel,shy,shy at,sic on,signal beacon,simmer,sincerity,sling,sling at,smart,smarting,smoke,smudge fire,snap,snap up,snipe,snipe at,soak up,soul,source of light,spark,sparkle,spirit,spirit up,sponge,spunk,spunk up,starch,stars,start,start in,start off,start out,steam,steam up,stew,stimulate,stimulated,sting,stinging,stir,stir the blood,stir the embers,stir the feelings,stir the fire,stir up,stir-fry,stirred,stoke,stoke the fire,stoke up,strafe,strike,strike a light,strip,stuff,substance,substratum,summon up,sun,sun-dry,superannuate,superheat,surplus,suspend,swab,take a potshot,take aim at,take fire,take off,taper,tepefy,terminate,the four elements,three-alarm fire,thrill,throw,throw at,thrust,tickle,tilt,time fire,tingle,tingling,toast,torch,torpedo,torrefy,toss,toss at,touch off,towel,trigger,turn a pot,turn off,turn on,turn out,turn to,two-alarm fire,unfrock,unit of being,urethral fever,urtication,vaccinal fever,vehemence,vertical fire,verve,vigor,vim,vitality,vitalize,vivacity,vivify,volley,wake,wake up,waken,warm,warm over,warm the blood,warm up,warmth,warmth of feeling,watch fire,water,water fever,weazen,whet,whip up,wildfire,wipe,witch fire,wither,wizen,work into,work up,wound fever,zeal,zero in on,zest,zing,zip,zip up,zone fire') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=30360 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: 81857