PoC: Harvest affiliate members

SQL

# avoid duplicate user names
SELECT DISTINCT pl_title AS "Affiliate Members",
page_title AS "Affiliates"

FROM metawiki_p.pagelinks AS pl 

JOIN metawiki_p.page AS p
ON pl.pl_from = p.page_id

# harvest from the a list of affiliates subpage
WHERE p.page_title IN ( "Wikimedians_of_Cameroon_User_Group" )
# exclude anything that ends with _(WMF)
# as these are WMF staffs not aff members
AND pl_title NOT LIKE "%_(WMF)"
# remove MediaWiki_message_delivery as it's
# the mass message delivery default handle
AND pl_title NOT LIKE "%MediaWiki_message_delivery%"
# focus on the User: namespace
AND pl.pl_namespace = 2
SQL

Checking query status...
