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 'abiogenesis,access,accession,accomplishment,accretion,accrual,accruement,accumul' 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!=35993 AND dictionaryenglish.english='Development' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=35993 AND dictionaryenglish.english='Effort' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=35993 AND dictionaryenglish.english='Endeavor' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=35993 AND dictionaryenglish.english='Doing One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=35993 AND dictionaryenglish.english='abiogenesis,access,accession,accomplishment,accretion,accrual,accruement,accumulation,action,addition,advance,advancement,aggrandizement,aging,amplification,anacrusis,anagnorisis,angle,appreciation,apprenticeship,archigenesis,architectonics,architecture,argument,ascent,atmosphere,augmentation,background,ballooning,basic training,bass passage,beautification,biogenesis,birth,blastogenesis,bloating,blossoming,boom,boost,bourdon,breaking,breeding,bridge,broadening,budding,buildup,burden,burgeoning,by-product,cadence,catastrophe,characterization,chorus,circumstance,coda,color,complication,condition,conditioning,consequence,consequent,continuity,contrivance,corollary,crescendo,cultivation,denouement,derivation,derivative,design,developmental change,device,digenesis,dilation,discipline,distillate,division,drill,drilling,edema,effect,elaboration,elevation,embellishment,enlargement,epigenesis,episode,eumerogenesis,event,eventuality,eventuation,evolution,evolutionary change,evolvement,evolving,excrescence,exercise,expansion,expatiation,explication,exposition,extension,fable,falling action,fetching-up,figure,flood,flowering,folderol,fostering,fruit,furtherance,gain,gemmation,generation,genesis,germination,gimmick,gradual change,greatening,grooming,growth,gush,happening,harmonic close,harvest,heterogenesis,hike,histogenesis,homogenesis,housebreaking,improvement,in-service training,incident,increase,increment,inflation,interlude,intermezzo,introductory phrase,isogenesis,issue,jump,leap,legacy,line,local color,logical outcome,manual training,maturation,maturescence,maturing,maturity,measure,mellowing,merogenesis,metagenesis,military training,monogenesis,mood,motif,mounting,movement,multiplication,musical phrase,musical sentence,mythos,natural development,natural growth,nonviolent change,nurture,nurturing,occurrence,offshoot,offspring,on-the-job training,ongoing,ornament,orthogenesis,outcome,outgrowth,overgrowth,pangenesis,part,parthenogenesis,passage,perfection,period,peripeteia,phenomenon,phrase,plan,plot,practice,precipitate,preparation,procreation,product,productiveness,progress,progression,proliferation,pullulation,raise,raising,readying,rearing,recognition,refinement,refrain,rehearsal,reproduction,resolution,response,result,resultant,ripening,rise,rising action,ritornello,scheme,seasoning,secondary plot,section,senescence,sequel,sequela,sequence,sequent,situation,slant,sloyd,snowballing,spontaneous generation,spread,sprouting,stanza,statement,story,strain,structure,subject,subplot,surge,swelling,switch,tailpiece,tempering,thematic development,theme,tone,topic,training,tumescence,tutti,tutti passage,twist,unfolding,up,upbringing,upgrowth,upping,upshot,upsurge,upswing,uptrend,upturn,variation,vegetation,verse,vocational education,vocational training,waxing,widening,working-out') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=35993 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: 81961


Go Back ⇒
Go Home ⇒