Risolto cosi :
codice:
GROUP_CONCAT(
CASE WHEN WEEKDAY(calendar.start) = 0 THEN CONCAT('[',json_object('start',calendar.start),']')END) AS Event1,