address nodes near buildings of the same address but not inside

addresses.style

node,way    addr:unit               text    polygon
node,way    addr:housenumber        text    polygon
node,way    addr:street             text    polygon
node,way    addr:city               text    polygon
node,way    building                text    polygon

node,way    z_order                 int4    linear  # This is calculated during import
way         way_area                real            # This is calculated during import

badnode.sql

SELECT
    poly.osm_id, node.osm_id,
    poly."addr:street",
    poly."addr:housenumber"
  FROM planet_osm_polygon poly
    JOIN  planet_osm_point node ON (ST_DWithin(poly.way, node.way, 1000))
  WHERE poly.building IS NOT NULL
    AND poly."addr:housenumber" = node."addr:housenumber"
    AND poly."addr:street" = node."addr:street"
    AND NOT ST_Intersects(poly.way, node.way);