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 'abjure,abuse,acknowledge,adjure,administer an oath,affirm,agree,allege,and candl' 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!=52463 AND dictionaryenglish.english='Swear' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=52463 AND dictionaryenglish.english='Break One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=52463 AND dictionaryenglish.english='abjure,abuse,acknowledge,adjure,administer an oath,affirm,agree,allege,and candle,assert,assert under oath,asseverate,assure,attest,aver,avoid,avouch,avow,bear witness,believe in,blaspheme,book,certify,confess,count on,countersign,covenant,curse,curse and swear,cuss,declare,depone,depose,disclose,dysphemize,eschew,execrate,expletive,express the belief,forgo,forsake,forswear,give evidence,give up,go off,guarantee,have confidence in,imprecate,insist,kiss the book,make a promise,oath,pledge,plight,profess,promise,put under oath,put upon oath,rely on,renounce,scatologize,shun,state,swear by,swear by bell,swear in,swear off,swear the truth,swear to,swear to god,swear to goodness,talk dirty,testify,throw over,troth,trust in,undertake,underwrite,use language,vilify,vouch,vouchsafe,vow,warrant,witness') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=52463 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: 84721


Go Back ⇒
Go Home ⇒