Skip to content

Instantly share code, notes, and snippets.

@japharr

japharr/.sql

Last active February 7, 2017 14:39
Show Gist options
  • Save japharr/8dd8d1dc9e47dcd3448b70b9dd097e22 to your computer and use it in GitHub Desktop.
Save japharr/8dd8d1dc9e47dcd3448b70b9dd097e22 to your computer and use it in GitHub Desktop.
Download ZIP
saveit
Raw
.sql
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 384 AU'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 820 AE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 955 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 167 CM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'JJJ 417 AS'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 45 BX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSD 758 BB'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSD 760 BB'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'MUS 195 AY'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003331 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = '​KTU 829 BD'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AAA 798 CP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 03 CP '
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 375 AT'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 368 CB'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 652 DQ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FKJ 470 CN'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 968 DM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 629 CF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LND 937 BX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003278 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = '​FKJ 513 BT'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 457 BZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 972 BV'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 693 CC'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 780 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 896 BZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 537 AH'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 921 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FKJ 53 CZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 611 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 875 CA'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 360 BF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LND 920 BX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LND 938 BX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 159 BZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003338 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 828 BW'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AAA 643 BM    '
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AAA 799 CT'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AAA 841 AW'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 268 CE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 971 BV'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 787 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 905 CJ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'APP 479 XK'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 717 BX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BU 532 EPE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EKY 95 AW'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 306 CL'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 315 AA'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 392 BM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FKJ 246 CF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FKJ 491 BC'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FST 172 BP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FST 305 AX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 599 CW'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 348 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 640 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 991 DP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KTU 137 CC'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KTU 197 BZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LND 204 XL'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LND 531 CK'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSD 134 CM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSD 175 AT'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'MUS 254 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'MUS 263 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'MUS 263 BE '
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'MUS 739 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 559 CM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283663 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 827 BW'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AAA 796 CP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 315 CE '
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 539 AH'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EJ 254 EKY'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 612 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 826 CC'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KTU 254 BB'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSD 173 AT'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSD 174 AT'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 70785235 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSD 907 CY'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 131 AW'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 318 CE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 276 CQ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 379 BM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 910 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 915 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 761 CP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 172 CP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'JJJ 461 DQ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 615 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 684 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 830 DF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KTU 178 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003345 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 905 DM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 513 AG'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 515 AG'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'APP 734 BD'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'APP 907 CV'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BGW 47 AA'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FST 181 BH'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'JJJ 718 AY'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'JJJ 720 AY'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 724 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 648 BF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 648 BF '
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 796 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LND 626 CZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261376 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'MUS 883 CV'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261383 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 278 CQ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261383 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'APP 324 CM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261383 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 691 DA'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261383 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 361 CB'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261383 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'JJJ 661 BZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261383 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 354 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261383 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 785 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261383 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KTU 253 BB'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81261383 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSD 537 AJ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283770 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AAA 237 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283770 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BGW 49 AX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283770 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 44 DB'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283770 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FKJ 794 CJ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283770 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'JJJ 727 AY'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283770 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 523 CM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283770 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 856 BX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283770 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 886 AV'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283770 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSR 390 AX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283814 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 132 AW'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283814 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 325 CE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283814 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'APP 946 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283814 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 916 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283814 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FKJ 245 CF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283814 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 735 CN'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283814 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LND 288 BK'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283814 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'MUS 14 AC'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 784 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 899 BZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'APP 468 AT'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'APP 477 XK'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 308 CL'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 658 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 824 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FKJ 618 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 312 BZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 697 CC'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSD 419 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283807 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSR 44 AS'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003311 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AAA 797 CP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003311 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 177 CA'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003311 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EKY 23 CD'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003311 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FKJ 793 CJ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003311 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FST 182 BH'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003311 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 327 DV'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003311 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 608 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003311 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 614 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003311 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KTU 851 BD'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283800 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 767 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283800 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 158 BH'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283800 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 384 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283800 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 962 AA'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283800 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 174 CP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283800 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 240 BJ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283800 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 365 BJ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003324 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 832 AZ '
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003324 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 953 AZ '
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003324 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 318 BG'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003324 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 685 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003324 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 601 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003324 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 602 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AGL 541 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 685 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 687 DA'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 313 CF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 543 BW'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'FST 328 BG '
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 725 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 291 BC'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 339 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 356 AP'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 474 BS'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 685 DE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 847 DA'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KTU 184 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LND 143 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LND 159 CV'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSR 164 AY'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'LSR 389 AX'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'MUS 253 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'MUS 44 CA'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'PF 401 SPY (KRD 343 BL)'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 425 BF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 81283783 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 426 BF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'AKD 922 AH'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 357 BM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 540 AH'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 541 AH'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 659 DR'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'EPE 816 AU'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 736 CN'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 173 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 362 BF'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003285 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KTU 257 BB'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 432 AR'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'BDG 917 AM'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'GGE 703 CC'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KRD 165 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KSF 552 CN'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'KTU 176 BE'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'RSH 736 HN'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 613 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 615 AZ'
);
UPDATE vehicleparameters vp
SET vp.REGION_ID = 71003292 WHERE vp.VEHICLE_ID =
(
SELECT v.ID
FROM vehicle v
WHERE v.registrationno = 'SMK 616 AZ'
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment