SELECT rev_actor, MIN(rev_id)
FROM revision_userindex
GROUP BY rev_actor |
1 year ago |
SELECT rev_actor, MIN(rev_id)
FROM revision_userindex
GROUP BY rev_actor |
1 year ago |
SELECT rev_actor, MIN(rev_id)
FROM revision
GROUP BY rev_actor |
1 year ago |
SELECT MIN(rev_id)
FROM user
JOIN actor ON actor_user = user_id
JOIN... |
1 year ago |
SELECT MIN(rev_id)
FROM user
JOIN revision ON rev_user = user_id
WHERE... |
1 year ago |
SELECT MIN(rev_id), *
FROM user
JOIN revision ON rev_user = user_id
WHERE... |
1 year ago |