Untitled query #67999

SQL

select concat("* [[",replace(page_title,"_"," "),"]]") from page join templatelinks on tl_from=page_id join linktarget on lt_id=tl_target_id
where lt_namespace=828 and lt_title like "Location_map/data/%" and 
exists (select 1 from templatelinks join linktarget on lt_id=tl_target_id where lt_namespace=10
                                          and lt_title="Infobox_NRHP/conv" and tl_from=page_id) and
exists (select 1 from categorylinks where cl_from=page_id and cl_to=replace(lt_title,"Location_map/data/","Historic_district_contributing_properties_in_"));
SQL

Checking query status...
