Lucas_Werkmeister_WMDE added a comment.
Not very many users are using it, as far as I can tell. I won’t share the
exact result numbers, but sharing the queries in case anyone wants to check I
didn’t do something stupid:
MariaDB [wikidatawiki]> SELECT up_value, COUNT(*) FROM user_properties
WHERE up_property = 'VectorSkinVersion' GROUP BY up_value;
**Between 500 and 600 users**, total, have `VectorSkinVersion` set to 2,
**compared to over 900k** having it set to 1. (A handful have it set to 0,
which confuses me, and if I understand correctly, for users who never touched
the preference it wouldn’t be set at all? But it seems unlikely that almost a
million users would have manually set it to 1…)
MariaDB [wikidatawiki]> SELECT up_value, COUNT(*) FROM user_properties
WHERE up_property = 'VectorSkinVersion' AND EXISTS (SELECT * FROM recentchanges
WHERE rc_actor = (SELECT actor_id FROM actor WHERE actor_user = up_user)) GROUP
BY up_value;
Just under 300 users who made at least one edit in the past 30 days have the
preference set to 2, compared to just under 12k having it set to 1.
MariaDB [wikidatawiki]> SELECT up_value, COUNT(*) FROM user_properties
WHERE up_property = 'VectorSkinVersion' AND (SELECT COUNT(*) FROM recentchanges
WHERE rc_actor = (SELECT actor_id FROM actor WHERE actor_user = up_user)) >=
100 GROUP BY up_value;
A bit over 100 very active editors (≥100 edits in the past 30 days) have it
set to 2, compared to over 1300 very active editors having it set to 1.
TASK DETAIL
https://phabricator.wikimedia.org/T275251
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Lucas_Werkmeister_WMDE
Cc: SCherukuwada, nray, Michael, Lucas_Werkmeister_WMDE, Volker_E, Manuel,
karapayneWMDE, GreenReaper, R4356th, despens, darthmon_wmde, WMDE-leszek,
daniel, sdkim, alexhollender, LGoto, Yair_rand, MPhamWMF, ovasileva, Addshore,
Lydia_Pintscher, Aklapper, Jdlrobson, Nishu02, Romain, Patafisik_WMF,
Invadibot, Selby, caldera, maantietaja, Akuckartz, Demian, WDoranWMF,
EvanProdromou, DannyS712, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden,
LawExplorer, Winter, JJMC89, Iniquity, _jensen, rosalieper, Agabi10,
Scott_WUaS, Pchelolo, Niedzielski, Izno, Wikidata-bugs, aude, GWicke,
Dinoguy1000, Mbch331, Jay8g
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
