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 'It\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryengl' 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!=32928 AND dictionaryenglish.english='Finished' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=32928 AND dictionaryenglish.english='That\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=32928 AND dictionaryenglish.english='It\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=32928 AND dictionaryenglish.english='attic,ciceronian,sol,ablated,accomplished,ago,all bets off,all off,all over,all up,antiquated,antique,archetypical,asleep,asleep in jesus,at an end,at concert pitch,at rest,ausgespielt,balanced,bankrupt,bereft of life,blasted,blighted,blown over,breathless,broken,buffed,burnished,burnt up,by,bygone,bypast,called home,canceled,career,carrion,chaste,classic,cleaned up,clear,coached,coequal,complete,completed,concluded,consumed,consummate,conversant,coordinate,croaked,cultivated,cultured,dated,dead,dead and buried,dead and gone,death-struck,deceased,decided,defunct,deleted,demised,departed,departed this life,depleted,desolated,destitute of life,destroyed,devastated,developed,direct,dissipated,done,done for,done in,done with,down,down-and-out,drained,easy,eaten up,effete,elapsed,elegant,ended,equal,equilateral,eroded,eurythmic,even,exanimate,exemplary,exhausted,expert,expired,expunged,extinct,fallen,fini,finished up,food for worms,forgotten,fully developed,furbished,glace,glassy,glazed,gleaming,glossy,gone,gone glimmering,gone to glory,gone to pot,gone west,gone-by,graceful,gracile,harmonious,has-been,impoverished,in ruins,inanimate,initiate,initiated,irrecoverable,irremediable,kaput,lacquered,lapsed,late,late lamented,launched into eternity,lifeless,limpid,lucid,martyred,masterful,masterly,mature,matured,model,natural,neat,no more,obsolete,over,overthrown,passe,passed,passed away,passed on,past,pellucid,perfected,perfective,perspicuous,plain,polished,practiced,prepared,primed,professional,proficient,proportioned,pure,pushing up daisies,quintessential,ravaged,refined,regular,released,reposing,resting easy,restrained,ripe,ripened,round,rubbed,ruined,ruinous,run out,sainted,satiny,set at rest,settled,shellacked,shiny,shot,silken,silky,simple,skilled,sleek,sleeping,slick,smitten with death,smooth,spent,spoiled,still,stillborn,straightforward,suave,symmetric,taken away,taken off,tasteful,technical,terminated,terse,through,through with,trained,trim,unaffected,undone,uniform,unlabored,urbane,used up,vanished,varnished,velvety,versatile,virtuosic,washed up,washed-up,wasted,well-balanced,well-set,well-set-up,wiped out,with the lord,with the saints,without life,without vital functions,worn away,worn-out,wound up,wrapped up,wrecked,zapped') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=32928 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