MySQL 8.0

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

Create Table table_name(ReviewID INT, ReviewerID INT, ReviewText VARCHAR(50), Category VARCHAR(50), ItemID INT, date_time DATE);

Insert Into table_name Values(1,1212,'good product','Mobile',1,'2022-04-23'),
(2,1233,'will buy again','fruit',2,'2022-04-24'),
(3,1245,'not recommended','Mobile',1,'2022-04-25'),
(4,1236,'not ripe','fruit',2,'2022-04-22');

Records: 4  Duplicates: 0  Warnings: 0


CREATE VIEW my_view AS
(
  SELECT T.ReviewID, T.ReviewText, D.AllReviews
  FROM table_name T JOIN
  (
    SELECT Category, ItemID,
      GROUP_CONCAT(CONCAT(date_time, ' ', ItemID, ' ', ReviewText) ORDER BY date_time DESC SEPARATOR '\n') AllReviews
    FROM table_name
    GROUP BY Category, ItemID
  ) D
  ON T.Category = D.Category AND
     T.ItemID = D.ItemID
)
select * from my_view
ORDER BY ReviewID


ReviewID
ReviewText
AllReviews


1
good product
2022-04-25 1 not recommended
2022-04-23 1 good product

2
will buy again
2022-04-24 2 will buy again
2022-04-22 2 not ripe

3
not recommended
2022-04-25 1 not recommended
2022-04-23 1 good product

4
not ripe
2022-04-24 2 will buy again
2022-04-22 2 not ripe

ReviewID	ReviewText	AllReviews
1	good product	2022-04-25 1 not recommended 2022-04-23 1 good product
2	will buy again	2022-04-24 2 will buy again 2022-04-22 2 not ripe
3	not recommended	2022-04-25 1 not recommended 2022-04-23 1 good product
4	not ripe	2022-04-24 2 will buy again 2022-04-22 2 not ripe