مستخدمين أداة المُستَعيد

SQL

SELECT page.page_id, page.page_namespace, page.page_title, revision_userindex.rev_id AS "main_edit",
    (SELECT MAX(rev_id) FROM revision_userindex AS prev_edit
     WHERE prev_edit.rev_page = page.page_id AND prev_edit.rev_id < revision_userindex.rev_id) AS "prev_edit",
     comment_text,
     actor.actor_name
FROM revision_userindex
inner join page ON page.page_id = revision_userindex.rev_page
inner join comment on revision_userindex.rev_comment_id = comment.comment_id
inner join actor ON actor.actor_id = revision_userindex.rev_actor
WHERE page.page_namespace = 0
and page.page_is_redirect = 0
and comment_text  like "%[[وب:م و ص|مشروع ويكي الصيانة]]%"
ORDER BY revision_userindex.rev_id
limit 20;
SQL

Checking query status...
