Untitled query #23941

Fork of Historic Houses and such with hyphen in name by Dicklyon

This query is marked as a draft This query has been published by Dicklyon.

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.

SQL

SELECT page_title
FROM page
WHERE page_namespace = 0 AND page_is_redirect = 0
AND(page_title LIKE '%-%#_House_%' ESCAPE '#'
 OR page_title LIKE '%-%#_Farm' ESCAPE '#'
 OR page_title LIKE '%-%#_Barn' ESCAPE '#'
 OR page_title LIKE '%-%#_Shack' ESCAPE '#'
 OR page_title LIKE '%-%#_Mill' ESCAPE '#'
 OR page_title LIKE '%-%#_Cottage' ESCAPE '#'
 OR page_title LIKE '%-%#_Farmstead' ESCAPE '#'
 OR page_title LIKE '%-%#_Homestead' ESCAPE '#'
 OR page_title LIKE '%-%#_Home' ESCAPE '#'
 OR page_title LIKE '%-%#_Historic_District%' ESCAPE '#')

SQL

Checking query status...