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 'Muttering' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictiona' 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!=58044 AND dictionaryenglish.english='Whispering' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58044 AND dictionaryenglish.english='Under One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58044 AND dictionaryenglish.english='Muttering' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58044 AND dictionaryenglish.english='Mumbling' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=58044 AND dictionaryenglish.english='aspiration,bated breath,breath,breathy voice,buzz,cry,drone,droning,exhalation,gabble,gibber,gibbering,gossip,grapevine,hearsay,jabber,jibber,little voice,low voice,maundering,mouthing,mumble,mumbling,murmur,murmuration,murmuring,murmurish,murmurous,mutter,muttering,rumble,rumor,rustling,scuttlebutt,sigh,soft voice,stage whisper,still small voice,susurrant,susurration,susurrous,susurrus,talk,underbreath,undertone,whisper,whispery') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=58044 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: 83398


Go Back ⇒
Go Home ⇒