SELECT parcels.id, count(*) AS totale
FROM
    _BUFFERS  parcels,
    _POINTS ints
WHERE
    AND ST_intersects( ST_Buffer(parcels.centroid::geography, 800), ints.geom)
GROUP BY parcels.id;

SELECT r.id, r.pcount FROM
    (SELECT
        id, ST_Buffer(centroid::geography, 800) as the_geom
     FROM
        _BUFFERS ) n,
    LATERAL (
        SELECT
            n.id, count(*) as pcount
        FROM
            _POINTS p
        WHERE
            n.the_geom && geom
    ) r