[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
gerritbot added a comment. Change 181902 abandoned by Multichill: Implement a special page to show items with the most sitelinks Reason: Too frustrating, not going to invest time in this any more. https://gerrit.wikimedia.org/r/181902 TASK DETAIL https://phabricator.wikimedia.org/T48217 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Multichill, gerritbot Cc: Bene, Ricordisamoa, Aklapper, gerritbot, Wikidata-bugs, Qgil, matej_suchanek, Multichill, Lydia_Pintscher, daniel, aude, Malyacko ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
Multichill added a comment. Abandoned. Too frustrating, not going to invest time in this any more. Up for grabs. TASK DETAIL https://phabricator.wikimedia.org/T48217 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Multichill Cc: Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Wikidata-bugs, Qgil, matej_suchanek, Multichill, Lydia_Pintscher, daniel, aude, Malyacko ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
thiemowmde added a subscriber: thiemowmde. thiemowmde added a comment. The major problem with both patches is that they use `COUNT` and `JOIN` and `GROUP BY`. This does not scale well for such big tables. What we do now is to store the number of sitelinks per item in a "wb-sitelinks" page property (in the page_props table). `pp_sortkey` is a numeric field that can be accessed then, and possibly ordered (need to check this). This should already be deployed, as far as I know. So whoever wants to pick this up, please pick one of the existing patches, reopen it and change the SQL query to query pp_sortkey in page_props instead. TASK DETAIL https://phabricator.wikimedia.org/T48217 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: thiemowmde Cc: thiemowmde, Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Wikidata-bugs, Qgil, matej_suchanek, Multichill, Lydia_Pintscher, daniel, aude, Malyacko ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
gerritbot added a comment. Change 181902 restored by JanZerebecki: Implement a special page to show items with the most sitelinks Reason: Restoring to make it possible for Ricordisamoa to work on it. https://gerrit.wikimedia.org/r/181902 TASK DETAIL https://phabricator.wikimedia.org/T48217 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: gerritbot Cc: thiemowmde, Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Wikidata-bugs, Qgil, matej_suchanek, Multichill, Lydia_Pintscher, daniel, aude, Malyacko ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
Ricordisamoa added a comment. With https://gerrit.wikimedia.org/r/232698 I explore a different approach: it would be possible to use something like https://www.wikidata.org/wiki/Special:PagesWithProp/wb-sitelinks?sortbyvalue=1. The same would work with wb-claims, etc. TASK DETAIL https://phabricator.wikimedia.org/T48217 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ricordisamoa Cc: thiemowmde, Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Wikidata-bugs, Qgil, matej_suchanek, Multichill, Lydia_Pintscher, daniel, aude, Malyacko ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
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 DETAILhttps://phabricator.wikimedia.org/T48217EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Ricordisamoa, MultichillCc: 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
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
Multichill added a comment. This change got very old and in the meantime we have this information in SPARQL so anyone can retrieve this data. I don't think this is needed any more. I propose to abandon the change and close the task.TASK DETAILhttps://phabricator.wikimedia.org/T48217EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Ricordisamoa, MultichillCc: thiemowmde, Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Multichill, Lydia_Pintscher, daniel, GoranSMilovanovic, Soteriaspace, JakeTheDeveloper, QZanden, Izno, Wikidata-bugs, aude, TheDJ, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
gerritbot added a comment. Change 181902 abandoned by Thiemo Mättig (WMDE): Implement a special page to show items with the most sitelinks https://gerrit.wikimedia.org/r/181902TASK DETAILhttps://phabricator.wikimedia.org/T48217EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Ricordisamoa, gerritbotCc: thiemowmde, Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Multichill, Lydia_Pintscher, daniel, GoranSMilovanovic, Soteriaspace, JakeTheDeveloper, QZanden, Izno, Wikidata-bugs, aude, TheDJ, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
Multichill added a comment. @thiemowmde: Ricordisamoa was working on this change so I didn't close it yet because I wanted him to have the chance to comment. @Ricordisamoa sorry for the quick close.TASK DETAILhttps://phabricator.wikimedia.org/T48217EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Ricordisamoa, MultichillCc: thiemowmde, Ladsgroup, Bene, Ricordisamoa, Aklapper, gerritbot, Multichill, Lydia_Pintscher, daniel, GoranSMilovanovic, Soteriaspace, JakeTheDeveloper, QZanden, Izno, Wikidata-bugs, aude, TheDJ, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
Multichill added a comment. Looks like I worked on this months ago, I might as well finish it. TASK DETAIL https://phabricator.wikimedia.org/T48217 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign . EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Multichill Cc: Qgil, Lydia_Pintscher, daniel, Multichill, matej_suchanek, Wikidata-bugs, aude ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
Lydia_Pintscher added a comment. \o/ TASK DETAIL https://phabricator.wikimedia.org/T48217 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign . EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Multichill, Lydia_Pintscher Cc: Qgil, Lydia_Pintscher, daniel, Multichill, matej_suchanek, Wikidata-bugs, aude ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
Multichill added a comment. I took a different approach than Bene: I extended the standard QueryPage. Would appreciate input. If this approach works I plan to add some more special pages and maybe rewrite Special:unconnectedpages. TASK DETAIL https://phabricator.wikimedia.org/T48217 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign . EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Multichill Cc: Qgil, Lydia_Pintscher, daniel, Multichill, matej_suchanek, Wikidata-bugs, aude ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T48217: Implement a special page to show items with the most sitelinks
gerritbot added a subscriber: gerritbot. gerritbot added a comment. Change 181902 had a related patch set uploaded (by Siebrand): Implement a special page to show items with the most sitelinks https://gerrit.wikimedia.org/r/181902 https://phabricator.wikimedia.org/tag/patch-for-review/ TASK DETAIL https://phabricator.wikimedia.org/T48217 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign . EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Multichill, gerritbot Cc: gerritbot, Wikidata-bugs, Qgil, matej_suchanek, Multichill, Lydia_Pintscher, daniel, aude ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
