learn:oncallAMP
Query: SELECT GROUP_CONCAT(`cargo__scheduleFACservice`.`StaffAbbrev`) AS `StaffAbbrev)`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,GROUP_CONCAT(`cargo__scheduleFACservice`.`StaffFullName`) AS `StaffFullName)`,`cargo__facultyMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFACservice` LEFT OUTER JOIN `cargo__facultyMGH` ON ((`cargo__scheduleFACservice`.`StaffAbbrev`=`cargo__facultyMGH`.`copath_id`)) WHERE YEAR(Date)=2025 AND `cargo__scheduleFACservice`.`TaskAbbrev`='TaskAbbreviation' AND `cargo__scheduleFACservice`.`DayNumber`='1' AND `cargo__scheduleFACservice`.`WeekNumber`='4' AND DayNumer='7' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY GROUP_CONCAT(`cargo__scheduleFACservice`.`StaffAbbrev`),`cargo__scheduleFACservice`.`TaskAbbrev`,GROUP_CONCAT(`cargo__scheduleFACservice`.`StaffFullName`),`cargo__facultyMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'DayNumer' in 'WHERE' (172.27.81.126:30004)
