CREATE view montofri as SELECT 0 as dy UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4;
SET group_concat_max_len=255;
SELECT weeknum.wk, group_concat(ifnull(timedata.startTime,'NA') ORDER BY montofri.dy) as start,
group_concat(ifnull(timedata.endTime,'NA') ORDER BY montofri.dy) as END,
group_concat(weeknum.wk ORDER BY montofri.dy) as test
FROM montofri
JOIN (SELECT DISTINCT WEEKOFYEAR(DATE) as wk FROM timesheet) as weeknum
LEFT JOIN timesheet on montofri.dy=WEEKDAY(timesheet.DATE) AND weeknum.wk=WEEKOFYEAR(timesheet.DATE)
LEFT JOIN timedata on timesheet.id = timedata.timesheetID
GROUP BY weeknum.wk