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
(3834, 1, 794, 2, 0, NULL, 0, '2023-09-23 08:10:36', '2023-09-25 09:11:05', '2023-09-23', 'P3603', '23-05079-09-23', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Idoia 4 bajo', 'Zizur Mayor/Zizur Na', 'Navarra', '31180', 'España', 137.94, 0, '2023-09-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230923-HvENo8+bz6Iuc-038', '065f4f2d-7df7-432f-83ef-e778ed0ff806', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230923-HvENo8%2Bbz6Iuc-038&s=KOL2023&nf=P3603&i=137.94&cr=229', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3835, 1, 981, 2, 0, NULL, 0, '2023-09-23 21:35:52', '2023-09-25 09:13:01', '2023-09-23', 'P3600', '23-05080-09-23', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Kale Nagusia 69', 'Arbizu', 'Navarra', '31839', 'España', 43.71, 0, '2023-09-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230923-VbB+aSJoZCAxa-026', '863f89f9-22f9-445c-bade-c9a6c7e4fb03', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230923-VbB%2BaSJoZCAxa-026&s=KOL2023&nf=P3600&i=43.71&cr=234', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3836, 1, 802, 2, 0, NULL, 0, '2023-09-24 17:31:52', '2023-09-25 09:15:28', '2023-09-24', 'P3601', '23-05081-09-24', 'entrega preferentemente por la tarde.\r\ngracias', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Poeta blas de Otero, nº 14. piso: 3ºB', 'Madrid', 'Madrid', '28017', 'España', 30.61, 0, '2023-09-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240923-YhqggG2r+ZEk6-037', 'd6f93685-9c1f-4369-b55f-05be532287dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240923-YhqggG2r%2BZEk6-037&s=KOL2023&nf=P3601&i=30.61&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3837, 1, 136, 2, 0, NULL, 0, '2023-09-25 07:10:17', '2023-09-25 09:19:11', '2023-09-25', 'P3602', '23-05084-09-25', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'C/AVIADOR ZORITA, 13 - LOCAL PELUQUERIA', 'Madrid', 'Madrid', '28020', 'España', 103.46, 0, '2023-09-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250923-deZU24YEJRFGv-221', 'a99bd029-356e-45d3-82b7-cbaaed61a1e3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250923-deZU24YEJRFGv-221&s=KOL2023&nf=P3602&i=103.46&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3838, 1, 242, 1, 0, NULL, 0, '2023-09-25 09:23:26', '2023-09-25 09:25:52', '2023-09-25', 'P3604', '2023-09-25', '', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 61.64, 0, '2023-09-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250923-ckQc6UzdcrQGI-018', 'e0429527-506e-46cd-ad60-c3df846b6429', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250923-ckQc6UzdcrQGI-018&s=KOL2023&nf=P3604&i=61.64&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3839, 1, 345, 2, 0, NULL, 0, '2023-09-25 09:53:45', '2023-09-25 11:55:57', '2023-09-25', 'P3605', '23-05085-09-25', 'Horario de 10:00h a 19h', 0.00, 81.40, 17.09, 0.00, 0, 0.00, 0.00, 'Espronceda 336', 'Barcelona', 'Barcelona', '08027', 'España', 98.49, 0, '2023-09-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250923-mU5YRmfeZWStG-119', '1dab929c-41b5-4e5c-922e-711996e8fcbd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250923-mU5YRmfeZWStG-119&s=KOL2023&nf=P3605&i=98.49&cr=012', '[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
(3840, 1, 78, 2, 0, NULL, 0, '2023-09-25 10:21:48', '2023-09-25 12:27:13', '2023-09-25', 'P3606', '23-05086-09-25', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'AVND, DE SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 620.73, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250923-bgesBcJsqejKP-127', 'd1772940-6e81-4021-ac13-4df854c100df', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250923-bgesBcJsqejKP-127&s=KOL2023&nf=P3606&i=620.73&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3841, 1, 40, 2, 0, NULL, 0, '2023-09-25 11:40:35', '2023-09-26 09:09:40', '2023-09-25', 'P3607', '23-05087-09-25', 'martes cerrado', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 123.15, 0, '2023-09-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250923-X6n/o4mtIo7Oz-082', '1d34cf6e-fefe-4cd2-9a1d-204459f367c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250923-X6n%2Fo4mtIo7Oz-082&s=KOL2023&nf=P3607&i=123.15&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3842, 1, 372, 2, 0, NULL, 0, '2023-09-25 19:27:25', '2023-09-26 09:12:30', '2023-09-25', 'P3608', '23-05088-09-25', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer Arenal n 7', 'Castelló d\'Empúries', 'Girona', '17487', 'España', 17.50, 0, '2023-09-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250923-VYl2uCUtWwg6T-080', '0261df57-a7fa-40cd-841e-0501f8299f17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250923-VYl2uCUtWwg6T-080&s=KOL2023&nf=P3608&i=17.50&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3843, 1, 696, 1, 0, NULL, 0, '2023-09-26 09:53:47', '2023-09-26 09:53:47', '2023-09-26', 'P3609', '2023-09-26', '', 0.00, 265.98, 55.86, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 321.84, 0, '2023-09-26 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260923-YnRPqdiJEDR+W-115', '06b619a5-acc4-4b59-ba34-8f91285abb37', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260923-YnRPqdiJEDR%2BW-115&s=KOL2023&nf=P3609&i=321.83&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3844, 1, 522, 2, 0, NULL, 0, '2023-09-26 08:59:20', '2023-09-26 11:13:30', '2023-09-26', 'P3610', '23-05089-09-26', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 241.40, 0, '2023-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260923-AjWFP6TgUC/kb-237', '59837fc0-3f1e-4f1f-8e19-1db145987834', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260923-AjWFP6TgUC%2Fkb-237&s=KOL2023&nf=P3610&i=241.40&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3845, 1, 131, 2, 0, NULL, 0, '2023-09-26 09:52:40', '2023-09-26 11:55:43', '2023-09-26', 'P3612', '23-05090-09-26', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260923-SCujFCA5qMFiT-015', '7ced8973-30a8-43e0-98ad-b40b6d333a03', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260923-SCujFCA5qMFiT-015&s=KOL2023&nf=P3612&i=206.91&cr=227', '[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
(3846, 1, 262, 2, 0, NULL, 0, '2023-09-26 09:54:30', '2023-09-26 12:01:41', '2023-09-26', 'P3611', '23-05091-09-26', 'Lunes y sábado por la tarde cerrado.', 0.00, 105.84, 22.23, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 128.07, 0, '2023-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260923-b8u2wJ+Sk+s35-070', '077bb3ef-f2af-48a8-95b8-a5703b75944f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260923-b8u2wJ%2BSk%2Bs35-070&s=KOL2023&nf=P3611&i=128.07&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3847, 1, 754, 2, 0, NULL, 0, '2023-09-26 12:39:08', '2023-09-27 09:11:00', '2023-09-26', 'P3617', '23-05093-09-26', 'ENTREGA PREFERIBLE DE 13.30 A 17.00.\r\nSI NO ESTAMOS LLAMAR 655286374', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'JOSEP TARRADELLAS 1662º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2023-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260923-Yhf3i9u8Is0m5-141', '4c9b0202-c6f6-489d-a3fe-059ed8d74cf9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260923-Yhf3i9u8Is0m5-141&s=KOL2023&nf=P3617&i=61.64&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3848, 1, 751, 2, 0, NULL, 0, '2023-09-26 15:12:14', '2023-09-27 09:13:00', '2023-09-26', 'P3613', '23-05094-09-26', '', 0.00, 52.32, 10.99, 0.00, 0, 0.00, 0.00, 'C/ Príncipe de Asturias 29 autoescuela+facil', 'Jávea/Xàbia', 'Alicante', '03730', 'España', 63.31, 0, '2023-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260923-LbA57h3Th4Hfw-118', '150ea867-1893-46a4-be92-67fd998d3d17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260923-LbA57h3Th4Hfw-118&s=KOL2023&nf=P3613&i=63.31&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3849, 1, 115, 2, 0, NULL, 0, '2023-09-26 16:14:51', '2023-09-27 09:16:04', '2023-09-26', 'P3614', '23-05095-09-26', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'MONASTERIO DE URDAX NR. 38', 'Pamplona/Iruña', 'Navarra', '31011', 'España', 275.88, 0, '2023-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260923-fC9bGW1YE/8DJ-141', 'e56709be-4381-4b38-8e7e-ea2e64f451ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260923-fC9bGW1YE%2F8DJ-141&s=KOL2023&nf=P3614&i=275.88&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3850, 1, 10, 2, 0, NULL, 0, '2023-09-26 16:47:48', '2023-09-27 09:18:33', '2023-09-26', 'P3615', '23-05096-09-26', '', 0.00, 179.14, 37.62, 0.00, 0, 0.00, 0.00, 'Agirre auzunea 1 behea', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 216.76, 0, '2023-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260923-M7bZSUHDmf2xM-048', 'a4505abb-fead-4e8d-83fc-708be84bfb0b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260923-M7bZSUHDmf2xM-048&s=KOL2023&nf=P3615&i=216.76&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3851, 1, 765, 2, 0, NULL, 0, '2023-09-26 20:42:02', '2023-09-27 09:21:25', '2023-09-26', 'P3618', '23-05097-09-26', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260923-N808d1IL5Km8E-131', 'ffa3f25d-7f18-4da7-84c8-3dce9af2c364', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260923-N808d1IL5Km8E-131&s=KOL2023&nf=P3618&i=103.46&cr=047', '[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
(3852, 1, 167, 2, 0, NULL, 0, '2023-09-27 06:13:24', '2023-09-27 09:25:03', '2023-09-27', 'P3616', '23-05098-09-27', '', 0.00, 317.56, 66.69, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 384.25, 0, '2023-09-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270923-kNiP1NOvjuRaC-181', '35f20bbf-b59e-446f-9624-eb48a7f74233', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270923-kNiP1NOvjuRaC-181&s=KOL2023&nf=P3616&i=384.25&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3853, 1, 795, 2, 0, NULL, 0, '2023-09-27 07:35:15', '2023-09-27 09:42:52', '2023-09-27', 'P3619', '23-05099-09-27', 'Avisar al teléfono 646228333  ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Ctra. Villacarrillo, Nº 50', 'Navas de San Juan', 'Jaén', '23240', 'España', 30.61, 0, '2023-09-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270923-Zyf97oBQfEkbu-237', 'bc2ae3f9-b0de-4ea2-83ae-583b957793f3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270923-Zyf97oBQfEkbu-237&s=KOL2023&nf=P3619&i=30.61&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3854, 1, 137, 2, 0, NULL, 0, '2023-09-27 08:57:14', '2023-09-27 11:09:25', '2023-09-27', 'P3620', '23-05100-09-27', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Pº ERMITA, 10', 'Madrid', 'Madrid', '28023', 'España', 172.43, 0, '2023-09-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270923-DF6zEjTvDcG2R-235', '48468112-4d34-452f-b014-5362632075f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270923-DF6zEjTvDcG2R-235&s=KOL2023&nf=P3620&i=172.43&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3855, 1, 982, 2, 0, NULL, 0, '2023-09-27 11:49:16', '2023-09-28 09:42:27', '2023-09-27', 'P3621', '23-05101-09-27', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'San inazio 17.1C', 'Beasain', 'Gipuzkoa', '20200', 'España', 17.50, 0, '2023-09-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270923-m2HVT/yT4snZE-052', 'b4eaacd8-242a-4dcc-9c51-5322bcb5c808', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270923-m2HVT%2FyT4snZE-052&s=KOL2023&nf=P3621&i=17.50&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3856, 1, 983, 2, 0, NULL, 0, '2023-09-27 14:55:26', '2023-09-28 09:45:51', '2023-09-27', 'P3624', '23-05104-09-27', '', 0.00, 19.83, 5.36, 0.00, 0, 0.00, 6.90, 'Huesca N° 45, 5° H', 'Logroño', 'La Rioja', '26005', 'España', 30.89, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-270923-dPFddKpU7+C3T-205', '279c4a6c-ca0e-456a-bc27-a33f37052655', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270923-dPFddKpU7%2BC3T-205&s=KOL2023&nf=P3624&i=30.89&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3857, 1, 728, 2, 0, NULL, 0, '2023-09-27 18:02:36', '2023-09-28 09:48:35', '2023-09-27', 'P3622', '23-05105-09-27', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Alberico Pardo 58 chalet 44', 'Santander', 'Cantabria', '39011', 'España', 30.61, 0, '2023-09-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270923-S0HKk6CSGLHDV-040', 'b29ac00f-95f4-493b-b48d-f7f9540b21ce', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270923-S0HKk6CSGLHDV-040&s=KOL2023&nf=P3622&i=30.61&cr=222', '[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
(3858, 1, 606, 2, 0, NULL, 0, '2023-09-27 20:57:20', '2023-09-28 09:51:48', '2023-09-27', 'P3623', '23-05106-09-27', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Bulevar de mariturri 14, 7b', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 30.61, 0, '2023-09-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270923-fG80Cpb3WHJ+z-057', '694ea515-0566-43d2-816b-746d799b2e8d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270923-fG80Cpb3WHJ%2Bz-057&s=KOL2023&nf=P3623&i=30.61&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3859, 1, 391, 2, 0, NULL, 0, '2023-09-28 07:45:01', '2023-09-28 09:54:31', '2023-09-28', 'P3625', '23-05107-09-28', '', 0.00, 65.14, 14.11, 0.00, 0, 0.00, 2.50, 'Calle divina pastora 13 bajo', 'Ansoáin', 'Navarra', '31013', 'España', 81.32, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-280923-nBX0xJe6S2tz7-134', 'c583cf82-1005-4dfb-857d-a67c26d08eb8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280923-nBX0xJe6S2tz7-134&s=KOL2023&nf=P3625&i=81.31&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3860, 1, 77, 1, 0, NULL, 0, '2023-09-28 10:23:34', '2023-09-28 10:24:12', '2023-09-28', 'P3626', '2023-09-28', '', 0.00, 707.85, 148.65, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 856.50, 0, '2023-09-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280923-McZNFPVHuuZen-205', 'bcc1c938-3b5c-48b4-ae0d-9efae2098d69', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280923-McZNFPVHuuZen-205&s=KOL2023&nf=P3626&i=856.50&cr=160', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3861, 1, 108, 2, 0, NULL, 0, '2023-09-28 12:56:04', '2023-09-29 09:45:05', '2023-09-28', 'P3629', '23-05108-09-28', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 157.64, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280923-QxeTd8oveIWNH-010', '5591046e-ee63-4c14-985f-657f8a84dbea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280923-QxeTd8oveIWNH-010&s=KOL2023&nf=P3629&i=157.63&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3862, 1, 984, 2, 0, NULL, 0, '2023-09-28 15:01:56', '2023-09-29 09:48:06', '2023-09-28', 'P3627', '23-05110-09-28', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Licenciado Poza 54 3º exterior derecha', 'Bilbao', 'Bizkaia', '48013', 'España', 17.50, 0, '2023-09-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280923-L5biTnVnl0Di0-252', '033d9b34-0c98-47a8-99f5-fea592af6737', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280923-L5biTnVnl0Di0-252&s=KOL2023&nf=P3627&i=17.50&cr=190', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3863, 1, 331, 2, 0, NULL, 0, '2023-09-28 19:30:27', '2023-09-29 09:54:19', '2023-09-28', 'P3628', '23-05111-09-28', '', 0.00, 61.32, 12.88, 0.00, 0, 0.00, 0.00, 'Plaza Historiador Francisco Domenech, 10', 'Caudete', 'Albacete', '02660', 'España', 74.20, 0, '2023-09-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280923-f1p7Y16fcIrzJ-048', 'c39133e3-6bba-42b8-80cc-be622b6c501f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280923-f1p7Y16fcIrzJ-048&s=KOL2023&nf=P3628&i=74.20&cr=044', '[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
(3864, 1, 152, 1, 0, NULL, 0, '2023-09-29 10:39:48', '2023-09-29 10:42:30', '2023-09-29', 'P3630', '2023-09-29', '', 0.00, 68.64, 14.41, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 83.05, 0, '2023-09-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290923-Eiiv9Kp0WyK6E-141', '0e4c9aa0-ea15-4bb6-9a59-e7ebfb0c3a77', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290923-Eiiv9Kp0WyK6E-141&s=KOL2023&nf=P3630&i=83.05&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3865, 1, 17, 1, 0, NULL, 0, '2023-09-29 10:51:09', '2023-09-29 10:52:19', '2023-09-29', 'P3631', '2023-09-29', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 137.94, 0, '2023-09-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290923-hl2kD2BPxiqwi-166', 'd1a0d427-90cc-4459-8ce9-0b6fb9a2e262', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290923-hl2kD2BPxiqwi-166&s=KOL2023&nf=P3631&i=137.94&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3866, 1, 985, 2, 0, NULL, 0, '2023-09-29 12:05:56', '2023-10-02 08:51:19', '2023-09-29', 'P3635', '23-05112-09-29', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, '8 de enero n5,1', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290923-O0R/a/c7kAtBD-148', '1327c85b-ab89-4c68-98e4-261c030208db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290923-O0R%2Fa%2Fc7kAtBD-148&s=KOL2023&nf=P3635&i=20.00&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3867, 1, 510, 2, 0, NULL, 0, '2023-09-30 13:58:05', '2023-10-02 08:54:27', '2023-09-30', 'P3632', '23-05113-09-30', 'A poder ser llamar antes de entregar. Teletrabajo y suelo estar en casa, pero por si acaso.', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Castillejos 343 6º 4ª', 'Barcelona', 'Barcelona', '08025', 'España', 71.98, 0, '2023-09-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300923-WnIMNhjHSd/Gd-228', '50e7bbc7-2679-4689-bea2-278898cdbe56', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300923-WnIMNhjHSd%2FGd-228&s=KOL2023&nf=P3632&i=71.98&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3868, 1, 986, 2, 0, NULL, 0, '2023-09-30 22:57:11', '2023-10-02 08:58:17', '2023-09-30', 'P3633', '23-05115-09-30', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Picos de Europa, 25 - Bajo B', 'Madrid', 'Madrid', '28038', 'España', 17.50, 0, '2023-09-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300923-gLVH5OGDV1m4g-252', 'df88c8d4-af12-4608-965c-0944d092bc1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300923-gLVH5OGDV1m4g-252&s=KOL2023&nf=P3633&i=17.50&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3869, 1, 987, 2, 0, NULL, 0, '2023-10-01 18:50:54', '2023-10-02 09:01:17', '2023-10-01', 'P3634', '23-05116-10-01', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Ilpea polígono industrial Aoiz', 'Aoiz/Agoitz', 'Navarra', '31430', 'España', 43.71, 0, '2023-10-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-011023-NVR51iI2RbaxE-137', '042119ad-753e-4651-85ab-92bfdac598ff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011023-NVR51iI2RbaxE-137&s=KOL2023&nf=P3634&i=43.71&cr=025', '[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
(3870, 1, 174, 2, 0, NULL, 0, '2023-10-02 09:08:42', '2023-10-02 11:26:52', '2023-10-02', 'P3636', '23-05117-10-02', 'Hola , no necesito folletos.\r\nservir lo antes posible.\r\nmuchas gracias ', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 344.85, 0, '2023-10-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021023-owg7DfbWn6FQ5-156', '2de2857e-ec06-4986-9ea1-8026c5f69c94', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021023-owg7DfbWn6FQ5-156&s=KOL2023&nf=P3636&i=344.85&cr=175', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3871, 1, 192, 2, 0, NULL, 0, '2023-10-02 09:57:10', '2023-10-02 12:20:58', '2023-10-02', 'P3637', '23-05118-10-02', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'plaza San Cristobal 3,bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 157.64, 0, '2023-10-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021023-KAqHGmrQU9t70-189', '441efd9e-8b56-46e4-988e-7a412b06f1b3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021023-KAqHGmrQU9t70-189&s=KOL2023&nf=P3637&i=157.63&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3872, 1, 988, 2, 0, NULL, 0, '2023-10-02 10:13:44', '2023-10-02 12:23:45', '2023-10-02', 'P3638', '23-05119-10-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sipiri 18, 2D', 'Sopelana', 'Bizkaia', '48600', 'España', 28.39, 0, '2023-10-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-021023-kexF7uGUya2pR-187', '46c56946-6641-4cfd-89a6-5fc866119324', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021023-kexF7uGUya2pR-187&s=KOL2023&nf=P3638&i=28.39&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3873, 1, 4, 2, 0, NULL, 0, '2023-10-02 17:58:04', '2023-10-03 09:09:42', '2023-10-02', 'P3639', '23-05120-10-02', '', 0.00, 309.42, 64.98, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 374.40, 0, '2023-10-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021023-jRuccbTAhvRJI-029', '0ddd151a-f137-4b1e-a2d8-c11b00877de9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021023-jRuccbTAhvRJI-029&s=KOL2023&nf=P3639&i=374.40&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3874, 1, 193, 2, 0, NULL, 0, '2023-10-02 18:05:49', '2023-10-03 09:10:46', '2023-10-02', 'P3640', '23-05121-10-02', 'Peluquería Zuriñe', 0.00, 97.47, 20.47, 0.00, 0, 0.00, 0.00, 'Calle Ubitarte bajo 6', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 117.94, 0, '2023-10-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021023-dhhseqmVzctSk-072', 'f0abe841-3f4e-49ea-a035-2c4eb0a5f146', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021023-dhhseqmVzctSk-072&s=KOL2023&nf=P3640&i=117.94&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3875, 1, 67, 2, 0, NULL, 0, '2023-10-03 08:36:11', '2023-10-03 10:38:27', '2023-10-03', 'P3641', '2023-10-03', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-031023-hGyVvtpv+eLce-058', 'e0db2d25-3635-43d9-8d6e-3916d35e72ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031023-hGyVvtpv%2BeLce-058&s=KOL2023&nf=P3641&i=275.88&cr=107', '[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
(3876, 1, 989, 2, 0, NULL, 0, '2023-10-03 09:37:53', '2023-10-03 11:48:28', '2023-10-03', 'P3642', '23-05125-10-03', 'Dejar en la oficina de reto en caso de que no haya nadie en casa.\r\nLa casa se encuentra al lado de un taller por unas escaleras que hay a la izquierda de frente al mismo. ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Adarzo26A', 'Santander', 'Cantabria', '39011', 'España', 17.50, 0, '2023-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031023-Qqv/eN7cfcGp5-233', 'fe0ed7fd-c60f-4f1d-aa0f-8b9d886f3cab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031023-Qqv%2FeN7cfcGp5-233&s=KOL2023&nf=P3642&i=17.50&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3877, 1, 120, 2, 0, NULL, 0, '2023-10-03 11:09:01', '2023-10-03 13:15:27', '2023-10-03', 'P3643', '23-05126-10-03', '', 0.00, 126.20, 26.50, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 152.70, 0, '2023-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031023-IQ5Qbxze0dj9/-220', 'ce684841-9131-4c36-8f1c-b9a9b5cdd67b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031023-IQ5Qbxze0dj9%2F-220&s=KOL2023&nf=P3643&i=152.69&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3878, 1, 190, 1, 0, NULL, 0, '2023-10-03 13:14:28', '2023-10-03 13:14:28', '2023-10-03', '', 'consumo peluquería', '', 0.00, 325.60, 68.38, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 393.98, 0, '2023-10-03 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3879, 1, 884, 2, 0, NULL, 0, '2023-10-03 21:55:05', '2023-10-04 09:07:04', '2023-10-03', 'P3644', '23-05128-10-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Lapurdi kalea 31 2b', 'Zarautz', 'Gipuzkoa', '20800', 'España', 17.50, 0, '2023-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031023-aVsl1mINo7ljP-003', 'ca36d98a-51b7-40fc-9de8-0aef22ccd0ae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031023-aVsl1mINo7ljP-003&s=KOL2023&nf=P3644&i=17.50&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3880, 1, 102, 2, 0, NULL, 0, '2023-10-04 06:46:23', '2023-10-04 09:10:12', '2023-10-04', 'P3645', '23-05129-10-04', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Riera Gavarra  numero 73 local', 'Canet de Mar', 'Barcelona', '08360', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-041023-LKRebk/jsIoYh-171', '6fc863b4-7893-459b-92da-5cf31044c25f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041023-LKRebk%2FjsIoYh-171&s=KOL2023&nf=P3645&i=71.47&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3881, 1, 906, 2, 0, NULL, 0, '2023-10-04 11:12:57', '2023-10-05 09:13:15', '2023-10-04', 'P3648', '23-05130-10-04', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'TAJO 6', 'Madrid', 'Madrid', '28002', 'España', 52.39, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-041023-jT5ynsCCQsXx7-236', '06f8cb04-f5b7-41d5-8479-2c725737ba2c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041023-jT5ynsCCQsXx7-236&s=KOL2023&nf=P3648&i=52.39&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3882, 1, 990, 2, 0, NULL, 0, '2023-10-04 12:08:12', '2023-10-04 15:45:19', '2023-10-04', 'P3646', '23-05131-10-04', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Glories Catalanes, 2', 'Llorenç del Penedès', 'Tarragona', '43712', 'España', 17.50, 0, '2023-10-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041023-cfzks9Io1N9em-168', '4e8ea4a3-2e97-4259-869d-aec515d667fa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041023-cfzks9Io1N9em-168&s=KOL2023&nf=P3646&i=17.50&cr=057', '[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
(3883, 1, 857, 2, 0, NULL, 0, '2023-10-04 13:59:04', '2023-10-05 09:19:23', '2023-10-04', 'P3647', '23-05133-10-04', '', 0.00, 162.45, 34.11, 0.00, 1, 8.45, 0.00, 'C/ Doctor Marañón 12', 'Almonte', 'Huelva', '21730', 'España', 205.01, 0, '2023-10-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041023-lO0nyzj55mwNt-006', '2042d73f-8313-47c0-be96-93e5dba8e198', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041023-lO0nyzj55mwNt-006&s=KOL2023&nf=P3647&i=196.56&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3884, 1, 127, 2, 0, NULL, 0, '2023-10-05 07:48:24', '2023-10-05 10:29:59', '2023-10-05', 'P3649', '23-05134-10-05', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 157.64, 0, '2023-10-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051023-LgHpoVGqqeqBB-217', 'af660dd9-8a90-4b04-8796-8a8aa4248bde', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051023-LgHpoVGqqeqBB-217&s=KOL2023&nf=P3649&i=157.63&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3885, 1, 259, 2, 0, NULL, 0, '2023-10-05 08:47:05', '2023-10-05 11:04:36', '2023-10-05', 'P3650', '23-05135-10-05', 'ENTREGAR ENTRE LAS 9:00 Y LA 13:00 ', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Gipuzkoa kalea 53 bajo', 'Zarautz', 'Gipuzkoa', '20800', 'España', 241.40, 0, '2023-10-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051023-RdOLOwYjFCGFe-080', '35452749-1df1-4208-8017-f83916f1b16e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051023-RdOLOwYjFCGFe-080&s=KOL2023&nf=P3650&i=241.40&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3886, 1, 992, 2, 0, NULL, 0, '2023-10-05 13:25:33', '2023-10-06 10:10:34', '2023-10-05', 'P3651', '23-05136-10-05', 'De lunes a viernes de 9 a13.30 y de 16 a 19.30', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avda Sancho ell Sabio. 25 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 30.61, 0, '2023-10-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051023-ORMS1qsr1VOSA-189', 'bb7bd0fa-ac35-4363-b3ae-a7f6fbed3f7b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051023-ORMS1qsr1VOSA-189&s=KOL2023&nf=P3651&i=30.61&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3887, 1, 367, 2, 0, NULL, 0, '2023-10-05 21:16:41', '2023-10-06 10:23:58', '2023-10-05', 'P3652', '23-05137-10-05', 'Detrás del Mercadona', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Arenal 7', 'Castelló d\'Empúries', 'Girona', '17486', 'España', 17.50, 0, '2023-10-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051023-Z2OHH+eYfdnsn-119', '03f4f3d5-dfec-48e1-b72f-acfd9adf9cd6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051023-Z2OHH%2BeYfdnsn-119&s=KOL2023&nf=P3652&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),
(3888, 1, 696, 1, 0, NULL, 0, '2023-10-06 10:42:55', '2023-10-06 10:43:10', '2023-10-06', 'P3653', '2023-10-06', '', 0.00, 283.14, 59.46, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 342.60, 0, '2023-10-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061023-YYGewWeZ1jWCB-085', '8ca13e69-05d1-45d7-9b48-44ce7bab1856', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061023-YYGewWeZ1jWCB-085&s=KOL2023&nf=P3653&i=342.60&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
