AND bg.charttime >= ie.intime - INTERVAL '6 HOUR' AND bg.charttime <= ie.intime + INTERVAL '1 DAY' ...