WLE in Ukraine images usage in Wikimarathon 2017 articles

SQL

SELECT CONCAT("[[", page_title, "]]", 
il_from, il_to
FROM ukwiki_p.imagelinks

JOIN ukwiki_p.page
ON ukwiki_p.page.page_id = il_from
WHERE il_from_namespace = 0
AND il_to IN
  (
    SELECT page_title
    FROM commonswiki_p.categorylinks
    JOIN commonswiki_p.page
    ON commonswiki_p.categorylinks.cl_to IN
    (
      "Images_from_Wiki_Loves_Earth_2016_in_Ukraine",
      "Images_from_Wiki_Loves_Earth_2015_in_Ukraine",
      "Images_from_Wiki_Loves_Earth_2014_in_Ukraine",
      "Images_from_Wiki_Loves_Earth_2013_in_Ukraine"
    )
    AND commonswiki_p.categorylinks.cl_type = "file"
    AND commonswiki_p.categorylinks.cl_from = commonswiki_p.page.page_id
  )
AND page_title IN
  (
    SELECT page_title
    FROM ukwiki_p.categorylinks
    JOIN ukwiki_p.page
    ON ukwiki_p.categorylinks.cl_to IN
   	(
   	  "Статті_Вікімарафону_2017",
      "Статті_Вікімарафону_2017_створені_ботами"
  	)
    AND ukwiki_p.page.page_id = ukwiki_p.categorylinks.cl_from
  )
SQL

Checking query status...
