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)
