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.