Image categories from WLM 2017 in Finland

SQL

use commonswiki_p;
SELECT
  page_title, 
  REPLACE(REPLACE(GROUP_CONCAT(cl2.cl_to), "Images_from_Wiki_Loves_Monuments_2017,", ""), "Images_from_Wiki_Loves_Monuments_2017", "") as categories
FROM 
  page, 
  categorylinks AS cl1, 
  categorylinks AS cl2  
WHERE 
  cl1.cl_to="Images_from_Wiki_Loves_Monuments_2017_in_Finland" 
  AND cl1.cl_from=cl2.cl_from
  AND cl2.cl_to NOT IN (
    "Taken_with_Sony_E_16-50mm_F3.5-5.6_OSS_PZ",
    "Cultural_heritage_monuments_in_Finland_without_image_in_Wikidata",
    "Cultural_heritage_monuments_in_Finland_with_known_IDs",
    "Self-published_work",
    "Media_with_locations",
    "Pages_with_maps",
    "Uploaded_via_Campaign:wlm-fi-rephotography-wikidata",
    "CC-BY-SA-4.0",
    "Cultural_heritage_monuments_in_Finland",
    "Images_from_Wiki_Loves_Monuments_2017_in_Finland", 
    "Uploaded_via_Campaign:wlm-fi-rephotography-url"
  ) 
  AND page_id=cl1.cl_from 
GROUP BY cl1.cl_from
ORDER BY sum(1)
SQL

Checking query status...
