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 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 surveyor='{{PAGENAME}}' OR contractors HOLDS '{{PAGENAME}}');fields=_pageName,Geo,completion_date;icon=Blue-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='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='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 (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR surveyor='{{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='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='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 (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR surveyor='{{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='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 (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}' OR surveyor='{{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='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 (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.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='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 (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='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 (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='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 | ||