Gebruiker:SirJective/Double entries

This is a list of entries in the cur database table, which are doubled: Same namespace, same title, different id.

This leads to bogus entries in several maintenance lists, I know of entries in the list of short articles and the list of orphaned articles.

Probably they are created by clicking "Save page" on a new article more than once, which confuses the software.

These entries can be handled by deleting and restoring them. This makes all entries appear in one version history. Entries with the same newest revision must be edited first to create a single newest revision.

See also meta:Multiple titles.

The SQL-Statement that can be used is

SELECT DISTINCT
 c1.cur_namespace,
 c1.cur_title,
 c1.cur_id,
 c1.cur_timestamp
FROM
 cur c1,
 cur c2 USE INDEX (name_title_timestamp)
WHERE
 (c1.cur_namespace = c2.cur_namespace
 AND c1.cur_title = c2.cur_title)
 AND c1.cur_id <> c2.cur_id
ORDER BY c1.cur_namespace, c1.cur_title, c1.cur_id;

To get the list in the form I present here, you must tweak the output a bit.

Last update: SirJective 18 nov 2004 19:51 (CET)

(An asterisk * marks entries which must be edited to create a new revision, before they can be deleted and undeleted.)

link	title	timestamps
[1]	Btw	20041010195754, 20041111222842
[2]	Kodokan	20041111102633, 20041026201005
[3]	Mehmet_V_Reşat	20040419124119, 20040419124119 *
[4]	Muiterij_van_Sepoy	20041025193029, 20041026212717
[5]	Sint_Pancratius	20041101141414, 20041101141418, 20041105174903
[6]	Zuidelijk_halfrond	20041010183141, 20041010183143, 20041010183155, 20041010183201, 20041010183311, 20041010183359, 20041107212435
[7]	Overleg_gebruiker:212.238.74.237	20041010195739, 20041010195928
[8]	Overleg_gebruiker:62.163.76.231	20041019145413, 20041019150047
[9]	Categorie:Tsjechoslowaaks_politicus	20041025103722, 20041025103722 *