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 'acceptable,acknowledging,affable,agreeable,amiable,amicable,appreciative,beholde' 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!=59632 AND dictionaryenglish.english='Grateful' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=59632 AND dictionaryenglish.english='Express One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=59632 AND dictionaryenglish.english='acceptable,acknowledging,affable,agreeable,amiable,amicable,appreciative,beholden,blissful,cheerful,cognizant of,comforting,compatible,complaisant,congenial,consoling,cordial,crediting,delectable,delicious,delightful,desirable,dulcet,en rapport,enjoyable,fair,fair and pleasant,favorable,felicific,felicitous,fine,genial,good,goodly,gracious,gratified,gratifying,harmonious,heart-warming,honeyed,indebted to,likable,mellifluous,mellow,much obliged,nice,obliged,pleasant,pleased,pleasing,pleasurable,pleasure-giving,pleasureful,refreshing,rejuvenating,restorative,restoring,rewarding,satisfying,sensible,sweet,thankful,under obligation,welcome') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=59632 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: 83071


Go Back ⇒
Go Home ⇒