SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete create table events ( id serial, operation_id int, type varchar(32), date timestamp ); insert into events values (1, 100, 'open', '2021-02-03 07:36:55'), (2, 100, 'open_page_1', '2021-02-03 07:36:55'), (3, 100, 'close_page_1', '2021-02-03 07:36:56'), (4, 200, 'open', '2021-02-03 07:36:55'), (5, 200, 'open_page_2', '2021-02-03 07:36:55'), (6, 300, 'open_page_1', '2021-02-03 07:36:55'); select * from events where date > current_timestamp - interval '3 hour' and type in ('open', 'open_page_1') and not exists ( select type from events e where e.operation_id = events.operation_id and type not in ('open', 'open_page_1') ) ;