Topic on Talk:Quarry

Jump to navigation Jump to search

Does the pagelinks table not get purged of links that no longer exist?

5
MSUGRA (talkcontribs)
Matěj Suchánek (talkcontribs)

The redirect page contains some navboxes, the links seem to come from those...

MSUGRA (talkcontribs)

Ah right, I missed those. Thanks for clearing that up!

MSUGRA (talkcontribs)

On a related note: the redirect table is said to only track redirects that have been changed after 2007. Without deeper knowledge of the subject, I wouldn't necessarily assume that old redirects on Wikipedia have been touched since then. That's why I opted to reconstruct them from the pagelinks+page tables instead. Someone on IRC said they think every page will have experienced an automated update of some sort since then, prompting them to be tracked.


Do you know more about this? Can I rely on the redirect table tracking all (relevant) redirects the way the pagelinks table does?

Matěj Suchánek (talkcontribs)

This is news for me. But we can quickly check if all redirects have an entry:

SELECT page.* FROM page
LEFT JOIN redirect ON rd_from = page_id
WHERE page_is_redirect = 1 AND rd_title IS NULL
Reply to "Does the pagelinks table not get purged of links that no longer exist?"