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,a fortiori,above all,absolutely,actually,all joking aside,all right,all' 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!=37488 AND dictionaryenglish.english='Indeed' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=37488 AND dictionaryenglish.english='So That\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=37488 AND dictionaryenglish.english='ok,roger,a fortiori,above all,absolutely,actually,all joking aside,all right,all the more,alright,alrighty,amen,and no mistake,as you say,assuredly,at all events,at any rate,aye,by all means,certainly,chiefly,clearly,da,decidedly,decisively,definitely,demonstrably,distinctly,dominantly,doubtlessly,easily,especially,even,ever so,exactly,factually,fine,first of all,for a certainty,for a fact,for certain,for real,for sure,forsooth,good,good enough,hear,historically,in all conscience,in chief,in fact,in reality,in the main,in truth,in very sooth,indeedy,indubitably,ja,just so,mainly,mais oui,manifestly,more than ever,most assuredly,most certainly,mostly,naturally,naturellement,nay,never so,no end,nothing else but,noticeably,observably,obviously,of a truth,of course,okay,oui,particularly,patently,peculiarly,positively,precisely,predominantly,primarily,principally,quite,rather,really,really-truly,right,righto,sensibly,seriously,still,still more,sure,sure thing,surely,to a certainty,to be sure,truly,truthfully,unambiguously,undeniably,undoubtedly,unequivocally,unmistakably,verily,veritably,very well,visibly,well and good,why yes,with truth,without doubt,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=37488 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: 80917


Go Back ⇒
Go Home ⇒