Fix disambiguation page that were never properly migrated from 1.4
authorAntoine Musso <hashar@users.mediawiki.org>
Sun, 10 Jul 2005 17:38:38 +0000 (17:38 +0000)
committerAntoine Musso <hashar@users.mediawiki.org>
Sun, 10 Jul 2005 17:38:38 +0000 (17:38 +0000)
commitecf33ec38b087f20afca2bb598f19ff14c07d7ca
treed8149b50f26fa95ed338a74c208ca4b50590c5ba
parent6bb742d45cd4938f686cde72f83b3f86446378af
Fix disambiguation page that were never properly migrated from 1.4

mysql> explain SELECT 'Disambiguations' as type,la.pl_namespace AS namespace,
       la.pl_title AS title, la.pl_from AS link_from
       FROM `pagelinks` AS la, `pagelinks` AS lb, `page` AS pa, `page` AS pb
       WHERE pb.page_namespace = 4
       AND pb.page_title = 'Liens_aux_pages_d\'homonymie'
       AND lb.pl_title = pb.page_title
       AND pa.page_id = lb.pl_from
       AND la.pl_title = pa.page_title;
---+------+----------+----------+-----+-----------+----+--------------+
tab|type  |possible k|key       |k_len|ref        |rows|Extra         |
---+------+----------+----------+-----+-----------+----+--------------+
pb |const |name_title|name_title|  259|const,const|   1|index         |
la |index |NULL      |pl_from   |  263|NULL       |1976|index         |
lb |index |pl_from   |pl_from   |  263|NULL       |1976|where & index |
pa |eq_ref|PRIMARY   |PRIMARY   |    4|lb.pl_from |   1|where         |
---+------+----------+----------+-----+-----------+----+--------------+
RELEASE-NOTES
includes/SpecialDisambiguations.php