MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.30


CREATE TABLE test 
(
  created_date TIMESTAMP(1) NOT NULL,
  origin_url   VARCHAR (200) NOT NULL,
  client_session_id VARCHAR (50) NOT NULL
);
INSERT INTO test VALUES
('2021-01-18 11:02:24.0', 'https://ttttttt.com/', 'znkjoc3gfth2c3m0t1klii'),
('2021-01-18 11:02:35.0', 'https://zendes.com/', 'znkjoc3gfth2c3m0t1klii'),
('2021-01-18 11:11:03.0', 'https://testett.com/', 'znkjoc3gfth2c3m0t1klii'),
('2021-01-18 11:49:28.0', 'https://zendes.com/', 'znkjoc3gfth2c3m0t1klii'),
('2021-01-18 11:50:36.0', 'https://zendes.com/', 'znkjoc3gfth2c3m0t1klii'),
('2021-01-18 11:51:05.0', 'https://zendes.com/', 'znkjoc3gfth2c3m0t1klii');

Records: 6  Duplicates: 0  Warnings: 0


SELECT
  created_date,
  LEAD(created_date, 2) OVER (PARTITION BY origin_url, client_session_id 
                            ORDER BY created_date DESC, origin_url, client_session_id) AS l_3,
  TIMESTAMPDIFF
  (
    MINUTE,
    created_date, 
    LEAD(created_date, 2) OVER (PARTITION BY origin_url, client_session_id 
                            ORDER BY created_date DESC, origin_url, client_session_id)
  ) AS min_diff,
  origin_url,
  client_session_id
FROM test;


created_date
l_3
min_diff
origin_url
client_session_id


2021-01-18 11:11:03.0
null
null
https://testett.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:02:24.0
null
null
https://ttttttt.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:51:05.0
2021-01-18 11:49:28.0
-1
https://zendes.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:50:36.0
2021-01-18 11:02:35.0
-48
https://zendes.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:49:28.0
null
null
https://zendes.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:02:35.0
null
null
https://zendes.com/
znkjoc3gfth2c3m0t1klii


SELECT
  created_date,
  LEAD(created_date, 2) OVER (PARTITION BY origin_url, client_session_id 
                            ORDER BY created_date DESC, origin_url, client_session_id) AS l_3,
  ABS(TIMESTAMPDIFF
  (
    MINUTE,
    created_date, 
    LEAD(created_date, 2) OVER (PARTITION BY origin_url, client_session_id 
                            ORDER BY created_date DESC, origin_url, client_session_id)
  )) AS min_diff,
  UNIX_TIMESTAMP(created_date) -
  UNIX_TIMESTAMP
  (
    LEAD(created_date, 2) OVER (PARTITION BY origin_url, client_session_id 
                            ORDER BY created_date DESC, origin_url, client_session_id)
  ) AS ut_d,
  origin_url,
  client_session_id
FROM test;


created_date
l_3
min_diff
ut_d
origin_url
client_session_id


2021-01-18 11:11:03.0
null
null
null
https://testett.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:02:24.0
null
null
null
https://ttttttt.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:51:05.0
2021-01-18 11:49:28.0
1
97.0
https://zendes.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:50:36.0
2021-01-18 11:02:35.0
48
2881.0
https://zendes.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:49:28.0
null
null
null
https://zendes.com/
znkjoc3gfth2c3m0t1klii

2021-01-18 11:02:35.0
null
null
null
https://zendes.com/
znkjoc3gfth2c3m0t1klii


SELECT * FROM
(
  SELECT
    created_date,
    LEAD(created_date, 2) 
           OVER (PARTITION BY origin_url, client_session_id 
                   ORDER BY created_date DESC, origin_url, client_session_id) AS l_3,
    created_date -
    LEAD(created_date, 2) 
           OVER (PARTITION BY origin_url, client_session_id 
                   ORDER BY created_date DESC, origin_url, client_session_id) AS l_diff,
    UNIX_TIMESTAMP(created_date) -
    UNIX_TIMESTAMP
    (
      LEAD(created_date, 2) OVER (PARTITION BY origin_url, client_session_id 
                            ORDER BY created_date DESC, origin_url, client_session_id)
    ) AS ut_d,
    origin_url,
    client_session_id 
  FROM test
) AS t
WHERE t.ut_d  < 180;


created_date
l_3
l_diff
ut_d
origin_url
client_session_id


2021-01-18 11:51:05.0
2021-01-18 11:49:28.0
177.0
97.0
https://zendes.com/
znkjoc3gfth2c3m0t1klii

created_date	l_3	min_diff	origin_url	client_session_id
2021-01-18 11:11:03.0	null	null	https://testett.com/	znkjoc3gfth2c3m0t1klii
2021-01-18 11:02:24.0	null	null	https://ttttttt.com/	znkjoc3gfth2c3m0t1klii
2021-01-18 11:51:05.0	2021-01-18 11:49:28.0	-1	https://zendes.com/	znkjoc3gfth2c3m0t1klii
2021-01-18 11:50:36.0	2021-01-18 11:02:35.0	-48	https://zendes.com/	znkjoc3gfth2c3m0t1klii
2021-01-18 11:49:28.0	null	null	https://zendes.com/	znkjoc3gfth2c3m0t1klii
2021-01-18 11:02:35.0	null	null	https://zendes.com/	znkjoc3gfth2c3m0t1klii