Mailing List Archive

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/

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/
>