Untitled

SELECT MIN(st.description) as description, COUNT(*) as installations FROM subscriptions s LEFT JOIN subscription_types st ON s.subscription_type_id = st.id LEFT JOIN subscribers sb ON s.subscriber_id = sb.id LEFT JOIN installations i ON sb.installation_id = i.id WHERE i.id = 1 GROUP BY subscription_type_id;