Untitled query #33138

SQL

use commonswiki_p;

SELECT 
	fi_p.page_title AS fi_page_title, 
    group_concat(c_p.page_id) AS commons_page_title 
FROM 
	page AS c_p, 
    category, 
    categorylinks, 
    globalimagelinks AS gil, 
    fiwiki_p.page AS fi_p
WHERE 
	gil_to=c_p.page_title 
    AND c_p.page_id=cl_from
    AND cl_to=cat_title
    AND cat_title IN ("Images_from_Wiki_Loves_Monuments_2018") 
    AND c_p.page_namespace=6 
    AND gil_page_namespace_id=0
	AND fi_p.page_id=gil_page
    AND fi_p.page_namespace=0
    AND gil_wiki="fiwiki"
GROUP BY fi_page_title, commons_page_title
SQL

Checking query status...
