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 -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/
_______________________________________________
Wikitech-l mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/

Reply via email to