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 'bo,bad breath,bad smell,be aromatic,be redolent of,body odor,breathe,emit a smel' 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!=31176 AND dictionaryenglish.english='Stink' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=31176 AND dictionaryenglish.english='Disgrace Oneself' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=31176 AND dictionaryenglish.english='Sully One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=31176 AND dictionaryenglish.english='bo,bad breath,bad smell,be aromatic,be redolent of,body odor,breathe,emit a smell,exhale,fetidity,fetidness,fetor,foul breath,foul odor,frowst,funk,graveolence,halitosis,malodor,mephitis,miasma,nidor,noxious stench,offend the nostrils,offensive odor,reek,reeking,rotten smell,smell,smell bad,smell of,smell to heaven,smell up,stench,stench of decay,stink out,stink up,suck,yield an odor') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=31176 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: 83233


Go Back ⇒
Go Home ⇒