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 'autobahn,spartan,us highway,abandonment,abbreviated,abort,about,about to be,abri' 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!=47199 AND dictionaryenglish.english='Close' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47199 AND dictionaryenglish.english='Adjacent' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47199 AND dictionaryenglish.english='Very Close' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47199 AND dictionaryenglish.english='Neck And Neck' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47199 AND dictionaryenglish.english='On Someone\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47199 AND dictionaryenglish.english='autobahn,spartan,us highway,abandonment,abbreviated,abort,about,about to be,abridged,abstruse,accented,accommodate,accost,accurate,adjacent,adjust,advance,agree,airless,airtight,alert,all but,alley,alleyway,almost,along toward,alongside,already in sight,alveolar,angustifoliate,angustirostrate,angustisellate,angustiseptal,apical,apico-alveolar,apico-dental,aposiopestic,approach,approaching,appropinquate,approximate,approximately,approximating,approximative,arcane,arena,arm-in-arm,around,arrange,arterial,arterial highway,arterial street,artery,articulated,as good as,assiduous,assimilated,at close quarters,at hand,attached,attentive,autistic,autoroute,autostrada,avaricious,avenue,back,bang,bar,barricade,barytone,bashful,batten,batten down,battle,bear down on,bear down upon,bear up,beclouded,belt highway,bilabial,blind,blind alley,block,block up,blockade,bolt,bonded,boulevard,box,brawl,breakoff,breathless,breezeless,brewing,brief,bristling,broad,broil,brusque,buddy-buddy,buried,burning,button,button up,bypass,byway,cabalistic,cacuminal,camino real,careful,carriageway,causeway,causey,cease,ceasing,cemented,censored,center,central,centralize,cerebral,cessation,chaussee,cheap,checked,cheek-by-jowl,chock,choke,choke off,cincture,circumferential,circumscribed,clap,clash,classified,climax,clinch,clipped,clos,close,close about,close at hand,close by,close down,close in,close off,close tight,close up,close with,close-fitting,close-knit,close-lipped,close-textured,close-tongued,close-woven,closed,closefisted,closely,closemouthed,closing,clouded,collide,combat,come,come closer,come forward,come near,come on,come to blows,come together,come up,coming,compact,compacted,compactly,comparable,compass,compass about,compendious,complete,completing,completion,compose,compressed,concealed,concenter,concentralize,concentrate,concentrated,concise,conclude,conclusion,concrete,condensed,confidential,confine,confined,confining,confront,congested,connect,conscientious,consolidated,consonant,consonantal,constant,constrict,constricted,contain,container,contend,contest,continuant,contract,contracted,converge,coop,corduroy road,correct,county road,court,courtyard,cover,covered,covert,crammed,crammed full,cramp,cramped,crawling,crescent,crisp,critical,croft,crowd,crowded,cryptic,cul-de-sac,culmination,curt,curtilage,cut,cut and thrust,dark,dead-end street,debar,decline,delicate,delimited field,demanding,dense,densely,dental,desinence,desistance,detailed,determine,devoted,dike,direct,dirt road,discontinuance,discontinuation,discontinue,discreet,disregard,dissimilated,dissociable,docked,dog,dorsal,draw near,draw nigh,drive,driveway,duel,dumb,dustproof,dusttight,eclipsed,economical of words,elliptic,embay,embosom,embrace,enclasp,enclave,enclose,enclosure,encompass,encounter,end,ending,enfold,enigmatic,envelop,environ,enwrap,epigrammatic,esoteric,establish,evasive,even,exact,exacting,exchange blows,exigent,express,expressway,exquisite,faithful,fall in with,familiar,fast,fast by,fasten,fastened,fence,feud,field,fight,fight a duel,fine,finical,finicking,finicky,finish,finish up,finishing,firm,firmly,fix,fixed,flat,fold,fold up,forthcoming,forty,freeway,front,full,full development,funnel,fussy,fusty,future,gain upon,gasproof,gastight,gathering,give and take,give satisfaction,glide,glossal,glottal,glued,gluey,gnomic,go around,go round,going to happen,grapple,grapple with,gravel road,ground,guarded,guttural,hand and glove,hand-in-hand,hard,hard by,hardfisted,heavily,heavy,hereabout,hereabouts,hermetic,hermetically sealed,hid,hidden,high,highroad,highway,highways and byways,homestretch,homologous,hot,humid,hush-hush,ignore,ill-ventilated,illiberal,immediate,imminent,impendent,impending,impenetrable,impermeable,in a cloud,in a fog,in danger imminent,in eclipse,in prospect,in purdah,in reserve,in spitting distance,in store,in the cards,in the neighborhood,in the offing,in the vicinity,in the wind,in the wings,in view,incapacious,incommodious,incommunicado,incompatible,indisposed to talk,inerrable,inerrant,infallible,inseparable,insociable,instant,intense,intent,intersect,interstate highway,intimate,intonated,invest,involve,isthmian,isthmic,jam,jam-packed,jammed,join,jostle,joust,just about,key,kill,kraal,labial,labiodental,labiovelar,laconic,lane,lap,lapse,last lap,last round,last stage,latch,latent,lateral,lax,light,lightproof,lighttight,like,limited,lingual,liquid,list,local road,lock,lock out,lock up,looming,lot,low,lowering,lurking,main drag,main road,make,make up,massive,mathematical,maturation,maturity,meager,mean,meet,menacing,meticulous,mews,micrometrically precise,microscopic,mid,mingy,minuscule,minute,miserly,mix it up,monophthongal,mopey,mopish,morose,motorway,much at one,much the same,muggy,mum,musty,mute,muted,mysterious,narrow,narrow the gap,nasal,nasalized,near,near at hand,near the mark,nearabout,nearabouts,nearby,nearing,nearish,nearly,nearly the same,nice,niggardly,nigh,nigh about,nighhand,nighish,nip,nongregarious,nonporous,not far,not far from,not quite,obfuscated,obscure,obscured,obstruct,obturate,occlude,occlusive,occult,oilproof,oiltight,on the horizon,only a step,open,oppressive,overhanging,overlook,oxytone,pack,packed,padlock,painstaking,palatal,palatalized,pale,paling,pally,palsy-walsy,parcel of land,park,parkway,parsimonious,particular,patch,pave,paved road,pen,penny-pinching,penurious,perfection,perorate,pharyngeal,pharyngealized,phonemic,phonetic,phonic,pike,pinch,pinchfisted,pinching,pinpoint,pitch,pitched,pithy,place,plank road,plat,plot,plot of ground,plumb,pointed,populous,posttonic,practically,precise,precisianistic,precisionistic,preparing,pretty near,primary highway,private,private road,privy,propinque,proximal,proximate,pruned,punctilious,punctual,quad,quadrangle,quarrel,quasi,quiet,rainproof,raintight,rassle,real estate,recondite,refined,relatable,religious,religiously exact,relinquishment,renunciation,reserved,resolve,restricted,reticent,retroflex,right-of-way,rigid,rigorous,ring road,riot,ripeness,road,roadbed,roadway,round,round about,rounded,rounding off,rounding out,route nationale,row,royal road,run a tilt,run together,same but different,save-all,scant,scanty,scientific,scientifically exact,scramble,scrap,scratch,scrupulous,scrutinizing,scuffle,seal,seal off,seal up,sealed,searching,secluded,secluse,secondary road,secret,secretive,section,secure,self-contained,self-sufficient,semivowel,sententious,sequestered,serried,set,settle,settle with,severe,shifty,short,short and sweet,shortened,shut,shut down,shut fast,shut off,shut out,shut the door,shut tight,shut up,shut up shop,shutdown,side-by-side,sidle up to,sign,silent,similar,skirmish,slam,slender,smokeproof,smoketight,smothered,snap,snug,socially incompatible,soft,solid,solidly,sonant,spar,sparing of words,speechless,speedway,square,squeeze,squeeze shut,stale,state highway,staunch,step up,sticky,stifle,stifled,stifling,stingy,stop,stop up,stopped,stopping,stormproof,stormtight,straighten out,strait,strangle,strangulate,street,stressed,strict,strive,strong,struggle,stuck,stuffy,substantial,subtle,succinct,suffocate,suffocating,sullen,sultry,summary,superhighway,suppressed,surcease,surd,surround,suspend,swarming,switch off,syllabic,synopsized,taciturn,taped,taper,teeming,tense,terminate,termination,terminus,terrace,terse,that will be,theater,thereabout,thereabouts,thick,thick as thieves,thick-growing,thickly,thickset,thorough,thoroughfare,threatening,throaty,through street,thrust and parry,thruway,tight,tight-fisted,tight-lipped,tightfisted,tilt,tiny,to come,to the point,toft,toll road,tonal,tongue-tied,tonic,top secret,topping off,tourney,township road,tract,truncated,turn off,turnpike,tussle,twangy,ulterior,unaccented,unbreatheable,unclubbable,uncommunicative,uncompanionable,uncongenial,under an eclipse,under cover,under house arrest,under security,under wraps,underground,undeviating,undisclosable,undisclosed,undivulgable,undivulged,unerring,unfriendly,ungenerous,ungenial,unite,unknown,unloquacious,unrevealable,unrevealed,unrounded,unsociable,unsocial,unspoken,unstressed,untalkative,untellable,untold,unutterable,unvented,unventilated,unwhisperable,upcoming,velar,vicinal,viscid,viscose,viscous,vocalic,vocoid,voiced,voiceless,vowel,vowellike,wage war,waiting,war,warm,water-repellant,waterproof,watertight,weak,wedged,well-nigh,wide,wind up,windless,windproof,windtight,windup,within call,within earshot,within hearing,within reach,word-bound,wordless,work out,wrap,wrapped in clouds,wrestle,wynd,yard,zip up,zipper') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=47199 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: 82450


Go Back ⇒
Go Home ⇒