Thread:Project:Support desk/Cleaning up externallinks table/reply

Hi Patrick,

I cannot help you directly, but I know that what you want is possible. It is a MySQL question: In table "externallinks" you have the column "el_from", which contains the number of the refering wiki page; this should be the "page_id" from the "page" table.

What you need is a query, which returns all rows from externallinks, which have a number in el_from, which is not present in page_id.