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 'First' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryen' 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!=58278 AND dictionaryenglish.english='General' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Foremost' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Highest' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Outstanding' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Illustrious' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Highly Placed' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Of High Standing' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Noble' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Of High Rank' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Of High Class' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Excellent' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Best' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Top' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Summit' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Chief\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='First' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Topmost' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Chief' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Older' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Upper' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='Supreme' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58278 AND dictionaryenglish.english='adc,babbittish,co,od,philistine,abstract,accepted,accustomed,across the board,aide,aide-de-camp,aleatoric,aleatory,all-inclusive,amorphous,approximate,ascendant,associated,assorted,at the head,bland,blanket,blended,blobby,blurred,blurry,boss,bourgeois,brigadier,brigadier general,broad,campy,captain,casual,catholic,chance,chancy,chaotic,chicken colonel,chief,chief of staff,civic,civil,collective,collectivistic,colonel,combined,commandant,commander,commander in chief,commanding,commanding officer,commissioned officer,common,commonplace,communal,communistic,community,commutual,company officer,composite,comprehensive,confused,conjoint,controlling,cooperative,cosmopolitan,customary,disordered,diversified,dominant,encyclopedic,everyday,exec,executive officer,extended,extensive,familiar,featureless,field marshal,field officer,first lieutenant,five-star general,foggy,four-star general,fuzzy,general officer,generalissimo,generalized,generic,global,governing,habitual,hazy,head,hegemonic,hegemonistic,heterogeneous,high-camp,hit-or-miss,homely,homespun,humdrum,hybrid,ill-defined,imprecise,imprudent,in ascendancy,in charge,in chief,in common,in the ascendant,inaccurate,inchoate,inclusive,incoherent,indecisive,indefinable,indefinite,indeterminable,indeterminate,indiscreet,indiscriminate,indiscriminative,indistinct,inexact,insensitive,international,jemadar,joint,junior officer,kitschy,lax,leading,lieutenant,lieutenant colonel,lieutenant general,loose,low-camp,major,major general,marechal,marshal,master,miscellaneous,mixed,mongrel,mutual,national,natural,naturalistic,naturistic,nebulous,neutral,nonjudgmental,nonspecific,normal,obscure,officer,one-star general,orderless,orderly,orderly officer,ordinary,overall,panoramic,paramount,plebeian,pop,popular,predominant,predominate,prepollent,preponderant,preponderate,prepotent,prevailing,prevalent,promiscuous,public,random,realistic,reciprocal,regnant,regular,regulating,regulative,regulatory,reigning,risaldar,routine,ruling,run-of-the-mill,senior officer,shadowed forth,shadowy,shapeless,shared,shavetail,sirdar,social,socialistic,societal,sovereign,staff officer,state,stochastic,subahdar,subaltern,sublieutenant,supranational,supreme,sweeping,tactless,the old man,the brass,three-star general,top brass,two-star general,typical,uncharacterized,unclear,uncritical,uncriticizing,undefined,undemanding,undestined,undetermined,undifferentiated,undifferentiating,undiscreet,undiscriminating,undiscriminative,uneventful,unexacting,unexceptional,unfastidious,universal,unmeticulous,unparticular,unplain,unrestricted,unselective,unspecific,unspecified,unsubtle,untactful,usual,vague,veiled,vernacular,vulgar,wholesale,wide,widespread,worldwide') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=58278 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