Untitled query #17569

SQL

USE svwiki_p;
/*
SET sql_mode='PIPES_AS_CONCAT';
select '- [['||pl_title||']] <!--'|| c ||' Links-->' as output
from (select pl_title , count(*) as c , pl_namespace
      from pagelinks 
      where pl_from_namespace=0 and pl_namespace=0
      group by pl_title, pl_namespace
      having count(*)>100) as pl
  left join page
    on (pl_title=page_title and page_namespace= pl_namespace)
where page_id is null
order by c desc
*/

/*
SELECT rc_user_text AS Användare, COUNT(rc_id) AS Redigeringar, MAX(rc_timestamp) AS Senaste  FROM recentchanges
WHERE rc_bot=0 AND rc_type < 5 
GROUP BY rc_user_text
HAVING Redigeringar > 19
ORDER BY Redigeringar DESC;
*/
/*
SELECT user_name, user_editcount from user
ORDER BY user_editcount DESC
LIMIT 100;
*/


/*SELECT el_from, el_to,  substring(el_to,20,999) AS what, INSTR(substring(el_to,21,999),'/') as pos, substring(el_to,21,INSTR(substring(el_to,21,999),'/')-1) as del FROM externallinks
*/
SELECT substring(el_to,21,INSTR(substring(el_to,21,999),'/')-1) AS del, COUNT(*) AS antal FROM externallinks
WHERE el_to LIKE 'http://runeberg.org%'
/*GROUP BY del*/
ORDER BY antal DESC
/*LIMIT 500

/*
DESCRIBE geo_tags;

SELECT gt_lat, gt_lon, gt_primary, rc_title, rc_timestamp, rc_type FROM recentchanges
INNER JOIN geo_tags ON gt_page_id = rc_cur_id
WHERE rc_user_text='Larske' AND rc_type<5 AND gt_primary=1
ORDER BY rc_timestamp ASC

/*
SELECT MID(rc_timestamp,1,10) AS timme, COUNT(DISTINCT rc_user_text)
FROM recentchanges
WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170603120000' AND rc_timestamp < '20170604000000' AND rc_bot LIKE '0' AND (rc_type LIKE '0' OR rc_type LIKE '1')
GROUP BY timme
ORDER BY timme 
LIMIT 1000;

USE trwiki_p;
SELECT MID(rc_timestamp,1,10) AS timme, COUNT(DISTINCT rc_user_text)
FROM recentchanges
WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170603120000' AND rc_timestamp < '20170604000000' AND rc_bot LIKE '0'  AND (rc_type LIKE '0' OR rc_type LIKE '1')
GROUP BY timme
ORDER BY timme 
LIMIT 1000
*/

/*
USE svwiki_p;
SELECT MID(rc_timestamp,1,8) AS dygn, COUNT(DISTINCT rc_user_text)
FROM recentchanges
WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170422000000' AND rc_timestamp < '2017050600000' AND rc_bot LIKE '0' AND (rc_type LIKE '0' OR rc_type LIKE '1')
GROUP BY dygn
ORDER BY dygn 
LIMIT 1000;

USE trwiki_p;
SELECT MID(rc_timestamp,1,8) AS dygn, COUNT(DISTINCT rc_user_text)
FROM recentchanges
WHERE rc_namespace LIKE '0' AND rc_timestamp > '20170422000000' AND rc_timestamp < '20170506000000' AND rc_bot LIKE '0' AND (rc_type LIKE '0' OR rc_type LIKE '1')
GROUP BY dygn
ORDER BY dygn 
LIMIT 1000
*/
SQL

Checking query status...
