Oh yes,

thanks a lot, it really helps.

Kind regards Martin

Am So., 31. Dez. 2023 um 00:03 Uhr schrieb alec@vc-celle.de:

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/