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 * |
