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 'adamite,bund,festschrift,rochdale cooperative,affiliation,age group,aggregate,al' 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!=37728 AND dictionaryenglish.english='Body' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=37728 AND dictionaryenglish.english='Move' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=37728 AND dictionaryenglish.english='Change One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=37728 AND dictionaryenglish.english='adamite,bund,festschrift,rochdale cooperative,affiliation,age group,aggregate,alliance,amount,amplitude,an existence,ana,anatomy,anthology,aquarium,area,array,ascender,ashes,ashram,assemblage,assembly,association,axis,back,band,basis,bastard type,batch,battalion,beard,being,belly,best part,better part,bevel,bevy,bigness,black letter,bloc,block,bodily size,body-build,bones,branch,breadth,brigade,budget,build,bulk,bunch,bundle,burden,cabal,cadaver,cake,caliber,cap,capital,carcass,carrion,case,cast,caste,cat,chap,character,chrestomathy,church,clan,class,clay,clique,clod,clump,cluster,coalition,coarseness,cohort,collectanea,collection,college,colony,combination,combine,committee,common market,commonwealth,commune,communion,community,company,compilation,complement,concrete,concreteness,concretion,confederacy,confederation,conglomerate,conglomeration,congress,consistency,consumer cooperative,contingent,cooperative,cooperative society,core,corporealize,corporify,corps,corpse,corpulence,corpus,corpus delicti,coterie,council,counter,coverage,covey,creature,credit union,crew,critter,crowbait,crowd,crux,customer,customs union,data,dead body,dead man,dead person,decedent,denomination,density,depth,descender,detachment,detail,diameter,dimension,dimensions,distance through,division,dry bones,duck,durability,dust,earth,earthling,economic class,economic community,em,embalmed corpse,embody,en,endogamous group,entelechy,entity,essence,essentials,expanse,expansion,extended family,extension,extent,face,faction,family,fat-faced type,fatness,federation,feet,fellow,fellowship,figure,firmness,fleet,flesh,florilegium,font,food for worms,form,frame,fraternity,free trade area,fullness,fund,fundamental,fuselage,gang,gauge,generality,gens,girth,gist,gravamen,greatness,groove,groundling,group,grouping,groupment,guy,hand,head,heart,height,holdings,homo,hulk,hull,human,human being,in-group,incarnate,incorporate,individual,italic,joker,junta,kinship group,knot,largeness,late lamented,league,length,letter,library,life,ligature,living soul,logotype,lot,lower case,lump,machine,magnitude,main body,major part,majority,majuscule,man,mass,masses,material body,materiality,materialize,measure,measurement,meat,menagerie,minuscule,mob,moiety,monad,mortal,mortal remains,most,movement,mummification,mummy,museum,nick,node,nose,nuclear family,number,object,offshoot,one,order,organic remains,organism,organization,out-group,outfit,pack,palpability,parcel,partnership,party,peer group,person,persona,personage,personality,personify,persuasion,phalanx,phratria,phratry,phyle,physical body,physique,pi,pica,pith,platoon,plurality,point,political machine,ponderability,posse,print,proportion,proportions,purport,quantity,quantum,radius,range,raw data,reach,reembody,regiment,reincarnate,relics,religious order,reliquiae,remains,richness,ring,roman,salon,sans serif,scale,schism,school,scope,script,sect,sectarism,segment,sense,set,settlement,shank,shape,shoulder,single,size,skeleton,small cap,small capital,social class,society,solid,solid body,solidity,soma,somebody,someone,something,soul,soundness,spread,squad,stability,stable,stamp,staple,steadiness,stem,stiff,stock,stoutness,strength,string,sturdiness,subcaste,substance,substantiality,substantialize,substantialness,substantiate,substantify,sum,tangibility,team,tellurian,tenement of clay,terran,the dead,the deceased,the defunct,the departed,the loved one,the third dimension,thickness,thing,thrust,torso,total,totem,toughness,transmigrate,treasure,tribe,troop,troupe,trunk,type,type body,type class,type lice,typecase,typeface,typefounders,typefoundry,union,unit,upper case,upshot,variety,version,viscosity,volume,whole,width,wing,worldling,zoo') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=37728 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: 81706


Go Back ⇒
Go Home ⇒