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, 5, 6, 7, 8, 10, 11, 13, 14, 15, 16, 17, 18, 19, 20, 21, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 73, 75, 76, 77, 78, 86, 87, 89, 90, 92, 93, 94, 95, 96, 192, 215, 266, 286, 299, 324, 347, 358, 359, 367, 375, 376, 383, 391, 395, 398, 399, 401, 407, 412, 413, 417, 420, 425, 427, 428, 430, 437, 464, 468, 473, 475, 477, 478, 484, 485, 499, 500, 503, 505, 508, 511, 514, 516, 518, 519, 523, 552, 558, 560, 564, 565, 569, 581, 584, 588, 589, 591, 594, 596, 598, 599, 600, 602, 605, 608, 615, 620, 622, 658, 664, 668, 673, 685, 690, 692, 693, 700, 705, 713, 722, 735, 755, 759, 761, 776, 783, 784, 788, 790, 791, 792, 793, 795, 801, 803, 804, 807, 811, 835, 841, 844, 845, 848, 850, 851, 852, 855, 857, 859, 861, 864, 868, 869, 870, 876, 877, 880, 884, 890, 896, 920, 923, 924, 927, 929, 938, 957, 964, 969, 971, 982, 1006, 1023, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 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, 1259, 1260, 1261, 1262, 1263, 1264, 1265, 1266, 1267, 1268, 1269, 1270, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1290, 1291, 1292, 1293, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1301, 1302, 1303, 1304, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1317, 1318, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1346, 1347, 1348, 1350) GROUP BY `SadrListOfDrug`.`drug_name` HAVING COUNT(distinct `SadrListOfDrug`.`sadr_id`) > 0 | 79 | 79 | 4 | maybe slow |