| matej_suchanek removed subscribers: Wikidata-bugs, matej_suchanek. matej_suchanek edited the task description. (Show Details) |
EDIT DETAILS
SELECT ips_item_id, COUNT(ips_item_id) FROM wb_items_per_site GROUP by ips_item_id ORDER BY COUNT(ips_item_id) DESC LIMIT 100;
--------------------------
**Version**: unspecified
**Severity**: minor
```lang=sql
SELECT ips_item_id, COUNT(ips_item_id) FROM wb_items_per_site GROUP by ips_item_id ORDER BY COUNT(ips_item_id) DESC LIMIT 100;
```
--------------------------
**URL**: https://www.wikidata.org/wiki/Special:SpecialPages
...
Rough query:SELECT ips_item_id, COUNT(ips_item_id) FROM wb_items_per_site GROUP by ips_item_id ORDER BY COUNT(ips_item_id) DESC LIMIT 100;
--------------------------
**Version**: unspecified
**Severity**: minor
```lang=sql
SELECT ips_item_id, COUNT(ips_item_id) FROM wb_items_per_site GROUP by ips_item_id ORDER BY COUNT(ips_item_id) DESC LIMIT 100;
```
--------------------------
**URL**: https://www.wikidata.org/wiki/Special:SpecialPages
TASK DETAIL
EMAIL PREFERENCES
To: Ricordisamoa, matej_suchanek
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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
