Demolition Site - Revision history

127.0.0.1 at 20:12, 5 August 2025

2025-08-05T20:12:04Z

← Older revision		Revision as of 20:12, 5 August 2025
Line 1:		Line 1:
	<noinclude>{{Locations\| Name=Demolition Site\| Codename=loc_demolition_site\| WaitTime=0\| TravelTime=1800\| TravelTimeFormatted=00H 30M 00S\| Difficulty=6		<noinclude>{{Locations\| Name=Demolition Site\| Codename=loc_demolition_site\| WaitTime=0\| TravelTime=1800\| TravelTimeFormatted=00H 30M 00S\| Difficulty=7
	}}		}}
	</noinclude>{{LocationJobItems		</noinclude>{{LocationJobItems

2025-07-31T01:18:12Z

Outposts

← Older revision		Revision as of 01:18, 31 July 2025
Line 54:		Line 54:
	table=Locations, ItemFilterLink, Outposts		table=Locations, ItemFilterLink, Outposts
	\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename		\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename
	\| fields=Outposts._pageName=Name, COUNT(~~DISTINCT Outposts.Codename~~)=Count		\| fields=Outposts._pageName=Name, COUNT(*)=Count
	\| where=Locations.Codename="loc_demolition_site"		\| where=Locations.Codename="loc_demolition_site"
	\| group by=Outposts._pageName		\| group by=Outposts._pageName
	\| format=table		\| format=table
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

2025-07-31T00:51:28Z

← Older revision		Revision as of 00:51, 31 July 2025
Line 54:		Line 54:
	table=Locations, ItemFilterLink, Outposts		table=Locations, ItemFilterLink, Outposts
	\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename		\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename
	\| fields=COUNT(*)=Count		\| fields=Outposts._pageName=Name, COUNT(DISTINCT Outposts.Codename)=Count
	\| where=Locations.Codename="loc_demolition_site" ~~AND~~ Outposts.~~Codename="explosives_factory"~~		\| where=Locations.Codename="loc_demolition_site"
			\| group by=Outposts._pageName
	\| format=table		\| format=table
	}}		}}<!-- ZC_CP_Autogen_End -->
	<!-- ZC_CP_Autogen_End -->

2025-07-31T00:45:00Z

Outposts

← Older revision		Revision as of 00:45, 31 July 2025
Line 55:		Line 55:
	\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename		\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename
	\| fields=COUNT(*)=Count		\| fields=COUNT(*)=Count
	\| where=Locations.Codename="loc_demolition_site"		\| where=Locations.Codename="loc_demolition_site" AND Outposts.Codename="explosives_factory"
	\| format=table		\| format=table
	}}		}}
	<!-- ZC_CP_Autogen_End -->		<!-- ZC_CP_Autogen_End -->

2025-07-31T00:44:49Z

Outposts

← Older revision		Revision as of 00:44, 31 July 2025
Line 56:		Line 56:
	\| fields=COUNT(*)=Count		\| fields=COUNT(*)=Count
	\| where=Locations.Codename="loc_demolition_site"		\| where=Locations.Codename="loc_demolition_site"
	~~\| group by=Outposts._pageName~~
	\| format=table		\| format=table
	}}		}}
	<!-- ZC_CP_Autogen_End -->		<!-- ZC_CP_Autogen_End -->

2025-07-31T00:44:40Z

Outposts

← Older revision		Revision as of 00:44, 31 July 2025
Line 55:		Line 55:
	\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename		\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename
	\| fields=COUNT(*)=Count		\| fields=COUNT(*)=Count
	\| where=Locations.Codename="loc_demolition_site~~" AND Outposts.Codename="explosives_factory~~"		\| where=Locations.Codename="loc_demolition_site"
	\| group by=Outposts._pageName		\| group by=Outposts._pageName
	\| format=table		\| format=table
	}}		}}
	<!-- ZC_CP_Autogen_End -->		<!-- ZC_CP_Autogen_End -->

2025-07-31T00:44:29Z

Outposts

← Older revision		Revision as of 00:44, 31 July 2025
Line 54:		Line 54:
	table=Locations, ItemFilterLink, Outposts		table=Locations, ItemFilterLink, Outposts
	\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename		\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename
	\| fields=~~SUM~~(1)=Count		\| fields=COUNT(*)=Count
	\| where=Locations.Codename="loc_demolition_site" ~~and~~ Outposts.Codename="explosives_factory"		\| where=Locations.Codename="loc_demolition_site" AND Outposts.Codename="explosives_factory"
	\| group by=Outposts._pageName		\| group by=Outposts._pageName
	\| format=table		\| format=table
	}}<!-- ZC_CP_Autogen_End -->		}}
			<!-- ZC_CP_Autogen_End -->

2025-07-31T00:43:53Z

Outposts

← Older revision		Revision as of 00:43, 31 July 2025
Line 54:		Line 54:
	table=Locations, ItemFilterLink, Outposts		table=Locations, ItemFilterLink, Outposts
	\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename		\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename
	\| fields=~~COUNT~~(1)=Count		\| fields=SUM(1)=Count
	\| where=Locations.Codename="loc_demolition_site" and Outposts.Codename="explosives_factory"		\| where=Locations.Codename="loc_demolition_site" and Outposts.Codename="explosives_factory"
	\| group by=Outposts._pageName		\| group by=Outposts._pageName
	\| format=table		\| format=table
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

2025-07-31T00:43:12Z

Outposts

← Older revision		Revision as of 00:43, 31 July 2025
Line 54:		Line 54:
	table=Locations, ItemFilterLink, Outposts		table=Locations, ItemFilterLink, Outposts
	\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename		\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename
	\| fields=COUNT(~~Outposts.Codename~~)=Count		\| fields=COUNT(1)=Count
	\| where=Locations.Codename="loc_demolition_site" and Outposts.Codename="explosives_factory"		\| where=Locations.Codename="loc_demolition_site" and Outposts.Codename="explosives_factory"
	\| group by=Outposts._pageName		\| group by=Outposts._pageName
	\| format=table		\| format=table
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->

2025-07-31T00:42:28Z

Outposts

← Older revision		Revision as of 00:42, 31 July 2025
Line 54:		Line 54:
	table=Locations, ItemFilterLink, Outposts		table=Locations, ItemFilterLink, Outposts
	\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename		\| join on=ItemFilterLink.Codename=Locations.Codename,Outposts.Codename=ItemFilterLink.LinkCodename
	\| fields=COUNT(~~DISTINCT~~ Outposts.Codename)=Count		\| fields=COUNT(Outposts.Codename)=Count
	\| where=Locations.Codename="loc_demolition_site" and Outposts.Codename="explosives_factory"		\| where=Locations.Codename="loc_demolition_site" and Outposts.Codename="explosives_factory"
	\| group by=Outposts._pageName		\| group by=Outposts._pageName
	\| format=table		\| format=table
	}}<!-- ZC_CP_Autogen_End -->		}}<!-- ZC_CP_Autogen_End -->