Database Anniversary Dates: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
Anniversary dates for: | Anniversary dates for: | ||
<!-- this will self-update the age --> | <!-- this will self-update the age BUT NOT THE UNITS as they are added and removed --> | ||
== Cargo == | |||
{{#cargo_query: | |||
tables=CollectionLocation | |||
|fields=_pageName=unit, StartDate=start, EndDate=end, CONCAT("{{Location Age | Location =", _pageName, " }}")=fee, | |||
DATEDIFF(EndDate,StartDate)=nr of days | |||
|order by=unit | |||
|limit=5 | |||
|default=no results were found | |||
}} | |||
* {{Location Age | Location =GRA EMIP }} | * {{Location Age | Location =GRA EMIP }} | ||
== old == | |||
* {{Location Age | Location =GRA MICU }} | * {{Location Age | Location =GRA MICU }} | ||
* {{Location Age | Location =GRA N3 }} | * {{Location Age | Location =GRA N3 }} | ||
| Line 14: | Line 24: | ||
* {{Location Age | Location =HSC CCU }} | * {{Location Age | Location =HSC CCU }} | ||
* {{Location Age | Location =HSC D4 }} | * {{Location Age | Location =HSC D4 }} | ||
* {{Location Age | Location =HSC WRS3 }} | |||
* {{Location Age | Location =HSC D5 }} | * {{Location Age | Location =HSC D5 }} | ||
* {{Location Age | Location =HSC H4 }} | * {{Location Age | Location =HSC H4 }} | ||
| Line 21: | Line 32: | ||
* {{Location Age | Location =HSC SICU }} | * {{Location Age | Location =HSC SICU }} | ||
* {{Location Age | Location =HSC EMIP }} | * {{Location Age | Location =HSC EMIP }} | ||
* {{Location Age | Location =STB B5old }} | * {{Location Age | Location =STB B5old }} | ||
* {{Location Age | Location =STB B4 }} | * {{Location Age | Location =STB B4 }} | ||
| Line 28: | Line 38: | ||
* {{Location Age | Location =STB CICU }} | * {{Location Age | Location =STB CICU }} | ||
* {{Location Age | Location =STB E5 }} | * {{Location Age | Location =STB E5 }} | ||
* {{Location Age | Location =STB E6 }} | * {{Location Age | Location =STB E6 B }} | ||
* {{Location Age | Location =STB MICU }} | * {{Location Age | Location =STB MICU }} | ||
* {{Location Age | Location =STB SICU }} | * {{Location Age | Location =STB SICU }} | ||