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 'account,adherents,advantageousness,agreeableness,allot,alphabetize,analyze,anima' 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!=54438 AND dictionaryenglish.english='Class' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=54438 AND dictionaryenglish.english='Catch Someone\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=54438 AND dictionaryenglish.english='account,adherents,advantageousness,agreeableness,allot,alphabetize,analyze,animal kingdom,antonomasia,appraise,appreciate,arrange,ashram,assembly,assess,assign,assort,auspiciousness,bearing,beneficialness,benevolence,benignity,binomial nomenclature,biosystematics,biosystematy,biotype,birth,blood,body,bracket,branch,brand,break down,breed,breeding,brethren,brood,caliber,call,caste,catalog,categorize,category,church,churchgoers,clan,classification,classify,codify,cogency,colony,color,commonwealth,commune,communion,community,condition,confession,congregation,consider,deme,denomination,descent,description,desert,digest,discernment,disciples,distinction,divide,division,domain,echelon,economic class,elegance,endogamous group,estate,estimate,evaluate,excellence,expedience,extended family,extraction,factor,fairness,faith,family,favorableness,feather,figure,file,fineness,first-rateness,flock,fold,folk,followers,footing,form,form an estimate,gauge,genotype,genre,gens,genus,give an appreciation,glossology,goodliness,goodness,grace,grade,grain,group,grouping,guess,head,heading,healthiness,helpfulness,hierarchy,hold,house,identify,ilk,importance,index,ism,judge,kidney,kin,kind,kindness,kingdom,kinship group,label,laity,laymen,league,level,line,lineage,list,make an estimation,mark,matriclan,measure,merit,minyan,moiety,nation,nature,niceness,nomenclature,nonclerics,nonordained persons,nuclear family,onomastics,onomatology,order,orismology,parish,parishioners,part,patriclan,pedigree,people,persuasion,phratria,phratry,phyle,phylum,pigeonhole,place,place-names,place-naming,plant kingdom,pleasantness,polyonymy,position,power structure,precedence,predicament,presence,prestige,prize,profitableness,quality,race,range,rank,rate,rating,realm,reckon,refinement,regard,rewardingness,rubric,savoir faire,school,score,sect,section,seculars,separate,sept,series,set,settlement,sheep,sift,skillfulness,social class,society,sort,sort out,soundness,species,sphere,stage,stamp,standing,station,status,stem,stirps,stock,strain,stratum,stripe,style,subcaste,subclass,subdivide,subdivision,subfamily,subgenus,subgroup,subkingdom,suborder,subspecies,subtribe,superclass,superfamily,superiority,superorder,superspecies,systematics,tabulate,taste,taxonomy,terminology,thrash out,tier,title,toponymy,totem,track,tribe,trinomialism,type,usefulness,validity,valuate,value,variety,virtue,virtuousness,weigh,wholeness,winnow,worth,year') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=54438 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: 102107