Difference between revisions of "scheduleNow"

From MGH Learn Pathology
Line 45: Line 45:
 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName,facultyMGH.pageid
 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName,facultyMGH.pageid
 
|group by=scheduleFACservice.Color
 
|group by=scheduleFACservice.Color
−
|where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#timel:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
+
|where= scheduleFACservice.LocationAbbrev = ‘MGH’ AND YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#timel:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
 
|limit=1|more results text=|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
 
|limit=1|more results text=|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
 
|}}
 
|}}

Revision as of 09:47, August 5, 2024

Anatomic pathology (AMP)
Service
AUT
BST
BR1
BR2
BR3
MGB CV
RP
CA
CB
CC
DP1 (0-2)
DP2 (3-5)
DP3 (6-9)
EYE
FSJ
FSS
GI1 (1-3)
GI2 (4-6)
GI3 (7-8) / (1-5)
GI4 (9-0) / (6-0)
GU1 (0-4)
GU2 (5-9)
GYL
GYS
OB
HN1 (5-9)
HN2 (0-4)
HP1 (BM)
HP2 (LN)
NP
NPAUT
PP
GR-S
AP CHIEF
Resident
DEM
NEA, SFA
TYY
KZL
-
-
-
LHV
-
-
-
-
-
-
KSH
GEO
-
-
-
-
-
-
LCC
-
-
-
-
-
-
-
-
ELY (E)
-
-
Fellow
-
-
-
-
-
-
-
-
-
HH579
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Attending[1]
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='AUT' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='BST' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='BR1' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='BR2' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='BR3' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='CV' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='RP' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='CA' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='CB' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='CC' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='DPA' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='DPB' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='DPC' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='EYE' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='Frozen Section' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='Frozen Section' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='GI1' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='GI2' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='GI3' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='GI4' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='GU1' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='GU2' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='GYL' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='GYS' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='OB' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='HN1' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='HN2' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='HPA' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='HPB' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='NP' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='NPAUT' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='PP' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='RLS' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFACservice`.`StaffAbbrev` AS `StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev` AS `TaskAbbrev`,`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 `cargo__scheduleFACservice`.`LocationAbbrev` = ‘MGH’ AND YEAR(Date)=2026 AND `cargo__scheduleFACservice`.`TaskAbbrev`='AP CHIEF' AND `cargo__scheduleFACservice`.`DayNumber`='2' AND `cargo__scheduleFACservice`.`WeekNumber`='12' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `cargo__scheduleFACservice`.`StaffAbbrev`,`cargo__scheduleFACservice`.`TaskAbbrev`,`cargo__scheduleFACservice`.`StaffFullName`,`cargo__facultyMGH`.`pageid` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xE2\x80\x98MGH\xE2\x80\x99 AND YEAR(Date)=2026 AND `cargo__scheduleFACservic...' at line 1 (172.27.81.126:30004)

Call
Patalas
Nielsen
Sgroi
Sgroi
Sgroi
Padera
Smith
Zhang
Zhang
Zhang
Moran
Moran
Moran
ANA
-
-
Drage
Drage
Drage
Drage
Lu
Lu
Young
Young
Brackett
Alzumaili
Alzumaili
Sohani
Sohani
Stemmer-Rach
Stemmer-Rach
Hung
-
-

Clinical pathology (LMM)
Service
BTS
COAG
CORE
MICRO
HLA - A
HLA - B
HPA
HPB
HG
MOL: Consult
MOL: HER2
MOL: A non-NGS
MOL: A NGS
MOL: B NGS
MOL: B non-NGS
MOL: B FISH
IMMUNO
CP CHIEF
Resident
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
JSE
Fellow
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Attending[1]
Makar
Connell
LiuL
-
-
-
Sohani
Fitzpatrick
Higgins
-
-
-
-
-
-
-
MFL12
-
Call
27364
No results Connell
15433
32443
25338
25338
Sohani
Sohani
Higgins
-
-
-
-
-
-
-
MFL12
-

[1]Faculty schedule displayed using the QGenda API.

Retrieved from "https://learn.mghpathology.org/index.php?title=scheduleNow&oldid=131295"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital