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 'Come On' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, 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!=55466 AND dictionaryenglish.english='Well' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55466 AND dictionaryenglish.english='Let\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55466 AND dictionaryenglish.english='Come On' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55466 AND dictionaryenglish.english='Lets Go' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55466 AND dictionaryenglish.english='Lets' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=55466 AND dictionaryenglish.english='ably,abysm,abyss,acceptably,adeptly,adequately,adroitly,agilely,all right,all the way,altogether,amply,appropriately,approvingly,aptly,aright,artfully,artificial lake,artistically,baths,bayou lake,becomingly,benignantly,benignly,beyond all expectation,blow out,bonanza,brilliantly,bunkum,capably,capitally,cascade,cataract,cavity,certainly,chasm,cistern,clear,cleverly,comfortable,comfortably,competently,completely,conceivably,concernedly,considerably,considerately,cornucopia,correctly,crater,crevasse,cunningly,dam,dead water,decently,decorously,deep,deftly,deluge,depth,dexterously,dextrously,dig,diggings,dike,doing nicely,doubtlessly,drain,drain out,easily,easy,effectively,effectually,efficiently,effortlessly,empty,engulf,entirely,etang,excavation,excellently,exhaust,expertly,facilely,famously,far,farm pond,favorably,featly,find vent,fine,finely,fishpond,fit,fitly,fittingly,flood,flow,flow out,font,fortunate,fortunately,fount,fountain,fountainhead,freely,freshwater lake,fully,generously,glacial lake,gold mine,good,gulf,gush,gush out,hale,handily,happily,happy,headspring,headstream,headwater,heedfully,hole,hollow,humanely,humanly,inception,indeed,ingeniously,inland sea,interestedly,inundate,jet,justly,kindheartedly,kindly,lagoon,laguna,lake,lakelet,landlocked water,lightly,likely,linn,loch,lode,lough,mainspring,masterfully,mere,millpond,millpool,mine,neatly,nicely,nimbly,nyanza,obviously,origin,outflow,outpour,overbrim,overflow,overrun,overwhelm,oxbow lake,passably,perfectly,perhaps,pit,plash,play,pleasantly,plumb,pond,pondlet,pool,possibly,pour,pour out,pour over,probably,proficiently,properly,prosperously,provenance,provenience,providential,puddle,quarry,quite,rather,readily,really,reservoir,resource,resourcefully,right,rightly,riverhead,root,roundly,royally,run out,run over,salina,salt pond,sane,satisfactorily,satisfyingly,shaft,significantly,skillfully,slam,slop,slosh,sluice out,smoothly,snug,softheartedly,somewhat,sound,source,source of supply,spa,spew,spew out,spill,spill out,spill over,spit,splendidly,spout,spout out,spray,spring,springhead,springs,spritz,spryly,spurt,spurtle,squirt,stagnant water,standing water,staple,still water,sublimely,submerge,substantial,successfully,suitably,sump,superbly,surely,surge,swamp,sweep,swimmingly,tank,tarn,tenderheartedly,thoughtfully,tidal pond,to good purpose,to some purpose,tolerably,truly,unailing,undoubtedly,unquestionably,unsick,unsickly,up and about,utterly,vein,very well,volcanic lake,vomit,vomit forth,vomit out,warmheartedly,warmly,water hole,water pocket,watering place,well out,well-fixed,well-heeled,well-off,well-to-do,wellhead,wellspring,whelm,white,wholesome,wholly,with consummate skill,with finesse,with genius,with skill,workings,yawning abyss') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=55466 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: 81882