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 'Suspicious About' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, d' 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!=43039 AND dictionaryenglish.english='Doubt' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=43039 AND dictionaryenglish.english='Suspect' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=43039 AND dictionaryenglish.english='Have One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=43039 AND dictionaryenglish.english='Suspicious About' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=43039 AND dictionaryenglish.english='humism,pyrrhonism,agnosticism,agonize over,all-overs,anxiety,apprehension,apprehensiveness,awake a doubt,be at sea,be diffident,be doubtful,be dubious,be possessive,be skeptical,be uncertain,beat about,call in question,challenge,concern,confutability,contest,contestability,controvertibility,deniability,diffidence,disbelief,disbelieve,discredit,disputability,dispute,disquiet,distrust,distrustfulness,doubtful,doubtfulness,dubiety,dubiousness,dubitancy,fear,feel unsure,flounder,fluctuate,foreboding,greet with skepticism,grope,half believe,half-belief,harbor suspicions,have reservations,hesitate,hesitation,in doubt,incertitude,incredulity,irresolution,leeriness,misdoubt,misgive,misgiving,mistrust,mistrustfulness,puzzle over,qualm,qualmishness,query,question,questionableness,raise a question,refutability,reservations,scepticism,scoff,scoffing,scruple,scrupulousness,self-doubt,shadow of doubt,skepticalness,skepticism,smell a rat,suspect,suspicion,suspiciousness,thrash about,throw doubt upon,total skepticism,treat with reserve,unbelief,uncertainty,vacillate,wariness,waver,wonder,wonder whether,worry') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=43039 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: 81053


Go Back ⇒
Go Home ⇒