Untitled query #24631

SQL

USE commonswiki_p;
SELECT categ.pl_title, gil_to, ips_item_id
FROM (SELECT * FROM categorylinks WHERE cl_to LIKE 'IMO&_%' ESCAPE '&' AND cl_type = 'subcat') AS categ
JOIN page AS page_categ ON page_categ.page_id = categ.cl_from
JOIN categorylinks AS files ON files.cl_to = page_categ.page_title
JOIN page AS page_files ON page_files.page_id = files.cl_from
JOIN globalimagelinks ON gil_to = page_files.page_title
JOIN wikidatawiki_p.wb_items_per_site ON ips_site_id = gil_wiki AND ips_site_page = gil_page_title
WHERE files.cl_type = 'file'
AND gil_page_namespace_id = 0
LIMIT 1;
SQL

Checking query status...
