Addshore added a comment.
Something like this will help..
SELECT
ips_site_id AS site,
COUNT(*) AS count
FROM wikidatawiki.wb_items_per_site
GROUP BY ips_item_id
ORDER BY count ASC;
TASK DETAIL
https://phabricator.wikimedia.org/T119611
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: Aklapper, Addshore, StudiesWorld, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
