przerabiam paginację na nodes. robię zapytanie w funkcji:
SELECT COUNT(*) FROM vnodes n
                JOIN customersview c ON (n.ownerid = c.id)
                JOIN networks net ON net.id = n.netid
                LEFT JOIN location_cities lc ON lc.id = n.location_city
                LEFT JOIN location_boroughs lb ON lb.id = lc.boroughid
                LEFT JOIN location_districts ld ON ld.id = lb.districtid
                LEFT JOIN location_states ls ON ls.id = ld.stateid  WHERE 1=1  GROUP BY n.name  ORDER BY n.name asc