SELECT `SadrListOfDrug`.`drug_name` AS `drug_name`, COUNT(distinct SadrListOfDrug.sadr_id) as cnt FROM `pvers`.`sadr_list_of_drugs` AS `SadrListOfDrug` LEFT JOIN `pvers`.`sadrs` AS `Sadr` ON (`SadrListOfDrug`.`sadr_id` = `Sadr`.`id`) LEFT JOIN `pvers`.`sadr_followups` AS `SadrFollowup` ON (`SadrListOfDrug`.`sadr_followup_id` = `SadrFollowup`.`id`) LEFT JOIN `pvers`.`doses` AS `Dose` ON (`SadrListOfDrug`.`dose_id` = `Dose`.`id`) LEFT JOIN `pvers`.`routes` AS `Route` ON (`SadrListOfDrug`.`route_id` = `Route`.`id`) LEFT JOIN `pvers`.`frequencies` AS `Frequency` ON (`SadrListOfDrug`.`frequency_id` = `Frequency`.`id`) WHERE `SadrListOfDrug`.`sadr_id` IN (1, 160, 242, 249, 374, 450, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 537, 538, 539, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 554, 555, 556, 557, 558, 559, 573, 574, 575, 576, 581, 582, 583, 584, 585, 586, 587, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 812, 904, 905, 907, 975, 988, 989, 1000, 1022, 1203, 1279, 1409, 1575, 1758, 1849, 1850, 1851, 1854, 1855, 1856, 1857, 1858, 1859, 1860, 1861, 1862, 1863, 1864, 1865, 1866, 1867, 1868, 1869, 1870, 1871, 1872, 1873, 1874, 1875, 1876, 1877, 1878, 1879, 1880, 1881, 1882, 1883, 1884, 1885, 1886, 1887, 1888, 1889, 1890, 1891, 1892, 1893, 1894, 1895, 1896, 1897, 1898, 1899, 1900, 1901, 1902, 1903, 1904, 1905, 1906, 1907, 1908, 1909, 1910, 1911, 1912, 1913, 1914, 1915, 1916, 1917, 1918, 1919, 1920, 1921, 1922, 1923, 1924, 1925, 1926, 1927, 1928, 1929, 1930, 1931, 1932, 1933, 1934, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1942, 1943, 1944, 1945, 1946, 1947, 1948, 1949, 1950, 1951, 1952, 1953, 1954, 1955, 1956, 1957, 1958, 1959, 1960, 1961, 1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2025, 2026, 2027, 2028, 2029, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2037, 2038, 2039, 2040, 2041, 2042, 2043, 2044, 2049, 2050, 2052, 2053, 2054, 2055, 2056, 2058, 2140, 2164, 2165, 2166, 2167, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2179, 2180, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2189, 2190, 2191, 2192, 2193, 2194, 2195, 2196, 2197, 2198, 2199, 2200, 2201, 2247, 2359, 2360, 2361, 2362, 2363, 2364, 2365, 2366, 2367, 2368, 2738, 3180, 3182, 3183, 3314, 3352, 3392, 3393, 3394, 3395, 3396, 3397, 3398, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3421, 3422, 3423, 3424, 3425, 3426, 3427, 3433, 3434, 3521, 3522, 3523, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3531, 3532, 3533, 3534, 3535, 3536, 3537, 3538, 3539, 3540, 3541, 3542, 3543, 3544, 3545, 3546, 3547, 3548, 3549, 3550, 3551, 3552, 3553, 3554, 3555, 3556, 3557, 3560, 3561, 3562, 3564, 3566, 3568, 3569, 3570, 3571, 3572, 3574, 3575, 3576, 3579, 3580, 3616, 3709, 3710, 3711, 3712, 3713, 3714, 3715, 3716, 3718, 3719, 3720, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 3729, 3730, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 3792, 3793, 3794, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 3802, 3803, 3804, 3805, 3806, 3807, 3808, 3809, 3810, 3811, 3812, 3813, 3814, 3815, 3816, 3817, 3842, 3846, 3875, 3876, 3877, 3878, 3897, 3963, 4009, 4120, 4204, 4541, 4600, 4969, 4970, 4975, 4976, 4977, 4978, 4979, 4980, 4981, 4982, 4983, 4984, 4985, 4986, 4987, 4988, 4990, 4991, 4992, 4993, 4994, 4995, 4996, 4997, 4998, 4999, 5000, 5001, 5002, 5003, 5004, 5005, 5006, 5007, 5008, 5009, 5010, 5011, 5012, 5013, 5014, 5015, 5016, 5017, 5018, 5019, 5020, 5021, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5034, 5035, 5036, 5037, 5041, 5042, 5043, 5044, 5045, 5046, 5047, 5048, 5049, 5051, 5054, 5055, 5056, 5057, 5058, 5059, 5060, 5061, 5062, 5063, 5064, 5065, 5066, 5067, 5068, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5077, 5078, 5079, 5080, 5081, 5082, 5083, 5084, 5085, 5086, 5087, 5088, 5089, 5090, 5091, 5092, 5093, 5094, 5095, 5096, 5097, 5098, 5099, 5100, 5101, 5102, 5103, 5104, 5105, 5106, 5107, 5108, 5110, 5112, 5113, 5114, 5115, 5116, 5117, 5120, 5121, 5122, 5123, 5124, 5125, 5126, 5127, 5128, 5129, 5130, 5131, 5132, 5133, 5134, 5135, 5136, 5137, 5138, 5139, 5140, 5141, 5142, 5143, 5144, 5145, 5146, 5147, 5148, 5149, 5150, 5151, 5152, 5153, 5154, 5155, 5156, 5157, 5158, 5159, 5160, 5161, 5162, 5163, 5164, 5165, 5166, 5167, 5168, 5169, 5170, 5171, 5172, 5173, 5174, 5175, 5176, 5177, 5178, 5179, 5180, 5181, 5182, 5183, 5185, 5186, 5187, 5188, 5189, 5190, 5191, 5192, 5193, 5194, 5195, 5196, 5197, 5198, 5199, 5200, 5201, 5202, 5203, 5204, 5206, 5207, 5211, 5212, 5213, 5214, 5215, 5216, 5217, 5218, 5219, 5220, 5221, 5222, 5223, 5224, 5225, 5226, 5227, 5228, 5229, 5230, 5231, 5232, 5233, 5234, 5235, 5236, 5237, 5238, 5239, 5240, 5241, 5242, 5243, 5244, 5245, 5246, 5247, 5248, 5249, 5250, 5251, 5252, 5253, 5254, 5255, 5256, 5257, 5258, 5259, 5260, 5261, 5262, 5263, 5264, 5265, 5266, 5267, 5268, 5269, 5270, 5271, 5272, 5273, 5274, 5276, 5278, 5280, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5291, 5292, 5293, 5294, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5306, 5307, 5308, 5309, 5310, 5311, 5312, 5313, 5314, 5315, 5316, 5317, 5318, 5319, 5320, 5321, 5322, 5323, 5324, 5325, 5326, 5327, 5328, 5329, 5330, 5331, 5332, 5333, 5334, 5335, 5336, 5337, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5349, 5350, 5351, 5352, 5353, 5354, 5355, 5356, 5357, 5358, 5359, 5360, 5361, 5362, 5363, 5364, 5365, 5366, 5367, 5368, 5369, 5370, 5371, 5372, 5373, 5374, 5375, 5376, 5377, 5378, 5379, 5380, 5381, 5382, 5383, 5384, 5385, 5386, 5387, 5388, 5389, 5390, 5391, 5392, 5393, 5394, 5395, 5397, 5399, 5413, 5419, 5421, 5422, 5423, 5424, 5425, 5428, 5429, 5430, 5431, 5432, 5433, 5434, 5435, 5436, 5437, 5438, 5439, 5440, 5441, 5442, 5443, 5444, 5445, 5446, 5447, 5448, 5449, 5450, 5451, 5452, 5453, 5454, 5455, 5456, 5457, 5458, 5459, 5460, 5461, 5462, 5463, 5464, 5465, 5466, 5467, 5468, 5469, 5470, 5471, 5472, 5473, 5474, 5475, 5476, 5477, 5478, 5479, 5480, 5481, 5483, 5484, 5485, 5486, 5487, 5488, 5489, 5490, 5491, 5492, 5493, 5494, 5495, 5496, 5497, 5498, 5499, 5500, 5501, 5502, 5503, 5504, 5505, 5506, 5507, 5508, 5509, 5510, 5511, 5512, 5513, 5514, 5515, 5516, 5517, 5518, 5519, 5520, 5521, 5542, 5557, 5563, 5583, 5584, 5585, 5586, 5590, 5591, 5609, 5613, 5614, 5633, 5634, 5642, 5643, 5645, 5647, 5648, 5649, 5650, 5651, 5653, 5658, 5665, 5666, 5669, 5671, 5673, 5675, 5680, 5681, 5682, 5684, 5686, 5689, 5692, 5693, 5695, 5696, 5697, 5703, 5706, 5707, 5711, 5716, 5717, 5719, 5720, 5721, 5726, 5727, 5729, 5730, 5731, 5750, 5751, 5752, 5766, 5779, 5898, 5925, 5962, 5993, 6032, 6036, 6077, 6128, 6130, 6147, 6151, 6188, 6189, 6245, 6261, 6268, 6430, 6468, 6484, 6642, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6670, 6671, 6672, 6673, 6674, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6692, 6704, 6718, 6719, 6721, 6722, 6723, 6724, 6725, 6726, 6727, 6728, 6729, 6734, 6737, 6738, 6739, 6740, 6741, 6742, 6743, 6746, 6748, 6752, 6757, 6758, 6760, 6761, 6763, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6778, 6779, 6780, 6781, 6782, 6783, 6784, 6785, 6786, 6788, 6789, 6790, 6791, 6792, 6793, 6795, 6800, 6801, 6802, 6803, 6804, 6805, 6806, 6807, 6808, 6809, 6810, 6811, 6812, 6813, 6814, 6815, 6816, 6817, 6818, 6819, 6820, 6821, 6822, 6823, 6824, 6825, 6826, 6827, 6828, 6829, 6830, 6831, 6832, 6833, 6834, 6835, 6836, 6837, 6838, 6839, 6840, 6841, 6842, 6843, 6844, 6845, 6846, 6847, 6848, 6849, 6850, 6851, 6852, 6853, 6854, 6855, 6857, 6862, 6863, 6873, 6874, 6875, 6879, 6880, 6881, 6882, 6883, 6884, 6885, 6886, 6887, 6888, 6889, 6890, 6891, 6892, 6893, 6894, 6895, 6896, 6898, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6908, 6909, 6910, 6911, 6912, 6913, 6914, 6915, 6916, 6917, 6918, 6919, 6920, 6921, 6922, 6923, 6924, 6927, 6929, 6930, 6931, 6932, 6933, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6942, 6943, 6944, 6946, 6947, 6948, 6949, 6950, 6951, 6952, 6953, 6954, 6955, 6956, 6957, 6959, 6960, 6961, 6962, 6963, 6965, 6966, 6968, 6969, 6970, 6971, 6972, 6973, 6974, 6977, 6979, 6980, 6982, 6983, 6984, 6985, 6986, 6987, 6988, 6989, 6990, 6991, 6992, 6993, 6994, 6995, 6996, 6999, 7000, 7001, 7002, 7003, 7004, 7005, 7006, 7007, 7008, 7009, 7011, 7014, 7015, 7016, 7017, 7018, 7019, 7020, 7022, 7023, 7024, 7025, 7026, 7027, 7028, 7030, 7031, 7033, 7034, 7036, 7037, 7039, 7040, 7041, 7042, 7043, 7044, 7046, 7047, 7049, 7059, 7060, 7061, 7063, 7064, 7066, 7067, 7068, 7069, 7070, 7071, 7072, 7073, 7074, 7075, 7076, 7077, 7078, 7079, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7087, 7088, 7089, 7090, 7091, 7092, 7093, 7094, 7095, 7096, 7097, 7098, 7099, 7100, 7101, 7102, 7103, 7104, 7105, 7106, 7107, 7108, 7109, 7110, 7111, 7112, 7113, 7114, 7115, 7117, 7118, 7119, 7120, 7121, 7123, 7124, 7125, 7126, 7127, 7129, 7130, 7131, 7134, 7135, 7137, 7138, 7139, 7143, 7144, 7145, 7146, 7147, 7148, 7149, 7150, 7151, 7152, 7153, 7155, 7156, 7157, 7159, 7160, 7161, 7162, 7163, 7164, 7165, 7166, 7169, 7173, 7200, 7201, 7202, 7203, 7204, 7206, 7207, 7222, 7226, 7227, 7228, 7229, 7230, 7231, 7232, 7233, 7234, 7235, 7236, 7237, 7238, 7240, 7241, 7242, 7243, 7244, 7245, 7246, 7247, 7248, 7250, 7252, 7253, 7254, 7255, 7256, 7257, 7258, 7259, 7260, 7261, 7262, 7263, 7264, 7265, 7266, 7268, 7269, 7270, 7271, 7272, 7273, 7274, 7276, 7277, 7279, 7283, 7284, 7285, 7287, 7288, 7289, 7290, 7291, 7293, 7294, 7295, 7296, 7298, 7299, 7300, 7301, 7302, 7303, 7304, 7305, 7306, 7307, 7308, 7309, 7310, 7311, 7312, 7313, 7314, 7316, 7318, 7319, 7320, 7321, 7322, 7323, 7324, 7325, 7326, 7327, 7330, 7331, 7333, 7337, 7338, 7339, 7340, 7341, 7342, 7343, 7344, 7345, 7346, 7347, 7351, 7357, 7360, 7361, 7362, 7373, 7385, 7387, 7388, 7389, 7390, 7391, 7392, 7393, 7394, 7395, 7396, 7397, 7398, 7399, 7400, 7401, 7403, 7404, 7406, 7408, 7409, 7410, 7411, 7412, 7417, 7418, 7419, 7420, 7421, 7422, 7423, 7426, 7429, 7431, 7433, 7434, 7436, 7437, 7438, 7442, 7443, 7444, 7449, 7450, 7452, 7453, 7454, 7455, 7456, 7459, 7460, 7461, 7462, 7463, 7464, 7469, 7470, 7471, 7472, 7473, 7474, 7477, 7478, 7479, 7480, 7481, 7482, 7483, 7484, 7485, 7492, 7503, 7504, 7505, 7506, 7507, 7508, 7509, 7510, 7511, 7512, 7513, 7514, 7515, 7516, 7517, 7518, 7519, 7520, 7521, 7522, 7523, 7524, 7525, 7526, 7527, 7528, 7529, 7530, 7531, 7532, 7533, 7534, 7535, 7536, 7537, 7538, 7539, 7540, 7541, 7542, 7543, 7544, 7545, 7546, 7547, 7548, 7549, 7550, 7551, 7552, 7553, 7554, 7555, 7556, 7557, 7558, 7559, 7560, 7561, 7562, 7563, 7564, 7565, 7566, 7567, 7568, 7569, 7570, 7571, 7572, 7573, 7574, 7575, 7576, 7577, 7578, 7579, 7580, 7581, 7582, 7583, 7584, 7585, 7586, 7587, 7588, 7589, 7590, 7591, 7592, 7593, 7594, 7595, 7596, 7597, 7598, 7599, 7600, 7601, 7602, 7603, 7604, 7605, 7606, 7607, 7608, 7609, 7610, 7611, 7614, 7617, 7619, 7620, 7624, 7626, 7628, 7629, 7632, 7635, 7636, 7637, 7638, 7639, 7640, 7641, 7642, 7643, 7644, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7653, 7664, 7665, 7666, 7667, 7668, 7671, 7672, 7674, 7675, 7680, 7682, 7683, 7686, 7687, 7688, 7689, 7692, 7694, 7695, 7696, 7698, 7700, 7701, 7702, 7703, 7704, 7705, 7706, 7707, 7708, 7709, 7710, 7711, 7712, 7713, 7721, 7727, 7728, 7729, 7730, 7732, 7734, 7735, 7742, 7746, 7748, 7750, 7751, 7752, 7753, 7754, 7755, 7761, 7762, 7763, 7764, 7765, 7766, 7767, 7768, 7771, 7773, 7774, 7776, 7780, 7783, 7784, 7785, 7786, 7787, 7789, 7790, 7794, 7796, 7797, 7798, 7799, 7803, 7804, 7805, 7806, 7807, 7808, 7829, 7830, 7832, 7868, 7869, 7885, 7886, 7887, 7888, 7889, 7890, 7891, 7892, 7893, 7894, 7895, 7896, 7897, 7898, 7899, 7900, 7901, 7902, 7903, 7904, 7905, 7906, 7907, 7908, 7909, 7910, 7911, 7912, 7913, 7914, 7915, 7916, 7917, 7918, 7919, 7920, 7921, 7922, 7923, 7924, 7925, 7926, 7929, 7930, 7931, 7932, 7933, 7934, 7935, 7936, 7937, 7938, 7939, 7940, 7941, 7942, 7943, 7944, 7945, 7946, 7947, 7948, 7949, 7950, 7951, 7952, 7953, 7954, 7955, 7956, 7957, 7958, 7959, 7960, 7961, 7963, 7964, 7965, 7974, 7975, 7976, 7977, 7979, 7980, 8040, 8041, 8069, 8317, 8348, 8407, 8410, 8411, 8453, 8458, 8475, 8488, 8493, 8502, 8504, 8506, 8511, 8514, 8515, 8523, 8524, 8527, 8537, 8539, 8540, 8541, 8542, 8552, 8553, 8554, 8556, 8595, 8598, 8601, 8606, 8608, 8609, 8611, 8612, 8613, 8614, 8615, 8616, 8617, 8618, 8619, 8620, 8621, 8622, 8623, 8624, 8625, 8626, 8627, 8628, 8629, 8630, 8631, 8632, 8633, 8634, 8635, 8636, 8637, 8638, 8639, 8640, 8641, 8643, 8644, 8649, 8650, 8651, 8652, 8653, 8654, 8655, 8656, 8657, 8658, 8659, 8660, 8661, 8662, 8663, 8664, 8665, 8666, 8667, 8668, 8669, 8670, 8671, 8672, 8673, 8674, 8675, 8679, 8680, 8681, 8682, 8683, 8684, 8685, 8686, 8687, 8688, 8690, 8691, 8692, 8693, 8694, 8695, 8696, 8697, 8698, 8699, 8700, 8701, 8702, 8703, 8710, 8711, 8713, 8715, 8719, 8720, 8722, 8723, 8724, 8725, 8726, 8727, 8728, 8729, 8730, 8731, 8732, 8733, 8734, 8735, 8736, 8737, 8738, 8739, 8740, 8741, 8742, 8743, 8744, 8745, 8746, 8747, 8748, 8749, 8750, 8751, 8752, 8753, 8754, 8756, 8757, 8791, 8792, 8793, 8794, 8795, 8796, 8797, 8798, 8799, 8800, 8801, 8802, 8803, 8804, 8805, 8806, 8807, 8808, 8809, 8810, 8811, 8812, 8813, 8814, 8815, 8816, 8817, 8818, 8819, 8820, 8821, 8822, 8823, 8824, 8825, 8826, 8827, 8828, 8829, 8830, 8831, 8832, 8833, 8834, 8835, 8836, 8837, 8838, 8839, 8840, 8841, 8842, 8844, 8845, 8847, 8849, 8850, 8851, 8852, 8853, 8854, 8855, 8856, 8857, 8858, 8859, 8860, 8861, 8862, 8863, 8864, 8865, 8866, 8867, 8868, 8869, 8870, 8871, 8873, 8876, 8877, 8878, 8879, 8880, 8881, 8882, 8883, 8884, 8885, 8887, 8888, 8889, 8892, 8893, 8894, 8895, 8896, 8899, 8900, 8904, 8905, 8908, 8912, 8917, 8918, 8919, 8925, 8927, 8928, 8929, 8930, 8931, 8932, 8933, 8934, 8935, 8936, 8937, 8938, 8939, 8940, 8941, 8942, 8943, 8944, 8945, 8946, 8947, 8948, 8949, 8950, 8951, 8952, 8953, 8954, 8955, 8956, 8958, 8959, 8960, 8961, 8962, 8963, 8964, 8965, 8966, 8967, 8968, 8969, 8970, 8971, 8972, 8973, 8974, 8975, 8976, 8977, 9019, 9322, 9325, 9327, 9329, 9332, 9379, 9434, 9435, 9436, 9437, 9438, 9439, 9440, 9441, 9442, 9443, 9444, 9445, 9446, 9447, 9448, 9449, 9450, 9550, 9578, 9612, 9661, 9784, 9836, 9837, 9839, 9840, 9841, 9904, 9905, 9906, 10200, 10231, 10369, 10511, 10706, 10707, 10764, 11079, 11141, 11142, 11143, 11144, 11160, 11168, 11192, 11195, 11281, 11293, 11294, 11412, 11507, 11508, 11509, 11510, 11511, 11512, 11513, 11514, 11515, 11516, 11517, 11518, 11519, 11520, 11521, 11522, 11526, 11579, 11631, 11777, 11789, 11806, 11817, 11819, 11856, 11886, 12001, 12111, 12119, 12120, 12121, 12123, 12124, 12125, 12126, 12127, 12128, 12129, 12130, 12131, 12133, 12134, 12135, 12136, 12137, 12138, 12139, 12140, 12141, 12142, 12143, 12144, 12145, 12146, 12147, 12148, 12149, 12150, 12151, 12152, 12153, 12154, 12155, 12156, 12157, 12158, 12159, 12160, 12161, 12162, 12163, 12164, 12165, 12166, 12167, 12168, 12169, 12170, 12171, 12172, 12173, 12174, 12175, 12176, 12177, 12178, 12179, 12180, 12181, 12182, 12183, 12184, 12185, 12186, 12187, 12188, 12189, 12190, 12191, 12192, 12193, 12194, 12195, 12196, 12197, 12198, 12199, 12200, 12201, 12202, 12203, 12204, 12205, 12206, 12207, 12208, 12209, 12210, 12211, 12212, 12213, 12214, 12215, 12216, 12217, 12218, 12219, 12220, 12221, 12222, 12223, 12224, 12225, 12226, 12227, 12228, 12229, 12230, 12231, 12232, 12233, 12234, 12235, 12236, 12237, 12238, 12239, 12240, 12241, 12242, 12243, 12244, 12245, 12246, 12247, 12248, 12249, 12250, 12251, 12252, 12253, 12254, 12255, 12256, 12257, 12258, 12259, 12260, 12261, 12262, 12263, 12264, 12265, 12266, 12267, 12268, 12269, 12270, 12271, 12272, 12273, 12274, 12275, 12276, 12277, 12278, 12279, 12280, 12281, 12282, 12283, 12284, 12285, 12286, 12287, 12288, 12289, 12290, 12291, 12292, 12293, 12294, 12295, 12296, 12297, 12298, 12299, 12300, 12301, 12303, 12304, 12305, 12306, 12307, 12308, 12309, 12310, 12311, 12312, 12313, 12314, 12315, 12316, 12317, 12318, 12319, 12320, 12321, 12322, 12323, 12325, 12326, 12327, 12328, 12329, 12330, 12331, 12332, 12333, 12334, 12335, 12336, 12337, 12338, 12339, 12340, 12341, 12342, 12343, 12344, 12345, 12346, 12347, 12348, 12349, 12350, 12351, 12352, 12353, 12354, 12355, 12356, 12357, 12358, 12359, 12360, 12361, 12362, 12363, 12364, 12365, 12366, 12367, 12368, 12369, 12370, 12371, 12372, 12373, 12374, 12375, 12376, 12377, 12378, 12379, 12380, 12381, 12382, 12383, 12385, 12386, 12387, 12388, 12389, 12390, 12391, 12392, 12393, 12394, 12395, 12396, 12397, 12398, 12399, 12400, 12401, 12402, 12403, 12406, 12407, 12408, 12409, 12410, 12411, 12412, 12413, 12414, 12415, 12416, 12417, 12418, 12419, 12420, 12421, 12422, 12423, 12424, 12425, 12426, 12427, 12428, 12429, 12430, 12431, 12432, 12433, 12434, 12435, 12439, 12442, 12443, 12444, 12445, 12446, 12447, 12448, 12449, 12450, 12451, 12453, 12454, 12455, 12456, 12457, 12458, 12459, 12460, 12461, 12462, 12463, 12464, 12466, 12467, 12468, 12469, 12470, 12471, 12472, 12473, 12474, 12475, 12476, 12477, 12478, 12479, 12480, 12481, 12482, 12483, 12484, 12485, 12486, 12487, 12488, 12489, 12490, 12491, 12492, 12493, 12494, 12495, 12497, 12498, 12499, 12500, 12501, 12502, 12503, 12504, 12505, 12506, 12507, 12508, 12509, 12510, 12511, 12512, 12513, 12514, 12515, 12516, 12517, 12518, 12519, 12520, 12521, 12522, 12523, 12524, 12525, 12526, 12527, 12528, 12530, 12532, 12533, 12534, 12535, 12536, 12537, 12538, 12539, 12540, 12541, 12542, 12543, 12544, 12545, 12546, 12547, 12548, 12549, 12550, 12551, 12552, 12553, 12554, 12555, 12556, 12557, 12558, 12559, 12560, 12561, 12562, 12563, 12564, 12565, 12566, 12567, 12568, 12570, 12571, 12572, 12573, 12574, 12575, 12576, 12577, 12578, 12579, 12580, 12581, 12582, 12583, 12584, 12585, 12586, 12587, 12588, 12589, 12590, 12591, 12592, 12593, 12594, 12596, 12597, 12598, 12599, 12600, 12601, 12602, 12603, 12604, 12608, 12609, 12610, 12611, 12613, 12615, 12616, 12617, 12618, 12619, 12620, 12621, 12622, 12623, 12624, 12625, 12626, 12627, 12628, 12629, 12630, 12631, 12632, 12633, 12634, 12636, 12637, 12639, 12640, 12641, 12642, 12643, 12644, 12645, 12646, 12647, 12648, 12649, 12650, 12651, 12652, 12653, 12654, 12655, 12656, 12657, 12658, 12659, 12660, 12661, 12662, 12663, 12664, 12665, 12666, 12667, 12668, 12669, 12670, 12671, 12672, 12673, 12674, 12676, 12677, 12679, 12680, 12681, 12682, 12683, 12684, 12685, 12686, 12688, 12689, 12690, 12691, 12692, 12693, 12694, 12695, 12696, 12697, 12698, 12700, 12702, 12708, 12721, 12722, 12723, 12724, 12730, 12733, 12737, 12739, 12740, 12741, 12742, 12743, 12744, 12745, 12746, 12747, 12748, 12749, 12750, 12753, 12755, 12756, 12757, 12758, 12759, 12760, 12761, 12762, 12763, 12765, 12766, 12768, 12770, 12771, 12772, 12773, 12775, 12777, 12778, 12779, 12781, 12782, 12783, 12784, 12785, 12786, 12787, 12788, 12789, 12790, 12798, 12800, 12801, 12802, 12803, 12804, 12805, 12806, 12807, 12808, 12810, 12811, 12812, 12813, 12814, 12815, 12816, 12817, 12818, 12820, 12821, 12822, 12823, 12824, 12826, 12831, 12832, 12835, 12836, 12837, 12838, 12840, 12845, 12846, 12847, 12848, 12849, 12850, 12852, 12855, 12856, 12857, 12858, 12859, 12860, 12864, 12865, 12866, 12867, 12868, 12869, 12870, 12872, 12873, 12874, 12875, 12876, 12877, 12878, 12879, 12880, 12881, 12882, 12884, 12885, 12886, 12887, 12888, 12889, 12890, 12891, 12893, 12894, 12895, 12896, 12897, 12898, 12899, 12900, 12901, 12903, 12904, 12907, 12908, 12921, 12933, 12934, 12935, 12940, 12941, 12942, 12943, 12959, 12962, 12963, 12964, 12965, 12966, 12967, 12968, 12969, 12970, 12971, 12972, 12973, 12974, 12975, 13004, 13005, 13006, 13007, 13008, 13009, 13010, 13011, 13012, 13013, 13015, 13016, 13017, 13020, 13021, 13022, 13024, 13025, 13027, 13028, 13036, 13037, 13038, 13039, 13040, 13041, 13042, 13043, 13044, 13045, 13047, 13048, 13049, 13051, 13054, 13055, 13057, 13058, 13059, 13060, 13061, 13062, 13063, 13084, 13085, 13086, 13087, 13088, 13089, 13090, 13091, 13092, 13093, 13230, 13255, 13257, 13268, 13278, 13280, 13282, 13283, 13284, 13285, 13286, 13287, 13288, 13289, 13290, 13291, 13292, 13293, 13294, 13295, 13296, 13297, 13317, 13318, 13319, 13320, 13321, 13322, 13323, 13324, 13325, 13326, 13327, 13329, 13330, 13331, 13342, 13507, 13512, 13532, 13576, 13577, 13846, 13862, 13895, 13896, 13897, 13900, 13902, 13921, 13931, 13935, 13936, 13938, 14071, 14104, 14116, 14118, 14133, 14137, 14158, 14159, 14160, 14161, 14162, 14163, 14164, 14165, 14171, 14172, 14173, 14174, 14175, 14176, 14177, 14179, 14180, 14181, 14182, 14183, 14184, 14186, 14187, 14188, 14189, 14190, 14191, 14192, 14193, 14199, 14200, 14201, 14202, 14203, 14206, 14207, 14208, 14209, 14210, 14211, 14212, 14213, 14214, 14215, 14216, 14217, 14218, 14219, 14220, 14221, 14223, 14224, 14229, 14230, 14231, 14232, 14233, 14234, 14235, 14236, 14237, 14238, 14239, 14240, 14241, 14242, 14243, 14244, 14245, 14246, 14247, 14248, 14249, 14250, 14251, 14252, 14253, 14254, 14255, 14256, 14258, 14259, 14260, 14261, 14262, 14264, 14265, 14266, 14267, 14268, 14269, 14270, 14271, 14272, 14273, 14274, 14275, 14276, 14277, 14278, 14279, 14280, 14281, 14282, 14283, 14286, 14287, 14289, 14290, 14291, 14292, 14293, 14294, 14295, 14296, 14297, 14298, 14299, 14300, 14301, 14302, 14303, 14305, 14306, 14307, 14308, 14309, 14310, 14311, 14312, 14313, 14314, 14315, 14316, 14317, 14318, 14319, 14320, 14321, 14322, 14323, 14324, 14325, 14326, 14327, 14328, 14329, 14330, 14331, 14332, 14333, 14334, 14335, 14336, 14337, 14338, 14339, 14340, 14341, 14342, 14343, 14344, 14345, 14346, 14347, 14348, 14349, 14350, 14351, 14352, 14353, 14354, 14358, 14359, 14360, 14361, 14362, 14363, 14364, 14365, 14366, 14367, 14368, 14369, 14370, 14371, 14372, 14373, 14374, 14375, 14376, 14378, 14379, 14380, 14381, 14382, 14383, 14384, 14385, 14386, 14387, 14388, 14389, 14390, 14391, 14392, 14394, 14395, 14396, 14397, 14398, 14399, 14400, 14401, 14402, 14403, 14404, 14405, 14406, 14407, 14408, 14409, 14410, 14412, 14413, 14414, 14415, 14416, 14417, 14418, 14419, 14420, 14421, 14422, 14423, 14424, 14425, 14426, 14427, 14428, 14429, 14430, 14431, 14432, 14433, 14435, 14436, 14438, 14439, 14442, 14443, 14444, 14445, 14447, 14448, 14449, 14455, 14456, 14457, 14459, 14460, 14461, 14462, 14463, 14464, 14465, 14466, 14467, 14468, 14469, 14470, 14471, 14472, 14473, 14474, 14475, 14476, 14477, 14478, 14479, 14480, 14481, 14482, 14483, 14486, 14488, 14489, 14490, 14493, 14495, 14496, 14497, 14498, 14499, 14500, 14501, 14502, 14503, 14504, 14505, 14506, 14507, 14508, 14509, 14510, 14511, 14512, 14513, 14514, 14515, 14516, 14522, 14523, 14524, 14525, 14526, 14527, 14528, 14529, 14530, 14531, 14532, 14533, 14534, 14535, 14536, 14537, 14538, 14539, 14540, 14541, 14542, 14543, 14544, 14545, 14546, 14547, 14548, 14549, 14550, 14551, 14552, 14553, 14554, 14555, 14556, 14557, 14558, 14559, 14560, 14561, 14562, 14563, 14564, 14565, 14566, 14567, 14568, 14569, 14570, 14571, 14572, 14573, 14574, 14575, 14576, 14577, 14578, 14579, 14580, 14581, 14582, 14583, 14584, 14585, 14586, 14587, 14588, 14589, 14590, 14591, 14592, 14593, 14594, 14595, 14596, 14597, 14598, 14599, 14600, 14601, 14602, 14603, 14604, 14605, 14606, 14607, 14608, 14609, 14610, 14611, 14612, 14613, 14614, 14615, 14616, 14617, 14618, 14619, 14624, 14625, 14626, 14627, 14628, 14629, 14630, 14631, 14632, 14633, 14634, 14635, 14636, 14637, 14638, 14639, 14640, 14641, 14642, 14643, 14644, 14645, 14646, 14647, 14648, 14649, 14656, 14657, 14658, 14659, 14660, 14661, 14662, 14664, 14665, 14666, 14667, 14668, 14669, 14670, 14684, 14685, 14686, 14687, 14688, 14690, 14691, 14692, 14693, 14694, 14695, 14696, 14697, 14698, 14699, 14700, 14701, 14702, 14703, 14704, 14756, 14757, 14770, 14785, 14788, 14789, 14849, 14850, 14853, 14936, 14998, 15032, 15039, 15040, 15041, 15042, 15050, 15051, 15052, 15074, 15075, 15076, 15081, 15084, 15164, 15301, 15323, 15335, 15340, 15371, 15372, 15373, 15383, 15400, 15459, 15475, 15511, 15512, 15513, 15514, 15515, 15553, 15605, 15607, 15615, 15616, 15617, 15618, 15619, 15620, 15621, 15622, 15623, 15624, 15625, 15626, 15627, 15628, 15630, 15631, 15632, 15633, 15634, 15635, 15637, 15642, 15652, 15653, 15654, 15655, 15656, 15657, 15659, 15660, 15661, 15662, 15663, 15664, 15665, 15666, 15667, 15669, 15670, 15671, 15672, 15673, 15674, 15675, 15676, 15677, 15678, 15679, 15680, 15681, 15682, 15683, 15684, 15685, 15686, 15687, 15688, 15689, 15690, 15691, 15692, 15693, 15694, 15695, 15696, 15697, 15698, 15699, 15700, 15701, 15702, 15703, 15704, 15705, 15706, 15708, 15709, 15710, 15711, 15712, 15713, 15714, 15715, 15716, 15717, 15718, 15719, 15720, 15721, 15722, 15723, 15724, 15725, 15726, 15727, 15729, 15730, 15731, 15732, 15735, 15736, 15737, 15738, 15739, 15740, 15741, 15742, 15743, 15744, 15745, 15746, 15747, 15748, 15749, 15750, 15751, 15752, 15753, 15754, 15755, 15756, 15757, 15758, 15760, 15761, 15762, 15765, 15766, 15767, 15768, 15769, 15770, 15771, 15772, 15773, 15774, 15775, 15776, 15777, 15778, 15779, 15780, 15781, 15782, 15783, 15784, 15785, 15786, 15787, 15788, 15789, 15790, 15791, 15792, 15793, 15794, 15795, 15797, 15800, 15801, 15803, 15804, 15805, 15807, 15809, 15825, 15826, 15827, 15832, 15835, 15837, 15838, 15839, 15840, 15841, 15842, 15843, 15844, 15845, 15846, 15847, 15849, 15850, 15851, 15852, 15853, 15854, 15855, 15856, 15857, 15858, 15863, 15864, 15865, 15866, 15867, 15868, 15869, 15870, 15871, 15872, 15873, 15874, 15875, 15876, 15877, 15878, 15879, 15880, 15881, 15882, 15883, 15889, 15892, 15893, 15894, 15895, 15896, 15899, 15900, 15901, 15902, 15903, 15904, 15905, 15906, 15907, 15908, 15910, 15911, 15912, 15913, 15914, 15920, 15924, 15925, 15927, 15928, 15929, 15931, 15932, 15935, 15936, 15937, 15938, 15949, 15951, 15952, 15953, 15954, 15955, 15956, 15957, 15958, 15959, 15960, 15961, 15962, 15963, 15965, 15966, 15967, 15968, 15973, 15974, 15975, 15976, 15977, 15978, 15980, 15981, 15982, 15983, 15984, 15985, 15986, 15987, 15988, 15989, 15990, 15991, 15993, 15994, 15996, 15997, 16000, 16002, 16003, 16004, 16005, 16009, 16010, 16011, 16012, 16013, 16014, 16015, 16017, 16018, 16019, 16020, 16021, 16022, 16023, 16024, 16026, 16031, 16032, 16033, 16034, 16035, 16038, 16039, 16041, 16042, 16043, 16049, 16052, 16053, 16055, 16056, 16057, 16058, 16059, 16062, 16070, 16071, 16073, 16077, 16086, 16087, 16088, 16089, 16090, 16091, 16092, 16093, 16094, 16095, 16098, 16101, 16108, 16118, 16119, 16120, 16123, 16134, 16136, 16138, 16140, 16143, 16144, 16145, 16149, 16152, 16153, 16154, 16155, 16156, 16157, 16158, 16170, 16172, 16177, 16189, 16190, 16191, 16193, 16195, 16196, 16201, 16202, 16204, 16207, 16208, 16209, 16210, 16212, 16213, 16218, 16221, 16224, 16225, 16232, 16234, 16237, 16240, 16241, 16245, 16246, 16247, 16248, 16249, 16252, 16253, 16254, 16255, 16259, 16261, 16264, 16266, 16267, 16269, 16270, 16273, 16274, 16275, 16276, 16277, 16278, 16279, 16280, 16281, 16282, 16283, 16284, 16285, 16286, 16287, 16289, 16290, 16291, 16292, 16293, 16294, 16295, 16296, 16297, 16298, 16299, 16300, 16301, 16303, 16304, 16305, 16309, 16317, 16321, 16324, 16332, 16336, 16341, 16342, 16343, 16344, 16346, 16354, 16361, 16362, 16368, 16370, 16372, 16373, 16378, 16379, 16384, 16385, 16386, 16387, 16389, 16392, 16395, 16396, 16398, 16399, 16400, 16408, 16409, 16410, 16413, 16414, 16415, 16419, 16420, 16421, 16422, 16423, 16427, 16430, 16431, 16433, 16434, 16436, 16437, 16438, 16439, 16444, 16445, 16446, 16447, 16448, 16453, 16455, 16456, 16459, 16471, 16476, 16477, 16481, 16482) GROUP BY `SadrListOfDrug`.`drug_name` HAVING COUNT(distinct `SadrListOfDrug`.`sadr_id`) > 0 | 1787 | 1787 | 148 | maybe slow |