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;
+----------+------------------------------------+----------+------------------------+---------------+
| 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 |
+----------+------------------------------------+----------+------------------------+---------------+
479 rows in set (46 min 7.62 sec)
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;
+----------+------------------------+----------+-------------------+
| 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 |
+----------+------------------------+----------+-------------------+
75 rows in set (10.11 sec)
MariaDB [enwiki_p]> Ctrl-C -- exit!
Aborted