コンテンツにスキップ

英文维基 | 中文维基 | 日文维基 | 草榴社区

Wikipedia:保護依頼/20170513 template 100000

MariaDB [jawiki_p]> SELECT tl_title, count(*) AS n FROM templatelinks GROUP BY tl_title HAVING n >= 100000 ORDER BY n desc;
+----------------------------+--------+
| tl_title                   | n      |
+----------------------------+--------+
| Arguments                  | 997733 |
| Yesno                      | 561789 |
| No_globals                 | 510559 |
| Infobox                    | 464866 |
| Asbox                      | 454243 |
| Navbox                     | 437533 |
| Side_box                   | 436197 |
| Infobox/former             | 430644 |
| Reflist                    | 428228 |
| Navbox/former              | 383829 |
| If_empty                   | 368028 |
| Ifempty                    | 366126 |
| Flagicon                   | 357421 |
| Category_handler           | 350309 |
| Namespace_detect/config    | 336118 |
| Namespace_detect/data      | 336118 |
| Category_handler/data      | 336115 |
| Category_handler/shared    | 336115 |
| Category_handler/blacklist | 336115 |
| Category_handler/config    | 336115 |
| Message_box                | 332240 |
| Message_box/configuration  | 332227 |
| ISO_dateJA                 | 241187 |
| Lang                       | 232062 |
| Ambox                      | 231213 |
| Accessdate                 | 202518 |
| Accessdate/core            | 202485 |
| ISO_date/ymd               | 195316 |
| Checkdate                  | 195105 |
| DMC/core                   | 188729 |
| Country_flag_alias_JPN     | 187963 |
| Country_alias_JPN          | 187765 |
| Citation/showdate          | 180175 |
| Cite_web                   | 175294 |
| Sister                     | 175071 |
| Citation/showdateCore      | 174815 |
| InfoboxImage               | 170895 |
| 脚注ヘルプ                 | 169617 |
| Plainlink                  | 157403 |
| ISO639言語名               | 157358 |
| JPN                        | 152031 |
| DMC                        | 151560 |
| Commonscat                 | 142718 |
| DatedAI                    | 141262 |
| Math                       | 138823 |
| String                     | 135785 |
| Coordinates                | 129319 |
| 年月日                     | 119454 |
| Link                       | 111107 |
| 生年月日と年齢             | 108458 |
| Citation/core              | 106294 |
| Navbar                     | 106100 |
| Color                      | 102448 |
+----------------------------+--------+
53 rows in set (32.31 sec)

MariaDB [jawiki_p]> SELECT `page_title` FROM `page` \
    -> WHERE `page_namespace` = 10 \
    -> AND `page_title` IN ('Arguments','Yesno','No_globals','Infobox','Asbox','Navbox','Side_box','Infobox/former','Reflist','Navbox/former','If_empty','Ifempty','Flagicon','Category_handler','Namespace_detect/config','Namespace_detect/data','Category_handler/data','Category_handler/shared','Category_handler/blacklist','Category_handler/config','Message_box','Message_box/configuration','ISO_dateJA','Lang','Ambox','Accessdate','Accessdate/core','ISO_date/ymd','Checkdate','DMC/core','Country_flag_alias_JPN','Country_alias_JPN','Citation/showdate','Cite_web','Sister','Citation/showdateCore','InfoboxImage','脚注ヘルプ','Plainlink','ISO639言語名','JPN','DMC','Commonscat','DatedAI','Math','String','Coordinates','年月日','Link','生年月日と年齢','Citation/core','Navbar','Color') \
    -> AND `page_id` NOT IN (SELECT pr_page FROM page_restrictions);
+----------------------------+
| page_title                 |
+----------------------------+
| Accessdate/core            |
| Category_handler/blacklist |
| Checkdate                  |
| Citation/core              |
| Citation/showdate          |
| Citation/showdateCore      |
| Cite_web                   |
| Commonscat                 |
| Country_alias_JPN          |
| Country_flag_alias_JPN     |
| DMC                        |
| DatedAI                    |
| ISO639言語名               |
| ISO_date/ymd               |
| ISO_dateJA                 |
| If_empty                   |
| Ifempty                    |
| Link                       |
| Math                       |
| Navbar                     |
| Plainlink                  |
| Yesno                      |
| 年月日                     |
| 生年月日と年齢             |
+----------------------------+
24 rows in set (0.03 sec)