Requesting a query

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Requesting a query

Avocato
Hello all. Is there a query to list all redirects (of ns0) which exist in a specific wiki?
--
User:Avocato--

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Reply | Threaded
Open this post in threaded view
|

Re: Requesting a query

Legoktm
On Thu, Feb 13, 2014 at 4:51 PM, Avocato <[hidden email]> wrote:
> Hello all. Is there a query to list all redirects (of ns0) which exist in a
> specific wiki?

SELECT page_title FROM page WHERE page_namespace=0 AND page_is_redirect=1;

-- Legoktm

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Reply | Threaded
Open this post in threaded view
|

Re: Requesting a query

Avocato
Thanks, Legoktm. I'll try it.


2014-02-14 4:06 GMT+02:00 legoktm <[hidden email]>:
On Thu, Feb 13, 2014 at 4:51 PM, Avocato <[hidden email]> wrote:
> Hello all. Is there a query to list all redirects (of ns0) which exist in a
> specific wiki?

SELECT page_title FROM page WHERE page_namespace=0 AND page_is_redirect=1;

-- Legoktm

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette



--
User:Avocato--

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette