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
)
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)
UNION
(SELECT REPLACE(@cat, "_", " ") AS "Category")
 AND page_title LIKE "Media_contributed_by%"
SQL

Checking query status...
