مصادر المعرفات (ميدان التقنيه)

SQL

/*
actor_id	actor_user	actor_name
3532174	1950206	لوقا
select * from actor where actor_name like "لوقا";
*/
/*
select page.page_id,page.page_namespace,page.page_title,revision_userindex.rev_id as "main_edit" from revision_userindex
inner join page on page.page_id = revision_userindex.rev_page
where rev_actor = 3532174
order by revision_userindex.rev_id
limit 20 
*/
SELECT page.page_id, page.page_namespace, page.page_title, revision_userindex.rev_id AS "main_edit", MAX(prev_edit.rev_id) AS "prev_edit"
FROM revision_userindex
INNER JOIN page ON page.page_id = revision_userindex.rev_page
LEFT JOIN (
    SELECT rev_page, MAX(rev_id) AS rev_id
    FROM revision_userindex
    WHERE rev_actor = 3532174
    GROUP BY rev_page
) AS prev_edit ON prev_edit.rev_page = revision_userindex.rev_page
WHERE revision_userindex.rev_actor = 3532174
GROUP BY page.page_id, page.page_namespace, page.page_title, revision_userindex.rev_id
ORDER BY revision_userindex.rev_id
LIMIT 20;
SQL

Checking query status...
