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 'Rich People' 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!=21395 AND dictionaryenglish.english='Rich' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=21395 AND dictionaryenglish.english='Rich Person' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=21395 AND dictionaryenglish.english='The Rich' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=21395 AND dictionaryenglish.english='The `haves\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=21395 AND dictionaryenglish.english='Rich People' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=21395 AND dictionaryenglish.english='abounding,abounding in riches,absurd,abundant,achingly sweet,adipose,affluent,agreeable,agreeable-sounding,all-sufficing,ambrosial,ample,amusing,aplenty,appealing,arabesque,ariose,arioso,aromatic,baroque,beyond price,big-rich,bizarre,blooming,blubbery,bottomless,bounteous,bountiful,bright,bright-hued,brilliant,burning,bursting,bursting out,busy,buttery,butyraceous,canorous,cantabile,catchy,chichi,chrismal,chrismatory,cloying,colorful,colory,comfortable,comical,copious,costly,creamy,creative,dark,dear,dear-bought,deep,deep-colored,delicious,diffuse,disgustingly rich,droll,dulcet,easy,eccentric,effuse,elaborate,elegant,epidemic,euphonic,euphonious,euphonous,exciting,exhaustless,exotic,expensive,exquisite,extravagant,exuberant,fancy,fat,fattening,fatty,fecund,fertile,fine,fine-toned,flamboyant,flavorful,flavorous,flavorsome,flavory,florid,flourishing,flowery,flush,fragrant,frightfully rich,frilly,fructiferous,fruitful,fruity,full,full-bodied,full-flavored,funny,fussy,galore,gay,gay-colored,generous,golden,golden-tongued,golden-voiced,good as gold,gorgeous,greasy,heavy,high,high-colored,high-priced,high-wrought,hilarious,honeyed,humorous,in clover,in funds,in plenty,in quantity,in the money,incongruous,independent,independently rich,independently wealthy,inestimable,inexhaustible,intense,interesting,invaluable,inviting,juicy,labored,lardaceous,lardy,laughable,lavish,liberal,lively,loaded,ludicrous,luscious,lush,lustrous,luxuriant,luxurious,made of money,many,mawkish,maximal,melic,mellifluent,mellifluous,mellisonant,mellow,melodic,melodious,moneyed,moresque,mouth-watering,much,mucoid,music-flowing,music-like,musical,nonsensical,not affordable,numerous,nutty,of great cost,of great price,oily,oleaginous,oleic,on easy street,on velvet,oofy,opulent,ornate,ostentatious,outlandish,overelaborate,overelegant,overflowing,overlabored,oversweet,overworked,overwrought,palatial,picturesque,piquant,plangent,pleasant,pleasant-sounding,plenitudinous,plenteous,plentiful,plenty,plutocracy,potent,precious,pregnant,premium,preposterous,pretty-pretty,prevailing,prevalent,priceless,pricey,prodigal,productive,profitable,profuse,profusive,proliferous,prolific,prosperous,provided for,provocative,provoking,pulsing,pungent,quaint,quizzical,racy,rampant,readable,redolent,replete,resonant,resonating,rich as croesus,rich-colored,rich-flavored,ridiculous,rife,riotous,risible,rococo,rolling,rolling in money,running over,saccharine,sapid,savory,screaming,sebaceous,seminal,sickly-sweet,significant,silver-toned,silver-tongued,silver-voiced,silvery,singable,sleek,slick,slippery,smooth,soapy,songful,songlike,sonorous,spicy,splendid,steep,stiff,stimulating,strong,succulent,suety,sumptuous,superabundant,superb,swarming,sweet,sweet-flowing,sweet-sounding,tallowy,tantalizing,teeming,the haves,the rich,the wealthy,thought-challenging,thought-inspiring,thought-provoking,thriving,throbbing,tickling,titillating,top,tunable,tuneful,uberous,unctuous,unguent,unguentary,unguentous,unpayable,valuable,vibrant,vibrating,vivid,wallowing in wealth,warm,wealthy,well provided for,well-fixed,well-found,well-furnished,well-heeled,well-off,well-provided,well-stocked,well-to-do,whimsical,wholesale,witty,worthy') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=21395 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: 81763


Go Back ⇒
Go Home ⇒