نقاش ويكيبيديا:مشروع ويكي الصيانة/بدون إنترويكي (نسخة أولية)

SQL

SELECT
comment.comment_text AS "deleted_page",
revision_userindex.rev_timestamp AS "date_of_delete",
wb_items_per_site.ips_site_page AS "name_of_page"
FROM
(SELECT page_id, page_title FROM page WHERE page_namespace = 0) AS page
JOIN revision_userindex ON page.page_id = revision_userindex.rev_page
JOIN comment ON comment.comment_id = revision_userindex.rev_comment_id
JOIN wb_items_per_site ON wb_items_per_site.ips_item_id = REPLACE(page.page_title, "Q", "")
WHERE
comment.comment_text LIKE "%clientsitelink-remove%"
AND comment.comment_text LIKE "%enwiki%"
#AND rev_timestamp > (NOW() - INTERVAL 1 MONTH)
AND year(rev_timestamp) in (2023,2022,2021)
AND wb_items_per_site.ips_site_id = "arwiki"
AND comment.comment_text NOT LIKE "%Template%"
AND comment.comment_text NOT LIKE "%Category%"

SQL

Checking query status...