Something

SELECT          networks.id,                networks.name,                networks.active,                count(distinct(servers.id)) AS servers,                count(distinct(routers.id)) AS routers,                count(distinct(routersDownstreams.id)) AS downstreams,                count(distinct(routersUpstreams.id)) AS upstreamsFROM            networksLEFT JOIN       servers ON (networks.id = servers.networksID)LEFT JOIN       routers ON (networks.id = routers.networksID)LEFT JOIN       routersDownstreams ON (routers.id =routersDownstreams.routersID)LEFT JOIN       routersUpstreams ON (routers.id = routersUpstreams.routersID)GROUP BY        networks.idORDER BY        networks.name ASC