Json con GROUP_CONCAT

[max1974]

SET SESSION group_concat_max_len = 1000000;

Esatto cosi Funziona. Grazie 1000

Invece trovo anomalia in :

SELECT 
CASE WHEN WEEKDAY(calendar.start) = 0 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS Lunedi,
CASE WHEN WEEKDAY(calendar.start) = 1 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS Martedi,
CASE WHEN WEEKDAY(calendar.start) = 2 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS  Mercoledi,
CASE WHEN WEEKDAY(calendar.start) = 3 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS  Giovedi,
CASE WHEN WEEKDAY(calendar.start) = 4 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS  Venerdi,
CASE WHEN WEEKDAY(calendar.start) = 5 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS  Sabato,
CASE WHEN WEEKDAY(calendar.start) = 6 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS  Domenica
FROM calendar
WHERE WEEK(calendar.start) = 16 AND YEAR(calendar.start) = 2021 

come result ho

Lunedi 19-04-2021
Martedi 20-04-2021
Mercoledi 21-04-2021
Giovedi 22-04-2021
Venerdi 23-04-2021
Sabato 24-04-2021
Domenica 18-04-2021

Gradirei Domenica 25-04-2021.