[Wikidata-bugs] [Maniphest] [Commented On] T162244: [Story] Search index 10, 000 article placeholders on cywiki for testing and evaluation purposes

[hoo]

hoo added a comment.

mysql:wikiadmin@db1092 [wikidatawiki]> SELECT page_title FROM page INNER JOIN wb_entity_per_page ON epp_page_id = page_id INNER JOIN page_props AS pp_sl ON pp_sl.pp_page = page_id AND pp_sl.pp_propname = 'wb-sitelinks' INNER JOIN page_props AS pp_st ON pp_st.pp_page = page_id AND pp_st.pp_propname = 'wb-claims' WHERE pp_st.pp_value > 2 AND pp_sl.pp_value > 3 AND NOT EXISTS(SELECT 1 FROM wb_items_per_site WHERE ips_site_id = 'cywiki' AND ips_item_id = epp_entity_id) ORDER BY epp_entity_id ASC LIMIT 10000,1;
+------------+
| page_title |
+------------+
| Q16956     |
+------------+
1 row in set (0.58 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T162244

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: hoo
Cc: gerritbot, Lydia_Pintscher, Lucie, Aklapper, hoo, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, cmadeo, Lewizho99, Maathavan, Izno, Wikidata-bugs, aude, jayvdb, Ricordisamoa, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs