User:SQL/Admin CSS-JS Editing
Appearance
< User:SQL
This query is a variation the Often cited "On the top five wikis, 75% of admins have never edited CSS/JS; 92% of admins have almost never done so." query. The thing is - we need to look in the context of editing other users css/js as well. This presents far different numbers:
The Query
|
---|
SELECT Sum(cnt=0
OR cnt IS NULL) 0_edits,
sum(cnt>0
AND cnt<=10) 1_10_edits,
sum(cnt>10
AND cnt<=100) 11_100_edits,
sum(cnt>100) 101_plus_edits
FROM user
JOIN user_groups
ON ug_group = 'sysop'
AND ug_user = user_id
LEFT JOIN
(
SELECT rev_user_text user,
count(*) cnt
FROM page STRAIGHT_JOIN revision
ON rev_page = page_id
WHERE page_title RLIKE '^.*\.(css|js)$'
AND !INSTR( page_title, rev_user_text )
GROUP BY rev_user_text) edits
ON user = user_name;
|
0_edits |1_10_edits |11_100_edits |101_plus_edits | --------|-----------|-------------|---------------| 396 |470 |254 |91 |
So, whom are the actual active admins here?
The Query II
|
---|
SELECT user_name,
cnt
FROM user
JOIN user_groups
ON ug_group = 'sysop'
AND ug_user = user_id
LEFT JOIN
(
SELECT rev_user_text user,
Count(*) cnt
FROM page straight_join revision
ON rev_page = page_id
WHERE page_title RLIKE '^.*\.(css|js)$'
AND !instr( page_title, rev_user_text )
GROUP BY rev_user_text) edits
ON user = user_name
ORDER BY cnt DESC;
|
Query is presently running