MariaDB 10.3

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

CREATE TABLE `api_log` (
  `id` varchar(50) NOT NULL,
  `clientId` varchar(100) DEFAULT NULL,
  `inserted` int(11) DEFAULT NULL,
  `sessionId` mediumtext DEFAULT NULL,
  `stage` varchar(120) DEFAULT NULL,
  `request` longtext CHARACTER SET utf8mb4 DEFAULT NULL,
  `response` longtext CHARACTER SET utf8mb4 DEFAULT NULL,
  PRIMARY KEY (`id`)
);
INSERT INTO api_log
  VALUES
    ( "1", "abc", 1621008484, "session1", "production", '{"key":"value"}', '{"key":"value"}'),
    ( "2", "abc", 1621008494, "session2", "production", '{"key":"value"}', '{"key":"value"}'),
    ( "3", "abc", 1621008584, "session1", "production", '{"key":"value"}', '{"key":"value"}'),
    ( "4", "abc", 1621008684, "session2", "production", '{"key":"value"}', '{"key":"value"}'),
    ( "5", "abc", 1621008784, "session3", "production", '{"key":"value"}', '{"key":"value"}'),
    ( "6", "abc", 1621008884, "session4", "production", '{"key":"value"}', '{"key":"value"}'),
    ( "7", "abc", 1621008984, "session5", "production", '{"key":"value"}', '{"key":"value"}'),
    ( "8", "abc", 1621009084, "session6", "production", '{"key":"value"}', '{"key":"value"}'),
    ( "9", "abc", 1621009184, "session7", "production", '{"key":"value"}', '{"key":"value"}'),
    ("10", "abc", 1621009284, "session8", "production", '{"key":"value"}', '{"key":"value"}');
SELECT
  id
, clientId
, inserted
, sessionId
, stage
, request
, response
FROM
  (
    SELECT
      *
    , COUNT(*) OVER (PARTITION BY sessionId) AS sessionIdCounter
    FROM
      api_log
  ) AS derived
WHERE
  sessionIdCounter > 1
ORDER BY
  inserted ASC
;


id
clientId
inserted
sessionId
stage
request
response


1
abc
1621008484
session1
production
{"key":"value"}
{"key":"value"}

2
abc
1621008494
session2
production
{"key":"value"}
{"key":"value"}

3
abc
1621008584
session1
production
{"key":"value"}
{"key":"value"}

4
abc
1621008684
session2
production
{"key":"value"}
{"key":"value"}

id	clientId	inserted	sessionId	stage	request	response
1	abc	1621008484	session1	production	{"key":"value"}	{"key":"value"}
2	abc	1621008494	session2	production	{"key":"value"}	{"key":"value"}
3	abc	1621008584	session1	production	{"key":"value"}	{"key":"value"}
4	abc	1621008684	session2	production	{"key":"value"}	{"key":"value"}