Difference between revisions of "Template:BuildingQueryMap"
From DAS Wiki
Line 18: | Line 18: | ||
|tables=Buildings;where=building_type='Dwelling' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR surveyor='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Yellow-marker-small.png | |tables=Buildings;where=building_type='Dwelling' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR surveyor='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Yellow-marker-small.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, ren_architect | + | |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, ren_architect, ren_firm, renovation_date;icon=Yellow-marker-small.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-small.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-small.png |