Evaluation of Attending
|
|
|
|
|
|
|
|
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT DATE_FORMAT(`cargo__scheduleRFA`.`Date`, '%b %e, %Y') AS `Date`,CONCAT('{{evaluationResAtt-service|',`cargo__scheduleRFA`.`TaskAbbrev`,'}}') AS `Service`,CONCAT('{{evaluationResAtt-attending|',`cargo__scheduleRFA`.`StaffAbbrev`,'|',`cargo__scheduleRFA`.`TaskAbbrev`,'|',`cargo__scheduleRFA`.`Date`,'|',`cargo__scheduleRFA`.`UID`,'|',`cargo__scheduleRFA`.`WeekNumber`,'|',`cargo__scheduleRFA`.`ResAbbrev`,'}}') AS `Attending` FROM `cargo__scheduleRFA` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRFA`.`UID`=`cargo__evaluationResAtt`.`UID`)) WHERE (`cargo__scheduleRFA`.`TaskAbbrev`='COAG' OR TaskAbbrev='Micro' OR TaskAbbrev='BTS' OR TaskAbbrev='HG' OR TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND YEAR(`cargo__scheduleRFA`.`Date`)='2025' AND `cargo__scheduleRFA`.`ResAbbrev`='DPE' AND WEEK(`cargo__scheduleRFA`.`Date`) <= '2' GROUP BY MAX(QUARTER(`cargo__scheduleRFA`.`Date`)),`cargo__scheduleRFA`.`TaskAbbrev`,`cargo__scheduleRFA`.`StaffAbbrev` ORDER BY `cargo__scheduleRFA`.`Date` DESC LIMIT 100000 Function: CargoSQLQuery::run Error: 1111 Invalid use of group function (172.27.81.126:30004) |
|
