Wikimedia Bugzilla is closed!

There appear to be orphaned entries in the categorylinks table:

mysql> select * from categorylinks where cl_to='Matematikové';
+---------+---------------+------------------------+----------------+
| cl_from | cl_to         | cl_sortkey             | cl_timestamp   |
+---------+---------------+------------------------+----------------+
|   23285 | Matematikové | Alfred North Whitehead | 20050619191505 |
+---------+---------------+------------------------+----------------+

There's no matching page record, so the category page view doesn't list anything, but it still comes up in the counts for Special:Wantedcategories.

Running a cleanup on that wiki, but there's still the general problem.

Clearly we need to declare foreign keys.  ;)

Would it be possible to run a cleanup on enwiki? Category:Stub and a number of others have been clogging the list for ages :(

On lawiki, there are entries in the categorylinks table where the cl_from pageid has the value 0:

(0,'Usor_alias','I18n','2008-02-11 00:54:38','','','page'),
(0,'Usor_de-0','RunJobs.php','2008-02-11 00:54:38','','','page'),
(0,'Usor_en-0','RunJobs.php','2008-02-11 00:54:38','','','page'),
(0,'Usor_fr-0','RunJobs.php','2008-02-11 00:54:38','','','page'),
(0,'Usor_la-0','RunJobs.php','2008-02-11 00:54:38','','','page'),
(0,'Usor_ru-0','RunJobs.php','2008-02-11 00:54:38','','','page'),

These templates have been deleted several weeks ago. Therefore, these entries in the categorylinks table cause the templates wrongly to show up at Special:Wantedcategories.

Would it be possible to run a cleanup on lawiki?

See bug 16112/bug 36195