CINXE.COM

<!DOCTYPE html><html><head><meta charset="UTF-8" /><title>⚓ T2449 uncategorized pages report speedup hack</title><meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=yes" /><link rel="mask-icon" color="#3D4B67" href="https://phab.wmfusercontent.org/res/phabricator/db699fe1/rsrc/favicons/mask-icon.svg" /><link rel="apple-touch-icon" sizes="76x76" href="https://phab.wmfusercontent.org/file/data/wai6mh2gkrssonesklmm/PHID-FILE-jiixbumihmhuzz2paeut/favicon" /><link rel="apple-touch-icon" sizes="120x120" href="https://phab.wmfusercontent.org/file/data/a3izriz5azyzso4bnueg/PHID-FILE-ps6cpmki336a7zc3oqjn/favicon" /><link rel="apple-touch-icon" sizes="152x152" href="https://phab.wmfusercontent.org/file/data/o2jxp55a4p46ytynsfng/PHID-FILE-rug6ohtqrwvnunh5kj4x/favicon" /><link rel="icon" id="favicon" href="https://phab.wmfusercontent.org/file/data/ylbeoktf43zmd3loe435/PHID-FILE-ahr5qqrmgg3kjvzhpv4k/favicon" /><meta name="referrer" content="no-referrer" /><link rel="stylesheet" type="text/css" href="https://phab.wmfusercontent.org/res/defaultX/phabricator/45b62efe/core.pkg.css" /><link rel="stylesheet" type="text/css" href="https://phab.wmfusercontent.org/res/defaultX/phabricator/35995d6d/maniphest.pkg.css" /><script type="text/javascript" src="https://phab.wmfusercontent.org/res/defaultX/phabricator/98e6504a/rsrc/externals/javelin/core/init.js"></script></head><body class="device-desktop platform-windows phui-theme-blue"><div class="main-page-frame" id="main-page-frame"><div id="phabricator-standard-page" class="phabricator-standard-page"><div class="phabricator-main-menu phabricator-main-menu-background" id="UQ0_41"><a class=" phabricator-core-user-menu phabricator-core-user-mobile-menu" href="#" role="button" data-sigil="phui-dropdown-menu" data-meta="0_67"><span class="aural-only">Page Menu</span><span class="visual-only phui-icon-view phui-font-fa fa-bars" data-meta="0_68" aria-hidden="true"></span><span class="caret"></span></a><a class="phabricator-main-menu-search-button phabricator-expand-application-menu" data-sigil="jx-toggle-class" data-meta="0_66"><span class="phabricator-menu-button-icon phui-icon-view phui-font-fa fa-search" id="UQ0_96"></span></a><a class="phabricator-main-menu-brand" href="/"><span class="aural-only">Home</span><span class="phabricator-main-menu-project-logo" style="background-size: 40px 40px; background-position: 0 0; background-image: url(https://phab.wmfusercontent.org/file/data/ki2yptiznxwthixxdwas/PHID-FILE-be4byvg2akyovi3g33wq/logo)"></span><span class="phabricator-wordmark">Phabricator</span></a><ul class="phui-list-view phabricator-search-menu"><li class="phui-list-item-view phui-list-item-type-link phabricator-main-menu-search"><div class="" data-sigil=""><form action="/search/" method="POST"><input type="hidden" name="__csrf__" value="B@5h2oe3446d07577b92fcff81" /><input type="hidden" name="__form__" value="1" /><div class="phabricator-main-menu-search-container"><input type="text" name="query" id="UQ0_97" autocomplete="off" accesskey="F" autocorrect="off" autocapitalize="off" spellcheck="false" /><button id="UQ0_99" class="phui-icon-view phui-font-fa fa-search"><span class="aural-only">Search</span></button><button class="button dropdown has-icon phui-button-default phabricator-main-menu-search-dropdown" id="UQ0_100" data-sigil="global-search-dropdown" data-meta="0_69"><span class="aural-only">Configure Global Search</span><span class="visual-only phui-icon-view phui-font-fa fa-globe" data-sigil="global-search-dropdown-icon" data-meta="0_70" aria-hidden="true"></span><span class="caret"></span></button><input type="hidden" name="search:scope" value="all" data-sigil="global-search-dropdown-input" /><input type="hidden" id="UQ0_101" name="search:application" value="PhabricatorManiphestApplication" data-sigil="global-search-dropdown-app" /><input type="hidden" name="search:primary" value="true" /><div id="UQ0_98" class="phabricator-main-menu-search-target"></div></div></form></div></li></ul><a class=" phabricator-core-login-button" href="https://phabricator.wikimedia.org/auth/start/?next=%2FT2449" role="button"><div class="phui-button-text">Log In</div></a></div><div id="phabricator-standard-page-body" class="phabricator-standard-page-body"><div class="phui-crumbs-view phui-crumbs-border"><div class="phui-crumbs-actions"><a href="/maniphest/task/edit/nocreate/" class="phui-crumbs-action" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-plus-square" data-meta="0_71" aria-hidden="true"></span><span class="phui-crumbs-action-name">Create Task</span></a></div><a href="/maniphest/" class="phui-crumb-view phui-crumb-has-icon"><span class="visual-only phui-icon-view phui-font-fa fa-anchor" data-meta="0_72" aria-hidden="true"></span><span class="phui-crumb-name"> Maniphest</span> </a><span class="visual-only phui-icon-view phui-font-fa fa-angle-right phui-crumb-divider phui-crumb-view" data-meta="0_73" aria-hidden="true"></span><span class="phui-crumb-view phabricator-last-crumb"><span class="phui-crumb-name"> T2449</span> </span></div><div class="phui-two-column-view phui-side-column-right "><div class="phui-two-column-container"><div class="phui-two-column-header"><div class="phui-header-shell phui-header-tall "><h1 class="phui-header-view"><div class="phui-header-row"><div class="phui-header-col2"><span class="phui-header-header"><span class="visual-only phui-icon-view phui-font-fa fa-trash-o orange phui-header-icon" data-meta="0_62" aria-hidden="true"></span>uncategorized pages report speedup hack</span><div class="phui-header-subheader"><span class="phui-tag-view phui-tag-type-shade phui-tag-indigo phui-tag-shade phui-tag-icon-view "><span class="phui-tag-core "><span class="visual-only phui-icon-view phui-font-fa fa-check-square-o" data-meta="0_65" aria-hidden="true"></span>Closed, Invalid</span></span><span class="policy-header-callout"><span class="visual-only phui-icon-view phui-font-fa fa-globe bluegrey" data-meta="0_64" aria-hidden="true"></span><a class="policy-link" href="/policy/explain/PHID-TASK-wefep4t6y2h3bnvhvj2b/view/" data-sigil="workflow">Public</a></span></div></div><div class="phui-header-col3"><div class="phui-header-action-links"><a class="button button-grey has-icon has-text phui-button-default phui-mobile-menu msl phui-header-action-link" href="#" role="button" data-sigil="phui-dropdown-menu" data-meta="0_60"><span class="visual-only phui-icon-view phui-font-fa fa-bars" data-meta="0_61" aria-hidden="true"></span><div class="phui-button-text">Actions</div></a></div></div></div></h1></div></div><div class="phui-two-column-content"><div class="phui-two-column-row grouped"><div class="phui-side-column"><div class=""><div class="phui-box phui-box-border phui-object-box mlt mll mlr phui-two-column-properties"><ul class="phabricator-action-list-view " id="UQ0_0"><li id="UQ0_12" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/maniphest/task/edit/2449/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-pencil grey phabricator-action-view-icon" data-meta="0_38" aria-hidden="true"></span>Edit Task</a></li><li id="UQ0_19" class="phabricator-action-view phabricator-action-view-submenu phabricator-action-view-href action-has-icon" style="" data-sigil="phui-submenu" data-meta="0_40"><a href="#" class="phabricator-action-view-item" data-sigil="keep-open"><span class="visual-only phui-icon-view phui-font-fa fa-anchor phabricator-action-view-icon" data-meta="0_39" aria-hidden="true"></span>Edit Related Tasks...<span class="caret-right" id="UQ0_13"></span></a></li><li id="UQ0_14" class="phabricator-action-view phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/maniphest/task/subtask/2449/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-level-down phabricator-action-view-icon" data-meta="0_41" aria-hidden="true"></span>Create Subtask</a></li><li id="UQ0_15" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.has-parent/PHID-TASK-wefep4t6y2h3bnvhvj2b/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-chevron-circle-up grey phabricator-action-view-icon" data-meta="0_42" aria-hidden="true"></span>Edit Parent Tasks</a></li><li id="UQ0_16" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.has-subtask/PHID-TASK-wefep4t6y2h3bnvhvj2b/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-chevron-circle-down grey phabricator-action-view-icon" data-meta="0_43" aria-hidden="true"></span>Edit Subtasks</a></li><li id="UQ0_17" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.merge-in/PHID-TASK-wefep4t6y2h3bnvhvj2b/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-compress grey phabricator-action-view-icon" data-meta="0_44" aria-hidden="true"></span>Merge Duplicates In</a></li><li id="UQ0_18" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.close-as-duplicate/PHID-TASK-wefep4t6y2h3bnvhvj2b/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-times grey phabricator-action-view-icon" data-meta="0_45" aria-hidden="true"></span>Close As Duplicate</a></li><li id="UQ0_28" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-submenu phabricator-action-view-href action-has-icon" style="" data-sigil="phui-submenu" data-meta="0_47"><a href="#" class="phabricator-action-view-item" data-sigil="keep-open"><span class="visual-only phui-icon-view phui-font-fa fa-link grey phabricator-action-view-icon" data-meta="0_46" aria-hidden="true"></span>Edit Related Objects...<span class="caret-right" id="UQ0_25"></span></a></li><li id="UQ0_26" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.has-commit/PHID-TASK-wefep4t6y2h3bnvhvj2b/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-code grey phabricator-action-view-icon" data-meta="0_48" aria-hidden="true"></span>Edit Commits</a></li><li id="UQ0_27" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.has-mock/PHID-TASK-wefep4t6y2h3bnvhvj2b/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-camera-retro grey phabricator-action-view-icon" data-meta="0_49" aria-hidden="true"></span>Edit Mocks</a></li><li id="UQ0_32" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><form action="/subscriptions/add/PHID-TASK-wefep4t6y2h3bnvhvj2b/" method="POST" data-sigil="workflow"><input type="hidden" name="__csrf__" value="B@5h2oe3446d07577b92fcff81" /><input type="hidden" name="__form__" value="1" /><button class="phabricator-action-view-item"><span class="visual-only phui-icon-view phui-font-fa fa-plus-circle grey phabricator-action-view-icon" data-meta="0_50" aria-hidden="true"></span>Subscribe</button></form></li><li id="UQ0_34" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/subscriptions/mute/PHID-TASK-wefep4t6y2h3bnvhvj2b/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-volume-up grey phabricator-action-view-icon" data-meta="0_51" aria-hidden="true"></span>Mute Notifications</a></li><li id="UQ0_36" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/wmf/escalate-task/2449/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-eye-slash grey phabricator-action-view-icon" data-meta="0_52" aria-hidden="true"></span>Protect as security issue</a></li><li id="UQ0_38" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/token/give/PHID-TASK-wefep4t6y2h3bnvhvj2b/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-trophy grey phabricator-action-view-icon" data-meta="0_53" aria-hidden="true"></span>Award Token</a></li><li id="UQ0_40" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/flag/edit/PHID-TASK-wefep4t6y2h3bnvhvj2b/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-flag grey phabricator-action-view-icon" data-meta="0_54" aria-hidden="true"></span>Flag For Later</a></li></ul><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Assigned To</div><div class="phui-curtain-panel-body"><div class="phui-curtain-object-ref-list-view "><div class="phui-curtain-object-ref-list-view-empty">None</div></div></div></div><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Authored By</div><div class="phui-curtain-panel-body"><div class="phui-curtain-object-ref-list-view "><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-with-content"><td rowspan="2" class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/ovytmbleapqqbp2q34as/PHID-FILE-ukx4a3vvpumxtlt3rof2/profile-Screen_Shot_2014-11-24_at_10.24.10_AM.png)" href="/p/bzimport/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/bzimport/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_55"><span class="perfect-circle">•</span> bzimport</a></td></tr><tr><td class="phui-curtain-object-ref-view-epoch-cell"><span class="screen-only">Sep 11 2004, 2:29 AM</span><span class="print-only" aria-hidden="true">2004-09-11 02:29:00 (UTC+0)</span></td></tr></tbody></table></div></div></div></div><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Tags</div><div class="phui-curtain-panel-body"><ul class="phabricator-handle-tag-list "><li class="phabricator-handle-tag-list-item"><a href="/tag/mediawiki-special-pages/" class="phui-tag-view phui-tag-type-shade phui-tag-blue phui-tag-shade phui-tag-icon-view " data-sigil="hovercard" data-meta="0_57"><span class="phui-tag-core "><span class="visual-only phui-icon-view phui-font-fa fa-briefcase" data-meta="0_56" aria-hidden="true"></span>MediaWiki-Special-pages</span></a> <a href="/project/board/133/" class="maniphest-board-link">(To triage)</a></li></ul></div></div><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Referenced Files</div><div class="phui-curtain-panel-body"><div class="phui-curtain-object-ref-list-view "><div class="phui-curtain-object-ref-list-view-empty">None</div></div></div></div><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Subscribers</div><div class="phui-curtain-panel-body"><div class="phui-curtain-object-ref-list-view "><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/ktpxiau6eswechswlmd7/PHID-FILE-2vlsbryc7loxstbithpy/profile)" href="/p/demon/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/demon/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_58"><span class="perfect-circle">•</span> demon</a></td></tr></tbody></table></div><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/3hnsjs724gvw3q53gkvb/PHID-FILE-wakjv4u7qxfxihf2khpj/alphanumeric_lato-dark_W.png-_916b88-0%2C0%2C0%2C0.3.png)" href="/p/wikibugs-l-list/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/wikibugs-l-list/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_59"><span class="perfect-circle">•</span> wikibugs-l-list</a></td></tr></tbody></table></div></div></div></div></div></div></div><div class="phui-main-column"><div class="phui-box phui-box-border phui-object-box mlt mll mlr phui-box-blue-property "><div class="phui-header-shell "><h1 class="phui-header-view"><div class="phui-header-row"><div class="phui-header-col2"><span class="phui-header-header">Description</span></div><div class="phui-header-col3"></div></div></h1></div><div class="phui-property-list-section"><div class="phui-property-list-text-content"><div class="phabricator-remarkup"><div class="phabricator-remarkup"><p><strong>Author:</strong> <tt class="remarkup-monospaced">bugzilla_wikipedia_org.to.jamesd</tt></p> <p><strong>Description:</strong><br /> One approach to speed up uncategorized pages. Note <br /> that it is NOT optimal - ideally there would be an <br /> index for cur on cur_is_redirect. The lack of that <br /> forces loading of the full record of cur - if there <br /> was an index, we could take the value directly from <br /> the index without reading the main record at all. <br /> Better still, there would be an index on <br /> cur_namespace, cur_is_redirect and cur_title. That <br /> index could be used for many other queries, using <br /> cur_is_redirect in (0,1) when it doesn't matter <br /> whether it's a redirect or not. Field order makes a <br /> speed difference in indexes and I haven't evaluated <br /> whether cur_namespace or cur_is_redirect first is <br /> faster.</p> <p>See bug 250 for a periodically generated intermediate <br /> table approach which would make this cheaper without <br /> changing the cur table. This query could run against <br /> that intermediate table. We'd want one index on cur <br /> which contained every field in the intermediate table <br /> or we'd want cur updates to update the intermediate <br /> table directly (using insert delayed so they wouldn't <br /> block due to MyISAM poor locking if a query was <br /> running). With the text field removed from cur we <br /> wouldn't need this index on cur - it's just to dodge <br /> the time it takes to read all of the current full cur <br /> record.</p> <p>However, we don't have this yet, so:</p> <ol class="remarkup-list"> <li class="remarkup-list-item">create a table with just the cur_id - will load id</li> </ol> <p>from that index, so it's very fast. Will include <br /> records with the wrong namespace. Get them in batches <br /> of 50,000 and perform steps 2+3 for each batch.</p> <ol class="remarkup-list" start="2"> <li class="remarkup-list-item">join that with categorylinks to find the ones</li> </ol> <p>which have no category. Also very fast.</p> <ol class="remarkup-list" start="3"> <li class="remarkup-list-item">check the resulting list against cur to eliminate</li> </ol> <p>the redirects - has to read quite a large chunk of <br /> cur. This one can be done in small chunks - the <br /> sample here doesn't bother.<br /> 3b repeat 1/2/3 until all batches are in the <br /> temporary table.</p> <ol class="remarkup-list" start="4"> <li class="remarkup-list-item">finally the query we want</li> </ol> <p>This requires setup and cleanup steps which aren't <br /> present in the current framework which calls the <br /> uncategorized pages code in</p> <p>I don't recommend implementing this - use the <br /> intermediate table approach instead. It's a lot less <br /> messy than this hack.</p> <p>/* 1. First build a list of cur records in namespace <br /> 0 using the namespace index */<br /> /* can use limit 0,50000 then 51000,100000 etc. to <br /> meet the batching */<br /> /* requirement discussed later */<br /> /* 607593 for en */<br /> CREATE temporary TABLE cur_namespace0 (</p> <div class="remarkup-code-block" data-code-lang="text" data-sigil="remarkup-code-block"><pre class="remarkup-code">cur_namespace0_id int(8) unsigned NOT NULL, UNIQUE KEY id (cur_namespace0_id)</pre></div> <p>) TYPE=MyISAM PACK_KEYS=0;<br /> insert into cur_namespace0 (cur_namespace0_id)<br /> select cur_id from cur where cur_namespace=0;</p> <p>/* 2. now join this with category links to get list <br /> of cur records which */<br /> /* need to be checked against cur records for not <br /> is_redirect and to get title */<br /> /* order by cur_id so the subsequent check of cur <br /> will read cur in */<br /> /* order by the primary/clustered key, the fastest <br /> way */<br /> CREATE temporary TABLE uncat_nocat (</p> <div class="remarkup-code-block" data-code-lang="text" data-sigil="remarkup-code-block"><pre class="remarkup-code">uncat_nocat_id int(8) unsigned NOT NULL, UNIQUE KEY id (uncat_nocat_id),</pre></div> <p>) TYPE=MyISAM PACK_KEYS=0;<br /> insert into uncat_nocat (uncat_nocat_id)<br /> SELECT cur_namespace0_id<br /> FROM cur_namespace0 LEFT JOIN categorylinks ON <br /> cur_namespace0_id=cl_from<br /> WHERE cl_from IS NULL<br /> order by cur_namespace0_id;<br /> drop table cur_namespace0;</p> <p>/* 3. now we must read cur itself to eliminate the <br /> redirects */<br /> /* this hurts - 438803 records to check for en. */<br /> /* for en gets 176703 results in 4 min 17 sec on suda <br /> */<br /> /* should really do this in batches of 50,000 or so <br /> uncat_nocat records */<br /> /* uncat_nocat rather than cur because it's OK to <br /> scan uncat_nocat repeatedly */<br /> /* but we gain nothing by using chunks if we use cur <br /> chunks - want one */<br /> /* and only one scan of cur, even if we do it in <br /> pieces */<br /> /* cur_id is used to avoid more costly check of <br /> cur_title for */<br /> /* duplicates, which we would have to do if it was <br /> primary key. */<br /> CREATE temporary TABLE nocat (</p> <div class="remarkup-code-block" data-code-lang="text" data-sigil="remarkup-code-block"><pre class="remarkup-code">nocat_id int(8) unsigned NOT NULL, nocat_namespace tinyint(2) unsigned NOT NULL</pre></div> <p>default '0',</p> <div class="remarkup-code-block" data-code-lang="text" data-sigil="remarkup-code-block"><pre class="remarkup-code">nocat_title varchar(255) binary NOT NULL default '', UNIQUE KEY id (nocat_id), KEY title (nocat_title)</pre></div> <p>) TYPE=MyISAM PACK_KEYS=0;<br /> insert into nocat (nocat_id, nocat_namespace, <br /> nocat_title)<br /> SELECT uncat_nocat_id, cur_namespace, cur_title from <br /> cur, uncat_nocat<br /> WHERE cur_id=uncat_nocat_id and cur_is_redirect=0;<br /> drop table uncat_nocat;</p> <p>/* 4. finally the query we are really after */<br /> SELECT 'Uncategorizedpages' as type, nocat_namespace <br /> AS namespace, nocat_title AS title, nocat_title AS <br /> value<br /> FROM nocat<br /> ORDER BY nocat_title /*limit 50*/;</p> <p>/* cleanup */<br /> drop table nocat;</p> <hr class="remarkup-hr" /> <p><strong>Version</strong>: unspecified<br /> <strong>Severity</strong>: normal</p></div></div></div></div></div><div class="phui-box phui-box-border phui-object-box mlt mll mlr phui-box-blue-property "><div class="phui-header-shell "><h1 class="phui-header-view"><div class="phui-header-row"><div class="phui-header-col2"><span class="phui-header-header">Details</span></div><div class="phui-header-col3"></div></div></h1></div><div class="phui-property-list-section"><div class="phui-property-list-container grouped"><div class="phui-property-list-properties-wrap "><dl class="phui-property-list-properties"><dt class="phui-property-list-key">Reference </dt><dd class="phui-property-list-value">bz449 </dd></dl></div></div></div></div><div class="phui-timeline-view" id="UQ0_2"><h3 class="aural-only">Event Timeline</h3><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell phui-timeline-yellow" data-sigil="transaction anchor-container" data-meta="0_16"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/ovytmbleapqqbp2q34as/PHID-FILE-ukx4a3vvpumxtlt3rof2/profile-Screen_Shot_2014-11-24_at_10.24.10_AM.png)" class="visual-only phui-timeline-image" href="/p/bzimport/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="28548" id="28548" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill fill-has-color phui-timeline-icon-fill-yellow"><span class="visual-only phui-icon-view phui-font-fa fa-arrow-up phui-timeline-icon" data-meta="0_12" aria-hidden="true"></span></span><a href="/p/bzimport/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_0"><span class="perfect-circle">•</span> bzimport</a> raised the priority of this task from <span class="phui-timeline-value"></span> to <span class="phui-timeline-value">Medium</span>.<span class="phui-timeline-extra"><a href="#28548" data-sigil="has-tooltip" data-meta="0_11"><span class="screen-only">Nov 21 2014, 6:49 PM</span><span class="print-only" aria-hidden="true">2014-11-21 18:49:00 (UTC+0)</span></a></span></div><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-link phui-timeline-icon" data-meta="0_13" aria-hidden="true"></span></span><a href="/p/bzimport/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_1"><span class="perfect-circle">•</span> bzimport</a> added a project: <a href="/tag/mediawiki-special-pages/" class="phui-handle" data-sigil="hovercard" data-meta="0_2">MediaWiki-Special-pages</a>.</div><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-pencil phui-timeline-icon" data-meta="0_14" aria-hidden="true"></span></span><a href="/p/bzimport/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_3"><span class="perfect-circle">•</span> bzimport</a> set Reference to bz449.</div><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-plus phui-timeline-icon" data-meta="0_15" aria-hidden="true"></span></span><a href="/p/bzimport/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_4"><span class="perfect-circle">•</span> bzimport</a> added a subscriber: <span class="phui-handle" data-sigil="hovercard" data-meta="0_5">Unknown Object (MLST)</span>.</div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_19"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/ovytmbleapqqbp2q34as/PHID-FILE-ukx4a3vvpumxtlt3rof2/profile-Screen_Shot_2014-11-24_at_10.24.10_AM.png)" class="visual-only phui-timeline-image" href="/p/bzimport/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="28551" id="28551" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-pencil phui-timeline-icon" data-meta="0_18" aria-hidden="true"></span></span><a href="/p/bzimport/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_6"><span class="perfect-circle">•</span> bzimport</a> created this task.<span class="phui-timeline-extra"><a href="#28551" data-sigil="has-tooltip" data-meta="0_17"><span class="screen-only">Sep 11 2004, 2:29 AM</span><span class="print-only" aria-hidden="true">2004-09-11 02:29:00 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_28"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/ovytmbleapqqbp2q34as/PHID-FILE-ukx4a3vvpumxtlt3rof2/profile-Screen_Shot_2014-11-24_at_10.24.10_AM.png)" class="visual-only phui-timeline-image" href="/p/bzimport/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="28552" id="28552" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_27" aria-hidden="true"></span></span><a href="/p/bzimport/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_7"><span class="perfect-circle">•</span> bzimport</a> added a comment.<span class="phui-timeline-extra"><a href="#28552" data-sigil="has-tooltip" data-meta="0_26"><span class="screen-only">Jan 2 2006, 2:35 PM</span><span class="print-only" aria-hidden="true">2006-01-02 14:35:05 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_24"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_25" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_8"><div class="phabricator-remarkup"><p><strong>robchur</strong> wrote:</p> <p>Bumped: Is this relevant with our new schema?</p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_37"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/ktpxiau6eswechswlmd7/PHID-FILE-2vlsbryc7loxstbithpy/profile)" class="visual-only phui-timeline-image" href="/p/demon/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="28558" id="28558" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_36" aria-hidden="true"></span></span><a href="/p/demon/" class="phui-handle handle-availability-disabled phui-link-person" data-sigil="hovercard" data-meta="0_9"><span class="perfect-circle">•</span> demon</a> added a comment.<span class="phui-timeline-extra"><a href="#28558" data-sigil="has-tooltip" data-meta="0_35"><span class="screen-only">Feb 1 2009, 6:51 AM</span><span class="print-only" aria-hidden="true">2009-02-01 06:51:00 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_33"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_34" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_10"><div class="phabricator-remarkup"><p>While UncategorizedPages still is a crappy query, absolutely none of the above applies (cur and friends don't even exist anymore). Closing as INVALID.</p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div></div><div class="phui-box phui-box-border phui-object-box mlt mll mlr phui-object-box-flush "><a class="login-to-comment button" href="/login/?next=">Log In to Comment</a></div></div></div></div><div class="phui-two-column-content phui-two-column-footer"></div></div></div><div class="phabricator-standard-page-footer grouped"><span>Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct.</span> · <a href="https://wikimediafoundation.org/">Wikimedia Foundation</a> · <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Non-wiki_privacy_policy">Privacy Policy</a> · <a href="https://www.mediawiki.org/wiki/Special:MyLanguage/Code_of_Conduct">Code of Conduct</a> · <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use/Phabricator">Terms of Use</a> · <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:General_disclaimer">Disclaimer</a> · <a href="https://creativecommons.org/licenses/by-sa/4.0/">CC-BY-SA</a> · <a href="https://www.gnu.org/licenses/old-licenses/gpl-2.0.html">GPL</a> · <a href="https://www.mediawiki.org/wiki/Phabricator/Credits">Credits</a></div></div></div></div><script type="text/javascript" src="https://phab.wmfusercontent.org/res/defaultX/phabricator/2eeda9e0/core.pkg.js"></script><data data-javelin-init-kind="merge" data-javelin-init-data="{"block":0,"data":[{"hovercardSpec":{"objectPHID":"PHID-USER-ynivjflmc2dcl6w5ut5v"}},{"hovercardSpec":{"objectPHID":"PHID-USER-ynivjflmc2dcl6w5ut5v"}},{"hovercardSpec":{"objectPHID":"PHID-PROJ-4ae4jcwy4qaqp7r2cfeg"}},{"hovercardSpec":{"objectPHID":"PHID-USER-ynivjflmc2dcl6w5ut5v"}},{"hovercardSpec":{"objectPHID":"PHID-USER-ynivjflmc2dcl6w5ut5v"}},{"hovercardSpec":{"objectPHID":"PHID-MLST-3n6f7yggtuz4ktrvskho"}},{"hovercardSpec":{"objectPHID":"PHID-USER-ynivjflmc2dcl6w5ut5v"}},{"hovercardSpec":{"objectPHID":"PHID-USER-ynivjflmc2dcl6w5ut5v"}},{"phid":"PHID-XACT-TASK-jwnkao4a2tafgay"},{"hovercardSpec":{"objectPHID":"PHID-USER-oetk6bbl6omm354ejz3b"}},{"phid":"PHID-XACT-TASK-pm6vmfzxhfwytw4"},{"tip":"Via Conduit"},[],[],[],[],{"phid":"PHID-XACT-TASK-zczjr6mgs6f4chj","anchor":"28548"},{"tip":"Via Old World"},[],{"phid":"PHID-XACT-TASK-836d1fcadfc7701","anchor":"28551"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-jwnkao4a2tafgay\/","ref":"T2449#28552"},[],{"anchor":"28552"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_4\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_20\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_21\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_6\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-jwnkao4a2tafgay\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_22\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_23\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-jwnkao4a2tafgay","anchor":"28552"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-pm6vmfzxhfwytw4\/","ref":"T2449#28558"},[],{"anchor":"28558"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_8\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_29\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_30\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_10\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-pm6vmfzxhfwytw4\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_31\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_32\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-pm6vmfzxhfwytw4","anchor":"28558"},[],[],{"itemIDs":["UQ0_14","UQ0_15","UQ0_16","UQ0_17","UQ0_18"],"caretID":"UQ0_13"},[],[],[],[],[],[],{"itemIDs":["UQ0_26","UQ0_27"],"caretID":"UQ0_25"},[],[],[],[],[],[],[],{"hovercardSpec":{"objectPHID":"PHID-USER-ynivjflmc2dcl6w5ut5v"}},[],{"hovercardSpec":{"objectPHID":"PHID-PROJ-4ae4jcwy4qaqp7r2cfeg"}},{"hovercardSpec":{"objectPHID":"PHID-USER-oetk6bbl6omm354ejz3b"}},{"hovercardSpec":{"objectPHID":"PHID-USER-cqtipia3tizutncgpwpr"}},{"menuID":"UQ0_0"},[],[],[],[],[],{"map":{"UQ0_41":"phabricator-search-menu-expanded","UQ0_96":"menu-icon-selected"}},{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_43\" class=\"phabricator-action-view phabricator-action-view-type-label\" style=\"\"\u003e\u003cspan class=\"phabricator-action-view-item\"\u003eQueries\u003c\/span\u003e\u003c\/li\u003e\u003cli id=\"UQ0_45\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/7QeK_wflJk_7\/\" class=\"phabricator-action-view-item\"\u003eNewest Open Tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_47\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/all\/\" class=\"phabricator-action-view-item\"\u003eAll Tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_49\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/open\/\" class=\"phabricator-action-view-item\"\u003eOpen Tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_51\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/oqCBTAiQBgwa\/\" class=\"phabricator-action-view-item\"\u003eAuthored (oldest open)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_53\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/SH5VKrDBlEU3\/\" class=\"phabricator-action-view-item\"\u003eClosed by me\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_55\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/gd6mG.hk3..e\/\" class=\"phabricator-action-view-item\"\u003eOpen + Subscribed\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_57\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/9T8LzvTiy5gR\/\" class=\"phabricator-action-view-item\"\u003eOpen or Resolved tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_59\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/AtbLhf4ZUBGj\/\" class=\"phabricator-action-view-item\"\u003eUnbreak Now! (Newest first)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_61\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/NIBnes9aVyDQ\/\" class=\"phabricator-action-view-item\"\u003eUnbreak Now! (Oldest first)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_63\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/WKC5LNTfaXCf\/\" class=\"phabricator-action-view-item\"\u003eWikimedia-Incident - To Triage column\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_65\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/GTbIUdDaMLqV\/\" class=\"phabricator-action-view-item\"\u003eMediaWiki Train Deployments\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_67\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/KpRagEN3fCBC\/\" class=\"phabricator-action-view-item\"\u003e#RelEng To Triage - Oldest first\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_69\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/mkOQwHTmvsGv\/\" class=\"phabricator-action-view-item\"\u003e#RelEng - Latest Project-Admins tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_71\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/CnG3iW9ba4Sm\/\" class=\"phabricator-action-view-item\"\u003e#RelEng - Latest WMF-NDA tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_73\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/dXiDCQ1lr2TH\/\" class=\"phabricator-action-view-item\"\u003ePrivacy Engineering (Incoming)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_75\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/8bHBE5y3nW0T\/\" class=\"phabricator-action-view-item\"\u003eSecurity (Needs Triage)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_77\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/aWhl5RAqasgr\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (Incoming)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_79\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/AV_XTZmS8sSZ\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (Back Order) But Assigned\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_81\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/hPw5AfNlfd5X\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (In Progress) By Assigned\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_83\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/ylGCqhVtsW5D\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (Watching) No Update 30 Days\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_85\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/ZfhewVYD.6v2\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (In Progress) But Closed or Stalled\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_87\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/gb3pNSWyyZm1\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team Assigned But No Updates 30 days\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_89\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/1G5egePmdpkZ\/\" class=\"phabricator-action-view-item\"\u003eSecurity Readiness Reviews (Incoming)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_91\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/skCqxOTyF9gX\/\" class=\"phabricator-action-view-item\"\u003eWMCS extended backlog\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_93\" class=\"phabricator-action-view phabricator-action-view-type-label\" style=\"\"\u003e\u003cspan class=\"phabricator-action-view-item\"\u003eSearch\u003c\/span\u003e\u003c\/li\u003e\u003cli id=\"UQ0_95\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/advanced\/\" class=\"phabricator-action-view-item\"\u003eAdvanced Search\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"items":[{"name":"Search"},{"icon":"fa-globe","name":"All Documents","value":"all"},{"icon":"fa-anchor","name":"Current Application","value":"application"},{"name":"Saved Queries"},{"icon":"fa-certificate","name":"Open Documents","value":"open"},{"icon":"fa-certificate","name":"Authored Documents","value":"MaJUpIp4XQjD"},{"icon":"fa-certificate","name":"Subscribed Documents","value":"icqHFhjyxmbF"},{"icon":"fa-certificate","name":"Owned Documents","value":"xCgkkySoe4z7"},{"icon":"fa-certificate","name":"Open Tasks","value":"open-tasks"},{"name":"More Options"},{"icon":"fa-search-plus","name":"Advanced Search","href":"\/search\/query\/advanced\/"},{"icon":"fa-book","name":"User Guide: Search","href":"https:\/\/we.phorge.it\/diviner\/find\/?name=Search%20User%20Guide&type=article&jump=1"}],"icon":"fa-globe","value":"all"},[],[],[],[]]}"></data><data data-javelin-init-kind="behaviors" data-javelin-init-data="{"refresh-csrf":[{"tokenName":"__csrf__","header":"X-Phabricator-Csrf","viaHeader":"X-Phabricator-Via","current":"B@5h2oe3446d07577b92fcff81"}],"history-install":[]}"></data><data data-javelin-init-kind="behaviors" data-javelin-init-data="{"phabricator-tooltips":[],"phui-hovercards":[],"phabricator-transaction-list":[],"phabricator-show-older-transactions":[{"timelineID":"UQ0_2","viewData":[]}],"phabricator-watch-anchor":[],"phui-dropdown-menu":[],"phui-submenu":[],"workflow":[],"lightbox-attachments":[],"aphront-form-disable-on-submit":[],"toggle-class":[],"phabricator-gesture":[],"device":[],"high-security-warning":[{"show":false,"uri":"\/auth\/session\/downgrade\/","message":"Your session is in high security mode. When you finish using it, click here to leave."}],"phabricator-keyboard-shortcuts":[{"helpURI":"\/help\/keyboardshortcut\/","searchID":"UQ0_97","pht":{"\/":"Give keyboard focus to the search box.","?":"Show keyboard shortcut help for the current page."}}],"phabricator-search-typeahead":[{"id":"UQ0_98","input":"UQ0_97","button":"UQ0_99","selectorID":"UQ0_100","applicationID":"UQ0_101","defaultApplicationIcon":"fa-dot-circle-o","appScope":"application","src":"\/typeahead\/class\/PhabricatorSearchDatasource\/","limit":10,"placeholder":"Search","scopeUpdateURI":"\/settings\/adjust\/?key=search-scope"}],"quicksand-blacklist":[{"patterns":["\/phame\/live\/.*","\/conpherence\/.*","\/Z\\d+","\/file\/(data|download)\/.*","\/phortune\/.*","\/auth\/.*"]}]}"></data></body></html>