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(a)lists.wikimedia.org > To unsubscribe send an email to wikitech-l-leave(a)lists.wikimedia.org > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/