User:HippieBot/English pronouns with mismatch between heading and category
SELECT DISTINCT e1.page_title
FROM enwiktstruct AS e1
INNER JOIN categorylinks
ON e1.page_id = cl_from
AND e1.lang_id = 0
AND e1.head_id IS NULL
AND cl_to = 'English_pronouns'
LEFT JOIN enwiktstruct AS e2
ON e1.page_id = e2.page_id
AND e1.lang_id = e2.lang_id
AND e2.head_id = 39
WHERE e2.head_id IS NULL
UNION
SELECT DISTINCT e1.page_title
FROM enwiktstruct e1
INNER JOIN enwiktstruct AS e2
ON e1.page_id = e2.page_id
AND e1.lang_id = 0
AND e1.lang_id = e2.lang_id
AND e1.head_id = 39
AND e1.head_id = e2.head_id
LEFT JOIN categorylinks
ON e2.page_id = cl_from
AND cl_to = 'English_pronouns'
WHERE cl_to IS NULL
ORDER BY page_title;
- 'e
- 'um
- (s)he
- Her Maj
- Her Majesty
- Her Royal Highness
- His Maj
- His Majesty
- His Royal Highness
- I and I
- Your Maj
- Your Worship
- all
- anybodies
- anythink
- dem
everybody- ey
- hisn
- hym
- it self
- j00
- me fellow
neither- noone
- nought
- one's self
- ourn
- ourself
somebody- somewhat
- speake
- the one
- thee
- themselfs
- these ones
- thier
- thine
- thingmabob
- those ones
thou- thy
- thyself
us twovnder- we two
- what the fuck
what-have-you- whatevers
- xyrself
- y'all's
- ya'll
- yo
- your all's
- your honour
- yourn
- yous
- yuh