Untitled query #17569

SQL

USE svwiki_p;

SELECT rc_user_text, COUNT(*) AS antal_red, 
        SUM(IF(rc_new_len>rc_old_len,1,0)) AS antal_plus_red, 
        SUM(IF(rc_new_len>rc_old_len,rc_new_len-rc_old_len,0)) AS volym_plus_red, 
        SUM(IF(rc_new_len<rc_old_len,1,0)) AS antal_minus_red, 
        SUM(IF(rc_new_len<rc_old_len,rc_old_len-rc_new_len,0)) AS volym_minus_red FROM recentchanges WHERE
rc_title='Artikelnomineringar' 
AND rc_namespace=4
AND rc_type<5
#GROUP BY rc_user_text
ORDER BY rc_user_text, antal_red DESC, volym_plus_red DESC

/*
SELECT tl_title, COUNT(page_id) AS antal FROM templatelinks INNER JOIN page on tl_from=page_id WHERE
tl_title LIKE 'Illustrationsbehov%'
AND tl_namespace=10
AND page_namespace=0
GROUP BY tl_title
ORDER BY tl_title
*/

/*
SELECT page_title, rev_timestamp, rev_user_text FROM categorylinks INNER JOIN page ON cl_from=page_id INNER JOIN revision on page_id=rev_page 
WHERE cl_to = 'Mallar_för_illustrationsbehov'
AND rev_parent_id=0
ORDER BY rev_timestamp
*/

/*
SELECT * FROM recentchanges WHERE
rc_user_text LIKE 'Larske%' 
*/

/*
SELECT el_to FROM externallinks WHERE el_to LIKE '%www.iucnredlist%' AND
LENGTH(el_to)>27
*/

/*
SELECT NOW();
SELECT COUNT(*) FROM externallinks WHERE el_to LIKE '%www.iucnredlist%';
SELECT NOW();
SELECT COUNT(*) FROM externallinks WHERE el_to LIKE '%oldredlist%';
SELECT NOW();
*/

/*
SELECT rev_user_text, rev_timestamp FROM revision WHERE
rev_comment LIKE '%WP:HG%'
*
/*
SELECT log_action,log_title, log_user, user_name, log_timestamp, log_params FROM logging INNER JOIN user ON log_user=user_id WHERE
#log_action = 'block'
log_timestamp > '20160701000000'
#AND log_timestamp < '20180201000000'
#AND log_title = '213.204.35.226'
AND log_params LIKE '%06-15%'
#AND log_title LIKE '%:%'
#AND LENGTH(log_title)>30
#AND SUBSTR(log_title,5,1)=':'
#log_timestamp > '20180518000000'
ORDER BY log_timestamp DESC
#GROUP BY log_title
#ORDER BY log_title
*/
SQL

Checking query status...
