Untitled query #17569

SQL

USE svwiki_p;

SELECT * FROM logging WHERE
log_type = 'delete'
AND log_timestamp > '20210728000000'
LIMIT 100


/*
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...
