explain SELECT COUNT(DISTINCT `business_memberships`.`id`) FROM `business_memberships` LEFT OUTER JOIN `users` ON `users`.`id` = `business_memberships`.`user_id` LEFT OUTER JOIN `businesses` ON `businesses`.`id` = `business_memberships`.`business_id` LEFT OUTER JOIN `sop_settings_service_subscriptions` ON `sop_settings_service_subscriptions`.`business_id` = `businesses`.`id` WHERE `users`.`is_deactivated` = 0 AND `users`.`user_type` IN ('serviceuser', 'accountant', 'referral', 'reseller', 'franchise');

explain SELECT COUNT(*) FROM `payroll_correspondences` INNER JOIN `payroll_employments` ON `payroll_correspondences`.`payroll_employment_id` = `payroll_employments`.`id` WHERE `payroll_employments`.`business_id` = 76039;