MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `users` (
  `ID` int(11) NOT NULL,
  `email` varchar(255) NOT NULL DEFAULT '',
  `password` text NOT NULL,
  `username` varchar(25) NOT NULL DEFAULT '',
  `first_name` varchar(25) NOT NULL DEFAULT '',
  `last_name` varchar(25) DEFAULT '',
  `phone_number` varchar(500) DEFAULT '',
  `avatar` varchar(1000) DEFAULT 'default.png',
  `presentation` text,
  `joined_date` varchar(10) DEFAULT '',
  `game_list` text,
  `online_timestamp` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `users` (`ID`, `email`, `password`, `username`, `first_name`, `last_name`, `phone_number`, `avatar`, `presentation`, `joined_date`, `game_list`, `online_timestamp`) VALUES
(1, 'manju@mail.com', 'b1412a571b7299320156340ad096da80db54846ac3a624a3971094ecd61eb0b1ce7c6ef8faa7f86b3c39aa8590a5430a0f13d84fb6f4e55c028700774854d636rdSOnJ9wNxVP/xtlOsl6jZx2sYhWTWmWq53ce1vsbVs=', 'manju', '', '', '9865471230', '1698862132.png', '  Im looking for a pro CSGO Team. I can play every day after 6pm. Check my videos on youtube.   ', '', 'Game 1|Game 2|Game 3|Game 4|Game 5', 1539351337),
(6, 'm995@mail.com', '5e88c6b32ff3d2ca45348f5098d5c984e72f7f8098d97b74c9db43db820b3e150eb5d4c76b55780855cf16d343c9ae5b11cd84b824bf01b4b1a9a74f1e46e408nXMls+yFVW/UCZC6lqJoWWnjO8X0oVANoHJ/lco4lP4=', 'manjunath', '', '', '9876543210', 'default.png', 'Im looking for a pro CSGO Team. I can play every Day after 6pm.Check my Videos on Yuotube.', '', NULL, 1538741095),
(13, 'y3@mail.com', '4a02faf947753808243c2f3b599cd4d3acb7c5c342339c8d0e8e779842f23f5d6a514957fff4b39951bb402d8639e833a7acf5874cd86e1e991c340708dac684D8iFLZ5TrT4pBDi2+hF1bFpOAz6oKM4RxOBSd8R/Xzc=', 'ykthevillain', '', '', '7795', 'default.png', 'Im looking for a pro CSGO Team. I can play every Day after 6pm.Check my Videos on Yuotube.', '', 'Game 1|Game 2', 1538545782),
(14, 'nishanth@mail.com', 'd0cf48a3f26c17c847619efa191af7868ae59abc2e39209eb40e2915070687484de1ff6375555ff720833c77253ba27a1f32b68dd0c6dca2d31fbd537c4c20fdAOE8BFxvVyZGIOev2dk8gTE3g2+WeM251GHgHmHUbZI=', 'Nishanth', '', '', '9738508249', 'default.png', 'Im looking for a pro CSGO Team. I can play every Day after 6pm.Check my Videos on Yuotube.', '', NULL, 1539412338);
CREATE TABLE `user_friends` (
  `ID` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `friendid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `timestamp` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `user_friends` (`ID`, `userid`, `friendid`, `status`, `timestamp`) VALUES
(1, 8, 4, 2, 1538369252),
(2, 1, 2, 2, 1538454842),
(3, 7, 1, 2, 1538455395),
(4, 7, 2, 2, 1538455487),
(5, 11, 2, 3, 1538455512),
(6, 6, 2, 2, 1538455567),
(7, 2, 5, 2, 1538456136),
(8, 1, 6, 1, 1538491568),
(9, 12, 1, 2, 1538499199),
(12, 1, 7, 1, 1538565860),
(13, 14, 1, 2, 1538800794);
CREATE TABLE `feed_item_comment` (
  `ID` int(11) NOT NULL,
  `postid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `comment` varchar(3000) NOT NULL,
  `timestamp` time NOT NULL,
  `likes` int(11) NOT NULL,
  `commentid` int(11) NOT NULL,
  `replies` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `feed_item_comment` (`ID`, `postid`, `userid`, `comment`, `timestamp`, `likes`, `commentid`, `replies`) VALUES
(1, 1, 1, 'Look Good', '20:00:00', 0, 0, 0),
(2, 1, 14, 'So I\'m!', '20:10:00', 0, 0, 0),
(3, 2, 1, 'Fine', '15:00:15', 0, 0, 0),
(4, 2, 1, 'Not Good', '15:05:10', 0, 0, 0),
(5, 3, 1, 'manju comment', '13:17:31', 0, 0, 0),
(6, 3, 1, 'new cmt', '14:00:15', 0, 0, 0);
CREATE TABLE `feed_item` (
  `ID` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `content` text NOT NULL,
  `timestamp` time NOT NULL,
  `imageid` int(11) NOT NULL,
  `likes` int(11) NOT NULL,
  `comments` int(11) NOT NULL,
  `user_flag` int(11) NOT NULL,
  `likes_data` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `feed_item` (`ID`, `userid`, `content`, `timestamp`, `imageid`, `likes`, `comments`, `user_flag`, `likes_data`) VALUES
(1, 14, 'How are you?', '14:07:00', 0, 0, 2, 0, 'like'),
(2, 14, 'How are you doing?', '13:06:42', 0, 0, 2, 0, 'like'),
(3, 1, 'This is manju', '13:12:31', 0, 0, 2, 0, 'like');
select id, userid,content,timestamp,comment_count,
min(case when seq=1 then comment end) as comment1,
min(case when seq=1 then comment_timestamp end) as commenttime1,
min(case when seq=2 then comment end) as comment2,
min(case when seq=2 then comment_timestamp end) as commenttime2
from
(
select *,row_number() over(partition by id,userid order by comment_timestamp) as seq from 
(SELECT DISTINCT ft.ID as ID, ft.userid, ft.content, ft.timestamp, ft.comments as comment_count, ftc.comment, ftc.timestamp as comment_timestamp, uq.username, uq.avatar FROM users uq,
feed_item ft 
LEFT JOIN feed_item_comment ftc ON ftc.postid = ft.ID
LEFT JOIN user_friends uf ON uf.friendid = ftc.userid 
LEFT JOIN users u ON u.ID = uf.friendid WHERE uq.ID = ft.userid AND ft.userid
IN 
(SELECT u.ID FROM users u WHERE u.ID 
IN (SELECT uf.friendid FROM user_friends uf WHERE uf.status = '2' AND uf.userid = 1) 
OR u.ID IN 
(SELECT uf.userid FROM user_friends uf WHERE uf.status = '2' AND uf.friendid = 1) 
OR
u.ID = 1
)ORDER BY ft.ID DESC, ftc.timestamp DESC)X)Y
group by id, userid,content,timestamp,comment_count


id
userid
content
timestamp
comment_count
comment1
commenttime1
comment2
commenttime2


1
14
How are you?
14:07:00
2
Look Good
20:00:00
So I'm!
20:10:00

2
14
How are you doing?
13:06:42
2
Fine
15:00:15
Not Good
15:05:10

3
1
This is manju
13:12:31
2
manju comment
13:17:31
new cmt
14:00:15
id	userid	content	timestamp	comment_count	comment1	commenttime1	comment2	commenttime2
1	14	How are you?	14:07:00	2	Look Good	20:00:00	So I'm!	20:10:00
2	14	How are you doing?	13:06:42	2	Fine	15:00:15	Not Good	15:05:10
3	1	This is manju	13:12:31	2	manju comment	13:17:31	new cmt	14:00:15