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 'oregon boat,acoustic tile,antiknock,antlia,asphyxiate,baffler,bazoo,beak,beezer,' 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!=31440 AND dictionaryenglish.english='Muzzle' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=31440 AND dictionaryenglish.english='Gag' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=31440 AND dictionaryenglish.english='Close Someone\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=31440 AND dictionaryenglish.english='oregon boat,acoustic tile,antiknock,antlia,asphyxiate,baffler,bazoo,beak,beezer,bilbo,bill,bond,bonds,bottle up,bridle,bugle,camisole,censor,chains,chaps,choke,choke off,chops,clamp down on,collar,conk,cork,cork up,countenance,crack down on,crush,cuffs,cushion,damp,damp down,dampener,damper,deflate,dial,disarm,drown,dumbfound,embouchure,enchain,extinguish,face,features,fetter,gab,gag,gob,gyves,halter,hamper,hamstring,handcuff,handcuffs,hobble,hobbles,hog-tie,hold down,hopples,hush,hush-hush,hushcloth,irons,jaw,jaws,jowls,jump on,keep down,keep under,kill,kisser,knock out,leading strings,leash,lips,manacle,mandibles,map,maw,maxilla,mouth,muffle,muffler,mug,mush,mute,nares,neb,nib,nose,nostrils,nozzle,olfactory organ,oral cavity,paralyze,pecker,phiz,pillory,pour water on,premaxilla,proboscis,prostrate,puss,put down,put to silence,quash,quell,quench,quiet,quieten,quietener,reins,repress,restraint,restraints,rhinarium,rostrum,schnozzle,shackle,shush,shut down on,silence,silence cloth,silencer,sit down on,sit on,smash,smeller,smother,snoot,snout,soft pedal,soft-pedal,sordine,sordino,sound-absorbing material,soundproofing,soundproofing insulation,sourdine,squash,squelch,stanch,stifle,still,stocks,straightjacket,strait-waistcoat,straitjacket,strangle,stranglehold,strike dumb,stultify,subdue,suffocate,suppress,tether,throttle,trammel,trammels,trap,trunk,truss up,visage,yap,yoke') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=31440 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: 82212


Go Back ⇒
Go Home ⇒