Multichill added a comment. |
The page property wb-sitelinks got introduced. That might open some options. It's stored as a string so no simple output
MariaDB [wikidatawiki_p]> SELECT * FROM page_props WHERE pp_propname='wb-sitelinks' ORDER BY pp_value DESC LIMIT 20; +---------+--------------+----------+------------+ | pp_page | pp_propname | pp_value | pp_sortkey | +---------+--------------+----------+------------+ | 11009 | wb-sitelinks | 99 | 99 | | 28674 | wb-sitelinks | 99 | 99 | | 43781 | wb-sitelinks | 99 | 99 | | 6406 | wb-sitelinks | 99 | 99 | | 6151 | wb-sitelinks | 99 | 99 | | 28679 | wb-sitelinks | 99 | 99 | | 6271239 | wb-sitelinks | 99 | 99 | | 28680 | wb-sitelinks | 99 | 99 | | 8267529 | wb-sitelinks | 99 | 99 | | 780 | wb-sitelinks | 99 | 99 | | 6307853 | wb-sitelinks | 99 | 99 | | 5741069 | wb-sitelinks | 99 | 99 | | 8838925 | wb-sitelinks | 99 | 99 | | 51214 | wb-sitelinks | 99 | 99 | | 10768 | wb-sitelinks | 99 | 99 | | 14868 | wb-sitelinks | 99 | 99 | | 28698 | wb-sitelinks | 99 | 99 | | 6674203 | wb-sitelinks | 99 | 99 | | 3614 | wb-sitelinks | 99 | 99 | | 7710 | wb-sitelinks | 99 | 99 | +---------+--------------+----------+------------+ 20 rows in set (2 min 50.05 sec)
TASK DETAIL
EMAIL PREFERENCES
To: Ricordisamoa, Multichill
Cc: thiemowmde, Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Qgil, Multichill, Lydia_Pintscher, daniel, D3r1ck01, Izno, Wikidata-bugs, aude, TheDJ, Mbch331
Cc: thiemowmde, Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Qgil, Multichill, Lydia_Pintscher, daniel, D3r1ck01, Izno, Wikidata-bugs, aude, TheDJ, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs