Stamp printings and perforations

[tcawe]

It is now possible to see two lists on Colnect which were not available before:

Stamp printings

Stamp perforations

These allow collectors to filter by these values as well.

As you can notice from how the lists currently are, there are fixes to be done and I'd appreciate a relevant Duplicates report from any of the stamp coordinators.

Please answer the poll

[Myszek]

Hmmm, I'm not sure if this is an option I would use, so I choose "don't care".

I did see a lot of duplication though, for example "Self adhesive" and "self-adhesive". Also, "Litographed", "Litographic", "litography" and "Lithgraphy". My suggestion is to clean up here first before we really start using this feature.

[selofan]

Indeed, there's also a lot of duplicated perforations, because the description of them....

Also, to me, "self adhesive" should be a cathegory apart, as i've mentioned in another topic: "ATM labels"...

To me....

[Romeu]

Hello friends,

The modern postage stamps will rarely show some variety in printings or perforations. So I think these data are not relevant.

Stamps prior to the year 1950 is that we will find these requirements and also varieties in watermarks.

The catalog of stamps in Colnect aims to serve as a reference?

I think the ultimate goal is to have the stamps more representative of the various series and issues and so we can register our collections.

So I choose "don't care", too.

[tcawe]

The lists have been somewhat cleaned and as most people voted on making them public, the have now been publicly added and announced. You are welcome to submit duplicate reports to remove what needs be removed. You're most welcome to edit relevant stamps to ensure correct values. Yes, it's a work in progress.

[tcawe]

There's surely more work to be done on both lists.

For merging duplicates please submit a Duplicates report to iflvico.

To rename printings, reply here with a command like:

UPDATE `colnect`.`zst_printing_translation` SET `name` = '[NEW_ENGLISH_NAME]' WHERE `zst_printing_translation`.`id` =[PRINTING_ID] AND `zst_printing_translation`.`lang` =0;

Example:

UPDATE `colnect`.`zst_printing_translation` SET `name` = 'Recess and Photo' WHERE `zst_printing_translation`.`id` =3 AND `zst_printing_translation`.`lang` =0;

My suggestion is to use the same standard for upper and lower case and combinations (choose if using + or and). NOTE: Rename only to make minor fixes (capital letters and typos) because your fix will be only in the English language. You should not rename one printing method to another.

To rename perforations, reply here with a command like:

UPDATE `colnect`.`zst_perforation` SET `name` = '[NEW_ENGLISH_NAME]' WHERE `zst_perforation`.`id` =[PERFORATION_ID] ;

Example:

UPDATE `colnect`.`zst_perforation` SET `name` = 'Comb 10½ x 11' WHERE `zst_perforation`.`id` =2686;

Here I suggest to use a strict naming standard so for example Comb 10½ x 11 has "Comb" with upper case C, then a space, then the numbers using fraction characters ( ½x ¼ ¾ and not 1/2 1/4 3/4) and separate the two number with an x that has spaces on both sides.

[fabellogo]

Please delete it!

[tcawe]

This matter of permissions isn't about authority but about verifying input on a VERY sensitive issue. Merging duplicates in a wrong way can cause much havoc. You will not have to make many such submissions for printings/perforation or colors so please be patient. Ignacio will respond to you in a timely manner. I appreciate your understanding.

[DarioDeSantis]

Please verify that the syntax used in the following code lines is correct (lines are all of the same sort).

If it is indeed correct, then you can launch the following statements and have the perforation list neatly rearranged. Please note that only renaming has been applied, and that more instructions will soon follow, together with a detailed duplicate report.

Code: Select all

UPDATE colnect.zst_perforation SET name = "10¾ x 10¼" WHERE zst_perforation.id = 411 ;
UPDATE colnect.zst_perforation SET name = "10 x 11¼" WHERE zst_perforation.id = 1762 ;
UPDATE colnect.zst_perforation SET name = "10 x 11½" WHERE zst_perforation.id = 1718 ;
UPDATE colnect.zst_perforation SET name = "10 x 10¼" WHERE zst_perforation.id = 444 ;
UPDATE colnect.zst_perforation SET name = "10 x 10½" WHERE zst_perforation.id = 2462 ;
UPDATE colnect.zst_perforation SET name = "10 x 11" WHERE zst_perforation.id = 373 ;
UPDATE colnect.zst_perforation SET name = "10½ x 11" WHERE zst_perforation.id = 2160 ;
UPDATE colnect.zst_perforation SET name = "10½ x 10" WHERE zst_perforation.id = 1842 ;
UPDATE colnect.zst_perforation SET name = "10½ x 13" WHERE zst_perforation.id = 2128 ;
UPDATE colnect.zst_perforation SET name = "10¾ x 12" WHERE zst_perforation.id = 2302 ;
UPDATE colnect.zst_perforation SET name = "11½ x 12½" WHERE zst_perforation.id = 1999 ;
UPDATE colnect.zst_perforation SET name = "11½ x 13½" WHERE zst_perforation.id = 2047 ;
UPDATE colnect.zst_perforation SET name = "11½ x 14" WHERE zst_perforation.id = 2059 ;
UPDATE colnect.zst_perforation SET name = "11 x 10½" WHERE zst_perforation.id = 1759 ;
UPDATE colnect.zst_perforation SET name = "11 x 11¼" WHERE zst_perforation.id = 1043 ;
UPDATE colnect.zst_perforation SET name = "11 x 11½" WHERE zst_perforation.id = 1027 ;
UPDATE colnect.zst_perforation SET name = "11 x 12" WHERE zst_perforation.id = 1006 ;
UPDATE colnect.zst_perforation SET name = "11 x 10" WHERE zst_perforation.id = 378 ;
UPDATE colnect.zst_perforation SET name = "11 x 13" WHERE zst_perforation.id = 2270 ;
UPDATE colnect.zst_perforation SET name = "11 x 9" WHERE zst_perforation.id = 2463 ;
UPDATE colnect.zst_perforation SET name = "11¼ x 11¾" WHERE zst_perforation.id = 2360 ;
UPDATE colnect.zst_perforation SET name = "11¼ x 11" WHERE zst_perforation.id = 1844 ;
UPDATE colnect.zst_perforation SET name = "11½ x 10½" WHERE zst_perforation.id = 2197 ;
UPDATE colnect.zst_perforation SET name = "11½ x 10" WHERE zst_perforation.id = 1719 ;
UPDATE colnect.zst_perforation SET name = "11½ x 11" WHERE zst_perforation.id = 1025 ;
UPDATE colnect.zst_perforation SET name = "11½ x 11¼" WHERE zst_perforation.id = 1688 ;
UPDATE colnect.zst_perforation SET name = "11½ x 11¾" WHERE zst_perforation.id = 1895 ;
UPDATE colnect.zst_perforation SET name = "11½ x 12" WHERE zst_perforation.id = 921 ;
UPDATE colnect.zst_perforation SET name = "11½ x 12¼" WHERE zst_perforation.id = 2323 ;
UPDATE colnect.zst_perforation SET name = "11¾ x 12¼" WHERE zst_perforation.id = 259 ;
UPDATE colnect.zst_perforation SET name = "11¾ x 12½" WHERE zst_perforation.id = 2500 ;
UPDATE colnect.zst_perforation SET name = "12½ x 14" WHERE zst_perforation.id = 2295 ;
UPDATE colnect.zst_perforation SET name = "12½ x 11" WHERE zst_perforation.id = 2361 ;
UPDATE colnect.zst_perforation SET name = "12½ x 13¼" WHERE zst_perforation.id = 1396 ;
UPDATE colnect.zst_perforation SET name = "12 x 13" WHERE zst_perforation.id = 2213 ;
UPDATE colnect.zst_perforation SET name = "12¾" WHERE zst_perforation.id = 1506 ;
UPDATE colnect.zst_perforation SET name = "12 x 11½" WHERE zst_perforation.id = 1407 ;
UPDATE colnect.zst_perforation SET name = "12 x 12¼" WHERE zst_perforation.id = 1033 ;
UPDATE colnect.zst_perforation SET name = "12 x 12½" WHERE zst_perforation.id = 925 ;
UPDATE colnect.zst_perforation SET name = "12 x 13½" WHERE zst_perforation.id = 4347 ;
UPDATE colnect.zst_perforation SET name = "12 x 11" WHERE zst_perforation.id = 2456 ;
UPDATE colnect.zst_perforation SET name = "12 x 14" WHERE zst_perforation.id = 2457 ;
UPDATE colnect.zst_perforation SET name = "12½ x 11¾" WHERE zst_perforation.id = 139 ;
UPDATE colnect.zst_perforation SET name = "12½ x 13" WHERE zst_perforation.id = 2161 ;
UPDATE colnect.zst_perforation SET name = "12½ x 13½" WHERE zst_perforation.id = 1726 ;
UPDATE colnect.zst_perforation SET name = "12½ x 11½" WHERE zst_perforation.id = 2320 ;
UPDATE colnect.zst_perforation SET name = "12½ x 12" WHERE zst_perforation.id = 924 ;
UPDATE colnect.zst_perforation SET name = "12½ x 12¾" WHERE zst_perforation.id = 1602 ;
UPDATE colnect.zst_perforation SET name = "12½ x 12¼" WHERE zst_perforation.id = 1207 ;
UPDATE colnect.zst_perforation SET name = "12½ x 14¼" WHERE zst_perforation.id = 3291 ;
UPDATE colnect.zst_perforation SET name = "12¾ x 13" WHERE zst_perforation.id = 294 ;
UPDATE colnect.zst_perforation SET name = "12¾ x 13¼" WHERE zst_perforation.id = 947 ;
UPDATE colnect.zst_perforation SET name = "12¾ x 13½" WHERE zst_perforation.id = 4756 ;
UPDATE colnect.zst_perforation SET name = "12¾ x 12½" WHERE zst_perforation.id = 1711 ;
UPDATE colnect.zst_perforation SET name = "12¾ x 14" WHERE zst_perforation.id = 2200 ;
UPDATE colnect.zst_perforation SET name = "12¾ x 12¼" WHERE zst_perforation.id = 4312 ;
UPDATE colnect.zst_perforation SET name = "12¾ x 14¼" WHERE zst_perforation.id = 2515 ;
UPDATE colnect.zst_perforation SET name = "13¼ x 12½" WHERE zst_perforation.id = 1384 ;
UPDATE colnect.zst_perforation SET name = "13 x 12" WHERE zst_perforation.id = 2212 ;
UPDATE colnect.zst_perforation SET name = "13 x 13¼" WHERE zst_perforation.id = 2119 ;
UPDATE colnect.zst_perforation SET name = "13 x 13½" WHERE zst_perforation.id = 1140 ;
UPDATE colnect.zst_perforation SET name = "13½ x 14¼" WHERE zst_perforation.id = 2143 ;
UPDATE colnect.zst_perforation SET name = "13 x 12¼" WHERE zst_perforation.id = 2196 ;
UPDATE colnect.zst_perforation SET name = "13 x 12½" WHERE zst_perforation.id = 631 ;
UPDATE colnect.zst_perforation SET name = "13¼ x 13" WHERE zst_perforation.id = 2070 ;
UPDATE colnect.zst_perforation SET name = "13¼ x 13½" WHERE zst_perforation.id = 4769 ;
UPDATE colnect.zst_perforation SET name = "13¼ x 13¾" WHERE zst_perforation.id = 186 ;
UPDATE colnect.zst_perforation SET name = "13¼ x 14" WHERE zst_perforation.id = 200 ;
UPDATE colnect.zst_perforation SET name = "13¼ x 12¾" WHERE zst_perforation.id = 1704 ;
UPDATE colnect.zst_perforation SET name = "13¼ x 12" WHERE zst_perforation.id = 2243 ;
UPDATE colnect.zst_perforation SET name = "13¼ x 14¼" WHERE zst_perforation.id = 2390 ;
UPDATE colnect.zst_perforation SET name = "13½ x 13" WHERE zst_perforation.id = 1437 ;
UPDATE colnect.zst_perforation SET name = "13½ x 12" WHERE zst_perforation.id = 4762 ;
UPDATE colnect.zst_perforation SET name = "13½ x 12½" WHERE zst_perforation.id = 1695 ;
UPDATE colnect.zst_perforation SET name = "13½ x 13¾" WHERE zst_perforation.id = 2684 ;
UPDATE colnect.zst_perforation SET name = "13½ x 12" WHERE zst_perforation.id = 1887 ;
UPDATE colnect.zst_perforation SET name = "13½ x 12¾" WHERE zst_perforation.id = 1987 ;
UPDATE colnect.zst_perforation SET name = "13½ x 14½" WHERE zst_perforation.id = 1050 ;
UPDATE colnect.zst_perforation SET name = "13¾ x 13¼" WHERE zst_perforation.id = 201 ;
UPDATE colnect.zst_perforation SET name = "13¾ x 14" WHERE zst_perforation.id = 57 ;
UPDATE colnect.zst_perforation SET name = "13¾ x 14½" WHERE zst_perforation.id = 2468 ;
UPDATE colnect.zst_perforation SET name = "13¾ x 12¾" WHERE zst_perforation.id = 1701 ;
UPDATE colnect.zst_perforation SET name = "13¾ x 13½" WHERE zst_perforation.id = 1710 ;
UPDATE colnect.zst_perforation SET name = "14 x 13¼" WHERE zst_perforation.id = 199 ;
UPDATE colnect.zst_perforation SET name = "14 x 13½" WHERE zst_perforation.id = 2191 ;
UPDATE colnect.zst_perforation SET name = "14 x 13¾" WHERE zst_perforation.id = 42 ;
UPDATE colnect.zst_perforation SET name = "14½ x 13" WHERE zst_perforation.id = 693 ;
UPDATE colnect.zst_perforation SET name = "14¾ x 14" WHERE zst_perforation.id = 1692 ;
UPDATE colnect.zst_perforation SET name = "14 x 12¾" WHERE zst_perforation.id = 2155 ;
UPDATE colnect.zst_perforation SET name = "14 x 14¼" WHERE zst_perforation.id = 2638 ;
UPDATE colnect.zst_perforation SET name = "14 x 14½" WHERE zst_perforation.id = 1034 ;
UPDATE colnect.zst_perforation SET name = "14 x 12½" WHERE zst_perforation.id = 2298 ;
UPDATE colnect.zst_perforation SET name = "14 x 15" WHERE zst_perforation.id = 1960 ;
UPDATE colnect.zst_perforation SET name = "14¼ x 13" WHERE zst_perforation.id = 2072 ;
UPDATE colnect.zst_perforation SET name = "14¼ x 14" WHERE zst_perforation.id = 1919 ;
UPDATE colnect.zst_perforation SET name = "14¼ x 14¾" WHERE zst_perforation.id = 928 ;
UPDATE colnect.zst_perforation SET name = "14¼ x 12½" WHERE zst_perforation.id = 2516 ;
UPDATE colnect.zst_perforation SET name = "14¼ x 12¾" WHERE zst_perforation.id = 2514 ;
UPDATE colnect.zst_perforation SET name = "14½ x 13½" WHERE zst_perforation.id = 814 ;
UPDATE colnect.zst_perforation SET name = "14½ x 13¾" WHERE zst_perforation.id = 2183 ;
UPDATE colnect.zst_perforation SET name = "14½ x 14" WHERE zst_perforation.id = 1868 ;
UPDATE colnect.zst_perforation SET name = "14½ x 12¾" WHERE zst_perforation.id = 1781 ;
UPDATE colnect.zst_perforation SET name = "14½ x 14¼" WHERE zst_perforation.id = 1694 ;
UPDATE colnect.zst_perforation SET name = "14½ x 14¾" WHERE zst_perforation.id = 1780 ;
UPDATE colnect.zst_perforation SET name = "14¾ x 14½" WHERE zst_perforation.id = 2181 ;
UPDATE colnect.zst_perforation SET name = "15½" WHERE zst_perforation.id = 2079 ;
UPDATE colnect.zst_perforation SET name = "15 x 14" WHERE zst_perforation.id = 1408 ;
UPDATE colnect.zst_perforation SET name = "15½ x 14½" WHERE zst_perforation.id = 1071 ;
UPDATE colnect.zst_perforation SET name = "16" WHERE zst_perforation.id = 2542 ;
UPDATE colnect.zst_perforation SET name = "8 Vertical" WHERE zst_perforation.id = 1672 ;
UPDATE colnect.zst_perforation SET name = "8½ Horizontal" WHERE zst_perforation.id = 522 ;
UPDATE colnect.zst_perforation SET name = "8½ Vertical" WHERE zst_perforation.id = 523 ;
UPDATE colnect.zst_perforation SET name = "8¾" WHERE zst_perforation.id = 403 ;
UPDATE colnect.zst_perforation SET name = "9¾" WHERE zst_perforation.id = 410 ;
UPDATE colnect.zst_perforation SET name = "9¾ x 10¾" WHERE zst_perforation.id = 395 ;
UPDATE colnect.zst_perforation SET name = "10 Vertical" WHERE zst_perforation.id = 436 ;
UPDATE colnect.zst_perforation SET name = "9 x 14" WHERE zst_perforation.id = 2541 ;
UPDATE colnect.zst_perforation SET name = "9½ Vertical" WHERE zst_perforation.id = 501 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 10" WHERE zst_perforation.id = 451 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 10¾ x 10¼" WHERE zst_perforation.id = 497 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 10¾ x 10½" WHERE zst_perforation.id = 471 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 10¾ x 11" WHERE zst_perforation.id = 458 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 10 x 9½" WHERE zst_perforation.id = 502 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 10½" WHERE zst_perforation.id = 491 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 10½ x 10¾" WHERE zst_perforation.id = 463 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 10¾" WHERE zst_perforation.id = 470 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11" WHERE zst_perforation.id = 455 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11¼ x 11" WHERE zst_perforation.id = 475 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11¼ x 11½" WHERE zst_perforation.id = 488 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11½ x 11" WHERE zst_perforation.id = 515 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11¾ x 11½" WHERE zst_perforation.id = 499 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11 x 10½" WHERE zst_perforation.id = 494 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11 x 10¾" WHERE zst_perforation.id = 466 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11 x 11¼" WHERE zst_perforation.id = 461 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11¼" WHERE zst_perforation.id = 447 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11½" WHERE zst_perforation.id = 456 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11½ x 10¾" WHERE zst_perforation.id = 465 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11½" WHERE zst_perforation.id = 452 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11½ x 11¾" WHERE zst_perforation.id = 493 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 12 x 11½" WHERE zst_perforation.id = 500 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11¾ Vertical" WHERE zst_perforation.id = 505 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 8½ Vertical" WHERE zst_perforation.id = 453 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 9¾ Vertical" WHERE zst_perforation.id = 464 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 13¼ x 13¾" WHERE zst_perforation.id = 1471 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 13¾ x 13¼" WHERE zst_perforation.id = 1472 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 14" WHERE zst_perforation.id = 1446 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 15" WHERE zst_perforation.id = 2479 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 9¼ x 8½ on 3 sides" WHERE zst_perforation.id = 1477 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 13¼ Horizontal" WHERE zst_perforation.id = 1386 ;

[tcawe]

Done Looking forward to seeing this become organized. I know u'll do it the best way possible

[DarioDeSantis]

Here is a bunch of duplicated perforations, we only need one of each:

357 = 436

2593 = 2302

385 = 356

4762 = 1887

4777 = 1437

4771 = 2191

363 = 404 = 424 (yes, three of the same)

410 = 942

And here is another set of instructions to make our list prettier and prettier... (more to come)

Code: Select all

UPDATE colnect.zst_perforation SET name = "10 Horizontal" WHERE zst_perforation.id = 546 ;
UPDATE colnect.zst_perforation SET name = "11 Horizontal" WHERE zst_perforation.id = 377 ;
UPDATE colnect.zst_perforation SET name = "11 Vertical" WHERE zst_perforation.id = 379 ;
UPDATE colnect.zst_perforation SET name = "11¾ x 11¼" WHERE zst_perforation.id = 2353 ;
UPDATE colnect.zst_perforation SET name = "12 Horizontal" WHERE zst_perforation.id = 422 ;
UPDATE colnect.zst_perforation SET name = "12 Vertical" WHERE zst_perforation.id = 426 ;
UPDATE colnect.zst_perforation SET name = "comb 10½ x 11" WHERE zst_perforation.id = 2686 ;
UPDATE colnect.zst_perforation SET name = "comb 10" WHERE zst_perforation.id = 1049 ;
UPDATE colnect.zst_perforation SET name = "comb 10 x 10½" WHERE zst_perforation.id = 1132 ;
UPDATE colnect.zst_perforation SET name = "comb 10½ x 10" WHERE zst_perforation.id = 1893 ;
UPDATE colnect.zst_perforation SET name = "comb 10¾" WHERE zst_perforation.id = 2264 ;
UPDATE colnect.zst_perforation SET name = "comb 11" WHERE zst_perforation.id = 279 ;
UPDATE colnect.zst_perforation SET name = "comb 11 x 11¼" WHERE zst_perforation.id = 2433 ;
UPDATE colnect.zst_perforation SET name = "comb 11 x 11½" WHERE zst_perforation.id = 872 ;
UPDATE colnect.zst_perforation SET name = "comb 11 x 12" WHERE zst_perforation.id = 2628 ;
UPDATE colnect.zst_perforation SET name = "comb 11¼" WHERE zst_perforation.id = 34 ;
UPDATE colnect.zst_perforation SET name = "comb 11¼ x 10¼" WHERE zst_perforation.id = 853 ;
UPDATE colnect.zst_perforation SET name = "comb 11¼ x 11" WHERE zst_perforation.id = 291 ;
UPDATE colnect.zst_perforation SET name = "comb 11¼ x 11½" WHERE zst_perforation.id = 255 ;
UPDATE colnect.zst_perforation SET name = "comb 11¼ x 11¾" WHERE zst_perforation.id = 659 ;
UPDATE colnect.zst_perforation SET name = "comb 11¼ x 12" WHERE zst_perforation.id = 854 ;
UPDATE colnect.zst_perforation SET name = "comb 11¼ x 12¼" WHERE zst_perforation.id = 1654 ;
UPDATE colnect.zst_perforation SET name = "comb 11½" WHERE zst_perforation.id = 62 ;
UPDATE colnect.zst_perforation SET name = "comb 11½ x 11" WHERE zst_perforation.id = 1031 ;
UPDATE colnect.zst_perforation SET name = "comb 11½ x 11¼" WHERE zst_perforation.id = 658 ;
UPDATE colnect.zst_perforation SET name = "comb 11½ x 11¾" WHERE zst_perforation.id = 267 ;
UPDATE colnect.zst_perforation SET name = "comb 11½ x 12" WHERE zst_perforation.id = 256 ;
UPDATE colnect.zst_perforation SET name = "comb 11½ x 12¼" WHERE zst_perforation.id = 2434 ;
UPDATE colnect.zst_perforation SET name = "comb 11½ x 12½" WHERE zst_perforation.id = 2394 ;
UPDATE colnect.zst_perforation SET name = "comb 11½ x 12¾" WHERE zst_perforation.id = 1054 ;
UPDATE colnect.zst_perforation SET name = "comb 11½ x 13" WHERE zst_perforation.id = 4761 ;
UPDATE colnect.zst_perforation SET name = "comb 11½ x 10" WHERE zst_perforation.id = 1845 ;
UPDATE colnect.zst_perforation SET name = "comb 11¾" WHERE zst_perforation.id = 116 ;
UPDATE colnect.zst_perforation SET name = "comb 11¾ x 11" WHERE zst_perforation.id = 2629 ;
UPDATE colnect.zst_perforation SET name = "comb 11¾ x 11¼" WHERE zst_perforation.id = 657 ;
UPDATE colnect.zst_perforation SET name = "comb 11¾ x 11½" WHERE zst_perforation.id = 135 ;
UPDATE colnect.zst_perforation SET name = "comb 11¾ x 12" WHERE zst_perforation.id = 119 ;
UPDATE colnect.zst_perforation SET name = "comb 11¾ x 12¼" WHERE zst_perforation.id = 132 ;
UPDATE colnect.zst_perforation SET name = "comb 11¾ x 13¼" WHERE zst_perforation.id = 2349 ;
UPDATE colnect.zst_perforation SET name = "comb 11¾ x 12½" WHERE zst_perforation.id = 1411 ;
UPDATE colnect.zst_perforation SET name = "comb 12" WHERE zst_perforation.id = 112 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 11¼" WHERE zst_perforation.id = 856 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 11½" WHERE zst_perforation.id = 147 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 11¾" WHERE zst_perforation.id = 114 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 12¼" WHERE zst_perforation.id = 113 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 12½" WHERE zst_perforation.id = 101 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 11" WHERE zst_perforation.id = 873 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 13" WHERE zst_perforation.id = 1843 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 13¼" WHERE zst_perforation.id = 1736 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 13½" WHERE zst_perforation.id = 1783 ;
UPDATE colnect.zst_perforation SET name = "comb 12 x 14" WHERE zst_perforation.id = 1741 ;
UPDATE colnect.zst_perforation SET name = "comb 12¼" WHERE zst_perforation.id = 118 ;
UPDATE colnect.zst_perforation SET name = "comb 12¼ x 11¼" WHERE zst_perforation.id = 2440 ;
UPDATE colnect.zst_perforation SET name = "comb 12¼ x 11½" WHERE zst_perforation.id = 2438 ;
UPDATE colnect.zst_perforation SET name = "comb 12¼ x 11¾" WHERE zst_perforation.id = 109 ;
UPDATE colnect.zst_perforation SET name = "comb 12¼ x 12" WHERE zst_perforation.id = 117 ;
UPDATE colnect.zst_perforation SET name = "comb 12¼ x 12½" WHERE zst_perforation.id = 299 ;
UPDATE colnect.zst_perforation SET name = "comb 12½" WHERE zst_perforation.id = 26 ;
UPDATE colnect.zst_perforation SET name = "comb 12½ x 11½" WHERE zst_perforation.id = 2377 ;
UPDATE colnect.zst_perforation SET name = "comb 12½ x 11¾" WHERE zst_perforation.id = 1104 ;
UPDATE colnect.zst_perforation SET name = "comb 12½ x 12" WHERE zst_perforation.id = 115 ;
UPDATE colnect.zst_perforation SET name = "comb 12½ x 12¼" WHERE zst_perforation.id = 300 ;
UPDATE colnect.zst_perforation SET name = "comb 12½ x 12¾" WHERE zst_perforation.id = 288 ;
UPDATE colnect.zst_perforation SET name = "comb 12½ x 13" WHERE zst_perforation.id = 1249 ;
UPDATE colnect.zst_perforation SET name = "comb 12½ x 13½" WHERE zst_perforation.id = 2625 ;
UPDATE colnect.zst_perforation SET name = "comb 12½ x 14" WHERE zst_perforation.id = 2062 ;
UPDATE colnect.zst_perforation SET name = "comb 12½ x 13¼" WHERE zst_perforation.id = 1729 ;
UPDATE colnect.zst_perforation SET name = "comb 12¾" WHERE zst_perforation.id = 278 ;
UPDATE colnect.zst_perforation SET name = "comb 12¾ x 12½" WHERE zst_perforation.id = 325 ;
UPDATE colnect.zst_perforation SET name = "comb 12¾ x 13" WHERE zst_perforation.id = 61 ;
UPDATE colnect.zst_perforation SET name = "comb 12¾ x 13¼" WHERE zst_perforation.id = 805 ;
UPDATE colnect.zst_perforation SET name = "comb 12¾ x 13½" WHERE zst_perforation.id = 2280 ;
UPDATE colnect.zst_perforation SET name = "comb 12¾ x 14" WHERE zst_perforation.id = 2649 ;
UPDATE colnect.zst_perforation SET name = "comb 13" WHERE zst_perforation.id = 66 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 12½" WHERE zst_perforation.id = 280 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 12¾" WHERE zst_perforation.id = 296 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 13¼" WHERE zst_perforation.id = 47 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 13½" WHERE zst_perforation.id = 283 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 13¾" WHERE zst_perforation.id = 1310 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 14" WHERE zst_perforation.id = 2445 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 14½" WHERE zst_perforation.id = 2646 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 11" WHERE zst_perforation.id = 3496 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 12" WHERE zst_perforation.id = 1841 ;
UPDATE colnect.zst_perforation SET name = "comb 13 x 14¼" WHERE zst_perforation.id = 1067 ;
UPDATE colnect.zst_perforation SET name = "comb 13¼" WHERE zst_perforation.id = 67 ;

[DarioDeSantis]

Please add the following, too:

452 = 456 (duplicate)

and another batch of instructions:

Code: Select all

UPDATE colnect.zst_perforation SET name = "comb 13¼ x 12½" WHERE zst_perforation.id = 993 ;
UPDATE colnect.zst_perforation SET name = "comb 13¼ x 12¾" WHERE zst_perforation.id = 171 ;
UPDATE colnect.zst_perforation SET name = "comb 13¼ x 13" WHERE zst_perforation.id = 281 ;
UPDATE colnect.zst_perforation SET name = "comb 13¼ x 13½" WHERE zst_perforation.id = 27 ;
UPDATE colnect.zst_perforation SET name = "comb 13¼ x 13¾" WHERE zst_perforation.id = 37 ;
UPDATE colnect.zst_perforation SET name = "comb 13¼ x 14" WHERE zst_perforation.id = 197 ;
UPDATE colnect.zst_perforation SET name = "comb 13¼ x 12" WHERE zst_perforation.id = 1119 ;
UPDATE colnect.zst_perforation SET name = "comb 13½" WHERE zst_perforation.id = 32 ;
UPDATE colnect.zst_perforation SET name = "comb 13½ x 12½" WHERE zst_perforation.id = 2626 ;
UPDATE colnect.zst_perforation SET name = "comb 13½ x 12¾" WHERE zst_perforation.id = 803 ;
UPDATE colnect.zst_perforation SET name = "comb 13½ x 13" WHERE zst_perforation.id = 140 ;
UPDATE colnect.zst_perforation SET name = "comb 13½ x 13¼" WHERE zst_perforation.id = 25 ;
UPDATE colnect.zst_perforation SET name = "comb 13½ x 13¾" WHERE zst_perforation.id = 153 ;
UPDATE colnect.zst_perforation SET name = "comb 13½ x 14" WHERE zst_perforation.id = 207 ;
UPDATE colnect.zst_perforation SET name = "comb 13½ x 14½" WHERE zst_perforation.id = 205 ;
UPDATE colnect.zst_perforation SET name = "comb 13½ x 12" WHERE zst_perforation.id = 1743 ;
UPDATE colnect.zst_perforation SET name = "comb 13½ x 14½" WHERE zst_perforation.id = 1796 ;
UPDATE colnect.zst_perforation SET name = "comb 13¾" WHERE zst_perforation.id = 65 ;
UPDATE colnect.zst_perforation SET name = "comb 13¾ x 12¾" WHERE zst_perforation.id = 2627 ;
UPDATE colnect.zst_perforation SET name = "comb 13¾ x 13" WHERE zst_perforation.id = 698 ;
UPDATE colnect.zst_perforation SET name = "comb 13¾ x 13¼" WHERE zst_perforation.id = 198 ;
UPDATE colnect.zst_perforation SET name = "comb 13¾ x 13½" WHERE zst_perforation.id = 157 ;
UPDATE colnect.zst_perforation SET name = "comb 13¾ x 14" WHERE zst_perforation.id = 45 ;
UPDATE colnect.zst_perforation SET name = "comb 13¾ x 14¼" WHERE zst_perforation.id = 196 ;
UPDATE colnect.zst_perforation SET name = "comb 13¾ x 14½" WHERE zst_perforation.id = 172 ;
UPDATE colnect.zst_perforation SET name = "comb 14" WHERE zst_perforation.id = 46 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 12¾" WHERE zst_perforation.id = 2630 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 13" WHERE zst_perforation.id = 2624 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 13¼" WHERE zst_perforation.id = 208 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 13½" WHERE zst_perforation.id = 202 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 13¾" WHERE zst_perforation.id = 49 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 14¼" WHERE zst_perforation.id = 159 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 14½" WHERE zst_perforation.id = 164 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 14¾" WHERE zst_perforation.id = 1822 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 12" WHERE zst_perforation.id = 1739 ;
UPDATE colnect.zst_perforation SET name = "comb 14 x 15" WHERE zst_perforation.id = 799 ;
UPDATE colnect.zst_perforation SET name = "comb 14¼" WHERE zst_perforation.id = 301 ;
UPDATE colnect.zst_perforation SET name = "comb 14¼ x 13½" WHERE zst_perforation.id = 203 ;
UPDATE colnect.zst_perforation SET name = "comb 14¼ x 13¾" WHERE zst_perforation.id = 195 ;
UPDATE colnect.zst_perforation SET name = "comb 14¼ x 14" WHERE zst_perforation.id = 158 ;
UPDATE colnect.zst_perforation SET name = "comb 14¼ x 14¾" WHERE zst_perforation.id = 1824 ;
UPDATE colnect.zst_perforation SET name = "comb 14¼ x 13" WHERE zst_perforation.id = 1738 ;
UPDATE colnect.zst_perforation SET name = "comb 14¼ x 15" WHERE zst_perforation.id = 1618 ;
UPDATE colnect.zst_perforation SET name = "comb 14½" WHERE zst_perforation.id = 787 ;
UPDATE colnect.zst_perforation SET name = "comb 14½ x 13" WHERE zst_perforation.id = 2647 ;
UPDATE colnect.zst_perforation SET name = "comb 14½ x 13¾" WHERE zst_perforation.id = 173 ;
UPDATE colnect.zst_perforation SET name = "comb 14½ x 14" WHERE zst_perforation.id = 38 ;
UPDATE colnect.zst_perforation SET name = "comb 14½ x 13½" WHERE zst_perforation.id = 1786 ;
UPDATE colnect.zst_perforation SET name = "comb 14½ x 15" WHERE zst_perforation.id = 1851 ;
UPDATE colnect.zst_perforation SET name = "comb 14¾" WHERE zst_perforation.id = 1499 ;
UPDATE colnect.zst_perforation SET name = "comb 14¾ x 14" WHERE zst_perforation.id = 1821 ;
UPDATE colnect.zst_perforation SET name = "comb 14¾ x 14½" WHERE zst_perforation.id = 2247 ;
UPDATE colnect.zst_perforation SET name = "comb 14¾ x 14¼" WHERE zst_perforation.id = 749 ;
UPDATE colnect.zst_perforation SET name = "comb 15" WHERE zst_perforation.id = 751 ;
UPDATE colnect.zst_perforation SET name = "comb 15 x 14" WHERE zst_perforation.id = 748 ;
UPDATE colnect.zst_perforation SET name = "comb 15 x 14¼" WHERE zst_perforation.id = 1850 ;
UPDATE colnect.zst_perforation SET name = "comb 15 x 14½" WHERE zst_perforation.id = 2513 ;
UPDATE colnect.zst_perforation SET name = "comb 17½ x 18" WHERE zst_perforation.id = 1525 ;
UPDATE colnect.zst_perforation SET name = "frame 10½" WHERE zst_perforation.id = 3481 ;
UPDATE colnect.zst_perforation SET name = "frame 10¾" WHERE zst_perforation.id = 798 ;
UPDATE colnect.zst_perforation SET name = "frame 11" WHERE zst_perforation.id = 292 ;
UPDATE colnect.zst_perforation SET name = "frame 11 x 11½" WHERE zst_perforation.id = 2399 ;
UPDATE colnect.zst_perforation SET name = "frame 11¼" WHERE zst_perforation.id = 90 ;
UPDATE colnect.zst_perforation SET name = "frame 11¼ x 11" WHERE zst_perforation.id = 1103 ;
UPDATE colnect.zst_perforation SET name = "frame 11¼ x 11½" WHERE zst_perforation.id = 265 ;
UPDATE colnect.zst_perforation SET name = "frame 11¼ x 11¾" WHERE zst_perforation.id = 834 ;
UPDATE colnect.zst_perforation SET name = "frame 11¼ x 12¼" WHERE zst_perforation.id = 127 ;
UPDATE colnect.zst_perforation SET name = "frame 11½" WHERE zst_perforation.id = 85 ;
UPDATE colnect.zst_perforation SET name = "frame 11½ x 11¼" WHERE zst_perforation.id = 247 ;
UPDATE colnect.zst_perforation SET name = "frame 11½ x 11¾" WHERE zst_perforation.id = 69 ;
UPDATE colnect.zst_perforation SET name = "frame 11½ x 12" WHERE zst_perforation.id = 80 ;
UPDATE colnect.zst_perforation SET name = "frame 11½ x 12¼" WHERE zst_perforation.id = 95 ;
UPDATE colnect.zst_perforation SET name = "frame 11¾" WHERE zst_perforation.id = 21 ;
UPDATE colnect.zst_perforation SET name = "frame 11¾ x 11¼" WHERE zst_perforation.id = 833 ;
UPDATE colnect.zst_perforation SET name = "frame 11¾ x 11½" WHERE zst_perforation.id = 92 ;
UPDATE colnect.zst_perforation SET name = "frame 11¾ x 12" WHERE zst_perforation.id = 258 ;
UPDATE colnect.zst_perforation SET name = "frame 11¾ x 12¼" WHERE zst_perforation.id = 99 ;
UPDATE colnect.zst_perforation SET name = "frame 12" WHERE zst_perforation.id = 98 ;
UPDATE colnect.zst_perforation SET name = "frame 12 x 11½" WHERE zst_perforation.id = 75 ;
UPDATE colnect.zst_perforation SET name = "frame 12 x 11¾" WHERE zst_perforation.id = 107 ;
UPDATE colnect.zst_perforation SET name = "frame 12 x 12¼" WHERE zst_perforation.id = 97 ;
UPDATE colnect.zst_perforation SET name = "frame 12 x 12½" WHERE zst_perforation.id = 102 ;
UPDATE colnect.zst_perforation SET name = "frame 12¼" WHERE zst_perforation.id = 136 ;
UPDATE colnect.zst_perforation SET name = "frame 12¼ x 11¼" WHERE zst_perforation.id = 287 ;
UPDATE colnect.zst_perforation SET name = "frame 12¼ x 11¾" WHERE zst_perforation.id = 134 ;
UPDATE colnect.zst_perforation SET name = "frame 12¼ x 12" WHERE zst_perforation.id = 87 ;
UPDATE colnect.zst_perforation SET name = "frame 12½" WHERE zst_perforation.id = 33 ;
UPDATE colnect.zst_perforation SET name = "frame 12½ x 11½" WHERE zst_perforation.id = 284 ;
UPDATE colnect.zst_perforation SET name = "frame 12½ x 12" WHERE zst_perforation.id = 71 ;
UPDATE colnect.zst_perforation SET name = "frame 12½ x 12¾" WHERE zst_perforation.id = 55 ;
UPDATE colnect.zst_perforation SET name = "frame 12½ x 13" WHERE zst_perforation.id = 2412 ;
UPDATE colnect.zst_perforation SET name = "frame 12¾" WHERE zst_perforation.id = 302 ;
UPDATE colnect.zst_perforation SET name = "frame 12¾ x 13¼" WHERE zst_perforation.id = 307 ;
UPDATE colnect.zst_perforation SET name = "frame 13" WHERE zst_perforation.id = 28 ;
UPDATE colnect.zst_perforation SET name = "frame 13 x 12¾" WHERE zst_perforation.id = 322 ;
UPDATE colnect.zst_perforation SET name = "frame 13 x 13¼" WHERE zst_perforation.id = 126 ;
UPDATE colnect.zst_perforation SET name = "frame 13 x 13¾" WHERE zst_perforation.id = 312 ;
UPDATE colnect.zst_perforation SET name = "frame 13 x 12½" WHERE zst_perforation.id = 2401 ;
UPDATE colnect.zst_perforation SET name = "frame 13¼" WHERE zst_perforation.id = 36 ;
UPDATE colnect.zst_perforation SET name = "frame 13¼ x 12¾" WHERE zst_perforation.id = 204 ;
UPDATE colnect.zst_perforation SET name = "frame 13¼ x 13" WHERE zst_perforation.id = 141 ;
UPDATE colnect.zst_perforation SET name = "frame 13¼ x 13½" WHERE zst_perforation.id = 29 ;
UPDATE colnect.zst_perforation SET name = "frame 13¼ x 13¾" WHERE zst_perforation.id = 23 ;
UPDATE colnect.zst_perforation SET name = "frame 13¼ x 14" WHERE zst_perforation.id = 1010 ;
UPDATE colnect.zst_perforation SET name = "frame 13½" WHERE zst_perforation.id = 35 ;
UPDATE colnect.zst_perforation SET name = "frame 13½ x 13¼" WHERE zst_perforation.id = 30 ;
UPDATE colnect.zst_perforation SET name = "frame 13½ x 13¾" WHERE zst_perforation.id = 353 ;
UPDATE colnect.zst_perforation SET name = "frame 13½ x 13" WHERE zst_perforation.id = 2410 ;
UPDATE colnect.zst_perforation SET name = "frame 13½ x 14" WHERE zst_perforation.id = 2387 ;
UPDATE colnect.zst_perforation SET name = "frame 13¾" WHERE zst_perforation.id = 50 ;
UPDATE colnect.zst_perforation SET name = "frame 13¾ x 13¼" WHERE zst_perforation.id = 184 ;
UPDATE colnect.zst_perforation SET name = "frame 13¾ x 13½" WHERE zst_perforation.id = 163 ;
UPDATE colnect.zst_perforation SET name = "frame 13¾ x 14" WHERE zst_perforation.id = 53 ;
UPDATE colnect.zst_perforation SET name = "frame 14" WHERE zst_perforation.id = 51 ;
UPDATE colnect.zst_perforation SET name = "frame 14 x 13¼" WHERE zst_perforation.id = 1011 ;
UPDATE colnect.zst_perforation SET name = "frame 14 x 13¾" WHERE zst_perforation.id = 4 ;
UPDATE colnect.zst_perforation SET name = "frame 14 x 14½" WHERE zst_perforation.id = 54 ;
UPDATE colnect.zst_perforation SET name = "frame 14 x 14¾" WHERE zst_perforation.id = 1834 ;
UPDATE colnect.zst_perforation SET name = "frame 14 x 12¾" WHERE zst_perforation.id = 2409 ;
UPDATE colnect.zst_perforation SET name = "frame 14 x 13" WHERE zst_perforation.id = 2385 ;
UPDATE colnect.zst_perforation SET name = "frame 14 x 13½" WHERE zst_perforation.id = 2386 ;
UPDATE colnect.zst_perforation SET name = "frame 14¼" WHERE zst_perforation.id = 168 ;
UPDATE colnect.zst_perforation SET name = "frame 14¼ x 13½" WHERE zst_perforation.id = 2336 ;
UPDATE colnect.zst_perforation SET name = "frame 14½" WHERE zst_perforation.id = 2402 ;
UPDATE colnect.zst_perforation SET name = "frame 14½ x 14¼" WHERE zst_perforation.id = 6 ;
UPDATE colnect.zst_perforation SET name = "frame 14½ x 13½" WHERE zst_perforation.id = 2411 ;
UPDATE colnect.zst_perforation SET name = "frame 14½ x 14" WHERE zst_perforation.id = 2400 ;
UPDATE colnect.zst_perforation SET name = "frame 14¾ x 14" WHERE zst_perforation.id = 18 ;
UPDATE colnect.zst_perforation SET name = "frame 14¾ x 14½" WHERE zst_perforation.id = 1835 ;
UPDATE colnect.zst_perforation SET name = "frame 15" WHERE zst_perforation.id = 2413 ;
UPDATE colnect.zst_perforation SET name = "frame 18" WHERE zst_perforation.id = 652 ;
UPDATE colnect.zst_perforation SET name = "line 12½ x 13" WHERE zst_perforation.id = 1902 ;
UPDATE colnect.zst_perforation SET name = "line 13 x 12½" WHERE zst_perforation.id = 1894 ;
UPDATE colnect.zst_perforation SET name = "line 13 x 13¼" WHERE zst_perforation.id = 2035 ;
UPDATE colnect.zst_perforation SET name = "line 13 x 13½" WHERE zst_perforation.id = 1884 ;
UPDATE colnect.zst_perforation SET name = "line 13½ x 13" WHERE zst_perforation.id = 1901 ;
UPDATE colnect.zst_perforation SET name = "line 11½ x 13" WHERE zst_perforation.id = 2218 ;
UPDATE colnect.zst_perforation SET name = "line 13 x 11½" WHERE zst_perforation.id = 2219 ;
UPDATE colnect.zst_perforation SET name = "line 10" WHERE zst_perforation.id = 235 ;
UPDATE colnect.zst_perforation SET name = "line 10¼" WHERE zst_perforation.id = 1055 ;
UPDATE colnect.zst_perforation SET name = "line 10½" WHERE zst_perforation.id = 230 ;
UPDATE colnect.zst_perforation SET name = "line 10½ x 12" WHERE zst_perforation.id = 2405 ;
UPDATE colnect.zst_perforation SET name = "line 10¾" WHERE zst_perforation.id = 832 ;
UPDATE colnect.zst_perforation SET name = "line 11" WHERE zst_perforation.id = 246 ;
UPDATE colnect.zst_perforation SET name = "line 11 x 11½" WHERE zst_perforation.id = 3527 ;
UPDATE colnect.zst_perforation SET name = "line 11 x 12¼" WHERE zst_perforation.id = 4740 ;
UPDATE colnect.zst_perforation SET name = "line 11¼" WHERE zst_perforation.id = 846 ;
UPDATE colnect.zst_perforation SET name = "line 11¼ x 12" WHERE zst_perforation.id = 877 ;
UPDATE colnect.zst_perforation SET name = "line 11½" WHERE zst_perforation.id = 954 ;
UPDATE colnect.zst_perforation SET name = "line 11½ x 11" WHERE zst_perforation.id = 2424 ;
UPDATE colnect.zst_perforation SET name = "line 11½ x 12" WHERE zst_perforation.id = 2645 ;
UPDATE colnect.zst_perforation SET name = "line 11½ x 12½" WHERE zst_perforation.id = 1755 ;
UPDATE colnect.zst_perforation SET name = "line 12" WHERE zst_perforation.id = 788 ;
UPDATE colnect.zst_perforation SET name = "line 12 x 11¼" WHERE zst_perforation.id = 879 ;
UPDATE colnect.zst_perforation SET name = "line 12¼" WHERE zst_perforation.id = 238 ;
UPDATE colnect.zst_perforation SET name = "line 12½" WHERE zst_perforation.id = 236 ;
UPDATE colnect.zst_perforation SET name = "line 12½ x 11½" WHERE zst_perforation.id = 4758 ;
UPDATE colnect.zst_perforation SET name = "line 12½ x 12¾" WHERE zst_perforation.id = 1715 ;
UPDATE colnect.zst_perforation SET name = "line 12¾" WHERE zst_perforation.id = 1680 ;
UPDATE colnect.zst_perforation SET name = "line 13" WHERE zst_perforation.id = 1540 ;
UPDATE colnect.zst_perforation SET name = "line 13 x 12¾" WHERE zst_perforation.id = 1690 ;
UPDATE colnect.zst_perforation SET name = "line 13¼ x 14" WHERE zst_perforation.id = 1149 ;
UPDATE colnect.zst_perforation SET name = "line 13¼" WHERE zst_perforation.id = 2232 ;
UPDATE colnect.zst_perforation SET name = "line 13¼ x 13" WHERE zst_perforation.id = 1058 ;
UPDATE colnect.zst_perforation SET name = "line 13½" WHERE zst_perforation.id = 1066 ;
UPDATE colnect.zst_perforation SET name = "line 13¾" WHERE zst_perforation.id = 242 ;
UPDATE colnect.zst_perforation SET name = "line 13¾ x 14" WHERE zst_perforation.id = 880 ;
UPDATE colnect.zst_perforation SET name = "line 14" WHERE zst_perforation.id = 244 ;
UPDATE colnect.zst_perforation SET name = "line 14 x 12¼" WHERE zst_perforation.id = 4739 ;
UPDATE colnect.zst_perforation SET name = "line 14 x 13¾" WHERE zst_perforation.id = 878 ;
UPDATE colnect.zst_perforation SET name = "line 14 x 13" WHERE zst_perforation.id = 1150 ;
UPDATE colnect.zst_perforation SET name = "line 14½" WHERE zst_perforation.id = 1732 ;
UPDATE colnect.zst_perforation SET name = "line 14½ x 14" WHERE zst_perforation.id = 4757 ;
UPDATE colnect.zst_perforation SET name = "line 15" WHERE zst_perforation.id = 2562 ;
UPDATE colnect.zst_perforation SET name = "line  9" WHERE zst_perforation.id = 2406 ;
UPDATE colnect.zst_perforation SET name = "line  9½" WHERE zst_perforation.id = 2501 ;
UPDATE colnect.zst_perforation SET name = "line  9¾" WHERE zst_perforation.id = 965 ;
UPDATE colnect.zst_perforation SET name = "Punched 10 x 11¼" WHERE zst_perforation.id = 1909 ;
UPDATE colnect.zst_perforation SET name = "Punched 11½ x 12" WHERE zst_perforation.id = 1815 ;
UPDATE colnect.zst_perforation SET name = "Punched 12¼" WHERE zst_perforation.id = 1908 ;
UPDATE colnect.zst_perforation SET name = "Punched  6¼" WHERE zst_perforation.id = 1998 ;
UPDATE colnect.zst_perforation SET name = "Punched  7½" WHERE zst_perforation.id = 1758 ;
UPDATE colnect.zst_perforation SET name = "Punched 10½ x 11" WHERE zst_perforation.id = 1925 ;
UPDATE colnect.zst_perforation SET name = "Punched 12" WHERE zst_perforation.id = 1920 ;
UPDATE colnect.zst_perforation SET name = "Punched 12½" WHERE zst_perforation.id = 1924 ;
UPDATE colnect.zst_perforation SET name = "Punched 13" WHERE zst_perforation.id = 4346 ;
UPDATE colnect.zst_perforation SET name = "Punched 13 x 13¼" WHERE zst_perforation.id = 2184 ;
UPDATE colnect.zst_perforation SET name = "Punched 13¼ x 13½" WHERE zst_perforation.id = 1613 ;
UPDATE colnect.zst_perforation SET name = "Punched  7¼" WHERE zst_perforation.id = 1808 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 10½ x 10¾ on 2 sides" WHERE zst_perforation.id = 509 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut 11¼ x 11½" WHERE zst_perforation.id = 448 ;
UPDATE colnect.zst_perforation SET name = "Serpentine Die Cut" WHERE zst_perforation.id = 4770 ;

[tcawe]

SQLs launched. Please send a Duplicates report here and I'll process it.

[DarioDeSantis]

Is there any other good-willing collector available to fill in these duplicate data on his spreadsheet programme and attach the relative report here? Here come their IDs again:

357 = 436

2593 = 2302

385 = 356

4762 = 1887

4777 = 1437

4771 = 2191

363 = 404 = 424 (yes, three of the same)

410 = 942

452 = 456

[DarioDeSantis]

Gosh! Nobody seems to have enough time to make a duplicate report. Is it really that difficult?

I know some people were complaining about the difficulty to use a NIF just to add one or two stamps. How about complaining about how hard(er) it is to delete one or two items?