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

SQL

select 
# to show title only
CONCAT("[[:en:",SUBSTRING_INDEX(comment.comment_text, '*/', -1),"]]")  as "deleted_page",
TIMESTAMP(revision.rev_timestamp) as "date_of_delete",
CONCAT("[[:",wb_items_per_site.ips_site_page,"]]")   as "name_of_page"

from revision

join page on page.page_id = revision.rev_page
join comment on comment.comment_id = revision.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 "%:%"
#limit 10000
#where rev_id in (1173840751,1784446990)

SQL

Checking query status...