Difference between revisions of "Template:BuildingQueryMap"

From DAS Wiki
Line 1: Line 1:
 
{{#cargo_compound_query:
 
{{#cargo_compound_query:
−
tables=buildings;where=building_type='Library' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR ren_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Blue-marker.png
+
tables=buildings;where=building_type='Library' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Blue-marker.png
−
|tables=buildings;where=building_type='Church' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR ren_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Red-marker.png
+
|tables=buildings;where=building_type='Library' AND (ren_architect='{{PAGENAME}}' OR ren_firm='{{PAGENAME}}' OR ren_l_a='{{PAGENAME}}' OR ren_contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,renovation_date;icon=Blue-marker.png
−
|tables=buildings;where=building_type='Government' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR ren_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Brown-marker.png
 
−
|tables=buildings;where=building_type='Park' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR ren_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Green-marker.png
 
  
 +
|tables=buildings;where=building_type='Church' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Red-marker.png
 +
|tables=buildings;where=building_type='Church' AND (ren_architect='{{PAGENAME}}' OR ren_firm='{{PAGENAME}}' OR ren_l_a='{{PAGENAME}}' OR ren_contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,renovation_date;icon=Red-marker.png
  
−
|tables=buildings;where=building_type='Dwelling' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR ren_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}' OR ren_l_a='{{PAGENAME}}' OR ren_contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Yellow-marker.png
+
|tables=buildings;where=building_type='Government' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Brown-marker.png
 +
|tables=buildings;where=building_type='Government' AND (ren_architect='{{PAGENAME}}' OR ren_firm='{{PAGENAME}}' OR ren_l_a='{{PAGENAME}}' OR ren_contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,renovation_date;icon=Brown-marker.png
  
 +
|tables=buildings;where=building_type='Park' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Green-marker.png
 +
|tables=buildings;where=building_type='Park' AND (ren_architect='{{PAGENAME}}' OR ren_firm='{{PAGENAME}}' OR ren_l_a='{{PAGENAME}}' OR ren_contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,renovation_date;icon=Green-marker.png
 +
 +
|tables=buildings;where=building_type='Dwelling' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Yellow-marker.png
 +
|tables=buildings;where=building_type='Dwelling' AND (ren_architect='{{PAGENAME}}' OR ren_firm='{{PAGENAME}}' OR ren_l_a='{{PAGENAME}}' OR ren_contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,renovation_date;icon=Yellow-marker.png
 +
 +
|tables=buildings;where=building_type='Commercial' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Purple-marker.png
 +
|tables=buildings;where=building_type='Commercial' AND (ren_architect='{{PAGENAME}}' OR ren_firm='{{PAGENAME}}' OR ren_l_a='{{PAGENAME}}' OR ren_contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,renovation_date;icon=Purple-marker.png
 +
 +
|tables=buildings;where=building_type='Educational' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Orange-marker.png
 +
|tables=buildings;where=building_type='Educational' AND (ren_architect='{{PAGENAME}}' OR ren_firm='{{PAGENAME}}' OR ren_l_a='{{PAGENAME}}' OR ren_contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,renovation_date;icon=Orange-marker.png
  
−
|tables=buildings;where=building_type='Commercial' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR ren_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Purple-marker.png
 
−
|tables=buildings;where=building_type='Educational' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR ren_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Orange-marker.png
 
 
|tables=Grounds;where=landscape_architect='{{PAGENAME}}';fields=_pageName,Geo_center,opened;icon=Green-marker.png
 
|tables=Grounds;where=landscape_architect='{{PAGENAME}}';fields=_pageName,Geo_center,opened;icon=Green-marker.png
 +
 
|format=leaflet
 
|format=leaflet
 
|height= 600
 
|height= 600

Revision as of 13:43, June 17, 2021

Error: Table buildings not found.
Library Blue-marker.png Church Red-marker.png Government Brown-marker.png Commercial Purple-marker.png Dwelling Yellow-marker.png Park Green-marker.png Educational Orange-marker.png
Retrieved from "http://wiki.martenet.com/index.php?title=Template:BuildingQueryMap&oldid=2913"