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 'ok,roger,absolute,absolutely,acceptable,accurate,adequate,admissible,agreeable,a' 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!=57163 AND dictionaryenglish.english='Alright' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=57163 AND dictionaryenglish.english='Yes' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=57163 AND dictionaryenglish.english='That\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=57163 AND dictionaryenglish.english='ok,roger,absolute,absolutely,acceptable,accurate,adequate,admissible,agreeable,all right,alrighty,amen,as you say,assuredly,aye,better than nothing,by all means,certainly,correct,da,dead right,decent,doing nicely,exactly,fair,fairish,faultless,fine,flawless,good,good enough,goodish,hear,indeed,indeedy,ja,just,just right,just so,letter-perfect,mais oui,meticulous,moderate,most assuredly,naturally,naturellement,not amiss,not bad,not half bad,not so bad,of course,okay,oui,passable,perfect,positively,precisely,presentable,pretty good,proper,quite,rather,really,respectable,right,righto,satisfactory,straight,straight-up-and-down,sufficient,sure,sure thing,surely,tenable,tidy,to be sure,tolerable,truly,unailing,unexceptionable,unobjectionable,unsick,unsickly,up and about,very well,viable,well,well and good,why yes,workmanlike,yea,yeah,yep,yes,yes indeed,yes indeedy,yes sir,yes sirree') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=57163 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: 81861