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

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",
    (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
     AND prev_edit.rev_actor = 3532174) AS "prev_edit"
FROM revision_userindex
INNER JOIN page ON page.page_id = revision_userindex.rev_page
WHERE revision_userindex.rev_actor = 3532174
ORDER BY revision_userindex.rev_id
LIMIT 20;
SQL

Checking query status...
