User:This, that and the other/Twinkle tag data/2013-07

11:15, 31 July 2013 (UTC)

MariaDB [enwiki_p]> select page.page_id,page.page_title,page.page_is_redirect as is_redir,rd_title as redir_to,count(tl_from) as transclusions from ((redirect inner join page on rd_from=page.page_id) inner join templatelinks on page.page_namespace=tl_namespace and page.page_title=tl_title) where rd_namespace=10 and ( rd_title="Advert" or rd_title="All_plot" or rd_title="Autobiography" or rd_title="BLP_sources" or rd_title="BLP_unsourced" or rd_title="Improve_categories" or rd_title="Citation_style" or rd_title="Cleanup" or rd_title="Cleanup-reorganize" or rd_title="Close_paraphrasing" or rd_title="COI" or rd_title="Condense" or rd_title="Confusing" or rd_title="Context" or rd_title="Copy_edit" or rd_title="Copypaste" or rd_title="Dead_end" or rd_title="Disputed" or rd_title="Essay-like" or rd_title="Expand_language" or rd_title="Expert-subject" or rd_title="External_links" or rd_title="Fanpov" or rd_title="Fiction" or rd_title="Globalize" or rd_title="GOCEinuse" or rd_title="Hoax" or rd_title="In-universe" or rd_title="Incoherent" or rd_title="In_use" or rd_title="Lead_missing" or rd_title="Lead_rewrite" or rd_title="Lead_too_long" or rd_title="Lead_too_short" or rd_title="Cleanup-bare_URLs" or rd_title="Merge" or rd_title="Merge_from" or rd_title="Merge_to" or rd_title="Metricate" or rd_title="More_footnotes" or rd_title="New_unreviewed_article" or rd_title="No_footnotes" or rd_title="Non-free" or rd_title="Notability" or rd_title="Not_English" or rd_title="One_source" or rd_title="Original_research" or rd_title="Orphan" or rd_title="Over_coverage" or rd_title="Overlinked" or rd_title="Overly_detailed" or rd_title="Peacock" or rd_title="Plot" or rd_title="POV" or rd_title="Primary_sources" or rd_title="Prose" or rd_title="Recentism" or rd_title="Refimprove" or rd_title="Rough_translation" or rd_title="Sections" or rd_title="Self-published" or rd_title="Technical" or rd_title="Cleanup-tense" or rd_title="Third-party" or rd_title="Tone" or rd_title="Too_few_opinions" or rd_title="Uncategorized" or rd_title="Under_construction" or rd_title="Underlinked" or rd_title="Undue" or rd_title="Unreferenced" or rd_title="Unreliable_sources" or rd_title="Update" or rd_title="Very_long" or rd_title="Weasel" )  group by page.page_id; +--++--++---+ +--++--++---+ +--++--++---+ 479 rows in set (46 min 7.62 sec)
 * page_id | page_title                         | is_redir | redir_to               | transclusions |
 * 522796 | Npov                              |        1 | POV                    |           124 |
 * 568517 | NN                                |        1 | Notability             |             3 |
 * 855172 | Verify                            |        1 | Refimprove             |            92 |
 * 921940 | Pov                               |        1 | POV                    |            54 |
 * 964061 | Clean                             |        1 | Cleanup                |             2 |
 * 964062 | Cu                                |        1 | Cleanup                |             4 |
 * 993541 | Mergewith                         |        1 | Merge                  |            60 |
 * 1072367 | Inusefor                          |        1 | In_use                 |             2 |
 * 1174798 | Unsourced                         |        1 | Unreferenced           |          5339 |
 * 1300238 | Not_list                          |        1 | Prose                  |             1 |
 * 1312970 | Gcheck                            |        1 | Copy_edit              |             1 |
 * 1327834 | Bias                              |        1 | POV                    |            32 |
 * 1331305 | Not_verified                      |        1 | Refimprove             |           171 |
 * 1464938 | Cleanup-quality                   |        1 | Cleanup                |             1 |
 * 1472012 | NPOV                              |        1 | POV                    |           183 |
 * 1481671 | Ad                                |        1 | Advert                 |           685 |
 * 1549157 | Expert                            |        1 | Expert-subject         |           367 |
 * 1616336 | Cleanup-fiction                   |        1 | Fiction                |             3 |
 * 1628559 | Cleanup-clarity                   |        1 | Confusing              |             1 |
 * 1630292 | Unverified                        |        1 | Unreferenced           |            32 |
 * 1662355 | OriginalResearch                  |        1 | Original_research      |            45 |
 * 1697277 | Wip                               |        1 | In_use                 |             2 |
 * 1705581 | Translate                         |        1 | Not_English            |             7 |
 * 1767216 | Merge-to                          |        1 | Merge_to               |            36 |
 * 1801841 | Construction                      |        1 | Under_construction     |           252 |
 * 1829437 | Nonnotable                        |        1 | Notability             |             1 |
 * 1855197 | Cleanup-date                      |        1 | Cleanup                |           195 |
 * 1878320 | Mergeinto                         |        1 | Merge_to               |            87 |
 * 2056817 | Editing                           |        1 | In_use                 |             2 |
 * 2074538 | Simplify                          |        1 | Confusing              |             1 |
 * 2150947 | Copy-edit                         |        1 | Copy_edit              |             6 |
 * 2186535 | Explain_significance              |        1 | Notability             |             3 |
 * 2235652 | Merge-from                        |        1 | Merge_from             |            32 |
 * 2236633 | Advertisement                     |        1 | Advert                 |           209 |
 * 2343267 | Dispute                           |        1 | Disputed               |             8 |
 * 2433618 | Tense                             |        1 | Cleanup-tense          |            48 |
 * 2478797 | CatNeeded                         |        1 | Uncategorized          |             2 |
 * 2629609 | Unref                             |        1 | Unreferenced           |          3365 |
 * 2632890 | Limitedgeographicscope            |        1 | Globalize              |            54 |
 * 2637722 | Cleanup-references                |        1 | Citation_style         |            10 |
 * 2637741 | Cleanup-tone                      |        1 | Tone                   |            12 |
 * 2637796 | Cleanup-verify                    |        1 | Refimprove             |            11 |
 * 2638617 | Cleanup-context                   |        1 | Context                |            14 |
 * 2638902 | Cleanup-confusing                 |        1 | Confusing              |             8 |
 * 2641653 | Catneeded                         |        1 | Uncategorized          |             7 |
 * 2690497 | Originalresearch                  |        1 | Original_research      |            78 |
 * 2820872 | Bio-context                       |        1 | Context                |             1 |
 * 2898579 | Uncategorised                     |        1 | Uncategorized          |            30 |
 * 2911846 | Cleanup-copyedit                  |        1 | Copy_edit              |             3 |
 * 2944831 | LinkFarm                          |        1 | External_links         |             1 |
 * 2957429 | Neutrality                        |        1 | POV                    |            53 |
 * 3076126 | Notverified                       |        1 | Refimprove             |             2 |
 * 3147903 | Uncat                             |        1 | Uncategorized          |           466 |
 * 3213707 | Cite_sources                      |        1 | Refimprove             |             1 |
 * 3307381 | Long                              |        1 | Very_long              |             7 |
 * 3392319 | Weasel_words                      |        1 | Weasel                 |            44 |
 * 3454734 | World                             |        1 | Globalize              |             4 |
 * 3525478 | Worldwide                         |        1 | Globalize              |            19 |
 * 3572720 | Cleanup-english                   |        1 | Copy_edit              |             2 |
 * 3592479 | Categorize                        |        1 | Uncategorized          |             2 |
 * 3596243 | Globalise                         |        1 | Globalize              |            15 |
 * 3680410 | Nonenglish                        |        1 | Not_English            |             1 |
 * 3988639 | References                        |        1 | Unreferenced           |           901 |
 * 4105072 | Attention                         |        1 | Cleanup                |            21 |
 * 4131917 | Longish                           |        1 | Very_long              |             4 |
 * 4146370 | Cleanup-restructure               |        1 | Cleanup-reorganize     |            21 |
 * 4262522 | Cleanup-advert                    |        1 | Advert                 |             2 |
 * 4372625 | Sources                           |        1 | Refimprove             |           626 |
 * 4484895 | Mergefrom-multiple                |        1 | Merge_from             |             3 |
 * 4545726 | Unclear                           |        1 | Confusing              |            64 |
 * 4554817 | WIP                               |        1 | In_use                 |             7 |
 * 4827913 | Clean_up                          |        1 | Cleanup                |            56 |
 * 4909370 | Tech                              |        1 | Technical              |             1 |
 * 4917125 | Major_edit                        |        1 | In_use                 |             1 |
 * 4932705 | Outdated                          |        1 | Update                 |            46 |
 * 4932737 | Worldview                         |        1 | Globalize              |            28 |
 * 4932740 | Globalview                        |        1 | Globalize              |             1 |
 * 4941022 | Majoredit                         |        1 | In_use                 |             1 |
 * 4977589 | Secondary                         |        1 | Self-published         |             3 |
 * 4982513 | Nocat                             |        1 | Uncategorized          |            27 |
 * 4992465 | Significance                      |        1 | Notability             |             3 |
 * 5025009 | More_sources                      |        1 | Refimprove             |            76 |
 * 5042585 | Citations_missing                 |        1 | Refimprove             |          1727 |
 * 5072650 | Advertising                       |        1 | Advert                 |            24 |
 * 5072654 | Cleanup-advertising               |        1 | Advert                 |             2 |
 * 5160320 | Unencyclopedic_tone               |        1 | Tone                   |             6 |
 * 5256819 | Out_of_date                       |        1 | Update                 |            20 |
 * 5506307 | Advertisment                      |        1 | Advert                 |             6 |
 * 5786029 | Ref-cleanup                       |        1 | Citation_style         |             4 |
 * 5867404 | Unreliable                        |        1 | Unreliable_sources     |            63 |
 * 5992372 | CleanupConfusing                  |        1 | Confusing              |             1 |
 * 6033174 | In-use                            |        1 | In_use                 |             1 |
 * 6195568 | Recent                            |        1 | Recentism              |             6 |
 * 6197449 | Unencyclopaedic_tone              |        1 | Tone                   |             1 |
 * 6392842 | Nn                                |        1 | Notability             |            49 |
 * 6455328 | Organize                          |        1 | Cleanup-reorganize     |            20 |
 * 6529848 | Wait                              |        1 | In_use                 |             6 |
 * 6547343 | Clean-up                          |        1 | Cleanup                |            19 |
 * 6809040 | Original_Research                 |        1 | Original_research      |            23 |
 * 6852540 | Cleanup-jargon                    |        1 | Technical              |            15 |
 * 6929843 | Magazine                          |        1 | Tone                   |            72 |
 * 7013781 | List_to_prose                     |        1 | Prose                  |            11 |
 * 7137657 | Referenced                        |        1 | Refimprove             |            38 |
 * 7414612 | Grammar                           |        1 | Copy_edit              |            25 |
 * 7490404 | Citesources                       |        1 | Unreferenced           |            10 |
 * 7501468 | Essay-opinion                     |        1 | Essay-like             |             5 |
 * 7679638 | Lead_section                      |        1 | Lead_too_short         |            18 |
 * 7732867 | Tootechnical                      |        1 | Technical              |             4 |
 * 7782365 | Linkfarm                          |        1 | External_links         |            85 |
 * 7925142 | Citations_needed                  |        1 | Refimprove             |           128 |
 * 8023458 | PoV                               |        1 | POV                    |             1 |
 * 8083804 | Expert-portal                     |        1 | Expert-subject         |             4 |
 * 8127234 | Long_plot_summary                 |        1 | Plot                   |             1 |
 * 8158337 | Inuniverse                        |        1 | In-universe            |            27 |
 * 8260741 | Moresources                       |        1 | Refimprove             |            64 |
 * 8278102 | Expert-verify                     |        1 | Expert-subject         |            74 |
 * 8278118 | External-links                    |        1 | External_links         |             5 |
 * 8280318 | InUniverse                        |        1 | In-universe            |             1 |
 * 8280322 | In_universe                       |        1 | In-universe            |            24 |
 * 8292922 | Copy-paste                        |        1 | Copypaste              |             6 |
 * 8292926 | Copy_paste                        |        1 | Copypaste              |             3 |
 * 8297642 | Fansite                           |        1 | Fanpov                 |           293 |
 * 8306639 | Intro_length                      |        1 | Lead_too_long          |             4 |
 * 8356416 | Prose_timeline                    |        1 | Prose                  |             1 |
 * 8412149 | BLP_dispute                       |        1 | Disputed               |             1 |
 * 8435529 | Global                            |        1 | Globalize              |            22 |
 * 8479840 | NR                                |        1 | Unreferenced           |             1 |
 * 8794006 | AUTO                              |        1 | Autobiography          |             1 |
 * 8853927 | Reliablesources                   |        1 | Unreliable_sources     |            27 |
 * 8907807 | Coi                               |        1 | COI                    |           459 |
 * 8955344 | No_references                     |        1 | Unreferenced           |           139 |
 * 9192001 | Notable                           |        1 | Notability             |           396 |
 * 9405986 | PrimarySources                    |        1 | Primary_sources        |             4 |
 * 9783896 | Nointro                           |        1 | Lead_missing           |             9 |
 * 9838684 | Factfiction                       |        1 | Fiction                |             2 |
 * 10035390 | Neutral                           |        1 | POV                    |             9 |
 * 10070301 | Outofdate                         |        1 | Update                 |             2 |
 * 10236039 | Reliable_sources                  |        1 | Unreliable_sources     |            34 |
 * 10623202 | Missing_citations                 |        1 | Refimprove             |            14 |
 * 10629431 | Weasel-words                      |        1 | Weasel                 |             4 |
 * 11056574 | Made-up                           |        1 | Hoax                   |             2 |
 * 11187595 | Inline_citations                  |        1 | No_footnotes           |           311 |
 * 11187704 | Singlesource                      |        1 | One_source             |            37 |
 * 11187706 | Single_source                     |        1 | One_source             |           327 |
 * 11187955 | Unreferenced_article              |        1 | Unreferenced           |            54 |
 * 11254897 | Cleanup-Jargon                    |        1 | Technical              |             1 |
 * 11321330 | Morerefs                          |        1 | Refimprove             |           103 |
 * 11321379 | Morereferences                    |        1 | Refimprove             |            72 |
 * 11351680 | Citationstyle                     |        1 | Citation_style         |            17 |
 * 11396469 | Citation-style                    |        1 | Citation_style         |             6 |
 * 11396485 | Refstyle                          |        1 | Citation_style         |            38 |
 * 11406794 | Moreref                           |        1 | Refimprove             |            80 |
 * 11584748 | Noref                             |        1 | Unreferenced           |           760 |
 * 11627359 | Formal                            |        1 | Tone                   |             1 |
 * 11665107 | Norefs                            |        1 | Unreferenced           |           209 |
 * 11725196 | Externallinks                     |        1 | External_links         |            19 |
 * 11726161 | Reference_style                   |        1 | Citation_style         |             6 |
 * 12061448 | Noreferences                      |        1 | Unreferenced           |           256 |
 * 12232241 | Expandlead                        |        1 | Lead_too_short         |             6 |
 * 12315395 | Primary_Sources                   |        1 | Primary_sources        |            13 |
 * 12369247 | Citations                         |        1 | No_footnotes           |           668 |
 * 12369251 | No_citations                      |        1 | No_footnotes           |            89 |
 * 12581814 | Few_references                    |        1 | Refimprove             |             2 |
 * 12581820 | More_references                   |        1 | Refimprove             |           200 |
 * 12608858 | Work_in_progress                  |        1 | Under_construction     |             5 |
 * 12722971 | Roughtranslation                  |        1 | Rough_translation      |            39 |
 * 12731586 | Blpsources                        |        1 | BLP_sources            |            55 |
 * 12779111 | In-text_citations                 |        1 | No_footnotes           |            32 |
 * 12833050 | Ref-improve                       |        1 | Refimprove             |           192 |
 * 12833056 | Ref_improve                       |        1 | Refimprove             |         11786 |
 * 12833064 | Improve_references                |        1 | Refimprove             |            10 |
 * 12833069 | Improvereferences                 |        1 | Refimprove             |           136 |
 * 12833072 | Improverefs                       |        1 | Refimprove             |            25 |
 * 12833074 | Improve_refs                      |        1 | Refimprove             |             6 |
 * 12864803 | Shorten                           |        1 | Very_long              |             5 |
 * 13020442 | UpdateWatch                       |        1 | Update                 |            12 |
 * 13052626 | Nofootnote                        |        1 | No_footnotes           |            12 |
 * 13501288 | Too_short                         |        1 | Lead_too_short         |             8 |
 * 13501351 | Leadtoolong                       |        1 | Lead_too_long          |             3 |
 * 13511006 | No_lead                           |        1 | Lead_missing           |            36 |
 * 13648581 | Too_many_links                    |        1 | External_links         |             8 |
 * 13708193 | Essay-entry                       |        1 | Essay-like             |             8 |
 * 13716248 | Reference-style                   |        1 | Citation_style         |             2 |
 * 13751323 | Leadtooshort                      |        1 | Lead_too_short         |            92 |
 * 14136105 | Proseline                         |        1 | Prose                  |            21 |
 * 14352939 | Nocitations                       |        1 | No_footnotes           |            67 |
 * 14431596 | Under-construction                |        1 | Under_construction     |             8 |
 * 14496955 | BLPSources                        |        1 | BLP_sources            |             4 |
 * 14639557 | Cleanup-refs                      |        1 | Citation_style         |             1 |
 * 14674652 | AD                                |        1 | Advert                 |             1 |
 * 14681679 | Too_long                          |        1 | Very_long              |            19 |
 * 14685444 | Nolead                            |        1 | Lead_missing           |            15 |
 * 15097429 | Restructure                       |        1 | Cleanup-reorganize     |            31 |
 * 15126940 | RefImprove                        |        1 | Refimprove             |            57 |
 * 15167935 | Inline_refs_needed                |        1 | No_footnotes           |             6 |
 * 15409695 | Inline-citations                  |        1 | No_footnotes           |            14 |
 * 15414519 | Toolong                           |        1 | Very_long              |            29 |
 * 15414598 | Introrewrite                      |        1 | Lead_rewrite           |            18 |
 * 15414627 | Tooshort                          |        1 | Lead_too_short         |            73 |
 * 15414665 | Intromissing                      |        1 | Lead_missing           |            65 |
 * 15470153 | Longintro                         |        1 | Lead_too_long          |             2 |
 * 15481392 | Intro                             |        1 | Lead_rewrite           |             6 |
 * 15937570 | Autobio                           |        1 | Autobiography          |            11 |
 * 16007694 | References_needed                 |        1 | Unreferenced           |            12 |
 * 16049395 | Intro_too_long                    |        1 | Lead_too_long          |            22 |
 * 16169905 | Verification                      |        1 | Refimprove             |            35 |
 * 16182943 | Undue_weight                      |        1 | Undue                  |            12 |
 * 16213106 | Merge_into                        |        1 | Merge_to               |            52 |
 * 16673923 | Selfpublished                     |        1 | Self-published         |            14 |
 * 16673927 | Self_published                    |        1 | Self-published         |            13 |
 * 16690987 | Nr                                |        1 | Unreferenced           |            14 |
 * 16693696 | New                               |        1 | New_unreviewed_article |             2 |
 * 16773491 | Primarysource                     |        1 | Primary_sources        |            25 |
 * 16878567 | Copyediting                       |        1 | Copy_edit              |             3 |
 * 16907910 | Cleanup_tone                      |        1 | Tone                   |             1 |
 * 16908073 | Weasel_section                    |        1 | Weasel                 |             5 |
 * 17267251 | Essaylike                         |        1 | Essay-like             |             3 |
 * 17351746 | Incoherent-topic                  |        1 | Incoherent             |            13 |
 * 17360638 | Internallinks                     |        1 | Underlinked            |             1 |
 * 17452835 | Cleanup-essay                     |        1 | Essay-like             |             1 |
 * 17467311 | Weaselwords                       |        1 | Weasel                 |             5 |
 * 17597788 | Additionalcitations               |        1 | Refimprove             |            32 |
 * 17745648 | Additional_citations              |        1 | Refimprove             |            23 |
 * 17806801 | Inline                            |        1 | No_footnotes           |          1657 |
 * 18049947 | Revisions_sandboxed               |        1 | Under_construction     |             3 |
 * 18074382 | Improve                           |        1 | Cleanup                |            24 |
 * 18352724 | Notablity                         |        1 | Notability             |            17 |
 * 18760521 | Under_Construction                |        1 | Under_construction     |            34 |
 * 18797916 | UNDERCONSTRUCTION                 |        1 | Under_construction     |             4 |
 * 18801344 | Toomanylinks                      |        1 | External_links         |            56 |
 * 18949790 | Improveref                        |        1 | Refimprove             |            24 |
 * 19081220 | Tech_jargon                       |        1 | Technical              |             1 |
 * 19149994 | Non_free                          |        1 | Non-free               |             2 |
 * 19210935 | Linkrot                           |        1 | Cleanup-bare_URLs      |          2035 |
 * 19329803 | Oneref                            |        1 | One_source             |            56 |
 * 19406251 | Short_intro                       |        1 | Lead_too_short         |             1 |
 * 19473869 | Cats_needed                       |        1 | Uncategorized          |             3 |
 * 19628257 | No_refs                           |        1 | Unreferenced           |            24 |
 * 19628276 | Fewrefs                           |        1 | Refimprove             |             2 |
 * 19774970 | Expert_subject                    |        1 | Expert-subject         |             5 |
 * 19787288 | Reimprove                         |        1 | Refimprove             |           100 |
 * 20153098 | No_ref                            |        1 | Unreferenced           |            37 |
 * 20156970 | Original-research                 |        1 | Original_research      |             7 |
 * 20370472 | BLPunreferenced                   |        1 | BLP_unsourced          |            15 |
 * 20595656 | BLPrefimprove                     |        1 | BLP_sources            |           168 |
 * 20633107 | Expand_lead                       |        1 | Lead_too_short         |            16 |
 * 20654543 | Jargon                            |        1 | Technical              |            63 |
 * 20686690 | Biased                            |        1 | POV                    |             6 |
 * 20785124 | Uc                                |        1 | Under_construction     |             6 |
 * 20869373 | Complex                           |        1 | Technical              |             7 |
 * 21043346 | COI-section                       |        1 | COI                    |             4 |
 * 21045322 | Unreferencedblp                   |        1 | BLP_unsourced          |             3 |
 * 21045449 | Blpunsourced                      |        1 | BLP_unsourced          |             7 |
 * 21239142 | BLPunsourced                      |        1 | BLP_unsourced          |            45 |
 * 21241401 | BLPsources                        |        1 | BLP_sources            |           162 |
 * 21264123 | Conflict_of_interest              |        1 | COI                    |             2 |
 * 21297834 | Tldr                              |        1 | Very_long              |             2 |
 * 21508578 | Short_lead                        |        1 | Lead_too_short         |             3 |
 * 21540491 | Expand_language_(non-Latin_script) |       1 | Expand_language        |             1 |
 * 21548335 | Unreliablesources                 |        1 | Unreliable_sources     |             8 |
 * 21590170 | Primarysources                    |        1 | Primary_sources        |          5702 |
 * 21591821 | Toofewopinions                    |        1 | Too_few_opinions       |            16 |
 * 21610853 | Deadend                           |        1 | Dead_end               |            20 |
 * 21619195 | Morefootnotes                     |        1 | More_footnotes         |           843 |
 * 21734383 | COI-check                         |        1 | COI                    |            10 |
 * 21844056 | Verylong                          |        1 | Very_long              |            35 |
 * 21848205 | Nofootnotes                       |        1 | No_footnotes           |          2849 |
 * 21852838 | COI-issues                        |        1 | COI                    |             1 |
 * 21965734 | Intro-tooshort                    |        1 | Lead_too_short         |            26 |
 * 21977921 | MergeTo                           |        1 | Merge_to               |             5 |
 * 21977931 | MergeFrom                         |        1 | Merge_from             |             1 |
 * 21993451 | Quality                           |        1 | Cleanup                |            16 |
 * 22065733 | Unsourced_BLP                     |        1 | BLP_unsourced          |             7 |
 * 22157308 | BLP_unreferenced                  |        1 | BLP_unsourced          |            42 |
 * 22256243 | UnderConstruction                 |        1 | Under_construction     |             3 |
 * 22256338 | BLP_Sources                       |        1 | BLP_sources            |             1 |
 * 22256340 | Blp_sources                       |        1 | BLP_sources            |           114 |
 * 22256341 | BLPRefimprove                     |        1 | BLP_sources            |            31 |
 * 22256344 | BLP_Refimprove                    |        1 | BLP_sources            |            16 |
 * 22256347 | BLP_refimprove                    |        1 | BLP_sources            |          1034 |
 * 22256355 | Blprefimprove                     |        1 | BLP_sources            |            22 |
 * 22256356 | Blp_refimprove                    |        1 | BLP_sources            |            73 |
 * 22256367 | BLP_Improvereferences             |        1 | BLP_sources            |             1 |
 * 22294232 | CI                                |        1 | Improve_categories     |             8 |
 * 22294279 | Improve-cats                      |        1 | Improve_categories     |             1 |
 * 22294293 | More_categories                   |        1 | Improve_categories     |            12 |
 * 22294307 | Morecat                           |        1 | Improve_categories     |           578 |
 * 22294309 | Morecategories                    |        1 | Improve_categories     |             1 |
 * 22294312 | Morecats                          |        1 | Improve_categories     |             1 |
 * 22294331 | Category_improve                  |        1 | Improve_categories     |             8 |
 * 22300593 | Blpunref                          |        1 | BLP_unsourced          |             1 |
 * 22304402 | Unreferenced_BLP                  |        1 | BLP_unsourced          |            14 |
 * 22304403 | Refimprove_BLP                    |        1 | BLP_sources            |            77 |
 * 22414348 | Cleanup-article                   |        1 | Cleanup                |             2 |
 * 22454333 | RefimproveBLP                     |        1 | BLP_sources            |           856 |
 * 22454380 | UnreferencedBLP                   |        1 | BLP_unsourced          |            20 |
 * 22561670 | Overlink                          |        1 | Overlinked             |             1 |
 * 22587934 | More_refs                         |        1 | Refimprove             |            54 |
 * 22602471 | Underconstruction                 |        1 | Under_construction     |          1077 |
 * 22680459 | Bare_URLs                         |        1 | Cleanup-bare_URLs      |           276 |
 * 22829890 | Refimproveblp                     |        1 | BLP_sources            |            72 |
 * 23111781 | Onesource                         |        1 | One_source             |          1218 |
 * 23130176 | ProseTimeline                     |        1 | Prose                  |             2 |
 * 23130594 | Needs_footnotes                   |        1 | No_footnotes           |             2 |
 * 23130816 | Catimprove                        |        1 | Improve_categories     |            71 |
 * 23142112 | Notenglish                        |        1 | Not_English            |            36 |
 * 23289848 | RoughTranslation                  |        1 | Rough_translation      |            86 |
 * 23307667 | Unnamed_sport                     |        1 | Context                |             1 |
 * 23410541 | Unreferenced_blp                  |        1 | BLP_unsourced          |             4 |
 * 23435070 | Underconstuction                  |        1 | Under_construction     |             1 |
 * 23576869 | Primary                           |        1 | Primary_sources        |           264 |
 * 23662091 | Leadsection                       |        1 | Lead_missing           |             1 |
 * 23818265 | BLP_Unreferenced                  |        1 | BLP_unsourced          |             1 |
 * 23910313 | Blp-unreferenced                  |        1 | BLP_unsourced          |             2 |
 * 23932205 | Allplot                           |        1 | All_plot               |           506 |
 * 23984883 | Jargon-section                    |        1 | Technical              |             1 |
 * 24186583 | Intro-missing                     |        1 | Lead_missing           |             6 |
 * 24240109 | Blpdispute                        |        1 | Disputed               |             3 |
 * 24330808 | Fancruft                          |        1 | Overly_detailed        |            86 |
 * 24504939 | Gamecleanup                       |        1 | Cleanup                |             1 |
 * 24542937 | Userspace_BLP                     |        1 | BLP_unsourced          |            10 |
 * 24547818 | Close_paraphrase                  |        1 | Close_paraphrasing     |             3 |
 * 24566564 | Intro-toolong                     |        1 | Lead_too_long          |             4 |
 * 24644723 | Lead                              |        1 | Lead_rewrite           |            24 |
 * 24925975 | Unreferenced_stub                 |        1 | Unreferenced           |         21777 |
 * 25013518 | Unreferenced-blp                  |        1 | BLP_unsourced          |             2 |
 * 25087915 | No_lead_section                   |        1 | Lead_missing           |             6 |
 * 25105271 | Link_rot                          |        1 | Cleanup-bare_URLs      |           157 |
 * 25393460 | Gng                               |        1 | Notability             |             2 |
 * 25863355 | Or1                               |        1 | Original_research      |             3 |
 * 25882640 | Not_english                       |        1 | Not_English            |             1 |
 * 25987334 | Bare_links                        |        1 | Cleanup-bare_URLs      |            91 |
 * 26014053 | Long_lead                         |        1 | Lead_too_long          |             2 |
 * 26033673 | Unencyclopædic_tone               |        1 | Tone                   |             6 |
 * 26077656 | Moreinline                        |        1 | More_footnotes         |            12 |
 * 26173148 | Citestyle                         |        1 | Citation_style         |             5 |
 * 26286364 | Intro-rewrite                     |        1 | Lead_rewrite           |             9 |
 * 26286406 | Intro_missing                     |        1 | Lead_missing           |            26 |
 * 26527832 | Ref_Improve                       |        1 | Refimprove             |             2 |
 * 26530117 | Copyedit                          |        1 | Copy_edit              |           440 |
 * 26676311 | Reference_improve                 |        1 | Refimprove             |             4 |
 * 26823382 | Inuse                             |        1 | In_use                 |            83 |
 * 26891998 | BLP_sourced                       |        1 | BLP_sources            |            10 |
 * 27065575 | Mergefrom                         |        1 | Merge_from             |          1031 |
 * 27065666 | Mergeto                           |        1 | Merge_to               |          1154 |
 * 27147611 | More_cats                         |        1 | Improve_categories     |             1 |
 * 27262157 | Barelinks                         |        1 | Cleanup-bare_URLs      |           186 |
 * 27287919 | Refimproved                       |        1 | Refimprove             |             9 |
 * 27345427 | Source_Style                      |        1 | Citation_style         |             4 |
 * 27356691 | Sourced_wrong                     |        1 | Citation_style         |             1 |
 * 27427281 | Needs_references                  |        1 | Unreferenced           |             4 |
 * 27484030 | Cleanup-importance                |        1 | Notability             |            13 |
 * 27665911 | Noreference                       |        1 | Unreferenced           |             7 |
 * 27665915 | No_reference                      |        1 | Unreferenced           |             7 |
 * 27666024 | Refsneeded                        |        1 | Unreferenced           |            16 |
 * 27666026 | Refs_needed                       |        1 | Unreferenced           |            17 |
 * 27666032 | Ref_needed                        |        1 | Unreferenced           |             9 |
 * 27666061 | Citationsneeded                   |        1 | Refimprove             |            12 |
 * 27708290 | Too_many_sections                 |        1 | Condense               |             1 |
 * 27731568 | Emphasis                          |        1 | Undue                  |             1 |
 * 27925887 | Lead-too-short                    |        1 | Lead_too_short         |             1 |
 * 27937769 | Bareurls                          |        1 | Cleanup-bare_URLs      |           171 |
 * 27965949 | Reorganize                        |        1 | Cleanup-reorganize     |             3 |
 * 28052563 | Shortlead                         |        1 | Lead_too_short         |            36 |
 * 28373282 | Refcleanup                        |        1 | Citation_style         |            13 |
 * 28542962 | Accuracy                          |        1 | Disputed               |            34 |
 * 28806829 | Overdetailed                      |        1 | Overly_detailed        |            13 |
 * 28866091 | Primary_source                    |        1 | Primary_sources        |            58 |
 * 29023844 | Long_plot                         |        1 | Plot                   |             4 |
 * 29029335 | BLP_moresources                   |        1 | BLP_sources            |             4 |
 * 29447924 | Do-attempt                        |        1 | Orphan                 |             3 |
 * 29517450 | Bare_urls                         |        1 | Cleanup-bare_URLs      |            96 |
 * 29525353 | Too_technical                     |        1 | Technical              |            26 |
 * 29698461 | ReferencedBLP                     |        1 | BLP_sources            |             1 |
 * 29777399 | EL                                |        1 | External_links         |             4 |
 * 29803419 | Blp_unreferenced                  |        1 | BLP_unsourced          |             4 |
 * 30057532 | Refimprove_blp                    |        1 | BLP_sources            |            25 |
 * 30088176 | Lede_missing                      |        1 | Lead_missing           |             1 |
 * 30088216 | Lede_too_short                    |        1 | Lead_too_short         |             8 |
 * 30089353 | BLPmoreref                        |        1 | BLP_sources            |             7 |
 * 30106623 | Cleanup-linkrot                   |        1 | Cleanup-bare_URLs      |            55 |
 * 30248146 | Nofn                              |        1 | No_footnotes           |             1 |
 * 30369176 | NotEnglish                        |        1 | Not_English            |             1 |
 * 30435330 | No_inline_citations               |        1 | No_footnotes           |           590 |
 * 30467544 | Noinline                          |        1 | No_footnotes           |            11 |
 * 30467546 | Inlinerefs                        |        1 | No_footnotes           |            17 |
 * 30590950 | Intro_too_short                   |        1 | Lead_too_short         |             9 |
 * 30612530 | Blp_unsourced                     |        1 | BLP_unsourced          |             1 |
 * 30753214 | Third-party_sources               |        1 | Third-party            |            59 |
 * 30819529 | Bare_URL                          |        1 | Cleanup-bare_URLs      |            11 |
 * 30868626 | No_intro                          |        1 | Lead_missing           |            12 |
 * 30960043 | Unreviewed                        |        1 | New_unreviewed_article |           141 |
 * 31001765 | Out-of-date                       |        1 | Update                 |             1 |
 * 31121633 | Informal                          |        1 | Tone                   |             3 |
 * 31168253 | Structure                         |        1 | Cleanup-reorganize     |             7 |
 * 31197850 | BLP_improve                       |        1 | BLP_sources            |             3 |
 * 31199036 | World_view                        |        1 | Globalize              |             7 |
 * 31440357 | Refimporve                        |        1 | Refimprove             |            11 |
 * 31490954 | Too_detailed                      |        1 | Overly_detailed        |             4 |
 * 31501115 | List                              |        1 | Prose                  |           100 |
 * 31645718 | Inappropriate_tone                |        1 | Tone                   |          1361 |
 * 31676850 | Refimprove-blp                    |        1 | BLP_sources            |             2 |
 * 31715392 | BareURLs                          |        1 | Cleanup-bare_URLs      |             5 |
 * 31827105 | Link_farm                         |        1 | External_links         |            41 |
 * 31935428 | No_original_research              |        1 | Original_research      |             1 |
 * 31947628 | Intro-expand                      |        1 | Lead_too_short         |             2 |
 * 32182532 | Blp-unsourced                     |        1 | BLP_unsourced          |             1 |
 * 32272056 | Overcoverage                      |        1 | Over_coverage          |            39 |
 * 32297115 | Thirdparty                        |        1 | Third-party            |            18 |
 * 32699102 | Affiliated_sources                |        1 | Third-party            |             1 |
 * 32706550 | Independent_sources               |        1 | Third-party            |            10 |
 * 32737946 | Blp-refimprove                    |        1 | BLP_sources            |             9 |
 * 32741254 | Cleanup-reorganise                |        1 | Cleanup-reorganize     |            47 |
 * 32908011 | Cat_improve                       |        1 | Improve_categories     |           541 |
 * 33008697 | Spelling                          |        1 | Copy_edit              |             2 |
 * 33153108 | Bare-URLs                         |        1 | Cleanup-bare_URLs      |             4 |
 * 33252337 | BLP_source                        |        1 | BLP_sources            |            16 |
 * 33263769 | Over-detailed                     |        1 | Overly_detailed        |             1 |
 * 33263779 | Over_detailed                     |        1 | Overly_detailed        |            57 |
 * 33264516 | Machine_translation               |        1 | Rough_translation      |             1 |
 * 33367434 | BLPunref                          |        1 | BLP_unsourced          |             9 |
 * 33619620 | Excessive_detail                  |        1 | Overly_detailed        |             4 |
 * 33870194 | Longplot                          |        1 | Plot                   |            38 |
 * 33938635 | Universe                          |        1 | In-universe            |             3 |
 * 34030575 | Non-notable                       |        1 | Notability             |             2 |
 * 34213596 | Reorganise                        |        1 | Cleanup-reorganize     |             1 |
 * 34372686 | Cleanup_link-rot                  |        1 | Cleanup-bare_URLs      |             2 |
 * 34372708 | Cleanup_link_rot                  |        1 | Cleanup-bare_URLs      |             2 |
 * 34626922 | Engrish                           |        1 | Rough_translation      |             2 |
 * 34640819 | Extlinks                          |        1 | External_links         |             3 |
 * 34726419 | Cleanup_reorganize                |        1 | Cleanup-reorganize     |             1 |
 * 34730017 | External_linking                  |        1 | External_links         |             1 |
 * 34814200 | Lead_absent                       |        1 | Lead_missing           |             2 |
 * 34814217 | No_lede                           |        1 | Lead_missing           |             8 |
 * 34823012 | Single-source                     |        1 | One_source             |            12 |
 * 34884538 | Nosources                         |        1 | Unreferenced           |            36 |
 * 34884549 | No_sources                        |        1 | Unreferenced           |            41 |
 * 34916056 | Merge_section_to                  |        1 | Merge_to               |             4 |
 * 35108382 | BLP_more_sources                  |        1 | BLP_sources            |             1 |
 * 35298060 | Needs_additional_citations        |        1 | Refimprove             |             8 |
 * 35524609 | Needs_sections                    |        1 | Sections               |             1 |
 * 35639456 | Bare_refs                         |        1 | Cleanup-bare_URLs      |             1 |
 * 35639457 | Bare_references                   |        1 | Cleanup-bare_URLs      |            72 |
 * 35780483 | Too_much_plot                     |        1 | Plot                   |             2 |
 * 35941747 | Pov_problem                       |        1 | POV                    |             1 |
 * 36063175 | In_line_citation                  |        1 | No_footnotes           |             1 |
 * 36265356 | Bareurl                           |        1 | Cleanup-bare_URLs      |            12 |
 * 36380927 | Essay_like                        |        1 | Essay-like             |             8 |
 * 36436095 | Noleadsection                     |        1 | Lead_missing           |             3 |
 * 36482660 | In-line_citations                 |        1 | No_footnotes           |             8 |
 * 36559782 | Too_much_detail                   |        1 | Overly_detailed        |            22 |
 * 36652364 | BareURL                           |        1 | Cleanup-bare_URLs      |             2 |
 * 36841827 | Paraphrase                        |        1 | Close_paraphrasing     |             3 |
 * 36841834 | Paraphrasing                      |        1 | Close_paraphrasing     |             1 |
 * 36922529 | Disorganized                      |        1 | Cleanup-reorganize     |             1 |
 * 37085240 | Affiliated_with_the_subject       |        1 | Third-party            |             3 |
 * 37143893 | 3rdparty                          |        1 | Primary_sources        |             1 |
 * 37159100 | Wikilinks                         |        1 | Underlinked            |            13 |
 * 37322321 | Cleanup-layout                    |        1 | Cleanup-reorganize     |             4 |
 * 37322357 | Layout                            |        1 | Cleanup-reorganize     |            16 |
 * 37758197 | Bare                              |        1 | Cleanup-bare_URLs      |            10 |
 * 38193767 | Add_references                    |        1 | Refimprove             |             2 |
 * 38343696 | More_footnote                     |        1 | More_footnotes         |             1 |
 * 38682266 | Factual_accuracy                  |        1 | Disputed               |             3 |
 * 38769769 | Cleanup-link_rot                  |        1 | Cleanup-bare_URLs      |          1615 |
 * 38821953 | BLP_ref_improve                   |        1 | BLP_sources            |             3 |
 * 38864597 | Badsources                        |        1 | Unreliable_sources     |             4 |
 * 38875808 | Edited                            |        1 | In_use                 |             1 |
 * 38965553 | Addref                            |        1 | Refimprove             |             8 |
 * 39053436 | Add_links                         |        1 | Underlinked            |             1 |
 * 39086722 | UNREF                             |        1 | Unreferenced           |             2 |
 * 39108897 | Merge_with                        |        1 | Merge                  |             6 |
 * 39130569 | IC                                |        1 | No_footnotes           |             1 |
 * 39294242 | Clarity                           |        1 | Confusing              |             4 |
 * 39373433 | 1stpartysources                   |        1 | Primary_sources        |             1 |
 * 39775785 | Thirdpartysources                 |        1 | Primary_sources        |             1 |
 * 39896145 | Insufficient_inline_citations     |        1 | More_footnotes         |             3 |
 * 39962538 | Inconsistent_citation_style       |        1 | Citation_style         |             1 |
 * 40116740 | Onlyplot                          |        1 | All_plot               |             1 |

