Jump to content

User:Lady Lysine Ikinsile~enwiki/SQL query results

From Wikipedia, the free encyclopedia

mysql> select concat( '#', art_title, ' (', links_to, ' articles)' )

   -> from art
   -> where art.art_is_redirect = 1
   -> and art.art_is_stub = 0
   -> and art.art_is_disambig = 0
   -> order by links_to desc
   -> limit 200;
+-----------------------------------------------------------------+
| concat( '#', art_title, ' (', links_to, ' articles)' )      |
+-----------------------------------------------------------------+
| #Centuries (63 articles)                                    |
| #London_Borough (9 articles)                                |
| #Football_(soccer) (7 articles)                             |
| #English_language (5 articles)                              |
| #Bundesland (3 articles)                                    |
| #United_States (3 articles)                                 |
| #USA (3 articles)                                           |
| #Muslim (2 articles)                                        |
| #Farming (2 articles)                                       |
| #Web_site (2 articles)                                      |
| #Math (2 articles)                                          |
| #Wikimedia (1 articles)                                     |
| #December,_2003 (1 articles)                                |
| #Social (1 articles)                                        |
| #Japanese (1 articles)                                      |
| #Mathematic (1 articles)                                    |
| #SI (1 articles)                                            |
| #Net_jargon (1 articles)                                    |
| #Person (1 articles)                                        |
| #NPO (1 articles)                                           |
| #Symbols (1 articles)                                       |
| #Democratic (1 articles)                                    |
| #Animals (1 articles)                                       |
| #Market_place (1 articles)                                  |
| #French (1 articles)                                        |
| #Countries (1 articles)                                     |
| #Good (1 articles)                                          |
| #Roman_Catholic (1 articles)                                |
| #Philosopher (1 articles)                                   |
| #Liter (1 articles)                                         |
| #Multiverse (1 articles)                                    |