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

SQL

CREATE FUNCTION extract_substring (input_string TEXT)
RETURNS TEXT
BEGIN
  DECLARE output_string TEXT;
  SET output_string = SUBSTRING_INDEX(input_string, '*/', -1);
  RETURN TRIM(output_string);
END;


select 
extract_substring(comment.comment_text) 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...