| SELECT `MedicationProduct`.`generic_name_i` AS `generic_name_i`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`created` > '2020-04-01 08:08:08' AND `MedicationProduct`.`generic_name_i` > '' AND `MedicationProduct`.`medication_id` IN (12, 13, 35, 44, 45, 47, 49, 65, 66, 68, 69, 70, 71, 73, 74, 77, 78, 80, 81, 82, 84, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 98, 102, 103, 105, 106, 107, 115, 116, 118, 119, 123, 129, 130, 131, 132, 133, 134, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 151, 155, 156, 157, 158, 159, 160, 162, 164, 165, 166, 167, 168, 169, 170, 172, 173, 175, 176, 177, 178, 179, 180, 181, 182, 183, 191, 194, 195, 196, 197, 198, 204, 212, 214, 226, 227, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 244, 250, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 269, 270, 271, 272, 273, 274, 275, 276, 279, 281, 282, 283, 284, 285, 287, 289, 290, 292, 294, 297, 299, 303, 304, 305, 306, 307, 308, 313, 314, 315, 317, 318, 319, 320, 321, 325, 326, 327, 330, 331, 332, 333, 334, 335, 336, 337, 339, 340, 341, 342, 343, 344, 345, 346, 350, 352, 353, 355, 356, 357, 358, 359, 360, 363, 366, 367, 369, 370, 371, 372, 373, 377, 378, 379, 380, 381, 382, 383, 385, 386, 387, 388, 389, 390, 391, 392, 394, 395, 396, 399, 400, 401, 402, 403, 404, 406, 407, 408, 410, 415, 416, 417, 420, 421, 424, 425, 426, 427, 428, 429, 432, 433, 434, 435, 436, 438, 442, 443, 444, 445, 446, 447, 448, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 472, 477, 483, 484, 485, 486, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 525, 527, 538, 541, 542, 543, 581, 582, 583, 584, 587, 589, 590, 591, 592, 593, 594, 595, 596, 597, 599, 600, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 617, 618, 619, 623, 624, 626, 627, 628, 631, 632, 633, 636, 637, 638, 639, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 653, 654, 655, 656, 657, 660, 661, 662, 663, 664, 672, 673, 678, 684, 699, 700, 701, 702, 706, 707, 709, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 733, 734, 735, 740, 745, 746, 747, 748, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 765, 766, 768, 769, 770, 771, 772, 773, 774, 776, 777, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 800, 801, 802, 803, 804, 805, 806, 807, 814, 819, 820, 821, 825, 828, 830, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 848, 849, 850, 851, 852, 853, 854, 855, 857, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 880, 881, 882, 883, 884, 885, 887, 888, 889, 890, 891, 892, 893, 894, 896, 897, 899, 900, 901, 902, 903, 904, 908, 909, 910, 911, 916, 917, 918, 943, 945, 946, 947, 948, 949, 950, 954, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 973, 980, 987, 998, 999, 1003, 1005, 1008, 1027, 1029, 1030, 1031, 1033, 1058, 1061, 1078, 1085, 1086, 1088, 1089, 1090, 1091, 1092, 1093, 1105, 1106, 1110, 1113, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1134, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1166, 1167, 1168, 1176, 1179, 1180, 1181, 1182, 1183, 1184, 1186, 1187, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1204, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1260, 1261, 1262, 1263, 1265, 1266, 1269, 1270, 1271, 1276, 1279, 1280, 1281, 1289, 1290, 1291, 1292, 1293, 1294, 1297, 1298, 1299, 1300, 1301, 1302, 1303, 1304, 1305, 1306, 1308, 1309, 1310, 1312, 1313, 1315, 1319, 1320, 1323, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1354, 1356, 1377, 1378, 1414, 1417, 1420, 1432, 1434, 1435, 1436, 1437, 1438, 1439, 1444, 1445, 1450, 1454, 1458, 1461, 1463, 1464, 1469, 1471, 1473, 1475, 1477, 1483, 1484, 1485, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1501, 1502, 1504, 1505, 1506, 1507, 1510, 1512, 1514, 1522, 1526, 1527, 1530, 1531, 1532, 1533, 1534, 1536, 1538, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1553, 1554, 1555, 1556, 1557, 1558, 1559, 1561, 1562, 1563, 1564, 1566, 1567, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1588, 1590, 1592, 1593, 1594, 1595, 1600, 1601, 1602, 1603, 1604, 1605, 1606, 1607, 1609, 1610, 1612, 1617, 1620, 1623, 1624, 1625, 1626, 1627, 1628, 1629, 1630, 1631, 1632, 1633, 1634, 1635, 1636, 1637, 1638, 1640, 1641, 1642, 1643, 1646, 1647, 1650, 1651, 1655, 1661, 1662, 1664, 1665, 1669, 1670, 1671, 1674, 1676, 1677, 1678, 1679, 1682, 1683, 1684, 1686, 1689, 1691, 1694, 1696, 1702, 1705, 1706, 1708, 1711, 1717, 1719, 1720, 1722, 1723, 1727, 1729, 1731, 1736, 1737, 1742, 1743, 1744, 1747, 1748, 1749, 1750, 1752, 1753, 1755, 1757, 1768, 1769, 1772, 1774, 1781, 1782, 1783, 1784, 1789, 1791, 1792, 1793, 1794, 1795, 1796, 1797, 1798, 1799, 1802, 1805, 1807, 1809, 1811, 1813, 1819, 1822, 1823, 1824, 1828, 1830, 1836, 1844, 1846, 1847, 1857, 1858, 1859, 1860, 1862, 1864, 1865, 1869, 1870, 1877, 1879, 1881, 1882, 1883, 1885, 1886, 1887, 1888, 1889, 1891, 1892, 1894, 1895, 1896, 1897, 1907, 1908, 1909, 1910, 1911, 1912, 1913, 1914, 1915, 1916, 1917, 1918, 1919, 1921, 1925, 1926, 1927, 1929, 1930, 1931, 1933, 1934, 1935, 1936, 1940, 1941, 1945, 1946, 1949, 1952, 1953, 1954, 1956, 1957, 1958, 1959, 1960, 1961, 1962, 1964, 1965, 1966, 1967, 1968, 1969, 1975, 1976, 1977, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1992, 1994, 1995, 2018, 2021, 2022, 2027, 2028, 2030, 2035, 2036, 2038, 2041, 2042, 2043, 2044, 2045, 2046, 2047, 2050, 2053, 2055, 2056, 2060, 2061, 2064, 2065, 2066, 2068, 2069, 2090, 2091, 2099, 2100, 2101, 2104, 2105, 2107, 2108, 2114, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2123, 2124, 2125, 2126, 2128, 2129, 2130, 2131, 2132, 2134, 2135, 2136, 2137, 2144, 2147, 2151, 2152, 2153, 2154, 2155, 2156, 2157, 2158, 2159, 2160, 2161, 2162, 2163, 2164, 2165, 2167, 2170, 2171, 2173, 2181, 2182, 2183, 2184, 2185, 2187, 2188, 2190, 2191, 2192, 2193, 2194, 2196, 2197, 2198, 2199, 2200, 2201, 2203, 2206, 2207, 2208, 2209, 2210, 2211, 2213, 2214, 2215, 2216, 2218, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2232, 2233, 2234, 2235, 2236, 2240, 2241, 2255, 2256, 2257, 2258, 2260, 2262, 2269, 2270, 2271, 2272, 2273, 2274, 2276, 2277, 2279, 2281, 2283, 2287, 2288, 2289, 2291, 2292, 2295) GROUP BY `MedicationProduct`.`generic_name_i` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0 | 603 | 603 | 13 | |
