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}}';fields=_pageName,Geo;icon=Blue-marker.png | + | tables=buildings;where=building_type='Library' AND (architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}');fields=_pageName,Geo;icon=Blue-marker.png |
|tables=buildings;where=building_type='Church' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Red-marker.png | |tables=buildings;where=building_type='Church' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Red-marker.png | ||
|tables=buildings;where=building_type='Government' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Brown-marker.png | |tables=buildings;where=building_type='Government' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Brown-marker.png | ||
|tables=buildings;where=building_type='Park' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Green-marker.png | |tables=buildings;where=building_type='Park' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Green-marker.png | ||
− | |tables=buildings;where=building_type='Dwelling' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Yellow-marker.png | + | |tables=buildings;where=building_type='Dwelling' AND (architect='{{PAGENAME}}'OR architecture_firm='{{PAGENAME}}') ;fields=_pageName,Geo;icon=Yellow-marker.png |
|tables=buildings;where=building_type='Commercial' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Purple-marker.png | |tables=buildings;where=building_type='Commercial' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Purple-marker.png | ||
|tables=buildings;where=building_type='Educational' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Orange-marker.png | |tables=buildings;where=building_type='Educational' AND architect='{{PAGENAME}}';fields=_pageName,Geo;icon=Orange-marker.png |