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 'Sheaf' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryen' 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!=8157 AND dictionaryenglish.english='Bundle' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Bouquet' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Bunch' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Trouble' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Bother' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Worry' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Concern Oneself' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Worthwhile' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='មិន' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Bundle (of Sugarcane' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='It\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Sheaf' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Sugarcane' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Firewood' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Classifier For Bunches' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Bundles' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Sheaves' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Concerned' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='Necessary' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=8157 AND dictionaryenglish.english='accelerate,amble,array,bale,band,bandage,barge,batch,belt,bend,bind,bind up,bindle,body,bolt,bomb,boodle,bouquet,bow out,bowl along,brace,budget,bunch,bundle off,bundle up,bustle,chain,chase,cinch,clump,cluster,collect,collection,croodle,crowd,cuddle,cuddle up,curl up,dash,dash off,dash on,decamp,deck,dismiss,dispatch,do up,double-time,drag,drive on,expedite,fagot,fardel,fasces,fascine,festinate,float,flounce,foot,footslog,forward,gather together,get going,get moving,gird,girdle,girt,girth,give a start,give the air,give the gate,halt,haste,hasten,hasten on,hie on,hippety-hop,hitch,hobble,hop,hurry,hurry along,hurry on,hurry through,hurry up,hurry-scurry,hustle,hustle out,hustle up,jog,jolt,jump,kick off,lace,lap,lash,launch,leap,leash,limp,lose no time,lot,lumber,lunge,lurch,make haste,mince,mint,move quickly,nestle,nosegay,nuzzle,pace,pack,pack off,package,packet,paddle,parcel,peg,piaffe,piaffer,pile,plod,plunge,post,posy,pot,prance,precipitate,press,press on,push,push on,push through,put in motion,quicken,quiver,race,rack,railroad through,roll,roll up,rope,rouleau,run,rush,rush along,rush through,sashay,saunter,scamper,scramble,scuff,scuffle,scurry,scuttle,send,send away,send forth,send off,send packing,set,set afloat,set agoing,set going,set in motion,set on foot,shamble,sheaf,show the door,show the gate,shuffle,sidle,single-foot,skip,slink,slither,slog,slouch,snug up,snuggle,snuggle up to,speed,speed along,speed up,splice,spur,spurt,stagger,stalk,stamp,stampede,start,start going,start off,start up,stomp,straddle,straggle,strap,stride,stroll,strut,stump,swaddle,swagger,swathe,swing,tear,tie,tie up,tittup,toddle,totter,traipse,trip,trudge,truss,truss up,turn away,turn off,urge,wad,waddle,wamble,whip,whip along,wiggle,wire,wobble,wrap,wrap up') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=8157 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: 81808


Go Back ⇒
Go Home ⇒