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 'That Doesn\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictio' 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!=38105 AND dictionaryenglish.english='Nonsense' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=38105 AND dictionaryenglish.english='Do not go for free' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=38105 AND dictionaryenglish.english='That\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=38105 AND dictionaryenglish.english='That Doesn\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=38105 AND dictionaryenglish.english='greek,absurdity,absurdness,amphigory,antics,applesauce,babble,babblement,balderdash,baloney,bibble-babble,bilge,blabber,blah,blather,blatherskite,blether,bombast,bosh,buffoonery,bull,bullshit,bunk,bunkum,bushwa,cackle,capering,claptrap,cock,crap,double dutch,double-talk,drip,drivel,drool,eyewash,fantasticalness,fiddle-faddle,fiddledeedee,flapdoodle,flimflam,flummery,folderol,foolishness,frivolity,fudge,fustian,gabble,galimatias,gammon,garbage,gas,gibber,gibberish,gibble-gabble,gobbledygook,gook,guff,hocus-pocus,hogwash,hokum,hooey,horsefeathers,horseplay,hot air,humbug,inanity,jabber,jabberwocky,jargon,jazz,jesting,jiggery-pokery,jokes,joking,ludicrousness,malarkey,mischief,monkey business,monkeyshines,monstrousness,moonshine,mumbo jumbo,mumbo-jumbo,narrishkeit,niaiserie,nonsensicality,outrageousness,pack of nonsense,palaver,piffle,poppycock,pranks,prate,prattle,preposterousness,puffery,punk,rant,ridiculousness,rigamarole,rigmarole,rodomontade,rot,rubbish,shenanigans,shit,silliness,skimble-skamble,stuff and nonsense,stultiloquence,tomfoolery,tommyrot,trash,tricks,tripe,trumpery,twaddle,twattle,twiddle-twaddle,vaporing,waffle,waffling,waggishness,wildness') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=38105 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: 82651


Go Back ⇒
Go Home ⇒