SELECT
        -- subnet.*,
        subnet.id AS "subnet_ptr_id",
        fabric.id AS "fabric_id", fabric.name AS "fabric_name",
        vlan.vid AS "vlan_vid", vlan.name AS "vlan_name",
        space.id AS "space_id", space.name AS "space_name"
    FROM maasserver_fabric fabric
    LEFT OUTER JOIN maasserver_vlan vlan ON vlan.fabric_id = fabric.id
    LEFT OUTER JOIN maasserver_subnet subnet ON subnet.vlan_id = vlan.id
    LEFT OUTER JOIN maasserver_space space
        ON space.id IS NOT DISTINCT FROM vlan.space_id
    ORDER BY
        fabric.name,
        vlan.vid,
        subnet.cidr;