Untitled query #86617

SQL

SELECT rev_user_text AS editor, COUNT(*) AS edit_count
FROM wbc_entity_usage
JOIN revision ON eu_entity_id = rev_page
JOIN page ON page_id = rev_page
JOIN wb_item_terms AS term ON term.wb_item_id = eu_entity_id
WHERE
  term.term_entity_type = 'item'
  AND term.term_type = 'statement'
  AND term.term_property = 'P453' -- "Role" property
  AND term.term_value = 'Q7318358' -- "Victim of the Holocaust" value
  AND page_namespace = 0 -- Limit to items
GROUP BY rev_user_text
ORDER BY edit_count DESC
LIMIT 50;
SQL

Checking query status...
