Page MenuHomePhabricator

Gadget usage statistics for Portuguese Wikipedia
Closed, ResolvedPublic


This issue was converted from
Summary: User preferences usage on Portuguese Wikipedia
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Open
Assignee: @Alchimista

From: @He7d3r
Date: Sun, 28 Oct 2012 17:59:19

I would like to get a table like this
for Portuguese Wikipedia.

This might be useful to get it:

See Also:
T21288: Gadget usage statistics



Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:34 AM
bzimport set Reference to bz59480.

From: alchimista <>

Date: Mon, 29 Oct 2012 21:42:05

I can do it Helder, can we talk locally and discuss how do you want it, and * when *?

This query request is old. If you no longer require this query to be run, please close this bug as WONTFIX. Thanks!

Ideally, these stats should be updated periodically, but I would like an update before closing this. This is mostly useful to keep an updated table on
as a workaround for bug 19288.

TTO triaged this task as Lowest priority.Nov 26 2014, 11:42 AM
TTO updated the task description. (Show Details)
TTO set Security to None.

use ptwiki_p;
SELECT up_property,up_value,COUNT(*) FROM user_properties WHERE up_property LIKE 'gadget%' GROUP BY up_property,up_value;

Resultset (0 rows) on
(due to T60196?)

He7d3r renamed this task from DBQ-197 User preferences usage on Portuguese Wikipedia to Gadget usage statistics for Portuguese Wikipedia.Apr 11 2015, 2:23 PM

Here's my query:

  SUBSTR(up_property, 8) as gadget, 
  CAST(up_value AS SIGNED) AS enabled, 
  COUNT(DISTINCT up_user) AS users,
  IFNULL(SUM(recent_edits > 0), 0) AS recently_active_users
FROM user_properties
    rev_user AS user_id,
    COUNT(*) AS recent_edits
  FROM revision
  WHERE rev_timestamp BETWEEN "20140411" AND "20150411"
  GROUP BY rev_user
) AS recent_activity ON user_id = up_user
WHERE up_property LIKE 'gadget-%'
GROUP BY up_property, up_value;
He7d3r claimed this task.