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 'According To Rumor' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary,' 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!=49794 AND dictionaryenglish.english='Speech' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=49794 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!=49794 AND dictionaryenglish.english='According To Rumor' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=49794 AND dictionaryenglish.english='esp,address,after-dinner speech,alliteration,allocution,allusion,anacoluthon,anadiplosis,analogy,anaphora,anastrophe,answer,answering,antiphrasis,antithesis,antonomasia,apophasis,aporia,aposiopesis,apostrophe,articulated,articulation,blast,bull session,catachresis,chalk talk,chiasmus,chinfest,choice of words,circumlocution,climax,commerce,communicating,communication,communicational,communion,communional,composition,confab,confabulation,congress,connection,contact,conversation,conversational,converse,conversion,correspondence,dealing,dealings,debate,declamation,dialect,dialogue,diatribe,diction,discourse,disquisition,duologue,ecphonesis,elocution,emphasis,enunciated,enunciation,eulogy,exchange,exclamation,exhortation,expression,filibuster,forensic,forensic address,formal speech,formulation,funeral oration,gemination,grammar,harangue,homily,hortatory address,hypallage,hyperbaton,hyperbole,idiom,inaugural,inaugural address,information,interacting,interaction,interactional,interactive,interchange,intercommunication,intercommunicational,intercommunicative,intercommunion,intercommunional,intercourse,interplay,interresponsive,interrogative,interrogatory,invective,inversion,irony,jargon,jeremiad,language,langue,lecture,line,lingo,lingua,lingual,linguistic,linguistic intercourse,litotes,locution,malapropism,meiosis,message,metaphor,metonymy,nuncupative,onomatopoeia,oral,oral communication,oration,oxymoron,palaver,paregmenon,parenthesis,parlance,parley,parol,parole,pep talk,periphrasis,peroration,personal usage,personification,philippic,phrase,phraseology,phrasing,pitch,pleonasm,prepared speech,prepared text,preterition,prolepsis,pronounced,public speech,question-and-answer session,questioning,reading,recital,recitation,regression,repetition,reply,response,responsive,rhetoric,said,sales pitch,sales talk,salutatory,salutatory address,sarcasm,say,screed,sermon,set speech,simile,similitude,social intercourse,song and dance,sounded,speaking,speech circuit,speech situation,speechification,speeching,spiel,spoken,spoonerism,syllepsis,symploce,synecdoche,talk,talkathon,talkfest,talking,telepathic,telepathy,tirade,tongue,touch,traffic,transmissional,trialogue,truck,two-way communication,unwritten,usage,use of words,usus loquendi,utterance,uttered,valediction,valedictory,valedictory address,verbal,verbalization,verbiage,vernacular,viva voce,vocal,vocalization,vocalized,voice,voiced,voiceful,voicing,wordage,wording,words,zeugma') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=49794 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: 82380


Go Back ⇒
Go Home ⇒