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 'As Soon As' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, diction' 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!=55198 AND dictionaryenglish.english='Tram' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55198 AND dictionaryenglish.english='Until' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55198 AND dictionaryenglish.english='Bide One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55198 AND dictionaryenglish.english='As Soon As' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55198 AND dictionaryenglish.english='l,branch,cable railway,cog railway,el,electric,electric car,electric railway,elevated,elevated railway,embankment,feeder,feeder line,gravity-operated railway,horse railway,junction,light railroad,line,main line,metro,monorail,rack railway,rack-and-pinion railway,rail,rail line,railroad,railway,roadbed,roadway,sidetrack,siding,street railway,streetcar,streetcar line,subway,switchback,terminal,terminus,track,tramcar,tramline,trestle,trolley,trolley car,trolley line,trunk,trunk line,tube,turnout,underground') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=55198 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: 84370


Go Back ⇒
Go Home ⇒