problematic postgis query

gistfile1.sql

SET search_path TO us,postgis,hstore;
DROP TABLE IF EXISTS candidates;
CREATE TABLE candidates AS
     WITH agg_intersections AS
     (
          WITH intersection_nodes_wayrefs AS
          (
               WITH intersection_nodes AS
               (
                    SELECT
                         a.id AS node_id,
                         b.way_id,
                         a.geom
                    FROM
                         nodes a,
                         way_nodes b
                    WHERE
                         a.id = b.node_id AND
                         a.id IN
                         (
                              SELECT
                                   DISTINCT node_id
                              FROM
                                   way_nodes
                              GROUP BY
                                   node_id
                              HAVING
                                   COUNT(1) = 2
                         )
               )
               SELECT
                    DISTINCT a.node_id AS node_id,
                    b.id AS way_id,
                    b.tags->'highway' AS osm_highway,
                    a.geom AS geom,
                    b.tags->'ref' AS osm_ref
               FROM
                    intersection_nodes a,
                    ways b
               WHERE
                    a.way_id = b.id
          )
          SELECT
               node_id,
               array_agg(way_id) AS way_ids,
               array_agg(osm_highway) AS osm_highways,
               array_agg(osm_ref) AS osm_refs
          FROM
               intersection_nodes_wayrefs
          GROUP BY
               node_id
     )
     SELECT
          a.* ,
          b.geom AS node_geom,
          c.linestring AS way_geom
     FROM
          agg_intersections a,
          nodes b,
          ways c
     WHERE
          (
               'motorway' = ANY(osm_highways)
               AND NOT
               (
                    'motorway_link' = ANY(osm_highways)
                    OR
                    'service' = ANY(osm_highways)
                    OR
                    'motorway' = ALL(osm_highways)
                    OR
                    'construction' = ANY(osm_highways)
               )
          )    
     AND
          a.node_id = b.id
     AND
          c.id = ANY(a.way_ids);
;