/* remove duplicate user_id entries */
DELETE FROM `temp_registration` WHERE `temp_reg_id` IN (2225,2235); 

/* restore from backup */
INSERT INTO `temp_registration` (`temp_reg_id`, `ref_id`, `rsa_id`, `username`, `password`, `old_pass`, `old_email`, `old_username`, `password_expire_date`, `first_name`, `middle_name`, `last_name`, `job_title`, `register_type`, `organization_name`, `organization_address_id`, `secret_question_id`, `secret_answer`, `user_type`, `nace_group_id`, `nace_id`, `desc`, `user_id`, `doj`, `verification_code`, `ipaddress`, `csr`, `public_key`, `result`, `payment_id`, `payment_status`, `status`, `confirm`, `permission`, `interface`, `dp_type`, `dp_organisation`, `confirm_type`, `partner_id`, `partner_hashkey`, `created_at`, `modified_at`, `currency_id`, `email`, `apply_id`, `verified`, `certificate`, `certificate_name`, `uged_d`, `uged_c`, `accounting_software_id`, `idf_st`, `idf_r`, `upload_idf`) VALUES
(2225, NULL, 0, 'gerryp@inet.com', '065797287823de815a6620edd5e9ffc6c688aeef3b697b69da92a10c0a6922a1', NULL, NULL, NULL, '2023-03-11', 'Gerry', '', 'Purcell', '', 0, 'Purcell Brothers SPV Unlimited Company', 40192, 0, '', 3, 0, 0, '', 1790, '2022-03-11', '', '', NULL, NULL, NULL, 0, 0, 3, 0, 0, 1, 0, 0, 1, 0, '', '0000-00-00 00:00:00', '2022-03-11 00:00:00', 1, 'gerryp@inet.com', NULL, 0, NULL, NULL, NULL, NULL, 10, NULL, NULL, 0),
(2235, NULL, 0, 'purcell.gerard4@gmail.com', 'ddcf4f71a659a6aa081202007db70ad6de4b811ddea0b4c554260e57d8345069', NULL, NULL, NULL, '2023-04-05', 'Gerard', '', 'Purcell', '', 0, 'Purcell Brothers SPV Unlimited Company', 40192, 0, '', 3, 0, 0, '', 1790, '2022-04-05', '', '', NULL, NULL, NULL, 0, 0, 4, 0, 0, 1, 0, 0, 1, 0, '', '0000-00-00 00:00:00', '2022-04-05 00:00:00', 1, 'purcell.gerard4@gmail.com', NULL, 0, NULL, NULL, NULL, NULL, 10, NULL, NULL, 0);