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