Patrollers & rollbackers in cswiki

SQL

USE cswiki_p;
#SELECT DISTINCT eu_aspect, term_text
#FROM (SELECT * FROM wbc_entity_usage WHERE eu_aspect LIKE 'C.%') AS eu
#LEFT JOIN wikidatawiki_p.wb_terms ON term_type = 'label' AND term_language = 'cs' AND term_full_entity_id = REPLACE(eu_aspect, 'C.', '');
SELECT * FROM wikidatawiki_p.wb_terms WHERE term_type = 'label' AND term_language = 'cs' AND term_full_entity_id LIKE 'P%'
WHERE EXISTS (SELECT 1 FROM wbc_entity_usage WHERE eu_aspect = REPLACE(term_full_entity_id, 'P', 'C.P%' LIMIT 1);

SQL

Checking query status...