Untitled query #33138

This query is marked as a draft This query has been published by Zache.

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

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...