|
|
| (5 intermediate revisions by the same user not shown) |
| Line 2: |
Line 2: |
|
| |
|
| <!-- this will self-update the age BUT NOT THE UNITS as they are added and removed --> | | <!-- this will self-update the age BUT NOT THE UNITS as they are added and removed --> |
| == Cargo == | | == Current == |
| {{#cargo_query: | | {{#cargo_query: |
| tables=CollectionLocation | | tables=CollectionLocation |
| |fields=_pageName=unit, StartDate=start, EndDate=end, CONCAT("{{Location Age | Location =", _pageName, " }}")=fee, | | |fields=_pageName=unit, |
| DATEDIFF(EndDate,StartDate)=nr of days
| | StartDate=start, |
| | DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days, |
| | CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years |
| | |where=EndDate IS NULL |
| |order by=unit | | |order by=unit |
| |limit=5 | | |limit=100 |
| |default=no results were found | | |default=no results were found |
| }} | | }} |
|
| |
|
| * {{Location Age | Location =GRA EMIP }}
| | == Legacy == |
| | | {{#cargo_query: |
| == old == | | tables=CollectionLocation |
| * {{Location Age | Location =GRA MICU }}
| | |fields=_pageName=unit, |
| * {{Location Age | Location =GRA N3 }}
| | StartDate=start, |
| * {{Location Age | Location =GRA N5 }}
| | EndDate=end, |
| * {{Location Age | Location =GRA OVER}}
| | DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days, |
| * {{Location Age | Location =GRA W3 }}
| | CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years |
| * {{Location Age | Location =HSC A4 }}
| | |where=EndDate IS NOT NULL |
| * {{Location Age | Location =HSC B3 }}
| | |order by=unit |
| * {{Location Age | Location =HSC CCU }}
| | |limit=100 |
| * {{Location Age | Location =HSC D4 }}
| | |default=no results were found |
| * {{Location Age | Location =HSC WRS3 }}
| | }} |
| * {{Location Age | Location =HSC D5 }}
| |
| * {{Location Age | Location =HSC H4 }}
| |
| * {{Location Age | Location =HSC H4H }}
| |
| * {{Location Age | Location =HSC IICU }}
| |
| * {{Location Age | Location =HSC MICU }}
| |
| * {{Location Age | Location =HSC SICU }}
| |
| * {{Location Age | Location =HSC EMIP }}
| |
| * {{Location Age | Location =STB B5old }}
| |
| * {{Location Age | Location =STB B4 }}
| |
| * {{Location Age | Location =STB B5 }}
| |
| * {{Location Age | Location =STB CCU }}
| |
| * {{Location Age | Location =STB CICU }}
| |
| * {{Location Age | Location =STB E5 }}
| |
| * {{Location Age | Location =STB E6 B }}
| |
| * {{Location Age | Location =STB MICU }}
| |
| * {{Location Age | Location =STB SICU }}
| |
| * {{Location Age | Location =STB EMIP }}
| |
|
| |
|
| ==Ended== | | == Wiki == |
| * [[VIC MICU]] - '''18 yrs 3 mths''' - (1999-Jun-01 to 2017-Sep 25) | | * the first account on this wiki was set up 2008-03-11 |
| * [[VIC N3F]]- '''1 year''' - (2005-Jul-01 to 2006-Jun-30)
| |
| * [[VIC N4]] - '''3.5 mths''' - (2017-Sep-29 to 2018-Jan-12)
| |
| * [[VIC N5]] - '''12 yrs 2 mths''' - (2005-Aug-01 to 2017-Oct-01)
| |
| * [[VIC S3]] - '''12 yrs''' - (2005-Oct-01 to 2017-Sep-22)
| |
| * [[VIC S4]] - '''12 yrs''' - (2005-Oct-01 to 2017-Oct-01)
| |
| * {{Location Age | Location =VIC EMIP }}
| |
| * {{Location Age | Location =VIC S5 }}
| |
| * [[VIC N5C]] - '''1 yr''' - (2017-Oct-02 to 2018-Oct-27))
| |
| * [[VIC S5C]] - '''1 yr''' - (2017-Oct-02 to 2018-Oct-27))
| |
| * [[VIC N4C]] - '''1 yr''' - (2017-Oct-02 to 2018-Oct-27))
| |
|
| |
|
| == Related articles == | | == Related articles == |