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 'amytal,amytal pill,dalmatian,demerol,dolophine,h,luminal,luminal pill,m,mickey f' 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!=20571 AND dictionaryenglish.english='Rainbow' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=20571 AND dictionaryenglish.english='Indra\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=20571 AND dictionaryenglish.english='amytal,amytal pill,dalmatian,demerol,dolophine,h,luminal,luminal pill,m,mickey finn,nembutal,nembutal pill,seconal,seconal pill,tuinal,tuinal pill,alcohol,amobarbital sodium,analgesic,angry clouds,anodyne,anthelion,antigorite,antisun,aura,aureole,barb,barbiturate,barbiturate pill,black cat,black clouds,black stuff,blue,blue angel,blue devil,blue heaven,blue velvet,broken mirror,butterfly,calmative,candy cane,chameleon,cheetah,chimera,chloral hydrate,chromatic,chrysotile,circle,codeine,codeine cough syrup,cold,colorific,coloring,confetti,cool,corona,countersun,crazy quilt,depressant,depressor,dichromatic,dolly,downer,dream,fantasy,firedog,gathering clouds,glory,glowing,goofball,halcyon bird,halo,hard stuff,harlequin,harmonious,heroin,hop,horse,hypnotic,illusion,iridescence,iris,jaguar,junk,knockout drops,laudanum,leopard,liquor,lotus,lunar corona,lunar halo,mackerel,mackerel sky,many-colored,marble,marbled paper,matching,medley,meperidine,methadone,mock moon,mock sun,moire,monochromatic,monochrome,monochromic,moon dog,morphia,morphine,mother-of-pearl,mother-of-pearl cloud,motley,nacre,nacreousness,narcotic,nimbus,ocelot,opal,opalescence,ophite,opiate,opium,owl,pacifier,pain killer,paraselene,paregoric,parhelic circle,parhelion,parti-colored,patchwork quilt,peacock,pearliness,pen yan,phenobarbital,phenobarbital sodium,pigmentary,pipe,polychromatic,prismatic,purple heart,quietener,raven,red,ring,scag,secobarbital sodium,sedative,serpentine,serpentine marble,shit,shooting star,shot silk,sleep-inducer,sleeper,sleeping draught,sleeping pill,smack,sodium thiopental,solar corona,solar halo,somnifacient,soother,soothing syrup,soporific,spectral,spectrum,storm clouds,stormy petrel,sun dog,tar,thundercloud,thunderhead,tinctorial,tingent,toning,tortoise shell,tranquilizer,turps,variegated,warm,white stuff,yellow,yellow jacket,zebra') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=20571 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: 81581