Affiliations Committee portal + categories

SQL

use metawiki_p;
select page_title, cl_to from page
join categorylinks on page_id = cl_from
where page_namespace = 0
and page_title like "Affiliations\_Committee/%"
/* filter out translation subpages */
and page_title not like "Affiliations\_Committee/%/__"
and page_title not like "Affiliations\_Committee/%/___"
and page_title not like "Affiliations\_Committee/%/__-%"
and page_title not like "Affiliations\_Committee/%/___-%"
and page_title not like "Affiliations\_Committee/%/de-formal"
and page_title not like "Affiliations\_Committee/__"
and page_title not like "Affiliations\_Committee/___"
and page_title not like "Affiliations\_Committee/__-%"
and page_title not like "Affiliations\_Committee/___-%"
and page_title not like "Affiliations\_Committee/de-formal"
order by page_title;
SQL

Checking query status...
