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 'ok,roger,absolutely,all right,alright,alrighty,amen,and no mistake,as you say,as' 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!=35551 AND dictionaryenglish.english='Surely' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=35551 AND dictionaryenglish.english='That\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=35551 AND dictionaryenglish.english='ok,roger,absolutely,all right,alright,alrighty,amen,and no mistake,as you say,assuredly,at all events,at any rate,aye,beyond question,by all means,certainly,clearly,confidently,da,decidedly,decisively,definitely,determinedly,distinctly,doggedly,doubtless,doubtlessly,exactly,fatefully,fine,firmly,for a certainty,for a fact,for certain,for sure,forsooth,good,good enough,hear,in truth,indeed,indeedy,indefeasibly,indubitably,ineluctably,inescapably,inevasibly,inevitably,inexorably,inflexibly,irrevocably,ja,just so,mais oui,most assuredly,most certainly,naturally,naturellement,necessarily,nothing else but,of course,okay,oui,positively,precisely,quite,rather,really,relentlessly,right,righto,securely,solidly,steadily,sure,sure thing,to a certainty,to be sure,truly,unavoidably,uncontrollably,undoubtedly,unequivocally,unfalteringly,unmistakably,unpreventably,unquestionably,unswervingly,unyieldingly,very well,well and good,why yes,yea,yeah,yep,yes,yes indeed,yes indeedy,yes sir,yes sirree') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=35551 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: 81894


Go Back ⇒
Go Home ⇒