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 'Me Too' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionarye' 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!=33703 AND dictionaryenglish.english='Also' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=33703 AND dictionaryenglish.english='Yes' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=33703 AND dictionaryenglish.english='That\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=33703 AND dictionaryenglish.english='Me Too' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=33703 AND dictionaryenglish.english='above,additionally,again,all included,along,altogether,among other things,and,and all,and also,and so,as well,au reste,beside,besides,beyond,correspondingly,else,en plus,extra,farther,for lagniappe,further,furthermore,in addition,in like manner,inter alia,into the bargain,item,likewise,more,moreover,on the side,on top of,over,plus,similarly,so,still,then,therewith,to boot,too,vet,yea,yet') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=33703 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: 81869


Go Back ⇒
Go Home ⇒