SELECT	
	CONCAT(s.LogID, ' ') AS ActivityID,
	t.TeamName AS Team,
	CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName,
	CASE WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN 'Saturday' ELSE 'Sunday' END AS ActivityDay,
	DATE(s.DateTimeCreated) AS ActivityDate,
	MIN(s.DateTimeCreated) AS DataFrom,
	MAX(s.EstimateTimeFinish) AS DataTo,
	SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish) - TIME_TO_SEC(s.DateTimeCreated))) AS ActivityDuration,
	((SUM(TIME_TO_SEC(s.EstimateTimeFinish) - TIME_TO_SEC(s.DateTimeCreated)))/26640) AS PersonDays,
	CONCAT(r.CapexCode, ' - ', r.ResourceName) AS Resource,
	s.StaffActivity AS Activity,
	s.AdditionalNotes AS Notes,
	CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) FROM 5), '/', SUBSTRING(YEARWEEK(s.DateTimeCreated,1), 1, 4)) AS ActivityWeek,
	CASE COUNT(*) WHEN 1 THEN '(1 Event)' ELSE '(Multiple Events)' END AS DataAccuracy
FROM	
	StaffActivities s
INNER JOIN Users u ON u.UserID=s.StaffUserID	
INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID	
INNER JOIN Teams t ON t.TeamID=s.TeamID	
GROUP BY 	
	s.LogID
ORDER BY 	
	s.TeamID, u.Username, s.DateTimeCreated, Resource

1.  SELECT 
2.      CONCAT(s.LogID, ' ') AS ActivityID, 
3.      t.TeamName AS Team, 
4.      CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, 
5.      CASE WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN 'Saturday' ELSE 'Sunday' END AS ActivityDay, 
6.      DATE(s.DateTimeCreated) AS ActivityDate, 
7.      MIN(s.DateTimeCreated) AS DataFrom, 
8.      MAX(s.EstimateTimeFinish) AS DataTo, 
9.      SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish) - TIME_TO_SEC(s.DateTimeCreated))) AS ActivityDuration, 
10.      ((SUM(TIME_TO_SEC(s.EstimateTimeFinish) - TIME_TO_SEC(s.DateTimeCreated)))/26640) AS PersonDays, 
11.      CONCAT(r.CapexCode, ' - ', r.ResourceName) AS Resource, 
12.      s.StaffActivity AS Activity, 
13.      s.AdditionalNotes AS Notes, 
14.      CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) FROM 5), '/', SUBSTRING(YEARWEEK(s.DateTimeCreated,1), 1, 4)) AS ActivityWeek, 
15.      CASE COUNT(*) WHEN 1 THEN '(1 Event)' ELSE '(Multiple Events)' END AS DataAccuracy 
16.  FROM 
17.      StaffActivities s 
18.  INNER JOIN Users u ON u.UserID=s.StaffUserID 
19.  INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID 
20.  INNER JOIN Teams t ON t.TeamID=s.TeamID 
21.  GROUP BY 
22.      s.LogID 
23.  ORDER BY 
24.      s.TeamID, u.Username, s.DateTimeCreated, Resource