Untitled query #58544

This query is marked as a draft This query has been published by Larske.
SQL

SELECT COUNT(log_timestamp) AS antal, SUBSTRING(log_timestamp,1,4) AS year from logging JOIN actor ON log_actor=actor_id WHERE 
/*
SELECT log_timestamp, log_title, actor_name FROM logging JOIN actor on log_actor=actor_id WHERE 
*/
log_type = 'thanks'
AND log_timestamp > '20140101000000'
AND actor_name = 'Larske'
GROUP BY year
ORDER BY year

/*
SELECT REPLACE(log_title,'_',' ') FROM logging JOIN comment ON log_comment_id=comment_id WHERE 
log_action = 'delete'
AND comment_text LIKE 'Not_found_in_source'
AND log_timestamp > '20200901000000'
AND log_timestamp < '20201001000000'
ORDER BY log_timestamp
*/

/*
SELECT page_title FROM categorylinks JOIN page ON cl_from=page_id WHERE
cl_to = 'Robotskapade_artiklar_2014-06'
AND NOT EXISTS (SELECT page_title FROM categorylinks JOIN page ON cl_from=page_id JOIN langlinks ON page_id=ll_from WHERE 
cl_to = 'Robotskapade_artiklar_2014-06'
AND ll_lang = 'ceb')
*/


/*
SELECT SUBSTRING_INDEX(el_to_path,'/',2) AS del, COUNT(*) AS antal FROM externallinks WHERE
el_to_domain_index LIKE 'https://org.runeberg.'
GROUP BY del
ORDER BY antal DESC, del
*/

/*
SELECT COUNT(*) AS antal FROM externallinks JOIN page ON el_from=page_id WHERE
page_namespace=0 AND
el_to_domain_index LIKE 'http://org.runeberg.';

SELECT COUNT(*) AS antal FROM externallinks JOIN page ON el_from=page_id WHERE
page_namespace=0 AND
el_to_domain_index LIKE 'https://org.runeberg.';
*/



/*
SELECT REPLACE(pl_title,'_',' ') AS rödlänk, COUNT(pl_from) AS antal FROM pagelinks WHERE
pl_namespace = 0 AND
pl_from_namespace = 0 AND
NOT EXISTS ( SELECT page_title FROM page WHERE page_title=pl_title AND page_namespace = 0 )
GROUP BY rödlänk
ORDER BY antal DESC
*/
/*
SELECT log_timestamp, log_action, log_title, actor_name, comment_text FROM logging JOIN actor ON log_actor=actor_id JOIN comment ON log_comment_id=comment_id WHERE
*/
/*
SELECT actor_name, COUNT(*) AS antal FROM logging JOIN actor on log_actor=actor_id WHERE
*/

/*
SELECT actor_name, COUNT(*) AS antal FROM logging JOIN actor on log_actor=actor_id WHERE
log_timestamp > '20211025000000'
AND log_action = 'delete'
AND log_namespace = 10
AND log_title LIKE '%stub%'
GROUP BY actor_name
ORDER BY antal DESC, actor_name;


SELECT comment_text AS raderingskommentar, COUNT(*) AS antal FROM logging JOIN comment ON log_comment_id=comment_id WHERE
log_timestamp > '20211025000000'
AND log_action = 'delete'
AND log_namespace = 10
AND log_title LIKE '%stub%'
GROUP BY raderingskommentar
ORDER BY antal DESC, raderingskommentar
/*
ORDER BY log_timestamp DESC
*/

/*
SELECT lt_title AS mall, COUNT(*) AS antal_artiklar from templatelinks JOIN page ON tl_from=page_id JOIN linktarget ON tl_target_id = lt_id WHERE
lt_namespace = 10
AND page_namespace = 0
AND lt_title LIKE '%stub%'
AND NOT lt_title LIKE 'Robotskapad%'
GROUP BY lt_title
ORDER BY antal_artiklar DESC, mall
*/

/*
SELECT RAND();
SELECT page_id, page_title FROM page JOIN categorylinks on page_title=cl_to WHERE 
page_namespace = 0
AND page_is_redirect = 0
AND page_random >= RAND()
ORDER BY page_random
LIMIT 1
*/

/*
SELECT * FROM logging WHERE
log_action = 'block'
AND log_timestamp > '20220814000000'
AND log_params LIKE '%"sitewide";b:0;%'
*/

/*SELECT ipb_timestamp, ipb_expiry, ipb_address, page_title, comment_text, actor_name  FROM ipblocks JOIN comment ON ipb_reason_id=comment_id JOIN actor ON ipb_by_actor=actor_id JOIN ipblocks_restrictions ON ir_ipb_id=ipb_id JOIN page on page_id=ir_value
WHERE ipb_sitewide = 0
AND ipb_timestamp > '20220914000000'
ORDER BY ipb_timestamp DESC
*/

/*
SELECT LEFT(log_timestamp,8) AS Datum, COUNT(*) AS Antal FROM logging WHERE 
log_action = 'block'
AND log_timestamp > '20220101000000'
AND log_timestamp < '20230101000000'
GROUP BY Datum
ORDER BY Datum
*/
/*
SELECT FLOOR(DATEDIFF(CONCAT(LEFT(log_timestamp,4),'/',MID(log_timestamp,5,2),'/',MID(log_timestamp,7,2)), '2022/01/03')/7)+1 AS Vecka, COUNT(*) AS antal FROM logging WHERE
log_action = 'block'
AND log_timestamp > '20220103000000'
AND log_timestamp < '20230102000000'
GROUP BY Vecka
ORDER BY Vecka
*/


/*
SELECT   CONCAT(MID(log_timestamp,3,2),MID(log_timestamp,5,2)) AS Månad, COUNT(*) AS Antal FROM logging WHERE
log_action = 'block'
AND log_timestamp > '20200101000000'
AND log_timestamp < '20230801000000'
GROUP BY Månad
ORDER BY Månad
*/

/*
SELECT page_namespace, CONCAT('[[',IF(page_namespace=10,'Mall:',IF(page_namespace=14,':Kategori:','')),page_title,']]') AS artikel FROM page WHERE
*/
/*SELECT page_title FROM page WHERE
page_title LIKE '%ß%'
AND page_is_redirect = 1
AND (page_namespace = 0 OR page_namespace = -10 OR page_namespace = -14)
ORDER BY page_namespace, page_title
*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
