SQL
AخA
USE cswiki_p;
SELECT eu_entity_id, term_text, GROUP_CONCAT(page_title SEPARATOR '#')
FROM wbc_entity_usage
JOIN categorylinks ON cl_from = eu_page_id
JOIN page ON page_id = cl_from
LEFT JOIN wikidatawiki_p.wb_terms ON term_full_entity_id = eu_entity_id AND term_language = 'en' AND term_type = 'label'
WHERE eu_aspect = 'L.sk'
AND cl_to = 'Údržba:Doplnit_štítek_na_Wikidatech'
AND page_namespace = 0
AND eu_entity_id LIKE 'Q%'
GROUP BY eu_entity_id
ORDER BY eu_entity_id;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.