All DPLA institution upload categories

SQL

SET @cat = "Media_contributed_by_the_Digital_Public_Library_of_America";
(SELECT REPLACE(page_title, "_", " ") AS page_title
FROM page
 JOIN categorylinks ON page_id = cl_from
 WHERE cl_to = @cat AND page_namespace = 14
 AND page_title LIKE "Media_contributed_by%"
 AND page_title NOT IN ("Media_contributed_by_the_Digital_Public_Library_of_America_with_missing_institution",
						"Media_contributed_by_the_Digital_Public_Library_of_America_with_unknown_institution",
						"Media_contributed_by_the_Digital_Public_Library_of_America_with_unknown_partner")
)
UNION
(SELECT REPLACE(page_title, "_", " ") AS page_title
FROM page
 JOIN categorylinks ON page_id = cl_from
 WHERE cl_to IN ("Media_contributed_by_Digital_Commonwealth",
                 "Media_contributed_by_Digital_Library_of_Georgia",
                 "Media_contributed_by_Indiana_Memory",
                 "Media_contributed_by_Minnesota_Digital_Library",
                 "Media_contributed_by_North_Carolina_Digital_Heritage_Center",
                 "Media_contributed_by_the_National_Archives_and_Records_Administration_via_DPLA"
                 "Media_contributed_by_the_Ohio_Digital_Network",
                 "Media_contributed_by_the_Plains_to_Peaks_Collective",
                 "Media_contributed_by_The_Portal_to_Texas_History",
                 "Media_contributed_by_PA_Digital",
                 "Media_contributed_by_Northwest_Digital_Heritage",
                 "Media_contributed_by_Illinois_Digital_Heritage_Hub")
 AND page_namespace = 14
 AND page_title LIKE "Media_contributed_by%")
UNION
(SELECT REPLACE(@cat, "_", " ") AS page_title)
SQL

Checking query status...
