| hoo added a comment. |
Number of rows which occur at least twice (excludes aliases, for performance reasons):
mysql:wikiadmin@db1070 [wikidatawiki]> SELECT COUNT(*) FROM wb_terms AS t1 WHERE term_type != 'alias' AND EXISTS(SELECT 1 FROM wb_terms AS t2 USE INDEX(wb_terms_entity_id) WHERE t1.term_entity_type = t2.term_entity_type AND t1.term_entity_id = t2.term_entity_id AND t1.term_type = t2.term_type AND t1.term_language = t2.term_language AND t1.term_search_key = t2.term_search_key AND t1.term_row_id != t2.term_row_id); +-----------+ | COUNT(*) | +-----------+ | 129337897 | +-----------+ 1 row in set (21 hours 13 min 33.19 sec)
TASK DETAIL
EMAIL PREFERENCES
To: hoo
Cc: Aklapper, hoo, QZanden, Izno, Wikidata-bugs, aude, Mbch331
Cc: Aklapper, hoo, QZanden, Izno, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
