| aude added a comment. |
For just items:
queries for selecting items without descriptions on wikidata:
51 rows in set (0.01 sec)
[wikidatawiki]> SELECT page_title AS entity_id_serialization FROM page LEFT JOIN wb_terms ON ((((term_entity_id = REPLACE(page_title, 'Q', '')) AND term_entity_type = 'item' AND page_namespace = '0')) AND term_type = 'description' AND term_language = 'ar') WHERE (term_entity_type IS NULL) AND page_is_redirect = '0' AND page_namespace = '0' ORDER BY page_id DESC LIMIT 51
with a somewhat large limit and offset:
4000 rows in set (0.10 sec)
[wikidatawiki]> SELECT page_title AS entity_id_serialization FROM page LEFT JOIN wb_terms ON ((((term_entity_id = REPLACE(page_title, 'Q', '')) AND term_entity_type = 'item' AND page_namespace = '0')) AND term_type = 'description' AND term_language = 'ar') WHERE (term_entity_type IS NULL) AND page_is_redirect = '0' AND page_namespace = '0' ORDER BY page_id DESC LIMIT 4000,4000;
I think these queries are okay with one entity type, and not sure it's necessary to restrict the page to only work with properties. (although if we really want and think it helps, ok...)
The problem (the query posted by Jaime) is indeed the query with 'all' option, which we should remove, and only allow the query with one entity type at a time.
Cc: gerritbot, Lydia_Pintscher, thiemowmde, Marostegui, aude, hoo, daniel, Aklapper, jcrespo, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, D3r1ck01, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
