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 'abundance,abundantly,acceptably,adequacy,adequate,adequate supply,adequately,ade' 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!=27660 AND dictionaryenglish.english='Enough' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=27660 AND dictionaryenglish.english='That'' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=27660 AND dictionaryenglish.english='S Enough' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=27660 AND dictionaryenglish.english='Okay' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=27660 AND dictionaryenglish.english='That\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=27660 AND dictionaryenglish.english='abundance,abundantly,acceptably,adequacy,adequate,adequate supply,adequately,adequateness,admissibly,agreeably,ample,ampleness,amply,bare minimum,bare sufficiency,barely sufficient,comfortable,commensurate,commensurately,competence,competency,competent,competently,corresponding,decent,decently,due,enrage,equal to,exact measure,fairly,fit,good,good enough,incense,infuriate,ire,just enough,mad,madden,minimal,minimally,minimum,moderately,passably,plenty,plenty good enough,proportionate,proportionately,rather,reasonably,right amount,satisfaction,satisfactorily,satisfactoriness,satisfactory,satisfactory amount,satisfyingly,so-so,steam up,substantial,substantially,sufficiency,sufficient,sufficient for,sufficiently,sufficientness,sufficing,suitable,tolerably,umbrage,up to') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=27660 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: 81986


Go Back ⇒
Go Home ⇒