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 'abandon,accept,accord,acknowledge,admit,admit everything,admit exceptions,agree ' 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!=56688 AND dictionaryenglish.english='Concede' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=56688 AND dictionaryenglish.english='Give In' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=56688 AND dictionaryenglish.english='Retreat' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=56688 AND dictionaryenglish.english='Unreformed' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=56688 AND dictionaryenglish.english='Surrender One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=56688 AND dictionaryenglish.english='abandon,accept,accord,acknowledge,admit,admit everything,admit exceptions,agree provisionally,allow,allow for,assent grudgingly,avow,award,cede,come clean,confess,consider,consider the circumstances,consider the source,cop a plea,discount,disregard,express general agreement,give up,go along with,grant,let on,lift temporarily,make allowance for,not oppose,open up,out with it,own,own up,plead guilty,provide for,recognize,relax,relax the condition,relinquish,resign,set aside,spill,spill it,spit it out,submit,surrender,take account of,take into account,take into consideration,tell all,tell the truth,vouchsafe,waive,warrant,yield') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=56688 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: 81769


Go Back ⇒
Go Home ⇒