i.live_revision is not null i.live_revision is null creation_date > current_timestamp - interval '1' day creation_date > current_timestamp - interval '7' day creation_date > current_timestamp - interval '30' day