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 'Reflection' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, diction' 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!=36009 AND dictionaryenglish.english='Consciousness' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=36009 AND dictionaryenglish.english='\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=36009 AND dictionaryenglish.english='Reflection' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=36009 AND dictionaryenglish.english='The Right \' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=36009 AND dictionaryenglish.english='advertence,advertency,alertness,all-night vigil,apperception,appreciation,appreciativeness,assiduity,assiduousness,attention,attention span,attentiveness,awareness,brain,care,carefulness,cognition,cognizance,concentration,concern,consideration,diligence,ear,earnestness,experience,faculties,feeling,head,heed,heedfulness,insight,insomnia,insomniac,insomnolence,insomnolency,intellect,intellectual gifts,intellectuals,intelligence,intentiveness,intentness,lidless vigil,mentality,mindfulness,noesis,note,notice,observance,observation,parts,percept,perception,realization,recognition,regard,regardfulness,remark,respect,response,response to stimuli,restlessness,sensation,sense,sense impression,sense perception,senses,sensibility,sensory experience,sentience,sleeplessness,thought,tossing and turning,vigil,wake,wakefulness,wise man,wits') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=36009 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: 83072