Query for Overlapping Pages

overlap.sql

SELECT
  count(*)
FROM
(
  SELECT
      page
  FROM
      `httparchive.requests.*`
  WHERE
      _TABLE_SUFFIX='2018_01_01_desktop' AND
      ENDS_WITH(_TABLE_SUFFIX, 'desktop') AND
      page=url
) pre_period
JOIN
(
  SELECT
      page
  FROM
      `httparchive.requests.*`
  WHERE
    _TABLE_SUFFIX='2018_08_01_desktop' AND
    ENDS_WITH(_TABLE_SUFFIX, 'desktop') AND
    page=url
) post_period
ON (
  pre_period.page=post_period.page
)
;