Untitled query #24631

SQL

USE commonswiki_p;
#SELECT categ.cl_to, gil_to, gil_wiki, gil_page_title, 
SELECT categ.cl_to, GROUP_CONCAT(DISTINCT CONCAT('Q', ips_item_id), ', ') AS items
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
AND ips_item_id IS NOT NULL
AND ips_item_id <> ''
GROUP BY categ.cl_to;
SQL

Checking query status...
