Addshore added a comment.
SELECT
a.terms AS terms,
a.type AS type,
COUNT(*) AS count
FROM (
SELECT
term_entity_id AS entity,
term_type AS type,
COUNT(*) AS terms
FROM wikidatawiki.wb_terms
WHERE term_type IN ( 'label', 'description' )
GROUP BY term_entity_id, term_type
) AS a
GROUP BY a.terms, a.type
Takes an hour and 54 mins >.>
TASK DETAIL
https://phabricator.wikimedia.org/T119610
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: Aklapper, Addshore, StudiesWorld, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
