On 9/2/06, Leon Weber <leon.weber(a)leonweber.de>
wrote:
The same query returns a better result to me now
(yesterday it returned
Greg's result):
mysql> SELECT count(el_to) FROM dewiki_p.externallinks JOIN
dewiki_p.page ON el_from=page_id WHERE page_title='Fabrixx' AND
page_namespace=0\G
*************************** 1. row ***************************
count(el_to): 14
1 row in set (0.00 sec)
Yes, the page has been resaved since.
Other pages are just as bad.
SELECT count(el_to) FROM dewiki_p.externallinks JOIN dewiki_p.page ON
el_from=page_id WHERE page_title='KZ_Ladelund' and page_namespace=0;
\+--------------+
| count(el_to) |
+--------------+
| 1201 |
+--------------+
1 row in set (0.41 sec)
I've asked Tim Starling to run that query on one of the
live DB servers.
It returns 1201 there. His current guess is a software bug.
--Leon