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 'acculturate,advance,alter,ameliorate,amend,assimilate to,become,better,boost,bri' 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!=46699 AND dictionaryenglish.english='Transform' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=46699 AND dictionaryenglish.english='Move' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=46699 AND dictionaryenglish.english='Change One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=46699 AND dictionaryenglish.english='acculturate,advance,alter,ameliorate,amend,assimilate to,become,better,boost,bring forward,bring to,change,change into,change over,civilize,commute,convert,denature,do over,edify,educate,elevate,emend,enhance,enlighten,enrich,fatten,favor,forward,foster,go straight,improve,improve upon,lard,lift,make,make an improvement,make over,meliorate,mend,metabolize,metamorphose,modify,mutate,naturalize,nurture,permute,promote,raise,reconvert,reduce to,refine upon,reform,render,resolve into,reverse,shift,socialize,straighten out,switch,switch over,transfer,transfigure,translate,transmogrify,transmute,transpose,transubstantiate,turn back,turn into,upgrade,uplift') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=46699 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: 82256