Page MenuHomePhabricator
Paste P7517

wllimit=0 and watchlistdays=0
ActivePublic
Actions

Authored by SBisson on Sep 5 2018, 6:46 PM.
Tags
None
Referenced Files
F25669287: wllimit=0 and watchlistdays=0
Sep 5 2018, 6:55 PM
F25669208: wllimit=0 and watchlistdays=0
Sep 5 2018, 6:46 PM
Subscribers
None
-- USERS WITH LIMIT=0, DAYS=0 ACTIVE THIS YEAR
mysql:research@s3-analytics-slave [enwiki]> select count(user_id) from user inner join user_properties as upl on user_id=upl.up_user and upl.up_property='wllimit' and upl.up_value in (0, '0') inner join user_properties as upd on user_id=upd.up_user and upd.up_property='watchlistdays' and upd.up_value in (0, '0') where user_touched >= 20180101000000;
+----------------+
| count(user_id) |
+----------------+
| 1764 |
+----------------+
1 row in set (0.68 sec)
-- USERS WITH LIMIT=0, DAYS=0, WHO HAVE OPTED OUT OF WLFILTERS ACTIVE THIS YEAR
mysql:research@s3-analytics-slave [enwiki]> select count(user_id) from user inner join user_properties as upl on user_id=upl.up_user and upl.up_property='wllimit' and upl.up_value in (0, '0') inner join user_properties as upd on user_id=upd.up_user and upd.up_property='watchlistdays' and upd.up_value in (0, '0') inner join user_properties as upr on user_id=upr.up_user and upr.up_property='wlenhancedfilters-disable' and upr.up_value in (1, '1') where user_touched >= 20180101000000;
+----------------+
| count(user_id) |
+----------------+
| 1 |
+----------------+
1 row in set (6.87 sec)
-- USERS WITH LIMIT>0, DAYS=0 WHO HAVE OPTED OUT OF WLFILTERS ACTIVE THIS YEAR
mysql:research@s3-analytics-slave [enwiki]> select count(user_id) from user inner join user_properties as upl on user_id=upl.up_user and upl.up_property='wllimit' and upl.up_value > 0 inner join user_properties as upd on user_id=upd.up_user and upd.up_property='watchlistdays' and upd.up_value in (0, '0') inner join user_properties as upr on user_id=upr.up_user and upr.up_property='wlenhancedfilters-disable' and upr.up_value in (1, '1') where user_touched >= 20180101000000;
+----------------+
| count(user_id) |
+----------------+
| 1 |
+----------------+
1 row in set (0.02 sec)
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. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL