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

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 revision_userindex

join page 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 wb_items_per_site.ips_site_id like "arwiki"
# to remove any page not in 0 namespace
# and SUBSTRING_INDEX(comment.comment_text, '*/', -1) not like "%:%"
and comment.comment_text not like "%Template%" and comment.comment_text not like "%Category%"
#where rev_id in (1173840751,1784446990)

SQL

Checking query status...