MariaDB [enwiki_p]> select page_id,page_title,page_is_redirect as redirect,count(tl_from) as num_transclusions from page inner join templatelinks on page_namespace=tl_namespace and page_title=tl_title where page_namespace=10 and (    -> page_title="Advert" or page_title="All_plot" or page_title="Autobiography" or page_title="BLP_sources" or page_title="BLP_unsourced" or page_title="Improve_categories" or page_title="Citation_style" or page_title="Cleanup" or page_title="Cleanup-reorganize" or page_title="Close_paraphrasing" or page_title="COI" or page_title="Condense" or page_title="Confusing" or page_title="Context" or page_title="Copy_edit" or page_title="Copypaste" or page_title="Dead_end" or page_title="Disputed" or page_title="Essay-like" or page_title="Expand_language" or page_title="Expert-subject" or page_title="External_links" or page_title="Fanpov" or page_title="Fiction" or page_title="Globalize" or page_title="GOCEinuse" or page_title="Hoax" or page_title="In-universe" or page_title="Incoherent" or page_title="In_use" or page_title="Lead_missing" or page_title="Lead_rewrite" or page_title="Lead_too_long" or page_title="Lead_too_short" or page_title="Cleanup-bare_URLs" or page_title="Merge" or page_title="Merge_from" or page_title="Merge_to" or page_title="Metricate" or page_title="More_footnotes" or page_title="New_unreviewed_article" or page_title="No_footnotes" or page_title="Non-free" or page_title="Notability" or page_title="Not_English" or page_title="One_source" or page_title="Original_research" or page_title="Orphan" or page_title="Over_coverage" or page_title="Overlinked" or page_title="Overly_detailed" or page_title="Peacock" or page_title="Plot" or page_title="POV" or page_title="Primary_sources" or page_title="Prose" or page_title="Recentism" or page_title="Refimprove" or page_title="Rough_translation" or page_title="Sections" or page_title="Self-published" or page_title="Technical" or page_title="Cleanup-tense" or page_title="Third-party" or page_title="Tone" or page_title="Too_few_opinions" or page_title="Uncategorized" or page_title="Under_construction" or page_title="Underlinked" or page_title="Undue" or page_title="Unreferenced" or page_title="Unreliable_sources" or page_title="Update" or page_title="Very_long" or page_title="Weasel" -> ) group by page_id; +--++--+---+ +--++--+---+ +--++--+---+ 75 rows in set (10.11 sec)
 * page_id | page_title             | redirect | num_transclusions |
 * 390292 | POV                   |        0 |              5060 |
 * 392667 | Disputed              |        0 |              1982 |
 * 406575 | In_use                |        0 |               181 |
 * 432053 | Not_English           |        0 |                20 |
 * 494140 | Merge                 |        0 |              2981 |
 * 879515 | Merge_from            |        0 |              2989 |
 * 1058071 | Rough_translation     |        0 |               347 |
 * 1058710 | Globalize             |        0 |              3928 |
 * 1331291 | Technical             |        0 |              2552 |
 * 1331311 | Confusing             |        0 |              2288 |
 * 1331312 | Context               |        0 |              3092 |
 * 1331314 | Tone                  |        0 |              7529 |
 * 1331316 | Copy_edit             |        0 |              3038 |
 * 1369846 | Uncategorized         |        0 |              1635 |
 * 1440745 | Unreferenced          |        0 |            253413 |
 * 1473393 | Fiction               |        0 |               158 |
 * 1514395 | Merge_to              |        0 |              5387 |
 * 1519723 | Original_research     |        0 |             11995 |
 * 1721338 | Update                |        0 |              9676 |
 * 2237743 | Advert                |        0 |             14643 |
 * 2425121 | Under_construction    |        0 |              1947 |
 * 2548980 | Citation_style        |        0 |              3934 |
 * 2623628 | Very_long             |        0 |               630 |
 * 2756747 | Primary_sources       |        0 |             31885 |
 * 2854894 | Weasel                |        0 |              1320 |
 * 3055860 | Hoax                  |        0 |               148 |
 * 3389303 | Notability            |        0 |             58858 |
 * 3528081 | Fanpov                |        0 |              1210 |
 * 3718027 | Lead_too_long         |        0 |               613 |
 * 3731791 | Sections              |        0 |              1013 |
 * 4686853 | Peacock               |        0 |              3313 |
 * 4825480 | Too_few_opinions      |        0 |               280 |
 * 4892724 | Self-published        |        0 |              1568 |
 * 5360026 | In-universe           |        0 |              3290 |
 * 5422388 | Autobiography         |        0 |              1265 |
 * 5490805 | External_links        |        0 |              3741 |
 * 5738992 | Expert-subject        |        0 |              5630 |
 * 5898428 | Plot                  |        0 |              4002 |
 * 5938138 | Essay-like            |        0 |              3476 |
 * 6497089 | Recentism             |        0 |               430 |
 * 6849556 | Incoherent            |        0 |               153 |
 * 6850189 | Metricate             |        0 |                 5 |
 * 7215892 | Cleanup               |        0 |             27452 |
 * 7256413 | Orphan                |        0 |            120521 |
 * 7403289 | One_source            |        0 |             14922 |
 * 7414240 | No_footnotes          |        0 |             46505 |
 * 7784304 | Copypaste             |        0 |               158 |
 * 8155088 | COI                   |        0 |              7677 |
 * 8220422 | Overlinked            |        0 |                15 |
 * 8393593 | Lead_too_short        |        0 |              6108 |
 * 8470528 | Lead_rewrite          |        0 |              1403 |
 * 9732523 | Prose                 |        0 |              2626 |
 * 10160967 | Refimprove            |        0 |            196560 |
 * 10203880 | Cleanup-tense         |        0 |               224 |
 * 11757089 | Dead_end              |        0 |               569 |
 * 11847582 | BLP_sources           |        0 |             64133 |
 * 11913883 | Unreliable_sources    |        0 |              2409 |
 * 12133240 | Lead_missing          |        0 |              2490 |
 * 12414176 | Non-free              |        0 |               125 |
 * 14697869 | More_footnotes        |        0 |             21871 |
 * 14880368 | Cleanup-bare_URLs     |        0 |              6221 |
 * 15451956 | Cleanup-reorganize    |        0 |              1577 |
 * 15617540 | Overly_detailed       |        0 |              1299 |
 * 16357290 | All_plot              |        0 |              1611 |
 * 16982684 | Over_coverage         |        0 |                86 |
 * 18599798 | GOCEinuse             |        0 |                15 |
 * 18893839 | Undue                 |        0 |               370 |
 * 20275223 | BLP_unsourced         |        0 |              2923 |
 * 20609168 | Condense              |        0 |               152 |
 * 21304932 | Close_paraphrasing    |        0 |                71 |
 * 21539593 | Expand_language       |        0 |             43218 |
 * 22176975 | Improve_categories    |        0 |              2205 |
 * 24388707 | New_unreviewed_article |       0 |               976 |
 * 30265545 | Third-party           |        0 |              1263 |
 * 37158580 | Underlinked           |        0 |             13243 |

MariaDB [enwiki_p]> Ctrl-C -- exit! Aborted