Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P2108
enwiki searchNs properties
Active
Public
Actions
Authored by
Krenair
on Sep 28 2015, 10:46 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F2643881: enwiki searchNs properties
Sep 28 2015, 10:46 PM
2015-09-28 22:46:31 (UTC+0)
Subscribers
None
mysql:research@analytics-store.eqiad.wmnet [enwiki]> select up_property, up_value, count(*) from user_properties where up_property like 'searchNs%' group by up_property, up_value;
+-----------------------------+----------+----------+
| up_property | up_value | count(*) |
+-----------------------------+----------+----------+
| searchNs-0 | 1 | 432 |
| searchNs-1 | 0 | 9632094 |
| searchNs-1 | 1 | 4 |
| searchNs-10 | 1 | 4 |
| searchNs-100 | 1 | 3 |
| searchNs-101 | 1 | 2 |
| searchNs-108 | 1 | 3 |
| searchNs-109 | 1 | 3 |
| searchNs-11 | 1 | 5 |
| searchNs-12 | 1 | 5 |
| searchNs-13 | 1 | 4 |
| searchNs-14 | 1 | 5 |
| searchNs-15 | 1 | 4 |
| searchNs-2 | 1 | 4 |
| searchNs-3 | 1 | 3 |
| searchNs-4 | 1 | 4 |
| searchNs-446 | 1 | 3 |
| searchNs-447 | 1 | 3 |
| searchNs-5 | 1 | 4 |
| searchNs-6 | 1 | 3 |
| searchNs-7 | 1 | 3 |
| searchNs-710 | 1 | 3 |
| searchNs-711 | 1 | 3 |
| searchNs-8 | 1 | 4 |
| searchNs-828 | 1 | 3 |
| searchNs-829 | 1 | 3 |
| searchNs-9 | 1 | 5 |
| searchNs0 | | 12886 |
| searchNs0 | 0 | 4575 |
| searchNs1 | 1 | 40393 |
| searchNs10 | 1 | 33830 |
| searchNs100 | 1 | 35731 |
| searchNs101 | 1 | 26020 |
| searchNs106 | 0 | 1755 |
| searchNs106 | 1 | 25 |
| searchNs107 | 0 | 1767 |
| searchNs107 | 1 | 13 |
| searchNs108 | 1 | 13372 |
| searchNs109 | 1 | 9459 |
| searchNs11 | 1 | 237016 |
| searchNs118 | 1 | 1254 |
| searchNs119 | 1 | 1141 |
| searchNs12 | 1 | 108382 |
| searchNs13 | 1 | 26880 |
| searchNs14 | 1 | 42326 |
| searchNs15 | 1 | 28511 |
| searchNs2 | 1 | 43034 |
| searchNs2300 | 1 | 77 |
| searchNs2301 | 1 | 75 |
| searchNs2302 | 1 | 78 |
| searchNs2303 | 1 | 76 |
| searchNs2600 | 1 | 597 |
| searchNs3 | 1 | 35595 |
| searchNs4 | 1 | 70200 |
| searchNs4294967295 | 0 | 247058 |
| searchNs442 | 1 | 21 |
| searchNs443 | 1 | 17 |
| searchNs444 | 1 | 20 |
| searchNs445 | 1 | 16 |
| searchNs446 | 1 | 3668 |
| searchNs447 | 1 | 3012 |
| searchNs5 | 1 | 37722 |
| searchNs6 | 1 | 49632 |
| searchNs7 | 1 | 30864 |
| searchNs710 | 1 | 2518 |
| searchNs711 | 1 | 2354 |
| searchNs8 | 1 | 40388 |
| searchNs828 | 1 | 2278 |
| searchNs829 | 1 | 2055 |
| searchNs866 | 1 | 8 |
| searchNs867 | 1 | 5 |
| searchNs9 | 1 | 299449 |
| searchNs90 | 1 | 12 |
| searchNs91 | 1 | 11 |
| searchNs92 | 1 | 13 |
| searchNs93 | 1 | 10 |
| searchNsNS_LQT_SUMMARY | 1 | 21 |
| searchNsNS_LQT_SUMMARY_TALK | 1 | 21 |
| searchNsNS_LQT_THREAD | 1 | 21 |
| searchNsNS_LQT_THREAD_TALK | 1 | 21 |
+-----------------------------+----------+----------+
80 rows in set (5 min 25.06 sec)
Event Timeline
Krenair
edited the content of this paste.
(Show Details)
Sep 28 2015, 10:46 PM
2015-09-28 22:46:31 (UTC+0)
Krenair
changed the title of this paste from untitled to
enwiki searchNs properties
.
Krenair
updated the paste's language from
autodetect
to
autodetect
.
Jdforrester-WMF
mentioned this in
T114068: Clean up search user preferences in user_properties table on Wikimedia wikis
.
Sep 29 2015, 12:14 AM
2015-09-29 00:14:42 (UTC+0)
Log In to Comment