Untitled query #17569

SQL

USE svwiki_p;

SELECT month, COUNT(*) AS antal FROM logging WHERE
log_action = 'delete'
AND log_timestamp > '20210101000000'
BIND(SUBSTR(timestamp,1,6) AS month)
GROUP BY month
ORDER BY month



/*
SELECT page_title, "§" x, rev_timestamp, "§" y, actor_name FROM page INNER JOIN revision ON page_id=rev_page INNER JOIN actor on rev_actor=actor_id
WHERE page_namespace = 4 
AND page_title LIKE 'Sidor_föreslagna_för_radering/%'
*/

/*
SELECT DISTINCT p1.page_namespace, p1.page_title, cl_to, pp_propname FROM categorylinks 
INNER JOIN page p1 ON cl_from=p1.page_id 
INNER JOIN category ON cl_to=cat_title
INNER JOIN page p2 ON cat_title=p2.page_title
INNER JOIN page_props ON p2.page_id=pp_page
WHERE ((p1.page_namespace = 2 AND p1.page_title LIKE '%/%') OR p1.page_namespace= 3)
AND p1.page_title NOT LIKE 'Lsjbot%'
*/
SQL

Checking query status...
