Untitled query #58544

SQL

/*
AND pl_from = 91822
AND NOT EXISTS (
    SELECT NULL
    FROM page
    WHERE page_namespace = 0
    AND page_title = pl_title
)
AND EXISTS (
    SELECT log_title
    FROM logging
  	WHERE log_action = 'delete'
  	AND log_timestamp > '20220801000000'
    AND log_title = pl_title
)

*/
SELECT * FROM pagelinks INNER JOIN page ON pl_from=page_id INNER JOIN logging ON pl_title=log_title WHERE 
page_namespace = 0
AND log_timestamp > '20220805000000'
LIMIT 1




/*
SELECT COUNT(*) FROM recentchanges WHERE
rc_timestamp > '20220512000000'
AND rc_timestamp < '202206000000'
AND rc_namespace = 0
*/

/*
(SELECT actor_name, rc_type, rc_timestamp, page_title, rc_id, ct_id, ct_tag_id FROM recentchanges INNER JOIN page ON rc_cur_id=page_id INNER JOIN actor on rc_actor=actor_id LEFT JOIN change_tag ON rc_id=ct_rc_id WHERE rc_timestamp>'20220612180000' AND rc_timestamp<'20220613000000' AND rc_bot=0 AND rc_type<2 AND rc_namespace=0 ) 
UNION ALL 
(SELECT actor_name, rc_type, rc_timestamp, page_title, rc_id, ct_id, ct_tag_id FROM recentchanges INNER JOIN page ON rc_cur_id=page_id INNER JOIN actor on rc_actor=actor_id RIGHT JOIN change_tag ON rc_id=ct_rc_id WHERE rc_timestamp>'20220612180000' AND rc_timestamp<'20220613000000' AND rc_bot=0 AND rc_type<2 AND rc_namespace=0 ) 
*/

/*
SELECT * FROM change_tag_def  
*/
SQL

Checking query status...
