[MediaWiki-l] List all redirects (with target)

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

[MediaWiki-l] List all redirects (with target)

Emmanuel Engelhart-5
Hi,

How to list quickly all redirects, with from/to titles?

This seems to be impossible with the API and "Special:Listredirects" is
limited to the first 1000 redirects.

Kelson
--
Kiwix - Wikipedia Offline & more
* Web: http://www.kiwix.org
* Twitter: https://twitter.com/KiwixOffline
* more: http://www.kiwix.org/wiki/Communication

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: List all redirects (with target)

Tim Starling-2
On 09/07/13 22:26, Emmanuel Engelhart wrote:
> Hi,
>
> How to list quickly all redirects, with from/to titles?
>
> This seems to be impossible with the API and "Special:Listredirects" is
> limited to the first 1000 redirects.

You can query the "redirect" table in the database, e.g.

SELECT page_namespace,page_title,rd_namespace,rd_title
FROM redirect,page
WHERE page_id=rd_from;

-- Tim Starling


_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: List all redirects (with target)

Emmanuel Engelhart-5
Le 11/07/2013 06:17, Tim Starling a écrit :

> On 09/07/13 22:26, Emmanuel Engelhart wrote:
>> Hi,
>>
>> How to list quickly all redirects, with from/to titles?
>>
>> This seems to be impossible with the API and "Special:Listredirects" is
>> limited to the first 1000 redirects.
>
> You can query the "redirect" table in the database, e.g.
>
> SELECT page_namespace,page_title,rd_namespace,rd_title
> FROM redirect,page
> WHERE page_id=rd_from;

I need this remotely.

I have open a feature request:
https://bugzilla.wikimedia.org/show_bug.cgi?id=50981

Emmanuel
--
Kiwix - Wikipedia Offline & more
* Web: http://www.kiwix.org
* Twitter: https://twitter.com/KiwixOffline
* more: http://www.kiwix.org/wiki/Communication

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l