All DPLA institution upload categories

SQL

SET @cat = "Media_contributed_by_the_Digital_Public_Library_of_America";
USE commonswiki_p;
(SELECT REPLACE(page_title, "_", " ") AS "Category"
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 "Category"
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")
 AND page_namespace = 14
 AND page_title LIKE "Media_contributed_by%")
UNION
(SELECT REPLACE(@cat, "_", " ") AS "Category")
SQL

Checking query status...
