select 
users.id, users.sage_username, users.email, 
organizations.id, organizations.name, 
user_gateways.gateway_name, user_gateways.merchant_id, user_gateways.merchant_key, user_gateways.login, user_gateways.email, user_gateways.active, user_gateways.type 
from organizations 
join users on organizations.created_by_id = users.id 
join user_gateways on user_gateways.organization_id=organizations.id 
join 
   (select organization_id, gateway_name, count(gateway_name) 
       from user_gateways 
       group by organization_id, gateway_name 
       having count(gateway_name) > 1) as them 
   on them.organization_id = organizations.id;

users with more than one of a gateway

SQL