SELECT customers.`first_name`, customers.`last_name`, company.`company_username`, company.`company_name`, company.`company_subdomain`, subscription_details.`available_users`, subscription_details.`num_users` AS used_users, subscription_details.`start_date`, subscription_details.`end_date`, subscription_details.`plan_name`, subscription_details.`is_active` FROM customers, company, subscription_details WHERE customers.`user_id` = company.`creator` AND customers.`user_id` = subscription_details.`user_id` AND subscription_details.`is_active` = 1