Do you mean something like the following? This prints the username in
the case of the page with page_id 1.


SELECT actor_name
FROM   actor
        JOIN revision
          ON rev_actor = actor_id
        JOIN page
          ON rev_id = page_latest
WHERE  page_id = 1;


Regards,
Zabe


Am 2023-12-30 23:28, schrieb Martin Domdey:
> Hi,
>
> can you send me a mySQL query example please, how to get
> user.user_name of the user who edited page.page_latest ?
>
> Thank you very much
> Martin ...
> _______________________________________________
> Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org
> To unsubscribe send an email to wikitech-l-leave@lists.wikimedia.org
> https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/
_______________________________________________
Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org
To unsubscribe send an email to wikitech-l-leave@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/