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 'americanize,anglicize,acclimate,acclimatize,accommodate,acculturate,acculturize,' 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!=59819 AND dictionaryenglish.english='Naturalize' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=59819 AND dictionaryenglish.english='Enter the country' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=59819 AND dictionaryenglish.english='Naturalized' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=59819 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!=59819 AND dictionaryenglish.english='americanize,anglicize,acclimate,acclimatize,accommodate,acculturate,acculturize,accustom,adapt,adjust,admit,adopt,affiliate,assimilate,assimilate to,become,break,break in,bring to,case harden,change,change into,change over,condition,confer citizenship,confirm,convert,do over,domesticate,domesticize,establish,familiarize,fix,gentle,go native,habituate,harden,housebreak,inure,make,make over,orient,orientate,reconvert,reduce to,render,resolve into,reverse,season,shift,switch,switch over,tame,train,transform,turn back,turn into,wont') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=59819 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: 84539