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 'anniversary,annual holiday,bicentenary,bicentennial,biennial,bissextile day,cent' 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!=32794 AND dictionaryenglish.english='Birthday' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=32794 AND dictionaryenglish.english='Royal Birthday' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=32794 AND dictionaryenglish.english='Monk\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=32794 AND dictionaryenglish.english='anniversary,annual holiday,bicentenary,bicentennial,biennial,bissextile day,centenary,centennial,commemoration,decennial,diamond jubilee,golden wedding anniversary,holy days,immovable feast,jubilee,leap year,name day,natal day,octennial,quadrennial,quasquicentennial,quincentenary,quincentennial,quinquennial,septennial,sesquicentennial,sextennial,silver wedding anniversary,tercentenary,tercentennial,tricennial,triennial,wedding anniversary') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=32794 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: 81996


Go Back ⇒
Go Home ⇒