weirdly enough if i just run the query below, without date, for that one day i still get the same wrong unique visitor count: AS WITH InitialAggregation AS (
SELECT
CONCAT(post_visid_high, post_visid_low) AS unique_visitor_id,
COUNT(DISTINCT CONCAT(post_visid_high, post_visid_low...