User:This, that and the other/Twinkle tag data/2013-07
Appearance
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