[Wikidata-bugs] [Maniphest] [Commented On] T144592: Search index a limited number of article placeholders on cywiki for testing and evaluation purposes

[hoo]

hoo added a comment.

Concrete query used:

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_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 1000;

Results (indexable user page): https://cy.wikipedia.org/wiki/Defnyddiwr:Hoo_man/T144592-placeholders

Note: The placeholders themselves are not indexable, yet.

TASK DETAIL

https://phabricator.wikimedia.org/T144592

EMAIL PREFERENCES

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

To: hoo
Cc: Deskana, Izno, Lydia_Pintscher, Aklapper, Lucie, Ricordisamoa, Nemo_bis, DarTar, MZMcBride, hoo, D3r1ck01, Wikidata-bugs, aude, jayvdb, Mbch331

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