user
10/08/2021, 4:21 PMuser
10/08/2021, 4:21 PMuser
10/08/2021, 4:41 PMuser
10/08/2021, 4:41 PMuser
10/08/2021, 5:01 PMuser
10/08/2021, 5:01 PMuser
10/08/2021, 5:21 PMuser
10/08/2021, 5:21 PMuser
10/08/2021, 5:41 PMhttps://i.stack.imgur.com/Mek5n.png▾
https://i.stack.imgur.com/JpGUv.png▾
user
10/08/2021, 7:01 PMuser
10/08/2021, 7:21 PMuser
10/08/2021, 7:41 PMuser
10/08/2021, 7:41 PMuser
10/08/2021, 9:21 PMuser
10/08/2021, 10:01 PMnames
WHERE names.ID IN (SELECT NameID FROM eventname
WHERE eventname.EventID=events.ID) LIMIT 3) as Name
FROM events
As you can see I´m using json_arrayagg function to get more then one value as an single column.
After that I encode it with...user
10/08/2021, 10:21 PMuser
10/08/2021, 11:01 PMuser
10/09/2021, 1:01 AMuser
10/09/2021, 2:01 AMuser
10/09/2021, 5:01 AMuser
10/09/2021, 5:21 AMuser
10/09/2021, 6:41 AMuser
10/09/2021, 6:41 AMhttps://i.stack.imgur.com/wUKWY.png▾
user
10/09/2021, 6:41 AMuser
10/09/2021, 8:01 AMuser
10/09/2021, 8:21 AMuser
10/09/2021, 8:41 AMuser
10/09/2021, 9:01 AMuser
10/09/2021, 9:41 AMuser
10/09/2021, 10:01 AMenter image description here▾