INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3553, 1, 284, 2, 0, NULL, 0, '2023-07-25 15:50:55', '2023-07-26 09:21:11', '2023-07-25', 'P3336', '23-04744-07-25', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'AV MIL.LENARI Nº29 3º1ª', 'Viladecans', 'Barcelona', '08840', 'España', 43.71, 0, '2023-07-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250723-OvgRRKirTJMU/-185', '40f5aa3a-064b-4f23-93c2-c141aee16832', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250723-OvgRRKirTJMU%2F-185&s=KOL2023&nf=P3336&i=43.71&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3554, 1, 144, 2, 0, NULL, 0, '2023-07-26 09:22:41', '2023-07-26 11:30:23', '2023-07-26', 'P3338', '23-04745-07-26', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 103.46, 0, '2023-07-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260723-Fqouuy1CbzVSS-241', '8654e096-9124-4ed0-a70a-226c9812823d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260723-Fqouuy1CbzVSS-241&s=KOL2023&nf=P3338&i=103.46&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3555, 1, 75, 2, 0, NULL, 0, '2023-07-26 10:09:35', '2023-07-26 12:11:31', '2023-07-26', 'P3339', '23-04746-07-26', 'De martes a viernes de 10 00 a 19 00 ', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 172.43, 0, '2023-07-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260723-EWMGOCyV2r5/m-223', '18fc72ac-f20b-4417-bac4-3da3b112a1a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260723-EWMGOCyV2r5%2Fm-223&s=KOL2023&nf=P3339&i=172.43&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3556, 1, 897, 2, 0, NULL, 0, '2023-07-26 10:16:20', '2023-07-26 12:45:25', '2023-07-26', 'P3340', '23-04747-07-26', 'sino estoy lo pueden dejar en la tienda de motos de la esquina Stop & Go', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Baix de Sant Pere, 76 local B', 'Montcada i Reixac', 'Barcelona', '08110', 'España', 17.50, 0, '2023-07-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260723-A3jx7Ftlt764q-031', '4e69ef37-0f18-4602-9801-85829585f31a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260723-A3jx7Ftlt764q-031&s=KOL2023&nf=P3340&i=17.50&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3557, 1, 754, 2, 0, NULL, 0, '2023-07-26 13:05:48', '2023-07-27 09:17:15', '2023-07-26', 'P3341', '23-04748-07-26', '', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2023-07-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260723-N6gYMoKVwzgEY-134', '84edf167-5339-4d8e-9a45-ac561ac49d3e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260723-N6gYMoKVwzgEY-134&s=KOL2023&nf=P3341&i=61.64&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3558, 1, 898, 2, 0, NULL, 0, '2023-07-26 13:27:37', '2023-07-27 09:18:08', '2023-07-26', 'P3342', '23-04749-07-26', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'beato tomas de zumarraga n2 3C', 'Vitoria-Gasteiz', 'Álava', '1008', 'España', 17.50, 0, '2023-07-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260723-mLa/ipU4NDz6R-208', 'fd47d1d0-8b02-458a-a051-75350c4daa1b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260723-mLa%2FipU4NDz6R-208&s=KOL2023&nf=P3342&i=17.50&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3559, 1, 264, 2, 0, NULL, 0, '2023-07-27 07:39:34', '2023-07-27 09:55:51', '2023-07-27', 'P3343', '23-04750-07-27', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Gran via de les corts catalanes 432 ent 2', 'Barcelona', 'Barcelona', '08015', 'España', 17.50, 0, '2023-07-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270723-dDOid7xY5+ghi-204', '437bbb67-4288-4ed3-80ac-5a1b9ff24d4d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270723-dDOid7xY5%2Bghi-204&s=KOL2023&nf=P3343&i=17.50&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3560, 1, 40, 2, 0, NULL, 0, '2023-07-27 16:38:44', '2023-07-28 08:35:37', '2023-07-27', 'P3344', '23-04752-07-27', 'lunes 31 fiesta y cerrado el martes tambien', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 147.79, 0, '2023-07-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270723-IKzZEicVbduIv-048', 'd9529f2f-85f1-41d5-9f7d-325088cd8a81', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270723-IKzZEicVbduIv-048&s=KOL2023&nf=P3344&i=147.79&cr=237', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3561, 1, 899, 2, 0, NULL, 0, '2023-07-27 16:59:09', '2023-07-28 08:38:46', '2023-07-27', 'P3345', '23-04753-07-27', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'c/ Río Nalón 33 5A', 'Oviedo', 'Asturias', '33010', 'España', 17.50, 0, '2023-07-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270723-anuClFUwS0TZH-085', '564ae530-3be4-4f21-969c-8ded3136a396', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270723-anuClFUwS0TZH-085&s=KOL2023&nf=P3345&i=17.50&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3562, 1, 582, 2, 0, NULL, 0, '2023-07-27 17:37:27', '2023-07-28 08:41:29', '2023-07-27', 'P3346', '23-04754-07-27', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Mar Mediterráneo 40', 'San Fernando de Hena', 'Madrid', '28830', 'España', 28.39, 0, '2023-07-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270723-mqkCX4UW1iknB-205', 'ad6e8457-3abb-4025-9e27-78936adae0cb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270723-mqkCX4UW1iknB-205&s=KOL2023&nf=P3346&i=28.39&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3563, 1, 145, 2, 0, NULL, 0, '2023-07-28 15:27:01', '2023-08-01 09:25:52', '2023-07-28', 'P3359', '23-04755-07-28', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-280723-XnlhHdQVYPWc+-051', 'e7d38d6b-b241-48b8-83bb-745d36930ce7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280723-XnlhHdQVYPWc%2B-051&s=KOL2023&nf=P3359&i=105.96&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3564, 1, 379, 2, 0, NULL, 0, '2023-07-28 16:08:08', '2023-08-01 09:31:07', '2023-07-28', 'P3347', '23-04756-07-28', 'Se ruega llamar al teléfono móvil antes de la entrega para que esté alguien pendiente.\r\nGracias. Saludos', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Mazarredo nº 81, 5º izquierda izquierda', 'Bilbao', 'Bizkaia', '48009', 'España', 30.61, 0, '2023-07-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280723-K2tzK1ux3JamB-253', '27ec8869-77eb-4f8d-b0f2-3f0c0ef077b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280723-K2tzK1ux3JamB-253&s=KOL2023&nf=P3347&i=30.61&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3565, 1, 900, 2, 0, NULL, 0, '2023-07-29 10:44:54', '2023-08-01 09:34:37', '2023-07-29', 'P3348', '23-04757-07-29', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle de Miguel Servet, 17, -', 'Monzón', 'Huesca', '22400', 'España', 56.82, 0, '2023-07-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290723-AMGfg1GJq813m-082', '55b82b05-10cb-4930-95c5-7c009abd99e1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290723-AMGfg1GJq813m-082&s=KOL2023&nf=P3348&i=56.82&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3566, 1, 269, 2, 0, NULL, 0, '2023-07-29 11:24:58', '2023-08-01 09:37:35', '2023-07-29', 'P3349', '23-04759-07-29', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Atxutegi N2 1E', 'Erandio', 'Bizkaia', '48950', 'España', 17.50, 0, '2023-07-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290723-cOJfHFAJxa28Y-245', '19152da5-2da0-4296-ab2d-966846b7c441', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290723-cOJfHFAJxa28Y-245&s=KOL2023&nf=P3349&i=17.50&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3567, 1, 135, 2, 0, NULL, 0, '2023-07-29 20:28:10', '2023-08-01 09:42:42', '2023-07-29', 'P3360', '23-04762-07-29', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'C/ Moraza N15', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 551.76, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290723-LqvO7BMFT8kK3-171', 'b6a77b3f-f437-4577-b3fb-d67bd5f2e60e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290723-LqvO7BMFT8kK3-171&s=KOL2023&nf=P3360&i=551.76&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3568, 1, 712, 2, 0, NULL, 0, '2023-07-30 11:41:25', '2023-08-01 09:46:20', '2023-07-30', 'P3350', '23-04763-07-30', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Río Cubas 7 5°izda', 'Santander', 'Cantabria', '39004', 'España', 30.61, 0, '2023-07-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300723-ZaeW7zaJnb/EN-005', '22732066-9265-4045-86fd-a27c591c1652', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300723-ZaeW7zaJnb%2FEN-005&s=KOL2023&nf=P3350&i=30.61&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3569, 1, 741, 2, 0, NULL, 0, '2023-07-30 16:00:45', '2023-08-01 09:49:22', '2023-07-30', 'P3351', '23-04764-07-30', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Jerusalen, 13 3 B', 'Cáceres', 'Cáceres', '10005', 'España', 17.50, 0, '2023-07-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300723-Hh6POo6absPPn-071', '1ecd0218-dbbb-454a-b777-0f4dc40b6600', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300723-Hh6POo6absPPn-071&s=KOL2023&nf=P3351&i=17.50&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3570, 1, 558, 2, 0, NULL, 0, '2023-07-30 21:34:19', '2023-08-01 09:51:20', '2023-07-30', 'P3352', '23-04765-07-30', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Miramar n 2 8 C CadiZ', 'Cádiz', 'Cádiz', '11010', 'España', 17.50, 0, '2023-07-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300723-J5G81yVz3qHfE-089', 'dccab4ff-08ab-45d2-b927-048cd66059dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300723-J5G81yVz3qHfE-089&s=KOL2023&nf=P3352&i=17.50&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3571, 1, 901, 2, 0, NULL, 0, '2023-07-31 06:32:25', '2023-08-01 09:58:56', '2023-07-31', 'P3353', '23-04766-07-31', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida Nuevo Mundo, 4 local 6', 'Madrid', 'Madrid', '28660', 'España', 17.50, 0, '2023-07-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310723-DCHNCWkVoumEn-121', '9fad40b9-50ee-46e5-82a1-9a213cc1b0d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310723-DCHNCWkVoumEn-121&s=KOL2023&nf=P3353&i=17.50&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3572, 1, 902, 2, 0, NULL, 0, '2023-07-31 08:18:49', '2023-08-01 10:02:45', '2023-07-31', 'P3354', '23-04767-07-31', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'AV SANCHO EL FUERTE 49 1 (ORHY ASESORES)', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 17.50, 0, '2023-07-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310723-YBHNnVSIxpKeB-226', 'cd850601-cd89-4d9e-909c-21f0ec99e70a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310723-YBHNnVSIxpKeB-226&s=KOL2023&nf=P3354&i=17.50&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3573, 1, 897, 2, 0, NULL, 0, '2023-07-31 11:52:25', '2023-08-01 10:06:14', '2023-07-31', 'P3355', '23-04768-07-31', 'Sino estoy lo pueden dejar en la tienda de motos de la esquina stop&Go', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Baix de Sant Pere, 76 local B con esquina sant ignasi', 'Montcada i Reixac', 'Barcelona', '08110', 'España', 30.61, 0, '2023-07-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310723-YORDkAxgbQSTU-071', '0d93f454-3f23-47ac-b73a-41a873647ef6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310723-YORDkAxgbQSTU-071&s=KOL2023&nf=P3355&i=30.61&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3574, 1, 722, 2, 0, NULL, 0, '2023-07-31 16:30:29', '2023-08-01 10:10:41', '2023-07-31', 'P3356', '23-04769-07-31', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Gregal 4, Edificio Alcotán II, Apartamento 76', 'Villajoyosa/Vila Joi', 'Alicante', '03570', 'España', 28.39, 0, '2023-07-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310723-H8Ob8NF+Mei65-250', '4670aa13-e0a2-445a-a49c-dab0deb6a377', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310723-H8Ob8NF%2BMei65-250&s=KOL2023&nf=P3356&i=28.39&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3575, 1, 4, 2, 0, NULL, 0, '2023-07-31 17:08:40', '2023-08-01 10:17:03', '2023-07-31', 'P3357', '23-04770-07-31', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 310.37, 0, '2023-07-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310723-ctLZ+YxtTtaXC-045', 'f137f0a6-71a5-4f0c-a9f1-4114359e2c5a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310723-ctLZ%2BYxtTtaXC-045&s=KOL2023&nf=P3357&i=310.37&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3576, 1, 759, 2, 0, NULL, 0, '2023-08-01 06:32:45', '2023-08-01 10:19:57', '2023-08-01', 'P3358', '23-04771-08-01', 'Se trata de un edificio de Caixabank. Subir las escaleras y a mano derecha.', 0.00, 90.15, 18.93, 0.00, 0, 0.00, 0.00, 'Calle del Pintor Sorolla, 8', 'Valencia', 'Valencia', '46002', 'España', 109.08, 0, '2023-08-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010823-T5Kugoptsr+h/-130', '89abd8cc-1b68-4f64-aa19-8ec497a6d493', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-T5Kugoptsr%2Bh%2F-130&s=KOL2023&nf=P3358&i=109.08&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3577, 1, 149, 2, 0, NULL, 0, '2023-08-01 07:30:05', '2023-08-01 12:19:44', '2023-08-01', 'P3362', '23-04772-08-01', '', 0.00, 158.78, 33.34, 0.00, 0, 0.00, 0.00, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 192.12, 0, '2023-08-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010823-MpwKRIfOLayLk-045', 'edd9d19f-b003-4a34-963f-934849045aac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-MpwKRIfOLayLk-045&s=KOL2023&nf=P3362&i=192.12&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3578, 1, 712, 2, 1, 'lote incorrecto', 3568, '2023-08-01 10:34:58', '2023-08-01 10:34:58', '2023-08-01', 'R49', 'P3350 RECT.', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, '', '', '', '', '', 30.61, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-010823-ozSJW4OWp/DhK-101', '711ada3d-a93c-4d27-a49f-422204294ecb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-ozSJW4OWp%2FDhK-101&s=KOL2023&nf=R49&i=-30.61&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(3579, 1, 712, 1, 0, NULL, 0, '2023-08-01 10:40:13', '2023-08-01 10:41:06', '2023-08-01', 'P3361', '2023-08-01', '', 0.00, 16.28, 3.42, 0.00, 0, 0.00, 0.00, 'Rio cubas 7 5°izda', 'Santander', 'Cantabria', '39004', 'España', 19.70, 0, '2023-08-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010823-l/VLnANBdnwIg-228', '5c331953-4b75-40ec-8745-9194d4388694', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-l%2FVLnANBdnwIg-228&s=KOL2023&nf=P3361&i=19.70&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3580, 1, 712, 1, 1, 'gastos de envio incorrectos', 3579, '2023-08-01 10:42:26', '2023-08-01 10:42:26', '2023-08-01', 'R50', 'P3361 RECT.', '', 0.00, 16.28, 3.42, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 19.70, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-010823-UOGRnZLdNFwn3-190', '941b0d61-82d9-49aa-8782-6edd1cddded1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-UOGRnZLdNFwn3-190&s=KOL2023&nf=R50&i=-19.70&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3581, 1, 712, 1, 0, NULL, 0, '2023-08-01 10:44:44', '2023-08-30 13:01:58', '2023-08-01', 'P3476', '2023-08-01', '', 0.00, 16.28, 4.18, 0.00, 1, 1.04, 4.40, 'Rio cubas 7 5°izda', 'Santander', 'Cantabria', '39004', 'España', 25.14, 0, '2023-08-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010823-ITxJDA36drkJN-214', 'aa89f4b9-714f-4fca-9881-9f880c42620f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-ITxJDA36drkJN-214&s=KOL2023&nf=P3476&i=25.14&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3582, 1, 242, 1, 0, NULL, 0, '2023-08-01 11:03:18', '2023-08-01 11:06:29', '2023-08-01', 'P3363', '2023-08-01', '', 0.00, 89.54, 18.80, 0.00, 1, 4.66, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 113.00, 0, '2023-08-01 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010823-JF7sUtwz2IbMN-229', '780ca6bd-ff1a-4c30-85e7-62ad971592b7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-JF7sUtwz2IbMN-229&s=KOL2023&nf=P3363&i=113.00&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3583, 1, 242, 1, 1, 'faltan productos', 3582, '2023-08-01 11:21:37', '2023-08-01 11:21:37', '2023-08-01', 'R51', 'P3363 RECT.', '', 0.00, 89.54, 18.80, 0.00, 0, 4.66, 0.00, '', '', '', '', '', 113.00, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-010823-Xc8QhHt6v8bDf-163', '5b9ea0bf-6112-4695-b90f-c2d6683761d4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-Xc8QhHt6v8bDf-163&s=KOL2023&nf=R51&i=-113.00&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3584, 1, 242, 1, 0, NULL, 0, '2023-08-01 11:25:33', '2023-08-01 11:29:48', '2023-08-01', 'P3364', '2023-08-01', '', 0.00, 146.52, 30.77, 0.00, 1, 7.62, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 184.91, 0, '2023-08-01 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010823-BryYHFIo581EM-021', '4ac12c89-93f8-468a-9b0f-b9f9bd8aad62', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-BryYHFIo581EM-021&s=KOL2023&nf=P3364&i=184.91&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3585, 1, 903, 1, 0, NULL, 0, '2023-08-01 12:55:43', '2023-08-01 13:00:11', '2023-08-01', 'P3365', '2023-08-01', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'calle miño 20 ', 'Estepona', 'Málaga', '29680', 'España', 196.56, 0, '2023-08-01 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010823-oWBqTuswAB9FZ-126', 'c04e8a93-160d-4b28-9c4a-ac0676f3a89e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-oWBqTuswAB9FZ-126&s=KOL2023&nf=P3365&i=196.56&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3586, 1, 53, 2, 0, NULL, 0, '2023-08-01 17:15:05', '2023-08-02 09:13:52', '2023-08-01', 'P3366', '23-04773-08-01', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 206.91, 0, '2023-08-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010823-XC15gbunBguIw-188', 'fb0438e4-b987-494e-b2d0-a48c5864d58c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-XC15gbunBguIw-188&s=KOL2023&nf=P3366&i=206.91&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3587, 1, 144, 2, 0, NULL, 0, '2023-08-01 17:37:45', '2023-08-02 09:18:08', '2023-08-01', 'P3367', '23-04774-08-01', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 103.46, 0, '2023-08-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010823-fbkAOeMdCXVTJ-056', '3fbe84de-69b2-46f1-ac95-12eb0a31036a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010823-fbkAOeMdCXVTJ-056&s=KOL2023&nf=P3367&i=103.46&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3588, 1, 160, 2, 0, NULL, 0, '2023-08-02 06:32:37', '2023-08-02 09:20:27', '2023-08-02', 'P3368', '23-04775-08-02', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 137.94, 0, '2023-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020823-A8FRe3kjsRuDe-192', '934544cd-d93e-4b30-b68d-d2cfe709ea27', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020823-A8FRe3kjsRuDe-192&s=KOL2023&nf=P3368&i=137.94&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3589, 1, 154, 2, 0, NULL, 0, '2023-08-02 07:26:12', '2023-08-02 10:12:03', '2023-08-02', 'P3369', '23-04776-08-02', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 241.40, 0, '2023-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020823-b2uCeMO1FknKB-202', '800cf117-c216-4abe-9f33-34be5e2c2f18', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020823-b2uCeMO1FknKB-202&s=KOL2023&nf=P3369&i=241.40&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3590, 1, 110, 2, 0, NULL, 0, '2023-08-02 09:08:52', '2023-08-02 11:17:18', '2023-08-02', 'P3370', '23-04779-08-02', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020823-hMSLE+5dUmZI5-134', 'cbdb3197-d5da-4683-b279-af0cf0c5fd8d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020823-hMSLE%2B5dUmZI5-134&s=KOL2023&nf=P3370&i=275.88&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3591, 1, 28, 2, 0, NULL, 0, '2023-08-02 12:42:01', '2023-08-03 09:54:00', '2023-08-02', 'P3373', '23-04780-08-02', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020823-WTr6cAlSkOFXl-044', '1299ba1b-369a-4aee-920b-23ff75839936', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020823-WTr6cAlSkOFXl-044&s=KOL2023&nf=P3373&i=137.94&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3592, 1, 686, 2, 0, NULL, 0, '2023-08-02 13:14:36', '2023-08-03 09:56:32', '2023-08-02', 'P3371', '23-04782-08-02', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Sancho el sabio 11. Local 3. UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 172.43, 0, '2023-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020823-HEMMDWonL0t1n-186', 'eae3bda3-9e40-41a3-b4c4-4db5fcd02bcc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020823-HEMMDWonL0t1n-186&s=KOL2023&nf=P3371&i=172.43&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3593, 1, 192, 2, 0, NULL, 0, '2023-08-02 13:58:05', '2023-08-03 09:59:14', '2023-08-02', 'P3372', '23-04783-08-02', '', 0.00, 150.64, 31.63, 0.00, 0, 0.00, 0.00, 'plaza San Cristobal 3,bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 182.27, 0, '2023-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020823-VxCdLAODfuMRp-207', 'a758f9eb-9d01-4b50-812e-5bfed5e856f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020823-VxCdLAODfuMRp-207&s=KOL2023&nf=P3372&i=182.27&cr=122', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3594, 1, 904, 2, 0, NULL, 0, '2023-08-02 16:57:01', '2023-08-03 10:06:03', '2023-08-02', 'P3374', '23-04784-08-02', '', 0.00, 162.45, 34.54, 0.00, 0, 0.00, 2.50, 'Calle leon leal 2 ', 'Cáceres', 'Cáceres', '10002', 'España', 199.06, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-020823-VedxSg8j6k72/-063', 'de74b4da-f172-40f1-9580-8f31a9385968', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020823-VedxSg8j6k72%2F-063&s=KOL2023&nf=P3374&i=199.06&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3595, 1, 905, 2, 0, NULL, 0, '2023-08-03 15:56:50', '2023-08-04 09:10:00', '2023-08-03', 'P3375', '23-04785-08-03', 'Hola. Por favor, manden un correo  o llamen  (687 303 802) para comunicarme el dia y hora aproximada de la llegada del paquete. Gracias', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Callejones del Perchel 4, esc. 1 - 6 B', 'Málaga', 'Málaga', '29002', 'España', 17.50, 0, '2023-08-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030823-QyMF7DOMJFOZE-118', 'c0023780-2bbb-4d3a-9a46-c1c51199bafb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030823-QyMF7DOMJFOZE-118&s=KOL2023&nf=P3375&i=17.50&cr=230', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3596, 1, 906, 2, 0, NULL, 0, '2023-08-04 09:35:54', '2023-08-04 11:39:12', '2023-08-04', 'P3376', '23-04786-08-04', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'PORTO COLÓN 6. ESCALERA IZDA. 1 C', 'Alcorcón', 'Madrid', '28924', 'España', 52.39, 0, '2023-08-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040823-jGhthY6/AGbYr-188', '4bc53fcf-847e-4d73-b5ee-fa4a91cf9da5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040823-jGhthY6%2FAGbYr-188&s=KOL2023&nf=P3376&i=52.39&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3597, 1, 907, 1, 0, NULL, 0, '2023-08-04 11:59:29', '2023-08-04 12:01:20', '2023-07-30', 'P3377', '2023-07-30', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Río Cubas 7 5°izda', 'Santander', 'Cantabria', '39004', 'España', 30.61, 0, '2023-08-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300723-NDo/iLKCAIbL4-032', '8da36153-8fc4-41df-8a93-0ef0d65ae86b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300723-NDo%2FiLKCAIbL4-032&s=KOL2023&nf=P3377&i=30.61&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3598, 1, 528, 2, 0, NULL, 0, '2023-08-04 11:22:07', '2023-08-04 13:28:30', '2023-08-04', 'P3378', '23-04788-08-04', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Ibaizabal 6 - 1 Ctro ', 'Getxo', 'Bizkaia', '48991', 'España', 17.50, 0, '2023-08-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040823-OQm8zpW3K+bNV-050', 'd98f9328-dd3a-4447-8e5b-f6908069c8a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040823-OQm8zpW3K%2BbNV-050&s=KOL2023&nf=P3378&i=17.50&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3599, 1, 722, 2, 0, NULL, 0, '2023-08-06 08:38:13', '2023-08-07 08:56:42', '2023-08-06', 'P3379', '23-04790-08-06', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Avenida de Sagi Barba 18, 3º Izquierda ', 'Polop', 'Alicante', '03520', 'España', 71.98, 0, '2023-08-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060823-aqUJ4/VbLeCFk-140', 'e270cf51-5042-43d2-8e2b-1365ac548550', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060823-aqUJ4%2FVbLeCFk-140&s=KOL2023&nf=P3379&i=71.98&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3600, 1, 908, 2, 0, NULL, 0, '2023-08-06 11:14:13', '2023-08-07 09:02:46', '2023-08-06', 'P3380', '23-04791-08-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Josep Irla 18/20  A  1ro 2da', 'Sitges', 'Barcelona', '08870', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060823-U48zqRslx0ATs-042', '81962aa8-06a0-4fdf-8980-418a70ebf9db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060823-U48zqRslx0ATs-042&s=KOL2023&nf=P3380&i=17.50&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3601, 1, 77, 1, 0, NULL, 0, '2023-08-07 09:35:55', '2023-08-07 09:35:55', '2023-08-07', 'P3381', '2023-08-07', '', 0.00, 622.05, 130.63, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 752.68, 0, '2023-08-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070823-P/qbst6QSkqyq-241', 'd1425b43-7664-4773-b43c-2bc16bc7db09', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070823-P%2Fqbst6QSkqyq-241&s=KOL2023&nf=P3381&i=752.68&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3602, 1, 522, 2, 0, NULL, 0, '2023-08-07 07:48:05', '2023-08-07 10:13:20', '2023-08-07', 'P3382', '23-04792-08-07', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 344.85, 0, '2023-08-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070823-la29jRWa8WCr0-050', '1483bbf1-aa7a-4612-8d6d-0924464259ec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070823-la29jRWa8WCr0-050&s=KOL2023&nf=P3382&i=344.85&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3603, 1, 812, 2, 0, NULL, 0, '2023-08-07 08:20:58', '2023-08-07 10:27:51', '2023-08-07', 'P3383', '23-04793-08-07', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Amezketarrak 10, entresuelo derecha puerta 4', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 30.61, 0, '2023-08-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070823-BX1C/8HWDYooX-015', 'cea08fca-1801-417d-81e2-065442c06c2a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070823-BX1C%2F8HWDYooX-015&s=KOL2023&nf=P3383&i=30.61&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3604, 1, 78, 2, 0, NULL, 0, '2023-08-07 08:39:58', '2023-08-07 10:46:17', '2023-08-07', 'P3384', '23-04794-08-07', '', 0.00, 484.50, 101.75, 0.00, 0, 0.00, 0.00, 'avnd. de satrustegui 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 586.25, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070823-cAb4Y6/STDMWk-244', '663572ee-1310-4999-9bd3-1d8e221f13b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070823-cAb4Y6%2FSTDMWk-244&s=KOL2023&nf=P3384&i=586.25&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3605, 1, 521, 2, 0, NULL, 0, '2023-08-07 13:50:55', '2023-08-08 09:02:54', '2023-08-07', 'P3385', '23-04795-08-07', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ Vidangoz n° 7 - 4° izd', 'Pamplona/Iruña', 'Navarra', '31014', 'España', 65.52, 0, '2023-08-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070823-YP4mb0hT1SMsO-173', '81688cef-507c-4df7-8003-3ab21ce2f3af', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070823-YP4mb0hT1SMsO-173&s=KOL2023&nf=P3385&i=65.52&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3606, 1, 909, 2, 0, NULL, 0, '2023-08-07 14:41:24', '2023-08-08 09:03:32', '2023-08-07', 'P3386', '23-04798-08-07', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Saragossa 20', 'Amposta', 'Tarragona', '43870', 'España', 17.50, 0, '2023-08-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070823-ei0VAG7hMtuck-044', '8fb32775-a2e9-4f82-b826-54425394476e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070823-ei0VAG7hMtuck-044&s=KOL2023&nf=P3386&i=17.50&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
