Difference between revisions of "Template:Building query"
From DAS Wiki
Line 1: | Line 1: | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
− | tables=buildings;where=architect='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}';fields=_pageName=Project,completion_date=Completed,address=Address,image=Image | + | 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= | + | |
− | |tables=buildings;where=architecture_firm='{{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=contractors HOLDS '{{PAGENAME}}';fields=_pageName=Project,completion_date=Completed,address=Address,image=Image | + | |
− | |tables= buildings;where=ren_architect='{{PAGENAME}}'OR ren_l_a='{{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=buildings;where=ren_contractors HOLDS'{{PAGENAME}}';fields=_pageName=Project,renovation_date=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 | ||
|format=dynamic table | |format=dynamic table | ||
|default= | |default= | ||
}} | }} |
Revision as of 16:50, June 20, 2021
Error: Table buildings not found.