SQL daniel@sql-s5:wikidatawiki_p> select top20.ips_item_id, top20.n, ips.ips_site_page from ( select ips_item_id, count(*) as n from wb_items_per_site where ips_site_id like "%wiki" group by ips_item_id order by n desc limit 50 ) as top20 join wb_items_per_site as ips on ips.ips_item_id = top20.ips_item_id and ips.ips_site_id = 'enwiki'; +-------------+-----+----------------------------------------------------+ | ips_item_id | n | ips_site_page | +-------------+-----+----------------------------------------------------+ | 5296 | 286 | Main Page | | 6293548 | 286 | Special:RecentChanges | | 4299475 | 276 | Template:Bot | | 4844001 | 275 | Template:Soft redirect | | 4847311 | 273 | Template:Db | | 5611452 | 271 | Template:Mod | | 16467 | 271 | Template:Link FA | | 5461620 | 269 | Template:Babel | | 159 | 266 | Russia | | 5400303 | 264 | Template:! | | 1859 | 259 | True Jesus Church | | 30 | 256 | United States | | 5964 | 255 | Category:Candidates for speedy deletion | | 4960490 | 253 | Category:Languages | | 183 | 252 | Germany | | 52 | 251 | Wikipedia | | 46 | 248 | Europe | | 4655354 | 248 | User:Emijrp/List of Wikipedians by number of edits | | 5626526 | 248 | Category:User en | | 5544939 | 243 | Template:User en-2 | | 38 | 242 | Italy | | 1860 | 242 | English language | | 15 | 241 | Africa | | 142 | 241 | France | | 5547114 | 241 | Template:User en | | 4361 | 240 | Curitiba | | 29 | 239 | Spain | | 48 | 239 | Asia | | 4966679 | 239 | Category:Wikipedia | | 43 | 238 | Turkey | | 881 | 238 | Vietnam | | 16 | 235 | Canada | | 5462387 | 235 | Template:Commons | | 668 | 234 | India | | 36 | 233 | Poland | | 4587662 | 233 | Category:Europe | | 5626683 | 230 | Category:User en-2 | | 145 | 230 | United Kingdom | | 155 | 229 | Brazil | | 2316 | 229 | Kurów | | 5543187 | 229 | Template:User en-3 | | 6395874 | 229 | Category:User de | | 17 | 228 | Japan | | 37 | 228 | Lithuania | | 148 | 227 | China | | 33 | 226 | Finland | | 34 | 226 | Sweden | | 55 | 226 | Netherlands | | 4039395 | 226 | Wikipedia:Administrators | | 40 | 225 | Austria | +-------------+-----+----------------------------------------------------+ 50 rows in set (4 min 31.11 sec)