Untitled query #17569

SQL

USE svwiki_p;

SELECT rc_user_text, COUNT(*) AS antal, MIN(rc_timestamp) AS first, MAX(rc_timestamp) AS last, SUM(rc_new_length)-SUM(rc_old_length) AS volym FROM recentchanges WHERE
rc_title='Artikelnomineringar' 
#AND
#rc_namespace=4
GROUP BY rc_user_text
ORDER BY antal 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...
