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 'Confused' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionar' 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!=56641 AND dictionaryenglish.english='Bore' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=56641 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!=56641 AND dictionaryenglish.english='Confused' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=56641 AND dictionaryenglish.english='acupunctuation,acupuncture,aggravation,annoyance,auger,bad news,be tedious,bedevilment,billow,bite,bore stiff,bore to death,bore to distraction,bore to tears,boring,bother,botheration,bothersomeness,breakers,broach,burrow,buttonhole,buttonholer,caliber,chop,choppiness,chopping sea,comb,comber,countersink,crashing bore,delve,devilment,diameter,difficulty,dig,dig out,dike,dirty water,discompose,discontent,disquiet,dogging,downer,drag,dredge,drill,drill hole,drip,drive,dryasdust,dusty,eagre,empierce,empiercement,ennui,exasperation,excavate,exhaust,fix,fixing,flat tire,frightful bore,furrow,gape,gaup,gawk,glare,gloat,goggle,gore,goring,gouge,gouge out,gravity wave,groove,ground swell,grub,harassment,harrying,headache,heave,heavy sea,heavy swell,hole,hollow out,honeycomb,hounding,humdrum,impale,impalement,jade,lance,lancing,leave unsatisfied,lift,lop,lower,mine,molestation,needle,nuisance,pall,peak,peer,penetrate,penetration,perforate,perforation,persecution,pest,pierce,piercing,pill,pink,popple,prick,pricking,problem,proser,punch,punching,puncture,puncturing,quarry,radius,ream,ream out,riddle,riffle,ripple,rise,roll,roller,rough water,run through,sap,scend,scoop,scoop out,scrabble,scrape,scratch,sea,semidiameter,send,send to sleep,shovel,sink,skewer,skewering,spade,spear,spike,spit,stab,stare,stick,surf,surge,swell,tap,terebration,tidal bore,tidal wave,tide wave,tire,transfix,transfixation,transfixion,transforation,transpierce,trench,trepan,trepanning,trephine,trephining,trial,trouble,trough,tsunami,tunnel,twaddler,undulation,vexation,vexatiousness,water wave,wave,wavelet,wear out,weary,wet blanket,white horses,whitecaps,worriment,worry') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=56641 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: 81021


Go Back ⇒
Go Home ⇒