User:SQL/Admin CSS-JS Editing: Difference between revisions

Revision as of 19:27, 5 August 2018

Revision as of 19:34, 5 August 2018

Line 30:

--------|-----------|-------------|---------------|

396 |470 |254 |91 |

</pre>

So, whom are the actual active admins here?

{{collapse top|title=The Query II}}

<source lang="SQL">

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;

</source>

{{collapse bottom}}

<pre>

Query is presently running

</pre>