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, 710, 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, 886, 890, 896, 920, 923, 924, 927, 929, 938, 957, 964, 969, 971, 982, 1006, 1007) GROUP BY `SadrListOfDrug`.`drug_name` HAVING COUNT(distinct `SadrListOfDrug`.`sadr_id`) > 0 | 76 | 76 | 13 | maybe slow |