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 'Proper Noun' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictio' 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!=829 AND dictionaryenglish.english='Sign' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Asterisk' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Hyphen' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Symbol' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='1 N Sign' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Perception' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Symptom' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Signal' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Advertisement' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Notice' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Document' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Certificate' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Agree' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Give Consent' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Promise' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Give One'' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='S Word សន្យា' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Testament/Asterisk/Coat Of Arms/Hyphen/Rootsign/Sign/Signal/Symbol/Tilde/Token' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Give One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Proper Noun' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='Mark' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=829 AND dictionaryenglish.english='ok,roman candle,abandon,abnormality,accent,accent mark,accept,accredit,acute disease,adumbration,advertisement,affection,affirm,affliction,agent,agree on terms,aid to navigation,ailment,alarm,allergic disease,allergy,alphabet,alphabetic character,alphabetize,alternate,alternative,amber light,amen,analogy,announcement,approve,assign,assure,atrophy,attest,attestation,augury,auspice,authenticate,authorize,autograph,back,backup,bacterial disease,badge,balefire,banner,bar,basis for belief,be sponsor for,beacon,beacon fire,beat the drum,bell,bell buoy,betokening,betokenment,binary digit,birth defect,bit,blight,blinker,blue peter,body of evidence,bond,brand,broad hint,broadside,buoy,cancel,capitalize,cardiovascular disease,cartouche,caution light,certify,chain of evidence,change,changeling,character,characteristic,chronic disease,cipher,circulatory disease,close down,clue,colophon,comparison,complaint,complication,condensation trail,condition,confirm,congenital defect,consign,contract,contrail,copy,cosign,counterfeit,countersecure,countersign,course,cue,custos,cypher,data,datum,defect,deficiency disease,deformity,degenerative disease,deliver,deputy,device,differentia,digit,dip,direct,disability,disease,disorder,dispose of,distemper,documentation,donate,dot,double,dummy,earmark,emblem,employ,enchantment,endemic,endemic disease,endocrine disease,endorse,engage,enlist,ensign,ensure,epidemic disease,equal,equivalent,ersatz,evidence,exchange,exchange colors,exhibit,exponent,expression mark,fact,facts,fake,fantasy,fermata,figure,fill-in,flag,flag down,flare,flash,fog bell,fog signal,fog whistle,foghorn,foreboding,foreshadow,foreshadowing,foreshowing,foretoken,foretokening,forewarning,forgo,formalize,functional disease,fungus disease,gastrointestinal disease,genetic disease,gentle hint,gesticulation,gesture,get rid of,ghost,ghostwriter,give,give a signal,give permission,give the go-ahead,give the imprimatur,give the nod,give thumbs up,give up,glance,glimmer,glimmering,glosseme,go light,gong buoy,graph,grapheme,green light,grounds,grounds for belief,guarantee,guaranty,hail,hail and speak,half-mast,hallmark,handicap,heliograph,hereditary disease,hieroglyph,high sign,hint,hire,hoist a banner,hold,iatrogenic disease,icon,ideogram,ideograph,idiosyncrasy,illness,image,imitation,implication,index,indicant,indication,indicator,indisposition,infectious disease,infirmity,initial,initials,ink,inkling,innuendo,inscribe,insignia,insinuation,insure,international alphabet flag,international numeral pennant,intimation,item of evidence,join up,key signature,keynote,kick,lead,leer,letter,lexeme,lexical form,lexigraphic character,ligature,line,locum tenens,logotype,look,make a sign,make over,makeshift,malady,malaise,manifestation,mark,marker beacon,material grounds,measure,metaphor,metonymy,metronomic mark,miracle,monogram,morbidity,morbus,morpheme,motion,movement,muniments,muscular disease,mute witness,neurological disease,next best thing,nod,notarize,notation,note,notice,nudge,number,numeral,numero,nutritional disease,occupational disease,omen,organic disease,pandemic disease,parachute flare,pass,pass on,pass upon,path,pathological condition,pathology,pause,peculiarity,permit,personnel,phonetic character,phonetic symbol,phony,phrase,pictographic character,picture,piece of evidence,pilot flag,pinch hitter,piste,placard,plant disease,poke,police whistle,portent,poster,prefiguration,preindication,premises,premonitory shiver,premonitory sign,premonitory symptom,presa,present,presignifying,prodigy,prognosis,prognostic,prognostication,promise,prompt,proof,property,prophecy,protozoan disease,proxy,psychosomatic disease,quarantine flag,radio beacon,raise a cry,ratify,reason to believe,rebus,red flag,red light,register,release,relevant fact,relief,relinquish,reminder,replacement,representation,representative,reserves,respiratory disease,retain,ringer,rocket,rockiness,rubber stamp,sacrifice,sailing aid,salute,sanction,say amen to,scent,seal,second,second string,secondary,secondary disease,secure,seediness,segno,semaphore,semaphore flag,semaphore telegraph,semasiological unit,sememe,shadow,shake hands,shingle,show,sickishness,sickness,sigil,sign and seal,sign away,sign for,sign off,sign on,sign over,sign up,sign up for,signal,signal beacon,signal bell,signal fire,signal flag,signal gong,signal gun,signal lamp,signal light,signal mast,signal post,signal rocket,signal shot,signal siren,signal tower,signalize,signature,signboard,signifiant,significant,signs,slur,soothsay,sound an alarm,sound the trumpet,spar buoy,spares,speak,sponsor,spoor,stamp,stand behind,stand up for,stand-in,standard,stop light,strike a bargain,sub,subscribe,subscribe to,substituent,substitute,substitution,succedaneum,suggestion,superseder,supplanter,support,sure sign,surrender,surrogate,suspicion,swear and affirm,swear to,swell,syllabic,symbol,symbolization,symptom,symptomatology,symptomology,symptoms,syndrome,synecdoche,take on,telltale,telltale sign,tempo mark,term,the nod,the pip,the wink,third string,tie,time signature,token,tokening,touch,trace,traces,track,traffic light,traffic signal,trail,trait,transcribe,transfer,transliterate,turn over,type,undersign,understudy,underwrite,unfurl a flag,urogenital disease,utility player,validate,vapor trail,vestige,vicar,vice-president,vice-regent,vinculum,virus disease,visa,vise,volunteer,waive,wake,warning,warrant,wasting disease,watch fire,wave,wave a flag,wave the hand,whisper,white flag,wigwag,wigwag flag,wink,witness,wonder,wonderwork,word,worm disease,writing,written character,yellow flag') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=829 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