Untitled query #17569

SQL

USE svwiki_p;

SELECT rc_timestamp, rc_title, cl_to, rc_user_text FROM recentchanges INNER JOIN categorylinks ON rc_cur_id=cl_from
WHERE rc_new=1 
AND rc_namespace=0
AND cl_to LIKE '%chackspelare%'
ORDER BY rc_timestamp


/*
SELECT rc_user_text AS användare, COUNT(*) AS antal_red,
        SUM(IF(rc_new_len>rc_old_len+19,1,0)) AS antal_plusred, 
        SUM(IF(rc_new_len>rc_old_len+19,rc_new_len-rc_old_len,0)) AS volym_plusred, 
        SUM(IF(ABS(rc_new_len-rc_old_len)<20,1,0)) AS antal_putsred,
        SUM(IF(ABS(rc_new_len-rc_old_len)<20,ABS(rc_new_len-rc_old_len),0)) AS volym_putsred,
        SUM(IF(rc_new_len<rc_old_len-19,1,0)) AS antal_minusred, 
        SUM(IF(rc_new_len<rc_old_len-19,rc_old_len-rc_new_len,0)) AS volym_minusred FROM recentchanges WHERE
rc_title='Artikelnomineringar' 
AND rc_namespace=4
AND rc_type<5
GROUP BY användare
ORDER BY volym_plusred 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...
