On 9/2/06, Leon Weber leon.weber@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)
Unfortunately this is just evidence that it may not be one-time corruption.