Replicas browser and optimizer
Historic Houses and such with hyphen in name
This query is marked as a draft
This query has been published
Titles of articles contain a hyphen and ending with House, Farm, Barn, Shack, Mill, Cottage, Farmstead, Homestead, Home, or Historic District. Many of these should be moved to have an en dash instead. The results need careful pruning. In the case of "House" only, more characters are allowed after, because there are a lot of "House and Xxx Wing" and other constructions with House; but allowing characters after Barn, for examples, picks up a lot of false hits.
SELECT page_title FROM page WHERE page_namespace = 0 AND page_is_redirect = 0 AND(page_title LIKE '%-%#_House' ESCAPE '#')
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in