البحث عن مقالات ملخص تعديل معين

SQL

use arwiki_p;
    SELECT page_id,page_title,rev_id,rev_timestamp, comment_text,
    #concat("[[نقاش المستخدم:",page_title,"]]") as "الاسم",
    #concat("[https://ar.wikipedia.org/w/index.php?oldid=",rev_id," تحقق]") as "الرقم"
    FROM revision_userindex
    INNER JOIN page ON rev_page = page_id
    INNER JOIN actor ON rev_actor = actor.actor_id
    INNER JOIN comment ON comment_id = rev_comment_id
    WHERE
    #rev_timestamp between 20220217000000 and 20220218000000
	#AND page_namespace = 0
    #AND page.page_is_redirect = 0
    #AND
    actor_name = 'LokasBot'
    AND comment_text like _utf8"%توزيع أوسمة%" collate utf8_general_ci;

SQL

Checking query status...