CINXE.COM

<!DOCTYPE html> <html class="client-nojs vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-enabled skin-theme-clientpref-day vector-sticky-header-enabled vector-toc-available" lang="en" dir="ltr"> <head> <meta charset="UTF-8"> <title>Template:Database report - Wikipedia</title> <script>(function(){var className="client-js vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-enabled skin-theme-clientpref-day vector-sticky-header-enabled vector-toc-available";var cookie=document.cookie.match(/(?:^|; )enwikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy", "wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"01596022-cfac-4e38-bc24-9cb3baa83b15","wgCanonicalNamespace":"Template","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":10,"wgPageName":"Template:Database_report","wgTitle":"Database report","wgCurRevisionId":1240499914,"wgRevisionId":1240499914,"wgArticleId":67594914,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["Wikipedia semi-protected templates","Lua-based templates","Wikipedia bot-related templates"],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Template:Database_report","wgRelevantArticleId":67594914,"wgIsProbablyEditable":false,"wgRelevantPageIsProbablyEditable":false,"wgRestrictionEdit":["autoconfirmed"],"wgRestrictionMove":[],"wgNoticeProject":"wikipedia","wgCiteReferencePreviewsActive":false, "wgFlaggedRevsParams":{"tags":{"status":{"levels":1}}},"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":true,"wgPopupsFlags":0,"wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":false,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":700,"wgEditSubmitButtonLabelPublish":true,"wgULSPosition":"interlanguage","wgULSisCompactLinksEnabled":false,"wgVector2022LanguageInHeader":true,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q131385405","wgCheckUserClientHintsHeadersJsApi":["brands","architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"],"GEHomepageSuggestedEditsEnableTopics":true,"wgGETopicsMatchModeEnabled":false,"wgGEStructuredTaskRejectionReasonTextInputEnabled":false,"wgGELevelingUpEnabledForUser":false};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready", "user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.pygments":"ready","skins.vector.search.codex.styles":"ready","skins.vector.styles":"ready","skins.vector.icons":"ready","jquery.tablesorter.styles":"ready","ext.wikimediamessages.styles":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","ext.uls.interlanguage":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["ext.pygments.view","site","mediawiki.page.ready","jquery.tablesorter","mediawiki.toc","skins.vector.js","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.gadget.ReferenceTooltips","ext.gadget.switcher","ext.urlShortener.toolbar","ext.centralauth.centralautologin","mmv.bootstrap","ext.popups","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.eventLogging","ext.wikimediaEvents","ext.navigationTiming","ext.uls.interface","ext.cx.eventlogging.campaigns", "wikibase.client.vector-2022","ext.checkUser.clientHints"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=en&modules=ext.pygments%2CwikimediaBadges%7Cext.uls.interlanguage%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediamessages.styles%7Cjquery.tablesorter.styles%7Cskins.vector.icons%2Cstyles%7Cskins.vector.search.codex.styles%7Cwikibase.client.init&only=styles&skin=vector-2022"> <script async="" src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector-2022"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector-2022"> <meta name="generator" content="MediaWiki 1.44.0-wmf.14"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <meta property="og:title" content="Template:Database report - Wikipedia"> <meta property="og:type" content="website"> <link rel="preconnect" href="//upload.wikimedia.org"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//en.m.wikipedia.org/wiki/Template:Database_report"> <link rel="apple-touch-icon" href="/static/apple-touch/wikipedia.png"> <link rel="icon" href="/static/favicon/wikipedia.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="Wikipedia (en)"> <link rel="EditURI" type="application/rsd+xml" href="//en.wikipedia.org/w/api.php?action=rsd"> <link rel="canonical" href="https://en.wikipedia.org/wiki/Template:Database_report"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en"> <link rel="alternate" type="application/atom+xml" title="Wikipedia Atom feed" href="/w/index.php?title=Special:RecentChanges&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="login.wikimedia.org"> </head> <body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-10 ns-subject page-Template_Database_report rootpage-Template_Database_report skin-vector-2022 action-view"><a class="mw-jump-link" href="#bodyContent">Jump to content</a> <div class="vector-header-container"> <header class="vector-header mw-header"> <div class="vector-header-start"> <nav class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-dropdown" class="vector-dropdown vector-main-menu-dropdown vector-button-flush-left vector-button-flush-right" title="Main menu" > <input type="checkbox" id="vector-main-menu-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-main-menu-dropdown" class="vector-dropdown-checkbox " aria-label="Main menu" > <label id="vector-main-menu-dropdown-label" for="vector-main-menu-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-menu mw-ui-icon-wikimedia-menu"></span> <span class="vector-dropdown-label-text">Main menu</span> </label> <div class="vector-dropdown-content"> <div id="vector-main-menu-unpinned-container" class="vector-unpinned-container"> <div id="vector-main-menu" class="vector-main-menu vector-pinnable-element"> <div class="vector-pinnable-header vector-main-menu-pinnable-header vector-pinnable-header-unpinned" data-feature-name="main-menu-pinned" data-pinnable-element-id="vector-main-menu" data-pinned-container-id="vector-main-menu-pinned-container" data-unpinned-container-id="vector-main-menu-unpinned-container" > <div class="vector-pinnable-header-label">Main menu</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-main-menu.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-main-menu.unpin">hide</button> </div> <div id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation" > <div class="vector-menu-heading"> Navigation </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage-description" class="mw-list-item"><a href="/wiki/Main_Page" title="Visit the main page [z]" accesskey="z"><span>Main page</span></a></li><li id="n-contents" class="mw-list-item"><a href="/wiki/Wikipedia:Contents" title="Guides to browsing Wikipedia"><span>Contents</span></a></li><li id="n-currentevents" class="mw-list-item"><a href="/wiki/Portal:Current_events" title="Articles related to current events"><span>Current events</span></a></li><li id="n-randompage" class="mw-list-item"><a href="/wiki/Special:Random" title="Visit a randomly selected article [x]" accesskey="x"><span>Random article</span></a></li><li id="n-aboutsite" class="mw-list-item"><a href="/wiki/Wikipedia:About" title="Learn about Wikipedia and how it works"><span>About Wikipedia</span></a></li><li id="n-contactpage" class="mw-list-item"><a href="//en.wikipedia.org/wiki/Wikipedia:Contact_us" title="How to contact Wikipedia"><span>Contact us</span></a></li> </ul> </div> </div> <div id="p-interaction" class="vector-menu mw-portlet mw-portlet-interaction" > <div class="vector-menu-heading"> Contribute </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-help" class="mw-list-item"><a href="/wiki/Help:Contents" title="Guidance on how to use and edit Wikipedia"><span>Help</span></a></li><li id="n-introduction" class="mw-list-item"><a href="/wiki/Help:Introduction" title="Learn how to edit Wikipedia"><span>Learn to edit</span></a></li><li id="n-portal" class="mw-list-item"><a href="/wiki/Wikipedia:Community_portal" title="The hub for editors"><span>Community portal</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Special:RecentChanges" title="A list of recent changes to Wikipedia [r]" accesskey="r"><span>Recent changes</span></a></li><li id="n-upload" class="mw-list-item"><a href="/wiki/Wikipedia:File_upload_wizard" title="Add images or other media for use on Wikipedia"><span>Upload file</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> <a href="/wiki/Main_Page" class="mw-logo"> <img class="mw-logo-icon" src="/static/images/icons/wikipedia.png" alt="" aria-hidden="true" height="50" width="50"> <span class="mw-logo-container skin-invert"> <img class="mw-logo-wordmark" alt="Wikipedia" src="/static/images/mobile/copyright/wikipedia-wordmark-en.svg" style="width: 7.5em; height: 1.125em;"> <img class="mw-logo-tagline" alt="The Free Encyclopedia" src="/static/images/mobile/copyright/wikipedia-tagline-en.svg" width="117" height="13" style="width: 7.3125em; height: 0.8125em;"> </span> </a> </div> <div class="vector-header-end"> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-collapses vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"> <a href="/wiki/Special:Search" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only search-toggle" title="Search Wikipedia [f]" accesskey="f"><span class="vector-icon mw-ui-icon-search mw-ui-icon-wikimedia-search"></span> <span>Search</span> </a> <div class="vector-typeahead-search-container"> <div class="cdx-typeahead-search cdx-typeahead-search--show-thumbnail cdx-typeahead-search--auto-expand-width"> <form action="/w/index.php" id="searchform" class="cdx-search-input cdx-search-input--has-end-button"> <div id="simpleSearch" class="cdx-search-input__input-wrapper" data-search-loc="header-moved"> <div class="cdx-text-input cdx-text-input--has-start-icon"> <input class="cdx-text-input__input" type="search" name="search" placeholder="Search Wikipedia" aria-label="Search Wikipedia" autocapitalize="sentences" title="Search Wikipedia [f]" accesskey="f" id="searchInput" > <span class="cdx-text-input__icon cdx-text-input__start-icon"></span> </div> <input type="hidden" name="title" value="Special:Search"> </div> <button class="cdx-button cdx-search-input__end-button">Search</button> </form> </div> </div> </div> <nav class="vector-user-links vector-user-links-wide" aria-label="Personal tools"> <div class="vector-user-links-main"> <div id="p-vector-user-menu-preferences" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-userpage" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-dropdown" class="vector-dropdown " title="Change the appearance of the page's font size, width, and color" > <input type="checkbox" id="vector-appearance-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-appearance-dropdown" class="vector-dropdown-checkbox " aria-label="Appearance" > <label id="vector-appearance-dropdown-label" for="vector-appearance-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-appearance mw-ui-icon-wikimedia-appearance"></span> <span class="vector-dropdown-label-text">Appearance</span> </label> <div class="vector-dropdown-content"> <div id="vector-appearance-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <div id="p-vector-user-menu-notifications" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-overflow" class="vector-menu mw-portlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=en.wikipedia.org&uselang=en" class=""><span>Donate</span></a> </li> <li id="pt-createaccount-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Special:CreateAccount&returnto=Template%3ADatabase+report" title="You are encouraged to create an account and log in; however, it is not mandatory" class=""><span>Create account</span></a> </li> <li id="pt-login-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Special:UserLogin&returnto=Template%3ADatabase+report" title="You're encouraged to log in; however, it's not mandatory. [o]" accesskey="o" class=""><span>Log in</span></a> </li> </ul> </div> </div> </div> <div id="vector-user-links-dropdown" class="vector-dropdown vector-user-menu vector-button-flush-right vector-user-menu-logged-out" title="Log in and more options" > <input type="checkbox" id="vector-user-links-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-user-links-dropdown" class="vector-dropdown-checkbox " aria-label="Personal tools" > <label id="vector-user-links-dropdown-label" for="vector-user-links-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-ellipsis mw-ui-icon-wikimedia-ellipsis"></span> <span class="vector-dropdown-label-text">Personal tools</span> </label> <div class="vector-dropdown-content"> <div id="p-personal" class="vector-menu mw-portlet mw-portlet-personal user-links-collapsible-item" title="User menu" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport" class="user-links-collapsible-item mw-list-item"><a href="https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=en.wikipedia.org&uselang=en"><span>Donate</span></a></li><li id="pt-createaccount" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Special:CreateAccount&returnto=Template%3ADatabase+report" title="You are encouraged to create an account and log in; however, it is not mandatory"><span class="vector-icon mw-ui-icon-userAdd mw-ui-icon-wikimedia-userAdd"></span> <span>Create account</span></a></li><li id="pt-login" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Special:UserLogin&returnto=Template%3ADatabase+report" title="You're encouraged to log in; however, it's not mandatory. [o]" accesskey="o"><span class="vector-icon mw-ui-icon-logIn mw-ui-icon-wikimedia-logIn"></span> <span>Log in</span></a></li> </ul> </div> </div> <div id="p-user-menu-anon-editor" class="vector-menu mw-portlet mw-portlet-user-menu-anon-editor" > <div class="vector-menu-heading"> Pages for logged out editors <a href="/wiki/Help:Introduction" aria-label="Learn more about editing"><span>learn more</span></a> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Special:MyContributions" title="A list of edits made from this IP address [y]" accesskey="y"><span>Contributions</span></a></li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Special:MyTalk" title="Discussion about edits from this IP address [n]" accesskey="n"><span>Talk</span></a></li> </ul> </div> </div> </div> </div> </nav> </div> </header> </div> <div class="mw-page-container"> <div class="mw-page-container-inner"> <div class="vector-sitenotice-container"> <div id="siteNotice"></div> </div> <div class="vector-column-start"> <div class="vector-main-menu-container"> <div id="mw-navigation"> <nav id="mw-panel" class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-pinned-container" class="vector-pinned-container"> </div> </nav> </div> </div> <div class="vector-sticky-pinned-container"> <nav id="mw-panel-toc" aria-label="Contents" data-event-name="ui.sidebar-toc" class="mw-table-of-contents-container vector-toc-landmark"> <div id="vector-toc-pinned-container" class="vector-pinned-container"> <div id="vector-toc" class="vector-toc vector-pinnable-element"> <div class="vector-pinnable-header vector-toc-pinnable-header vector-pinnable-header-pinned" data-feature-name="toc-pinned" data-pinnable-element-id="vector-toc" > <h2 class="vector-pinnable-header-label">Contents</h2> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-toc.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-toc.unpin">hide</button> </div> <ul class="vector-toc-contents" id="mw-panel-toc-list"> <li id="toc-mw-content-text" class="vector-toc-list-item vector-toc-level-1"> <a href="#" class="vector-toc-link"> <div class="vector-toc-text">(Top)</div> </a> </li> <li id="toc-Example" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Example"> <div class="vector-toc-text"> <span class="vector-toc-numb">1</span> <span>Example</span> </div> </a> <ul id="toc-Example-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Parameters" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Parameters"> <div class="vector-toc-text"> <span class="vector-toc-numb">2</span> <span>Parameters</span> </div> </a> <button aria-controls="toc-Parameters-sublist" class="cdx-button cdx-button--weight-quiet cdx-button--icon-only vector-toc-toggle"> <span class="vector-icon mw-ui-icon-wikimedia-expand"></span> <span>Toggle Parameters subsection</span> </button> <ul id="toc-Parameters-sublist" class="vector-toc-list"> <li id="toc-sql" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#sql"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.1</span> <span>sql</span> </div> </a> <ul id="toc-sql-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-wikilinks" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#wikilinks"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.2</span> <span>wikilinks</span> </div> </a> <ul id="toc-wikilinks-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-comments" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#comments"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.3</span> <span>comments</span> </div> </a> <ul id="toc-comments-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-widths" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#widths"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.4</span> <span>widths</span> </div> </a> <ul id="toc-widths-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-table_style" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#table_style"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.5</span> <span>table_style</span> </div> </a> <ul id="toc-table_style-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-table_class" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#table_class"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.6</span> <span>table_class</span> </div> </a> <ul id="toc-table_class-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-excerpts" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#excerpts"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.7</span> <span>excerpts</span> </div> </a> <ul id="toc-excerpts-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-remove_underscores" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#remove_underscores"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.8</span> <span>remove_underscores</span> </div> </a> <ul id="toc-remove_underscores-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-interval" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#interval"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.9</span> <span>interval</span> </div> </a> <ul id="toc-interval-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-pagination" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#pagination"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.10</span> <span>pagination</span> </div> </a> <ul id="toc-pagination-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-max_pages" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#max_pages"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.11</span> <span>max_pages</span> </div> </a> <ul id="toc-max_pages-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-hide" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#hide"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.12</span> <span>hide</span> </div> </a> <ul id="toc-hide-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-row_template" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#row_template"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.13</span> <span>row_template</span> </div> </a> <ul id="toc-row_template-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-row_template_named_params" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#row_template_named_params"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.14</span> <span>row_template_named_params</span> </div> </a> <ul id="toc-row_template_named_params-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-skip_table" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#skip_table"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.15</span> <span>skip_table</span> </div> </a> <ul id="toc-skip_table-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-header_template" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#header_template"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.16</span> <span>header_template</span> </div> </a> <ul id="toc-header_template-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-footer_template" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#footer_template"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.17</span> <span>footer_template</span> </div> </a> <ul id="toc-footer_template-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-postprocess_js" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#postprocess_js"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.18</span> <span>postprocess_js</span> </div> </a> <ul id="toc-postprocess_js-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-silent" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#silent"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.19</span> <span>silent</span> </div> </a> <ul id="toc-silent-sublist" class="vector-toc-list"> </ul> </li> </ul> </li> <li id="toc-SQL_formatting_tips" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#SQL_formatting_tips"> <div class="vector-toc-text"> <span class="vector-toc-numb">3</span> <span>SQL formatting tips</span> </div> </a> <ul id="toc-SQL_formatting_tips-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Advanced_styling" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Advanced_styling"> <div class="vector-toc-text"> <span class="vector-toc-numb">4</span> <span>Advanced styling</span> </div> </a> <ul id="toc-Advanced_styling-sublist" class="vector-toc-list"> </ul> </li> </ul> </div> </div> </nav> </div> </div> <div class="mw-content-container"> <main id="content" class="mw-body"> <header class="mw-body-header vector-page-titlebar"> <nav aria-label="Contents" class="vector-toc-landmark"> <div id="vector-page-titlebar-toc" class="vector-dropdown vector-page-titlebar-toc vector-button-flush-left" title="Table of Contents" > <input type="checkbox" id="vector-page-titlebar-toc-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-titlebar-toc" class="vector-dropdown-checkbox " aria-label="Toggle the table of contents" > <label id="vector-page-titlebar-toc-label" for="vector-page-titlebar-toc-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-listBullet mw-ui-icon-wikimedia-listBullet"></span> <span class="vector-dropdown-label-text">Toggle the table of contents</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-titlebar-toc-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-namespace">Template</span><span class="mw-page-title-separator">:</span><span class="mw-page-title-main">Database report</span></h1> <div id="p-lang-btn" class="vector-dropdown mw-portlet mw-portlet-lang" > <input type="checkbox" id="p-lang-btn-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-lang-btn" class="vector-dropdown-checkbox mw-interlanguage-selector" aria-label="Go to an article in another language. Available in 1 language" > <label id="p-lang-btn-label" for="p-lang-btn-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--action-progressive mw-portlet-lang-heading-1" aria-hidden="true" ><span class="vector-icon mw-ui-icon-language-progressive mw-ui-icon-wikimedia-language-progressive"></span> <span class="vector-dropdown-label-text">1 language</span> </label> <div class="vector-dropdown-content"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="interlanguage-link interwiki-bn mw-list-item"><a href="https://bn.wikipedia.org/wiki/%E0%A6%9F%E0%A7%87%E0%A6%AE%E0%A6%AA%E0%A7%8D%E0%A6%B2%E0%A7%87%E0%A6%9F:Database_report" title="টেমপ্লেট:Database report – Bangla" lang="bn" hreflang="bn" data-title="টেমপ্লেট:Database report" data-language-autonym="বাংলা" data-language-local-name="Bangla" class="interlanguage-link-target"><span>বাংলা</span></a></li> </ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-edit wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q131385405#sitelinks-wikipedia" title="Edit interlanguage links" class="wbc-editpage">Edit links</a></span></div> </div> </div> </div> </header> <div class="vector-page-toolbar"> <div class="vector-page-toolbar-container"> <div id="left-navigation"> <nav aria-label="Namespaces"> <div id="p-associated-pages" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-associated-pages" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-template" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Template:Database_report" title="View the template [c]" accesskey="c"><span>Template</span></a></li><li id="ca-talk" class="vector-tab-noicon mw-list-item"><a href="/wiki/Template_talk:Database_report" rel="discussion" title="Discuss improvements to the content page [t]" accesskey="t"><span>Talk</span></a></li> </ul> </div> </div> <div id="vector-variants-dropdown" class="vector-dropdown emptyPortlet" > <input type="checkbox" id="vector-variants-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-variants-dropdown" class="vector-dropdown-checkbox " aria-label="Change language variant" > <label id="vector-variants-dropdown-label" for="vector-variants-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">English</span> </label> <div class="vector-dropdown-content"> <div id="p-variants" class="vector-menu mw-portlet mw-portlet-variants emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> </div> </div> </nav> </div> <div id="right-navigation" class="vector-collapsible"> <nav aria-label="Views"> <div id="p-views" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-views" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Template:Database_report"><span>Read</span></a></li><li id="ca-viewsource" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Template:Database_report&action=edit" title="This page is protected.
You can view its source [e]" accesskey="e"><span>View source</span></a></li><li id="ca-history" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Template:Database_report&action=history" title="Past revisions of this page [h]" accesskey="h"><span>View history</span></a></li> </ul> </div> </div> </nav> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-dropdown" class="vector-dropdown vector-page-tools-dropdown" > <input type="checkbox" id="vector-page-tools-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-tools-dropdown" class="vector-dropdown-checkbox " aria-label="Tools" > <label id="vector-page-tools-dropdown-label" for="vector-page-tools-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">Tools</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-tools-unpinned-container" class="vector-unpinned-container"> <div id="vector-page-tools" class="vector-page-tools vector-pinnable-element"> <div class="vector-pinnable-header vector-page-tools-pinnable-header vector-pinnable-header-unpinned" data-feature-name="page-tools-pinned" data-pinnable-element-id="vector-page-tools" data-pinned-container-id="vector-page-tools-pinned-container" data-unpinned-container-id="vector-page-tools-unpinned-container" > <div class="vector-pinnable-header-label">Tools</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-page-tools.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-page-tools.unpin">hide</button> </div> <div id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-has-collapsible-items" title="More options" > <div class="vector-menu-heading"> Actions </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-more-view" class="selected vector-more-collapsible-item mw-list-item"><a href="/wiki/Template:Database_report"><span>Read</span></a></li><li id="ca-more-viewsource" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Template:Database_report&action=edit"><span>View source</span></a></li><li id="ca-more-history" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Template:Database_report&action=history"><span>View history</span></a></li> </ul> </div> </div> <div id="p-tb" class="vector-menu mw-portlet mw-portlet-tb" > <div class="vector-menu-heading"> General </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Special:WhatLinksHere/Template:Database_report" title="List of all English Wikipedia pages containing links to this page [j]" accesskey="j"><span>What links here</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Special:RecentChangesLinked/Template:Database_report" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></a></li><li id="t-upload" class="mw-list-item"><a href="//en.wikipedia.org/wiki/Wikipedia:File_Upload_Wizard" title="Upload files [u]" accesskey="u"><span>Upload file</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Special:SpecialPages" title="A list of all special pages [q]" accesskey="q"><span>Special pages</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Template:Database_report&oldid=1240499914" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Template:Database_report&action=info" title="More information about this page"><span>Page information</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Special:UrlShortener&url=https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FTemplate%3ADatabase_report"><span>Get shortened URL</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Special:QrCode&url=https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FTemplate%3ADatabase_report"><span>Download QR code</span></a></li> </ul> </div> </div> <div id="p-electronpdfservice-sidebar-portlet-heading" class="vector-menu mw-portlet mw-portlet-electronpdfservice-sidebar-portlet-heading" > <div class="vector-menu-heading"> Print/export </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="electron-print_pdf" class="mw-list-item"><a href="/w/index.php?title=Special:DownloadAsPdf&page=Template%3ADatabase_report&action=show-download-screen"><span>Download as PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="javascript:print();" rel="alternate" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></a></li> </ul> </div> </div> <div id="p-wikibase-otherprojects" class="vector-menu mw-portlet mw-portlet-wikibase-otherprojects" > <div class="vector-menu-heading"> In other projects </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q131385405" title="Structured data on this page hosted by Wikidata [g]" accesskey="g"><span>Wikidata item</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> </div> </div> </div> <div class="vector-column-end"> <div class="vector-sticky-pinned-container"> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-pinned-container" class="vector-pinned-container"> </div> </nav> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-pinned-container" class="vector-pinned-container"> <div id="vector-appearance" class="vector-appearance vector-pinnable-element"> <div class="vector-pinnable-header vector-appearance-pinnable-header vector-pinnable-header-pinned" data-feature-name="appearance-pinned" data-pinnable-element-id="vector-appearance" data-pinned-container-id="vector-appearance-pinned-container" data-unpinned-container-id="vector-appearance-unpinned-container" > <div class="vector-pinnable-header-label">Appearance</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-appearance.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-appearance.unpin">hide</button> </div> </div> </div> </nav> </div> </div> <div id="bodyContent" class="vector-body" aria-labelledby="firstHeading" data-mw-ve-target-container> <div class="vector-body-before-content"> <div class="mw-indicators"> <div id="mw-indicator-pp-default" class="mw-indicator"><div class="mw-parser-output"><span typeof="mw:File"><a href="/wiki/Wikipedia:Protection_policy#semi" title="This high-risk template is permanently semi-protected to prevent vandalism"><img alt="Permanently protected template" src="//upload.wikimedia.org/wikipedia/en/thumb/1/1b/Semi-protection-shackle.svg/20px-Semi-protection-shackle.svg.png" decoding="async" width="20" height="20" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/en/thumb/1/1b/Semi-protection-shackle.svg/30px-Semi-protection-shackle.svg.png 1.5x, //upload.wikimedia.org/wikipedia/en/thumb/1/1b/Semi-protection-shackle.svg/40px-Semi-protection-shackle.svg.png 2x" data-file-width="512" data-file-height="512" /></a></span></div></div> </div> <div id="siteSub" class="noprint">From Wikipedia, the free encyclopedia</div> </div> <div id="contentSub"><div id="mw-content-subtitle"></div></div> <div id="mw-content-text" class="mw-body-content"><div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr"><div style="float: right; padding-left: 15px;" class="extendedconfirmed-show sysop-show"> <p><a class="external text" href="https://sdzerobot.toolforge.org/database-report?page=Template:Database_report">Update the table now</a> </p> </div> <div style="margin-bottom: 5px; border-bottom: 3px solid #2F74D0; padding-right: 10px;"> <p>This table is generated by querying the <a href="https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database" class="extiw" title="wikitech:Help:Toolforge/Database">database replica</a> by <a href="/wiki/User:SDZeroBot" title="User:SDZeroBot">a bot</a>.<br /> <mark>Edits made within the table area will be removed on the next update!</mark> </p> </div> <style data-mw-deduplicate="TemplateStyles:r1237875617">.mw-parser-output .documentation,.mw-parser-output .documentation-metadata{border:1px solid #a2a9b1;background-color:#ecfcf4;clear:both}.mw-parser-output .documentation{margin:1em 0 0 0;padding:1em}.mw-parser-output .documentation-metadata{margin:0.2em 0;font-style:italic;padding:0.4em 1em}.mw-parser-output .documentation-startbox{padding-bottom:3px;border-bottom:1px solid #aaa;margin-bottom:1ex}.mw-parser-output .documentation-heading{font-weight:bold;font-size:125%}.mw-parser-output .documentation-clear{clear:both}.mw-parser-output .documentation-toolbar{font-style:normal;font-size:85%}@media screen{html.skin-theme-clientpref-night .mw-parser-output .documentation,html.skin-theme-clientpref-night .mw-parser-output .documentation-metadata{background-color:#0b1e1c}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .documentation,html.skin-theme-clientpref-os .mw-parser-output .documentation-metadata{background-color:#0b1e1c}}</style><div class="documentation-container" role="complementary" aria-labelledby="documentation-heading"> <div class="documentation"> <div class="documentation-startbox"> <span class="documentation-heading" id="documentation-heading"><span typeof="mw:File"><span><img alt="" src="//upload.wikimedia.org/wikipedia/commons/thumb/4/43/Test_Template_Info-Icon_-_Version_%282%29.svg/50px-Test_Template_Info-Icon_-_Version_%282%29.svg.png" decoding="async" width="50" height="22" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/4/43/Test_Template_Info-Icon_-_Version_%282%29.svg/75px-Test_Template_Info-Icon_-_Version_%282%29.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/4/43/Test_Template_Info-Icon_-_Version_%282%29.svg/100px-Test_Template_Info-Icon_-_Version_%282%29.svg.png 2x" data-file-width="1792" data-file-height="800" /></span></span> Template documentation</span><span class="mw-editsection-like plainlinks">[<a href="/wiki/Template:Database_report/doc" title="Template:Database report/doc">view</a>] [<a href="/wiki/Special:EditPage/Template:Database_report/doc" title="Special:EditPage/Template:Database report/doc">edit</a>] [<a href="/wiki/Special:PageHistory/Template:Database_report/doc" title="Special:PageHistory/Template:Database report/doc">history</a>] [<a href="/wiki/Special:Purge/Template:Database_report" title="Special:Purge/Template:Database report">purge</a>]</span></div> <style data-mw-deduplicate="TemplateStyles:r1238436933">.mw-parser-output .ombox{margin:4px 0;border-collapse:collapse;border:1px solid #a2a9b1;background-color:var(--background-color-neutral-subtle,#f8f9fa);box-sizing:border-box;color:var(--color-base,#202122)}.mw-parser-output .ombox.mbox-small{font-size:88%;line-height:1.25em}.mw-parser-output .ombox-speedy{border:2px solid #b32424;background-color:#fee7e6}.mw-parser-output .ombox-delete{border:2px solid #b32424}.mw-parser-output .ombox-content{border:1px solid #f28500}.mw-parser-output .ombox-style{border:1px solid #fc3}.mw-parser-output .ombox-move{border:1px solid #9932cc}.mw-parser-output .ombox-protection{border:2px solid #a2a9b1}.mw-parser-output .ombox .mbox-text{border:none;padding:0.25em 0.9em;width:100%}.mw-parser-output .ombox .mbox-image{border:none;padding:2px 0 2px 0.9em;text-align:center}.mw-parser-output .ombox .mbox-imageright{border:none;padding:2px 0.9em 2px 0;text-align:center}.mw-parser-output .ombox .mbox-empty-cell{border:none;padding:0;width:1px}.mw-parser-output .ombox .mbox-invalid-type{text-align:center}@media(min-width:720px){.mw-parser-output .ombox{margin:4px 10%}.mw-parser-output .ombox.mbox-small{clear:right;float:right;margin:4px 0 4px 1em;width:238px}}body.skin--responsive .mw-parser-output table.ombox img{max-width:none!important}@media screen{html.skin-theme-clientpref-night .mw-parser-output .ombox-speedy{background-color:#310402}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .ombox-speedy{background-color:#310402}}</style><table class="plainlinks ombox mbox-small ombox-notice" role="presentation"><tbody><tr><td class="mbox-image"><span typeof="mw:File"><span><img alt="" src="//upload.wikimedia.org/wikipedia/commons/thumb/c/cf/Lua-Logo.svg/30px-Lua-Logo.svg.png" decoding="async" width="30" height="30" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/c/cf/Lua-Logo.svg/45px-Lua-Logo.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/c/cf/Lua-Logo.svg/60px-Lua-Logo.svg.png 2x" data-file-width="947" data-file-height="947" /></span></span></td><td class="mbox-text">This template uses <a href="/wiki/Wikipedia:Lua" title="Wikipedia:Lua">Lua</a>: <div><ul><li><a href="/wiki/Module:Database_report" title="Module:Database report">Module:Database report</a></li></ul></div></td></tr></tbody></table> <p>This template summons a bot to update the page with the results of the provided database query. It must be "closed" with <span class="nowrap">{{</span><a href="/wiki/Template:Database_report_end" title="Template:Database report end">Database report end</a><span class="nowrap">}}</span>; the text between these two templates will be replaced by the bot-generated table. It is possible to have multiple reports in one page. </p><p>The table is updated by the bot whenever you click the "Update the table now" button, and can be configured to automatically update <a href="#interval">periodically</a> by setting <code class="tpl-para" style="word-break:break-word;">|interval=<i>N</i></code> (one update every N days). </p><p>Some formatting options are provided which enable page titles to be wikilinked and article excerpts to be shown. For complex use cases, the <a href="#row_template">row_template</a> or <a href="#postprocess_js">postprocess_js</a> options can be used which allow you to format the query output in arbitrary ways using wikimarkup, Lua or JavaScript. </p><p>This template is currently powered by <a href="/wiki/User:SDZeroBot" title="User:SDZeroBot">SDZeroBot</a> (<a rel="nofollow" class="external text" href="https://github.com/siddharthvp/SDZeroBot/tree/master/db-tabulator">source code</a>). It populates <a href="/wiki/Category:SDZeroBot_database_report_subscriptions" title="Category:SDZeroBot database report subscriptions">Category:SDZeroBot database report subscriptions</a>. </p> <hr /> <p>Don't know SQL? No worries. SDZeroBot's <a class="external text" href="https://sdzerobot.toolforge.org/autosql">AutoSQL</a> will help you get the SQL equivalent of a query written in plain English. It doesn't work all the time, sadly – in which case you can ask for help at <a href="/wiki/Wikipedia:RAQ" class="mw-redirect" title="Wikipedia:RAQ">WP:RAQ</a>. </p> <meta property="mw:PageProp/toc" /> <div class="mw-heading mw-heading3"><h3 id="Example">Example</h3></div> <pre><span class="nowrap">{{Database report<br />|<b>sql</b>         = <br />    <span style="padding-left:1.0em;"> </span><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">SELECT</span><span class="w"> </span><span class="n">page_title</span><span class="p">,</span><span class="w"> </span><span class="n">rev_timestamp</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="ss">"Last revid"</span><span class="p">,</span><span class="w"> </span><span class="n">page_latest</span><span class="p">,</span><span class="w"> </span><span class="n">page_len</span><span class="p">,</span><span class="w"> </span><span class="n">actor_name</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">Creator</span><span class="p">,</span><span class="w"> </span><span class="n">user_editcount</span></code><br />    <span style="padding-left:1.0em;"> </span><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">FROM</span><span class="w"> </span><span class="n">pagetriage_page</span></code><br />    <span style="padding-left:1.0em;"> </span><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">JOIN</span><span class="w"> </span><span class="n">page</span><span class="w"> </span><span class="k">on</span><span class="w"> </span><span class="n">page_id</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="n">ptrp_page_id</span></code><br />    <span style="padding-left:1.0em;"> </span><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">JOIN</span><span class="w"> </span><span class="n">revision</span><span class="w"> </span><span class="k">ON</span><span class="w"> </span><span class="n">page_id</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="n">rev_page</span><span class="w"> </span><span class="k">AND</span><span class="w"> </span><span class="n">rev_parent_id</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">0</span></code><br />    <span style="padding-left:1.0em;"> </span><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">JOIN</span><span class="w"> </span><span class="n">actor</span><span class="w"> </span><span class="k">ON</span><span class="w"> </span><span class="n">rev_actor</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="n">actor_id</span></code><br />    <span style="padding-left:1.0em;"> </span><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">LEFT</span><span class="w"> </span><span class="k">JOIN</span><span class="w"> </span><span class="k">user</span><span class="w"> </span><span class="k">ON</span><span class="w"> </span><span class="n">user_id</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="n">actor_user</span></code><br />    <span style="padding-left:1.0em;"> </span><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">WHERE</span><span class="w"> </span><span class="n">page_namespace</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">0</span></code><br />    <span style="padding-left:1.0em;"> </span><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">AND</span><span class="w"> </span><span class="n">page_is_redirect</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">0</span></code><br />    <span style="padding-left:1.0em;"> </span><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">AND</span><span class="w"> </span><span class="n">ptrp_reviewed</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">0</span></code><br />|<b>wikilinks</b>   = 1, 5:2 <br />|<b>excerpts</b>    = <br />|<b>comments</b>    = <br />|<b>widths</b>      = 2:9em, 3:15em <br />|<b>interval</b>    = 7 <br />|<b>table_style</b> = <br />|<b>pagination</b>  = <br />|<b>max_pages</b>   = <br />}}</span> <i>... (This will be overwritten by the bot) ...</i> <span class="nowrap">{{Database report end}}</span> </pre> <div class="mw-heading mw-heading3"><h3 id="Parameters">Parameters</h3></div> <div class="mw-heading mw-heading4"><h4 id="sql">sql</h4></div> <dl><dd>The SQL query used to generate the report. Consider using <a rel="nofollow" class="external text" href="https://quarry.wmflabs.org/">Quarry</a> to test your SQL first. For queries with large outputs, consider using a <code>LIMIT</code> clause to limit the output size, or use <a href="#pagination">pagination</a>. <b>IMPORTANT</b>: The query must execute within 10 minutes. The bot uses a server-side timeout – MariaDB's <a rel="nofollow" class="external text" href="https://mariadb.com/kb/en/aborting-statements/">max_statement_time</a> variable to prevent overload on the DB. This should only contain 1 SQL statement. Do not combine multiple statements with semicolons.</dd> <dd>If the SQL needs to contain vertical pipes (|) or other characters that may get parsed as wikitext (like <code class="mw-highlight mw-highlight-lang-wikitext mw-content-ltr" dir="ltr"><span class="p">{{</span></code> and <code class="mw-highlight mw-highlight-lang-wikitext mw-content-ltr" dir="ltr">}}</code>), wrap the SQL with <code class="nowrap" style=""><nowiki>...</nowiki></code>.</dd> <dd><b>This is the only required parameter.</b></dd></dl> <p>Database table references: <a href="https://www.mediawiki.org/wiki/Manual:Page_table" class="extiw" title="mw:Manual:Page table">page</a> · <a href="https://www.mediawiki.org/wiki/Manual:revision_table" class="extiw" title="mw:Manual:revision table">revision</a> · <a href="https://www.mediawiki.org/wiki/Manual:text_table" class="extiw" title="mw:Manual:text table">text</a> · <a href="https://www.mediawiki.org/wiki/Manual:actor_table" class="extiw" title="mw:Manual:actor table">actor</a> · <a href="https://www.mediawiki.org/wiki/Manual:user_table" class="extiw" title="mw:Manual:user table">user</a> · <a href="https://www.mediawiki.org/wiki/Manual:Database_layout" class="extiw" title="mw:Manual:Database layout">main database layout manual page</a> </p> <div class="mw-heading mw-heading4"><h4 id="wikilinks">wikilinks</h4></div> <dl><dd>Wikilink page titles. The syntax is best explained with some examples:</dd></dl> <ul><li><code>wikilinks = <b>4</b></code> Links titles in the 4th column. Use this style if the column contains the full page name.</li> <li><code>wikilinks = <b>4:2</b></code> Links titles in 4th column to user (ns:2) namespace. Use this style if the column contains the page name without namespace. <ul><li>See <a href="/wiki/Template:Namespaces" title="Template:Namespaces">Template:Namespaces</a> for namespace numbers. Common ones are: 0 (article), 2 (user), 4 (Wikipedia), 6 (file), 10 (template), 14 (category), 118 (draft). For respective talk namespaces, add 1 to those numbers.</li></ul></li> <li><code>wikilinks = <b>5:2:show</b></code> Links titles in 4th column to user (ns:2) namespace, and additionally adds the namespace prefix to the displayed text.</li> <li><code>wikilinks = <b>4:c3</b></code> Links the titles in 4th column using namespace number given in the third column. Applicable for queries like <code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">SELECT</span><span class="w"> </span><span class="n">page_namespace</span><span class="p">,</span><span class="w"> </span><span class="n">page_title</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="p">...</span></code> that have both page title and namespace but in different columns.</li> <li><code>wikilinks = <b>4:c3:show</b></code> Same as above, but additionally put the namespace prefix in the displayed text.</li> <li><code>wikilinks = <b>2:2:show, 3:0</b></code> Links multiple columns! The configuration of each column (using one of the above styles) is comma-separated.</li> <li><code>wikilinks = <b>1:0, 2:2:show, 3:4</b></code> Adds links to three different columns: 1st column to mainspace, 2nd column to userspace making the "User:" prefix visible, and titles in 3rd column to WP space (with the namespace prefix piped).</li></ul> <div class="mw-heading mw-heading4"><h4 id="comments">comments</h4></div> <dl><dd>Comma-separated list of column numbers that contain edit summary comments or log action comments. Specifying this makes the bot escape the text so that edit summaries like "<i>added {{infobox person}}</i>" or "<i>removed [[File:Example.jpg]]</i>" are properly displayed without the template being transluded or images showing up on the report page.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="widths">widths</h4></div> <dl><dd>Explicitly specify the column widths. Eg. <code>widths = <b>2:10em, 4:20px</b></code> forces the 2nd column to have a width of 10em and the 4th column to get a width of 20px.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="table_style">table_style</h4></div> <dl><dd>The style attribute applied to the table element. By default this is <code>overflow-wrap: anywhere</code> which causes better overflow behaviour. To suppress the default, use <code>overflow-wrap: normal</code>.</dd> <dd><style data-mw-deduplicate="TemplateStyles:r1236090951">.mw-parser-output .hatnote{font-style:italic}.mw-parser-output div.hatnote{padding-left:1.6em;margin-bottom:0.5em}.mw-parser-output .hatnote i{font-style:normal}.mw-parser-output .hatnote+link+.hatnote{margin-top:-0.5em}@media print{body.ns-0 .mw-parser-output .hatnote{display:none!important}}</style><div role="note" class="hatnote navigation-not-searchable">Further information: <a href="#Advanced_styling">§ Advanced styling</a></div></dd></dl> <div class="mw-heading mw-heading4"><h4 id="table_class">table_class</h4></div> <dl><dd>The class attribute applied to the table element. By default, this is <code>wikitable sortable</code>.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="excerpts">excerpts</h4></div> <dl><dd>Show an excerpt of articles. Excerpt config takes the form:</dd></dl> <p><span style="padding-left:1.0em;"> </span><span style="padding-left:1.0em;"> </span>srcColumnNumber <span style="font-size:120%"><b>:</b></span> destColumnNumber <span style="font-size:120%"><b>:</b></span> namespace <span style="font-size:120%"><b>:</b></span> charLimit <span style="font-size:120%"><b>:</b></span> charHardLimit </p> <ul><li>Apart from srcColumnNumber everything is optional. However, optional parameters can only be used if the ones before were used, that is: to mention namespace, you also need to mention destColumnNumber first. <ul><li><b>srcColumnNumber</b>: <i>(required)</i> The column number containing page names whose excerpts are to be shown</li> <li><b>destColumnNumber</b>: The column number in which to place the excerpt. The original contents of that column will be shifted rightwards. If unspecified this takes the value (srcColumnNumber + 1)</li> <li><b>namespace</b>: The namespace number to use for page names in srcColumnNumber. If unspecified, it's taken as 0 – which means that the page name in srcColumnNumber is treated as the full page name (appropriate for mainspace). Use <code>c4</code> to get the namespace number from 4th column. This can be used as input to <span class="nowrap">{{</span><a href="/wiki/Template:Namespace_name" title="Template:Namespace name">Namespace name</a><span class="nowrap">}}</span>, to return the actual name: <code>"{{Namespace name|1}}:"</code> will return "Talk:" and <code>"{{Namespace name|10}}:"</code> will return "Template:".</li> <li><b>charLimit</b>: A soft limit for size of excerpt by number of characters. This is a soft limit, the excerpt can be longer to avoid cutting mid-sentence. (Default: 250)</li> <li><b>charHardLimit</b>: A hard char limit for size of excerpt. Sentences may be cut in the middle (but in that case will end in ellipsis). (Default: 500)</li></ul></li> <li>Most of the time, excerpt columns will mangle the layout of the table. Always use the <a href="#widths">widths</a> parameter to tune the column widths.</li> <li>Since excerpts add columns to the table, note that the column numbers used by all other parameters (<a href="#widths">widths</a>, <a href="#wikilinks">wikilinks</a>, <a href="#comments">comments</a>, <a href="#remove_underscores">remove_underscores</a>) take into account the added columns.</li> <li>Excerpts are only intended for articles and drafts. The Node.js code used for generating them is <a rel="nofollow" class="external text" href="https://github.com/siddharthvp/SDZeroBot/tree/master/TextExtractor.ts">here</a> – only the initial few lines of the first paragraph are kept with references, markup, images, infoboxes etc are removed.</li> <li>Excerpts for multiple columns are supported – in which case this parameter should be comma-separated list of excerpt configs.</li></ul> <div class="mw-heading mw-heading4"><h4 id="remove_underscores">remove_underscores</h4></div> <dl><dd>A comma-separated list of column numbers in which underscores are to be replaced with spaces. This is intended for columns containing page titles, since the database stores titles with underscores (_) in place of spaces. You can prettify it a bit by using this parameter. This is automatically done for columns with <a href="#wikilinks">wikilinks</a> or <a href="#excerpts">excerpts</a>.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="interval">interval</h4></div> <dl><dd>(No default) Numerical value. Number of days to wait between automatic updates. Minimum allowed value: 1. If unspecified, no periodic updates are done.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="pagination">pagination</h4></div> <dl><dd>(No default) Number of results to include in a page. Further results are saved to paginated subpages. For example, if <code class="tpl-para" style="word-break:break-word;">|pagination=1000</code> is set and there are 4200 results, 1–1000 are saved to the page containing the query. 1001–2000 are saved to the <code>/2</code> subpage, and so on. If unspecified, all results are saved on a single page. See also <a href="#max_pages">max_pages</a>.</dd> <dd>Note: Pagination cannot used when there are multiple reports on a page.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="max_pages">max_pages</h4></div> <dl><dd>(Default: 5). For use with <a href="#pagination">pagination</a> only. Max number of report pages to create. This can be set upto 20.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="hide">hide</h4></div> <dl><dd>Hide a column. Normally columns can be hidden by just not including it in the SELECT statement. However, some columns like namespace number are necessary for generation of <a href="#wikilinks">wikilinks</a> but undesirable in final output. Specify the column number(s) of such column(s) here, comma-separated if multiple.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="row_template">row_template</h4></div> <dl><dd>Generates a template call rather than a table row; the template must then generate the table row in turn or the table header/footer need to be suppressed using <code>skip_table</code> parameter. Values in the row are passed to the template as unnamed parameters (<code class="tpl-para" style="word-break:break-word;">|1=</code>, <code class="tpl-para" style="word-break:break-word;">|2=</code>, etc). <ul><li>To have the template substituted instead of transcluded, put "subst:" before the template name.</li> <li>To use a Lua module instead of a template, put "#invoke:" before the module name.</li></ul></dd></dl> <div class="mw-heading mw-heading4"><h4 id="row_template_named_params">row_template_named_params</h4></div> <dl><dd>While using row_template, instead of using unnamed parameters, use the column names as parameters. This is a boolean field - any value will work.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="skip_table">skip_table</h4></div> <dl><dd>Suppresses the table markup completely when using <code>row_template</code>. Any value will work.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="header_template">header_template</h4></div> <dl><dd>Generates a template call rather than a table header; the template must then generate the table header. No parameters are passed to this template. The template can be substituted as well - just specify "subst:" before the template name.</dd> <dd>If this is used without using <code>row_template</code> as well, then the header template will be placed over the table, and table headers will still be generated.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="footer_template">footer_template</h4></div> <dl><dd>Generates a footer calling the given template. For use with <code>skip_table</code>. This could be used along with <code>header_template</code> for collapsing (collapse top/collapse bottom) or creating columns (div col/div col end) in the generated content. No parameters are passed to the template. It can be substituted instead by specifying "subst:" before the template name. For quick reference: <code>|}</code> is <span class="nowrap">{{</span><a href="/wiki/Template:End" title="Template:End">end</a><span class="nowrap">}}</span>.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="postprocess_js">postprocess_js</h4></div> <dl><dd><i>Experimental</i></dd> <dd>Custom postprocessing code, in JavaScript, which is executed by the bot on the raw db output. Format:</dd> <dd><div class="mw-highlight mw-highlight-lang-js mw-content-ltr" dir="ltr"><pre><span></span><span class="kd">function</span><span class="w"> </span><span class="nx">postprocess</span><span class="p">(</span><span class="nx">rows</span><span class="p">)</span><span class="w"> </span><span class="p">{</span> <span class="w"> </span><span class="c1">// `rows` is an array.</span> <span class="w"> </span><span class="c1">// Each element in `rows` is an object with column names as keys, and with values stringified</span> <span class="w"> </span><span class="c1">// Eg. for SELECT page_namespace, page_title FROM page LIMIT 2</span> <span class="w"> </span><span class="c1">// the `rows` could be:</span> <span class="w"> </span><span class="c1">// [</span> <span class="w"> </span><span class="c1">// { page_namespace: '0', page_title: 'Main Page' },</span> <span class="w"> </span><span class="c1">// { page_namespace: '1', page_title: 'Main Page' },</span> <span class="w"> </span><span class="c1">// ]</span> <span class="w"> </span><span class="c1">// Write code to process rows here.</span> <span class="w"> </span><span class="c1">// Return it after modifications:</span> <span class="w"> </span><span class="k">return</span><span class="w"> </span><span class="nx">rows</span><span class="p">;</span> <span class="p">}</span> </pre></div></dd> <dd>The postprocess() function is applied on the query result <b>before</b> it is modified by other formatting options like <a href="#wikilinks">wikilinks</a>. It can be used to introduce new derived rows or columns (eg. a "Total" row at the bottom), dynamically modify rows based on content of other rows, etc. If the code contains wikimarkup-like syntax that could confuse the parser, wrap the whole code within <code class="nowrap" style=""><nowiki>...</nowiki></code>.</dd> <dd>The JS code is run on Node.js v18.14.2 sandboxed to use upto 16 MB of memory and 1.5 seconds of execution time. No network or filesystem access is allowed – with the exceptions below:</dd> <dd><code class="mw-highlight mw-highlight-lang-js mw-content-ltr" dir="ltr"><span class="k">await</span><span class="w"> </span><span class="nx">bot</span><span class="p">.</span><span class="nx">request</span><span class="p">(</span><span class="s1">'https://...'</span><span class="p">)</span></code> provides readonly access to various Wikimedia APIs. Supported endpoints: <a class="external text" href="https://en.wikipedia.org/api/rest_v1/">en.wikipedia.org/api/rest_v1</a>, <a class="external text" href="https://wikimedia.org/api/rest_v1/">wikimedia.org/api/rest_v1</a>, <a class="external text" href="https://www.mediawiki.org/wiki/API:REST_API">en.wikipedia.org/w/rest.php</a>, <a class="external text" href="https://www.mediawiki.org/wiki/API:Main_page">en.wikipedia/org/w/api.php</a>, <a class="external text" href="https://api.wikimedia.org/">api.wikimedia.org</a> and <a class="external text" href="https://query.wikidata.org/">query.wikidata.org</a>. These can be used for fetching pageview data (from REST API), ORES scores (from <a class="external text" href="https://api.wikimedia.org/wiki/Lift_Wing_API">Lift Wing</a>), and so on.</dd> <dd>For the Action API, <code class="mw-highlight mw-highlight-lang-js mw-content-ltr" dir="ltr"><span class="k">await</span><span class="w"> </span><span class="nx">bot</span><span class="p">.</span><span class="nx">api</span><span class="p">({</span><span class="nx">action</span><span class="o">:</span><span class="w"> </span><span class="s1">'query'</span><span class="p">,</span><span class="w"> </span><span class="p">...})</span></code> can be alternatively used. Parameters action: 'query', format: 'json' and formatversion: 2 are set by default.</dd></dl> <div class="mw-heading mw-heading4"><h4 id="silent">silent</h4></div> <dl><dd>Suppress visible output from this template. Only the table generated by the bot will be visible. The last update timestamp and query runtime are also not saved. This means that if the query result is unchanged, periodic updates won't reflect in the page history.</dd> <dd>This is a boolean field - any value will work.</dd></dl> <div class="mw-heading mw-heading3"><h3 id="SQL_formatting_tips">SQL formatting tips</h3></div> <ul><li>Datetime columns are stored in YYYYMMDDHHmmss format. Select them as <code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="n">DATE_FORMAT</span><span class="p">(</span><span class="n">rev_timestamp</span><span class="p">,</span><span class="w"> </span><span class="s1">'%Y-%m-%d %H:%i'</span><span class="p">)</span></code> or <code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="n">DATE_FORMAT</span><span class="p">(</span><span class="n">rev_timestamp</span><span class="p">,</span><span class="w"> </span><span class="s1">'%Y-%m-%d'</span><span class="p">)</span></code>.</li> <li>For generating a serial number column, select <code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="n">ROW_NUMBER</span><span class="p">()</span><span class="w"> </span><span class="n">OVER</span><span class="p">(</span><span class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="p">(</span><span class="k">SELECT</span><span class="w"> </span><span class="mi">1</span><span class="p">))</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="ss">"No."</span></code>. For example, see <a href="/wiki/Wikipedia:Database_reports/Fully_salted_titles_with_unusually_long_expiries" title="Wikipedia:Database reports/Fully salted titles with unusually long expiries">WP:Database reports/Fully salted titles with unusually long expiries</a>.</li> <li>To use this with <span class="nowrap">{{</span><a href="/wiki/Template:Static_row_numbers" title="Template:Static row numbers">static row numbers</a><span class="nowrap">}}</span>, put <code>header_template = static row numbers</code> and <code>table_class = wikitable sortable static-row-numbers static-row-header-text</code>.</li> <li>To display full wikilinked page names where namespace can vary (as in <code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">SELECT</span><span class="w"> </span><span class="n">page_namespace</span><span class="p">,</span><span class="w"> </span><span class="n">page_title</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="p">...</span></code>), use <code>|wikilinks=2:c1:show</code> and then hide the namespace column from display (<code>|hide=1</code>).</li> <li>This template also plays well with <span class="nowrap">{{</span><a href="/wiki/Template:Namespace_name" title="Template:Namespace name">Namespace name</a><span class="nowrap">}}</span>, which allows you to avoid extra queries: for example, <code>"{{Namespace name|1}}:"</code> will return "Talk:" and <code>"{{Namespace name|8}}:"</code> will return "MediaWiki:".</li></ul> <div class="mw-heading mw-heading3"><h3 id="Advanced_styling">Advanced styling</h3></div> <p>The default <a href="#table_style">table_style</a> is overflow-wrap:anywhere as it avoids columns becoming too wide due to presence of long non-breaking text. Sometimes, using <code class="mw-highlight mw-highlight-lang-text mw-content-ltr" style="" dir="ltr">overflow-wrap: anywhere; word-break: break-word</code> can help instead. These may cause even the headers to break mid-word – use the <a href="#widths">widths</a> setting to avoid that. </p><p>Another way to avoid the ugliness of headers breaking in the middle of a word is to apply the style on the <tbody> element instead. To do this, use <a href="#table_class">table_class</a> to apply a distinguishing class and then style it via <a href="/wiki/Wikipedia:TemplateStyles" title="Wikipedia:TemplateStyles">TemplateStyles</a>. You can also apply custom styles on the <thead> element this way. </p> <hr /> <p>The design of the bot and template were inspired from <a href="/wiki/User:ListeriaBot" title="User:ListeriaBot">User:ListeriaBot</a> and <span class="nowrap">{{</span><a href="/wiki/Template:Wikidata_list" title="Template:Wikidata list">Wikidata list</a><span class="nowrap">}}</span>. </p> <div class="documentation-clear"></div> </div> <div role="note" class="documentation-metadata plainlinks">The above <a href="/wiki/Wikipedia:Template_documentation" title="Wikipedia:Template documentation">documentation</a> is <a href="/wiki/Help:Transclusion" title="Help:Transclusion">transcluded</a> from <a href="/wiki/Template:Database_report/doc" title="Template:Database report/doc">Template:Database report/doc</a>. <span class="documentation-toolbar">(<a href="/wiki/Special:EditPage/Template:Database_report/doc" title="Special:EditPage/Template:Database report/doc">edit</a> | <a href="/wiki/Special:PageHistory/Template:Database_report/doc" title="Special:PageHistory/Template:Database report/doc">history</a>)</span><br />Editors can experiment in this template's sandbox <span class="documentation-toolbar">(<a class="external text" href="https://en.wikipedia.org/w/index.php?title=Template:Database_report/sandbox&action=edit&preload=Template%3ADocumentation%2Fpreload-sandbox">create</a> | <a class="external text" href="https://en.wikipedia.org/w/index.php?title=Template:Database_report/sandbox&preload=Template%3ADocumentation%2Fmirror&action=edit&summary=Create+sandbox+version+of+%5B%5BTemplate%3ADatabase+report%5D%5D">mirror</a>)</span> and testcases <span class="documentation-toolbar">(<a class="external text" href="https://en.wikipedia.org/w/index.php?title=Template:Database_report/testcases&action=edit&preload=Template%3ADocumentation%2Fpreload-testcases">create</a>)</span> pages.<br />Add categories to the <a href="/wiki/Template:Database_report/doc" title="Template:Database report/doc">/doc</a> subpage. <a href="/wiki/Special:PrefixIndex/Template:Database_report/" title="Special:PrefixIndex/Template:Database report/">Subpages of this template</a>.</div></div>    </div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?useformat=desktop&type=1x1&usesul3=0" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Retrieved from "<a dir="ltr" href="https://en.wikipedia.org/w/index.php?title=Template:Database_report&oldid=1240499914">https://en.wikipedia.org/w/index.php?title=Template:Database_report&oldid=1240499914</a>"</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/wiki/Help:Category" title="Help:Category">Category</a>: <ul><li><a href="/wiki/Category:Wikipedia_bot-related_templates" title="Category:Wikipedia bot-related templates">Wikipedia bot-related templates</a></li></ul></div><div id="mw-hidden-catlinks" class="mw-hidden-catlinks mw-hidden-cats-hidden">Hidden categories: <ul><li><a href="/wiki/Category:Wikipedia_semi-protected_templates" title="Category:Wikipedia semi-protected templates">Wikipedia semi-protected templates</a></li><li><a href="/wiki/Category:Lua-based_templates" title="Category:Lua-based templates">Lua-based templates</a></li></ul></div></div> </div> </main> </div> <div class="mw-footer-container"> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> This page was last edited on 15 August 2024, at 18:00<span class="anonymous-show"> (UTC)</span>.</li> <li id="footer-info-copyright">Text is available under the <a href="/wiki/Wikipedia:Text_of_the_Creative_Commons_Attribution-ShareAlike_4.0_International_License" title="Wikipedia:Text of the Creative Commons Attribution-ShareAlike 4.0 International License">Creative Commons Attribution-ShareAlike 4.0 License</a>; additional terms may apply. By using this site, you agree to the <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use" class="extiw" title="foundation:Special:MyLanguage/Policy:Terms of Use">Terms of Use</a> and <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy" class="extiw" title="foundation:Special:MyLanguage/Policy:Privacy policy">Privacy Policy</a>. Wikipedia® is a registered trademark of the <a rel="nofollow" class="external text" href="https://wikimediafoundation.org/">Wikimedia Foundation, Inc.</a>, a non-profit organization.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy policy</a></li> <li id="footer-places-about"><a href="/wiki/Wikipedia:About">About Wikipedia</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Wikipedia:General_disclaimer">Disclaimers</a></li> <li id="footer-places-contact"><a href="//en.wikipedia.org/wiki/Wikipedia:Contact_us">Contact Wikipedia</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Universal_Code_of_Conduct">Code of Conduct</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Developers</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/en.wikipedia.org">Statistics</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookie statement</a></li> <li id="footer-places-mobileview"><a href="//en.m.wikipedia.org/w/index.php?title=Template:Database_report&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobile view</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" lang="en" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> </div> </div> </div> <div class="vector-header-container vector-sticky-header-container"> <div id="vector-sticky-header" class="vector-sticky-header"> <div class="vector-sticky-header-start"> <div class="vector-sticky-header-icon-start vector-button-flush-left vector-button-flush-right" aria-hidden="true"> <button class="cdx-button cdx-button--weight-quiet cdx-button--icon-only vector-sticky-header-search-toggle" tabindex="-1" data-event-name="ui.vector-sticky-search-form.icon"><span class="vector-icon mw-ui-icon-search mw-ui-icon-wikimedia-search"></span> <span>Search</span> </button> </div> <div role="search" class="vector-search-box-vue vector-search-box-show-thumbnail vector-search-box"> <div class="vector-typeahead-search-container"> <div class="cdx-typeahead-search cdx-typeahead-search--show-thumbnail"> <form action="/w/index.php" id="vector-sticky-search-form" class="cdx-search-input cdx-search-input--has-end-button"> <div class="cdx-search-input__input-wrapper" data-search-loc="header-moved"> <div class="cdx-text-input cdx-text-input--has-start-icon"> <input class="cdx-text-input__input" type="search" name="search" placeholder="Search Wikipedia"> <span class="cdx-text-input__icon cdx-text-input__start-icon"></span> </div> <input type="hidden" name="title" value="Special:Search"> </div> <button class="cdx-button cdx-search-input__end-button">Search</button> </form> </div> </div> </div> <div class="vector-sticky-header-context-bar"> <nav aria-label="Contents" class="vector-toc-landmark"> <div id="vector-sticky-header-toc" class="vector-dropdown mw-portlet mw-portlet-sticky-header-toc vector-sticky-header-toc vector-button-flush-left" > <input type="checkbox" id="vector-sticky-header-toc-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-sticky-header-toc" class="vector-dropdown-checkbox " aria-label="Toggle the table of contents" > <label id="vector-sticky-header-toc-label" for="vector-sticky-header-toc-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-listBullet mw-ui-icon-wikimedia-listBullet"></span> <span class="vector-dropdown-label-text">Toggle the table of contents</span> </label> <div class="vector-dropdown-content"> <div id="vector-sticky-header-toc-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <div class="vector-sticky-header-context-bar-primary" aria-hidden="true" ><span class="mw-page-title-namespace">Template</span><span class="mw-page-title-separator">:</span><span class="mw-page-title-main">Database report</span></div> </div> </div> <div class="vector-sticky-header-end" aria-hidden="true"> <div class="vector-sticky-header-icons"> <a href="#" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only" id="ca-talk-sticky-header" tabindex="-1" data-event-name="talk-sticky-header"><span class="vector-icon mw-ui-icon-speechBubbles mw-ui-icon-wikimedia-speechBubbles"></span> <span></span> </a> <a href="#" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only" id="ca-subject-sticky-header" tabindex="-1" data-event-name="subject-sticky-header"><span class="vector-icon mw-ui-icon-article mw-ui-icon-wikimedia-article"></span> <span></span> </a> <a href="#" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only" id="ca-history-sticky-header" tabindex="-1" data-event-name="history-sticky-header"><span class="vector-icon mw-ui-icon-wikimedia-history mw-ui-icon-wikimedia-wikimedia-history"></span> <span></span> </a> <a href="#" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only mw-watchlink" id="ca-watchstar-sticky-header" tabindex="-1" data-event-name="watch-sticky-header"><span class="vector-icon mw-ui-icon-wikimedia-star mw-ui-icon-wikimedia-wikimedia-star"></span> <span></span> </a> <a href="#" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only" id="ca-edit-sticky-header" tabindex="-1" data-event-name="wikitext-edit-sticky-header"><span class="vector-icon mw-ui-icon-wikimedia-wikiText mw-ui-icon-wikimedia-wikimedia-wikiText"></span> <span></span> </a> <a href="#" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only" id="ca-ve-edit-sticky-header" tabindex="-1" data-event-name="ve-edit-sticky-header"><span class="vector-icon mw-ui-icon-wikimedia-edit mw-ui-icon-wikimedia-wikimedia-edit"></span> <span></span> </a> <a href="#" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only" id="ca-viewsource-sticky-header" tabindex="-1" data-event-name="ve-edit-protected-sticky-header"><span class="vector-icon mw-ui-icon-wikimedia-editLock mw-ui-icon-wikimedia-wikimedia-editLock"></span> <span></span> </a> </div> <div class="vector-sticky-header-buttons"> <button class="cdx-button cdx-button--weight-quiet mw-interlanguage-selector" id="p-lang-btn-sticky-header" tabindex="-1" data-event-name="ui.dropdown-p-lang-btn-sticky-header"><span class="vector-icon mw-ui-icon-wikimedia-language mw-ui-icon-wikimedia-wikimedia-language"></span> <span>1 language</span> </button> <a href="#" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--action-progressive" id="ca-addsection-sticky-header" tabindex="-1" data-event-name="addsection-sticky-header"><span class="vector-icon mw-ui-icon-speechBubbleAdd-progressive mw-ui-icon-wikimedia-speechBubbleAdd-progressive"></span> <span>Add topic</span> </a> </div> <div class="vector-sticky-header-icon-end"> <div class="vector-user-links"> </div> </div> </div> </div> </div> <div class="vector-settings" id="p-dock-bottom"> <ul></ul> </div><script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgHostname":"mw-web.codfw.main-8665775b5-m2t68","wgBackendResponseTime":117,"wgPageParseReport":{"limitreport":{"cputime":"0.158","walltime":"0.284","ppvisitednodes":{"value":1000,"limit":1000000},"postexpandincludesize":{"value":67496,"limit":2097152},"templateargumentsize":{"value":1008,"limit":2097152},"expansiondepth":{"value":9,"limit":100},"expensivefunctioncount":{"value":27,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":11430,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 216.559 1 Template:Documentation","100.00% 216.559 1 -total"," 65.89% 142.685 1 Template:Database_report/doc"," 19.10% 41.372 1 Template:Lua"," 10.74% 23.261 1 Template:Further"," 10.03% 21.714 2 Template:Tag"," 9.26% 20.063 2 Template:Tlf"," 5.29% 11.445 15 Template:Code"," 2.80% 6.059 4 Template:Namespace_name"," 2.63% 5.698 1 Template:Sandbox_other"]},"scribunto":{"limitreport-timeusage":{"value":"0.076","limit":"10.000"},"limitreport-memusage":{"value":1489048,"limit":52428800}},"cachereport":{"origin":"mw-web.eqiad.main-976d8f46b-bspf2","timestamp":"20250124190508","ttl":2592000,"transientcontent":false}}});});</script> </body> </html>