Query fails with internal error

SELECT COUNT(META().id) AS matches

FROM col1 AS d

WHERE d.`f1` = 'f1'

  AND (ARRAY_SUM((

      SELECT VALUE i.`cnt`

      FROM d.`x1` AS i

      WHERE i.`date` BETWEEN DATE_TRUNC_STR(DATE_ADD_STR(NOW_TZ("America/New_York"), -90, 'day'), 'day') AND DATE_TRUNC_STR(NOW_TZ("America/New_York"), 'day')

        AND i.`item` IN ['1234', '5678'] )) >= 1

    OR ARRAY_SUM((

      SELECT VALUE i.`cnt`

      FROM d.`x2` AS i

      WHERE i.`date` BETWEEN DATE_TRUNC_STR(DATE_ADD_STR(NOW_TZ("America/New_York"), -90, 'day'), 'day') AND DATE_TRUNC_STR(NOW_TZ("America/New_York"), 'day')

        AND i.`item` IN ['1234', '5678'] )) >= 1

    OR (ANY e IN d.x3 SATISFIES e.item IN ['i1', 'i2', 'i3']

      AND e.su.`x4` >= 1 END));