This query is marked as a draft This query has been published by Matěj Suchánek.

SQL

AخA
 
/*
SELECT wbc_entity_usage.*, page_namespace, page_title, page_touched FROM wbc_entity_usage
LEFT JOIN page ON page_id = eu_page_id
WHERE eu_aspect = 'X';
/*
SELECT ctd_name, afa_filter, afa_parameters
FROM change_tag_def, abuse_filter_action
WHERE ctd_user_defined = 1
AND afa_consequence = 'tag' AND (
  afa_parameters = ctd_name
  OR afa_parameters LIKE CONCAT('%\n', ctd_name)
  OR afa_parameters LIKE CONCAT(ctd_name, '\n%')
  OR afa_parameters LIKE CONCAT('%\n', ctd_name, '\n%')
);
#*/
#SELECT * FROM archive WHERE ar_page_id = 1739095;
#SELECT * FROM categorylinks WHERE cl_from = 1739095;
/*
SELECT page_title, pl_title FROM pagelinks
JOIN page ON page_id = pl_from
WHERE pl_namespace = 0 AND pl_title LIKE '%\_(rozcestník)'
AND NOT EXISTS (SELECT 1 FROM page WHERE page_title = pl_title AND page_namespace = pl_namespace)
AND pl_from_namespace = 0;
*/
SELECT page_title, rev_id, rev_parent_id#, rev_timestamp, comment_text
FROM revision_userindex
JOIN comment_revision ON comment_id = rev_comment_id
JOIN page ON page_id = rev_page
JOIN actor_revision ON actor_id = rev_actor
JOIN pagelinks ON pl_from = page_id
WHERE actor_name = 'MatSuBot'
AND page_namespace = 0 AND pl_from_namespace = 0 AND pl_namespace = 120 AND pl_title = 'P166'
AND comment_text LIKE '%; cleanup'
AND rev_timestamp > '201902';
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...