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 (2, 5, 9, 10, 52, 63, 64, 65, 98, 117, 123, 144, 146, 149, 162, 204, 208, 221, 222, 223, 224, 5183, 5199, 5201, 5213, 5214, 5217, 5219, 5220, 5221, 5223, 5224, 5226, 5232, 5236, 5237, 5240, 5243, 5246, 5250, 5253, 5256, 5283, 5296, 5298, 5305, 5325, 5341, 5345, 5372, 5382, 5391, 5395, 5399, 5400, 5542, 5582, 5592, 5634, 5635, 5640, 5641, 5643, 5654, 5655, 5714, 5755, 5790, 5791, 5795, 5796, 5802, 5869, 5878, 5879, 5906, 5907, 5918, 5921, 5922, 5925, 5932, 5963, 5976, 5979, 5981, 5982, 5997, 6007, 6019, 6023, 6031, 6034, 6035, 6050, 6051, 6052, 6053, 6070, 6080, 6082, 6085, 6110, 6111, 6113, 6117, 6118, 6119, 6137, 6138, 6167, 6174, 6180, 6186, 6199, 6208, 6233, 6238, 6253, 6254, 6255, 6258, 6264, 6272, 6277, 6287, 6297, 6299, 6302, 6306, 6307, 6309) GROUP BY `SadrListOfDrug`.`drug_name` HAVING COUNT(distinct `SadrListOfDrug`.`sadr_id`) > 0 | 108 | 108 | 8 | maybe slow |