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

SQL


select 
SUBSTRING_INDEX(comment.comment_text, '*/', -1)) as "comment_of_delete",
revision.rev_timestamp as "date_of_delete",
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"

limit 100;
#where rev_id in (1173840751,1784446990)

SQL

Checking query status...