Difference between revisions of "Template:Building query"

From DAS Wiki
 
(2 intermediate revisions by the same user not shown)
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 contractors HOLDS '{{PAGENAME}}');fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
+
tables=Buildings;where=architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR surveyor='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}';fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
  
|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=Project,renovation_date=Completed,address=Address,image=Image
+
|tables=Buildings;where=ren_architect='{{PAGENAME}}' OR ren_firm='{{PAGENAME}}' OR ren_l_a='{{PAGENAME}}' OR ren_contractors HOLDS '{{PAGENAME}}';fields=_pageName=Project,renovation_date=Completed,address=Address,image=Image
  
|tables=buildings;where=building_type='Church' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
+
|tables=Grounds;where=landscape_architect='{{PAGENAME}}' OR builder HOLDS '{{PAGENAME}}' OR other_designers HOLDS '{{PAGENAME}}';fields=_pageName=Project,opened=Completed,address=Address,image=Image
 
 
|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=Project,renovation_date=Completed,address=Address,image=Image
 
 
 
|tables=buildings;where=building_type='Government' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
 
 
 
|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=Project,renovation_date=Completed,address=Address,image=Image
 
 
 
|tables=buildings;where=building_type='Park' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
 
 
 
|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=Project,renovation_date=Completed,address=Address,image=Image
 
 
 
|tables=buildings;where=building_type='Dwelling' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
 
 
 
|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=Project,renovation_date=Completed,address=Address,image=Image
 
 
 
|tables=buildings;where=building_type='Commercial' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
 
 
 
|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=Project,renovation_date=Completed,address=Address,image=Image
 
 
 
|tables=buildings;where=building_type='Educational' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
 
 
 
|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=Project,renovation_date=Completed,address=Address,image=Image
 
 
 
|tables=Grounds;where=type HOLDS 'Park' AND (landscape_architect='{{PAGENAME}}' OR builder HOLDS '{{PAGENAME}}' OR other_designers HOLDS '{{PAGENAME}}');fields=_pageName=Project,opened=Completed,address=Address,image=Image
 
  
 
|order by=_pageName ASC
 
|order by=_pageName ASC

Latest revision as of 22:48, July 2, 2021

Project Completed Address Image
Project Completed Address Image