User:Legoktm/No enwiki report
Jump to navigation
Jump to search
mysql> select
-> CONCAT("[[Q",ips_item_id,"]]"),
-> COUNT(*)
-> from wb_items_per_site
-> where not exists (select * from wb_items_per_site as data where data.ips_item_id=wb_items_per_site.ips_item_id and data.ips_site_id = "enwiki")
-> GROUP BY ips_item_id
-> ORDER BY COUNT(*) DESC
-> LIMIT 100;
+--------------------------------+----------+
| CONCAT("[[Q",ips_item_id,"]]") | COUNT(*) |
+--------------------------------+----------+
| [[Q29520]] | 79 | SPECIALCASE: Wikipedia used to have an article on this, but it was replaced.
| [[Q42603]] (priest) | 70 | FIXED
| [[Q131244]] | 69 | NOENWIKI
| [[Q43136]] | 68 | NOENWIKI
| [[Q1458045]] | 67 | NOENWIKI
| [[Q81]] (radish) | 63 | FIXED FOR ENWIKI / ERROR "Site link [[pnbwiki:مولی]] already used by item [[Q1565252]]"
| [[Q45675]] | 62 | NOENWIKI - REDIRECT/MERGE
| [[Q124378]] (earthworm) | 60 | FIXED
| [[Q43533]] (crystal) | 59 | FIXED
| [[Q9005]] | 59 | DISAMBIG NEEDED
| [[Q12097]] | 59 | NOENWIKI (Wikidata is King. EnWiki is Monarch, incl. King)
| [[Q177220]] | 58 | NOENWIKI (Wikidata is Singer. EnWiki is Singing, incl. Singer)
| [[Q28165]] (cinnamon) | 58 | FIXED
| [[Q42844]] (depression) | 56 | FIXED
| [[Q36908]] (mountaineering) | 56 | FIXED for enWiki: link added
| [[Q44585]] (Nobel Prize in Chemistry) 56 | FIXED for enWiki: link added
| [[Q1907525]] | 56 |
| [[Q83311]] | 56 |
| [[Q19648]] | 55 |
| [[Q131136]] | 55 |
| [[Q88870]] | 55 |
| [[Q201251]] | 55 |
| [[Q171441]] | 55 |
| [[Q44120]] | 55 |
| [[Q82622]] | 54 |
| [[Q18550]] | 54 |
| [[Q80061]] | 54 |
| [[Q80117]] | 53 |
| [[Q484152]] | 52 |
| [[Q28298]] | 52 |
| [[Q207766]] | 52 |
| [[Q131183]] | 51 |
| [[Q789447]] | 50 |
| [[Q177932]] | 50 |
| [[Q243516]] | 50 |
| [[Q165094]] | 49 |
| [[Q191118]] | 49 |
| [[Q133363]] | 49 |
| [[Q134609]] | 49 |
| [[Q134293]] | 49 |
| [[Q103163]] | 48 |
| [[Q28803]] | 47 |
| [[Q165074]] | 47 |
| [[Q122574]] | 47 |
| [[Q162691]] | 47 |
| [[Q1213296]] | 46 |
| [[Q132539]] | 46 |
| [[Q172809]] | 46 |
| [[Q180323]] | 46 |
| [[Q240612]] | 46 |
| [[Q248254]] | 45 |
| [[Q2453469]] | 45 |
| [[Q154326]] | 45 |
| [[Q190200]] | 45 |
| [[Q132734]] | 44 |
| [[Q154002]] | 44 |
| [[Q154814]] | 44 |
| [[Q28507]] | 44 |
| [[Q106106]] | 44 |
| [[Q59882]] | 44 |
| [[Q164160]] | 44 |
| [[Q127418]] | 44 |
| [[Q149851]] | 44 |
| [[Q28078]] | 44 |
| [[Q172833]] | 44 |
| [[Q133105]] | 43 |
| [[Q134161]] | 43 |
| [[Q243695]] | 43 |
| [[Q186360]] | 43 |
| [[Q180569]] | 43 |
| [[Q167903]] | 43 |
| [[Q173053]] | 43 |
| [[Q150971]] | 43 |
| [[Q329888]] | 43 |
| [[Q241318]] | 43 |
| [[Q173113]] | 43 |
| [[Q1616828]] | 42 |
| [[Q191764]] | 42 |
| [[Q130585]] | 42 |
| [[Q179651]] | 42 |
| [[Q242630]] | 42 |
| [[Q107679]] | 42 |
| [[Q103382]] | 42 |
| [[Q170173]] | 42 |
| [[Q107711]] | 42 |
| [[Q183225]] | 41 |
| [[Q200433]] | 41 |
| [[Q493878]] | 41 |
| [[Q862978]] | 41 |
| [[Q179600]] | 41 |
| [[Q45018]] | 41 |
| [[Q176530]] | 41 |
| [[Q268378]] | 41 |
| [[Q102836]] | 41 |
| [[Q242129]] | 40 |
| [[Q184899]] | 40 |
| [[Q185078]] | 40 |
| [[Q30192]] | 40 |
| [[Q188624]] | 40 |
| [[Q15033]] | 40 |
+--------------------------------+----------+
100 rows in set (1 min 20.06 sec)