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
(4233, 1, 751, 2, 0, NULL, 0, '2023-12-12 08:03:46', '2023-12-12 09:34:41', '2023-12-12', 'P3973', '23-05493-12-12', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ Príncipe de Asturias 29 autoescuela+facil', 'Jávea/Xàbia', 'Alicante', '03730', 'España', 65.52, 0, '2023-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121223-O7jIrEPJzi16H-046', '15259fbc-05ea-4d26-828a-455ab9c1d981', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-O7jIrEPJzi16H-046&s=KOL2023&nf=P3973&i=65.52&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4234, 1, 162, 2, 0, NULL, 0, '2023-12-12 09:08:59', '2023-12-12 10:22:13', '2023-12-12', 'P3974', '23-05494-12-12', 'Entrega en horario de mañanas ', 0.00, 77.34, 16.24, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 93.58, 0, '2023-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121223-gTt4eU5XMZYz+-187', 'e8b4c9da-49c4-4371-8cc0-20ebfffcf670', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-gTt4eU5XMZYz%2B-187&s=KOL2023&nf=P3974&i=93.58&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4235, 1, 1084, 2, 0, NULL, 0, '2023-12-12 09:50:21', '2023-12-12 11:42:17', '2023-12-12', 'P3975', '23-05495-12-12', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Travesía Iván de Vargas, 3', 'Madrid', 'Madrid', '28019', 'España', 28.39, 0, '2023-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121223-D4p+m8rs9aaWd-003', '0df10f9b-7ed0-4679-8818-c426406a4411', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-D4p%2Bm8rs9aaWd-003&s=KOL2023&nf=P3975&i=28.39&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4236, 1, 273, 2, 0, NULL, 0, '2023-12-12 11:15:26', '2023-12-12 12:17:48', '2023-12-12', 'P3976', '23-05496-12-12', 'Horario de entrega: de lunes a viernes, de 8:30 h a 16:30 h', 0.00, 52.32, 10.99, 0.00, 0, 0.00, 0.00, 'Avda. Eduard Maristany, 46-48. ENDESA', 'Sant Adrià de Besòs', 'Barcelona', '08930', 'España', 63.31, 0, '2023-12-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-121223-JFsbwnjKuS9CG-135', 'bb0791fb-674f-4c6f-9a7a-6df2ce54b26c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-JFsbwnjKuS9CG-135&s=KOL2023&nf=P3976&i=63.31&cr=208', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4237, 1, 696, 1, 0, NULL, 0, '2023-12-12 13:24:15', '2023-12-12 13:24:32', '2023-12-12', 'P3977', '2023-12-12', '', 0.00, 514.80, 108.11, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 622.91, 0, '2023-12-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-121223-Xf5iI1/aZTrvx-187', '9ac77ce0-0cd2-4dc4-ae4d-e87da3bf9959', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-Xf5iI1%2FaZTrvx-187&s=KOL2023&nf=P3977&i=622.91&cr=075', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4238, 1, 270, 2, 0, NULL, 0, '2023-12-12 18:21:19', '2023-12-13 09:05:49', '2023-12-12', 'P3978', '23-05497-12-12', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Juan Bautista Zabala 9 (Comercio Gaurko)', 'Getxo', 'Bizkaia', '48991', 'España', 30.61, 0, '2023-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121223-VpOjXjpJuc3o4-180', '2086a2ff-9b15-42b2-9fe0-c23e34926c63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-VpOjXjpJuc3o4-180&s=KOL2023&nf=P3978&i=30.61&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4239, 1, 215, 2, 0, NULL, 0, '2023-12-12 19:26:56', '2023-12-13 09:06:20', '2023-12-12', '', '23-05498-12-12', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 1, 4, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0);
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
(4240, 1, 170, 2, 0, NULL, 0, '2023-12-12 20:13:34', '2023-12-13 09:12:51', '2023-12-12', 'P3979', '23-05500-12-12', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Plaza de las agustinas N°5  ', 'Hernani', 'Gipuzkoa', '20120', 'España', 137.94, 0, '2023-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121223-ckjJzunQKnHDa-155', 'e485aace-656c-4874-8616-3e7bbf3b8b53', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-ckjJzunQKnHDa-155&s=KOL2023&nf=P3979&i=137.94&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4241, 1, 85, 2, 0, NULL, 0, '2023-12-12 22:30:47', '2023-12-13 09:23:34', '2023-12-12', 'P3982', '23-05501-12-12', '', 0.00, 134.34, 28.21, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 162.55, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-121223-OtsqMu57j9pW/-212', 'f319c6f9-bae7-4ca4-a98e-bca4d54cfd58', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-OtsqMu57j9pW%2F-212&s=KOL2023&nf=P3982&i=165.05&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4242, 1, 566, 2, 0, NULL, 0, '2023-12-12 23:50:22', '2023-12-13 09:15:40', '2023-12-12', 'P3983', '23-05502-12-12', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'c/sant cugat 29', 'Mataró', 'Barcelona', '08302', 'España', 310.37, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-121223-RjrFeHvoU6w1W-190', 'db877cf4-a291-4498-bacc-5d1bc1b0cd9d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-RjrFeHvoU6w1W-190&s=KOL2023&nf=P3983&i=310.37&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4243, 1, 215, 2, 0, NULL, 0, '2023-12-13 09:06:32', '2023-12-13 09:30:27', '2023-12-12', 'P3980', '23-05498-12-12', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-121223-UN9CzHFKT3R0i-165', 'bae66399-86ac-4cc3-921f-b7393c4bf540', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-UN9CzHFKT3R0i-165&s=KOL2023&nf=P3980&i=209.41&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4244, 1, 215, 2, 0, NULL, 0, '2023-12-13 09:06:46', '2023-12-13 09:11:31', '2023-12-12', 'P3981', '23-05498-12-12', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-121223-odZmlSUARbS18-199', '4bcc53c9-2821-45e2-9793-a60635671db1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121223-odZmlSUARbS18-199&s=KOL2023&nf=P3981&i=209.41&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(4245, 1, 215, 2, 1, 'Pedido duplicado', 4244, '2023-12-13 09:10:14', '2023-12-13 09:10:14', '2023-12-13', 'R62', 'P3981 RECT.', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, '', '', '', '', '', 209.41, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-131223-iivWzUWgqAu6N-092', '2cc72d28-3cb2-4cbf-8c05-8a456e01018d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131223-iivWzUWgqAu6N-092&s=KOL2023&nf=R62&i=-209.41&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 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
(4246, 1, 91, 2, 0, NULL, 0, '2023-12-13 09:17:27', '2023-12-13 10:51:17', '2023-12-13', 'P3984', '23-05503-12-13', '', 0.00, 264.64, 55.57, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 320.21, 0, '2023-12-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131223-Z+m/U61txVb4n-083', '5550f3d0-f592-49c0-82d6-7cdf77fc0afb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131223-Z%2Bm%2FU61txVb4n-083&s=KOL2023&nf=P3984&i=320.20&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4247, 1, 468, 2, 0, NULL, 0, '2023-12-13 11:30:42', '2023-12-13 12:55:00', '2023-12-13', 'P3985', '23-05504-12-13', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Rof carballo 1 peluqueria', 'Lugo', 'Lugo', '27002', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-131223-H1Vpz0exOnvqE-253', 'c2e51b8b-488b-4cdc-8680-af136a32e955', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131223-H1Vpz0exOnvqE-253&s=KOL2023&nf=P3985&i=68.97&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4248, 1, 1085, 2, 0, NULL, 0, '2023-12-13 11:55:00', '2023-12-13 12:57:06', '2023-12-13', 'P3986', '23-05506-12-13', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Jerónimo Vicens, 12, 1 izda', 'Zaragoza', 'Zaragoza', '50002', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-131223-VS8X5PKunam/7-222', '88fd55c0-34c9-458c-be97-2ee6dda470ff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131223-VS8X5PKunam%2F7-222&s=KOL2023&nf=P3986&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),
(4249, 1, 1085, 2, 0, NULL, 0, '2023-12-13 11:58:07', '2023-12-13 11:58:07', '2023-12-13', '', '23-05507-12-13', NULL, 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Jerónimo Vicens, 12, 1 izda', 'Zaragoza', 'Zaragoza', '50002', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4250, 1, 1086, 2, 0, NULL, 0, '2023-12-13 12:05:40', '2023-12-13 13:09:55', '2023-12-13', 'P3987', '23-05508-12-13', 'Asesoria Lezo \r\n\r\nHorario entrega 9:00 a 13:00', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo Ubarburu 22 local k', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 17.50, 0, '2023-12-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131223-jUH/NLr/uNaQM-163', '35ed66ed-283d-4802-a14e-5d9476575f8d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131223-jUH%2FNLr%2FuNaQM-163&s=KOL2023&nf=P3987&i=17.50&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4251, 1, 754, 2, 0, NULL, 0, '2023-12-13 13:53:48', '2023-12-14 09:28:32', '2023-12-13', 'P3988', '23-05509-12-13', '', 0.00, 73.26, 15.38, 0.00, 1, 3.81, 0.00, 'josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 92.45, 0, '2023-12-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131223-G8VWl5FYb2Mur-060', '8b8a0cf6-5cba-4e1d-9715-14f4788b0149', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131223-G8VWl5FYb2Mur-060&s=KOL2023&nf=P3988&i=92.45&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4252, 1, 687, 1, 0, NULL, 0, '2023-12-13 17:07:31', '2023-12-13 17:07:31', '2023-12-13', 'P3989', '2023-12-13', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 103.46, 0, '2023-12-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-131223-MIiBzFKZRDeB6-053', '166b77cc-cca0-42a2-a72d-50a0be1ad9f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131223-MIiBzFKZRDeB6-053&s=KOL2023&nf=P3989&i=103.46&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
(4253, 1, 372, 2, 0, NULL, 0, '2023-12-13 19:20:24', '2023-12-14 09:30:16', '2023-12-13', 'P3990', '23-05510-12-13', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Venezuela, 17, 3º C', 'Vigo', 'Pontevedra', '36203', 'España', 17.50, 0, '2023-12-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131223-AmdMTv3uQArxu-025', 'deac3267-be1d-4f58-8ccb-623556944f63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131223-AmdMTv3uQArxu-025&s=KOL2023&nf=P3990&i=17.50&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4254, 1, 752, 2, 0, NULL, 0, '2023-12-13 21:22:37', '2023-12-14 09:32:18', '2023-12-13', 'P3991', '23-05511-12-13', 'Concesionario IMP SPORT BILBAO', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Poligono Irubide 2-3, pabellón 5', 'Galdakao', 'Bizkaia', '48960', 'España', 30.61, 0, '2023-12-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-131223-Blvb/zdVe+Bv0-006', '679faa84-7268-4565-9723-e9877f109fc7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131223-Blvb%2FzdVe%2BBv0-006&s=KOL2023&nf=P3991&i=30.61&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4255, 1, 1087, 2, 0, NULL, 0, '2023-12-14 07:29:33', '2023-12-14 09:36:10', '2023-12-14', 'P3992', '23-05512-12-14', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida Santander 9, Blq1, 1A', 'Alicante/Alacant', 'Alicante', '03540', 'España', 30.61, 0, '2023-12-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141223-Na0P9PVa7hNkl-226', '274ce632-c0de-4321-87d5-4ec6e82d1f90', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-Na0P9PVa7hNkl-226&s=KOL2023&nf=P3992&i=30.61&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4256, 1, 306, 2, 0, NULL, 0, '2023-12-14 08:43:43', '2023-12-14 10:05:20', '2023-12-14', 'P3993', '23-05513-12-14', 'de lunes a viernes de 9 a 18:30\r\nsabados de 8:30 a 13:30', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'calle puigmolto n 9 local comercial', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 379.34, 0, '2023-12-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141223-btJ8YdRHk1YPV-195', 'f628820a-efb6-4342-b9e2-c5b657ef526b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-btJ8YdRHk1YPV-195&s=KOL2023&nf=P3993&i=379.34&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4257, 1, 623, 2, 0, NULL, 0, '2023-12-14 08:49:51', '2023-12-14 10:08:11', '2023-12-14', 'P3994', '23-05514-12-14', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'La gaiteira 66 bajo', 'Coruña (A)', 'A Coruña', '15009', 'España', 551.76, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141223-bMdlyk1548o59-029', 'b34ef212-b4a7-411a-ac12-ce7def4ed7ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-bMdlyk1548o59-029&s=KOL2023&nf=P3994&i=551.76&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4258, 1, 1088, 2, 0, NULL, 0, '2023-12-14 09:52:44', '2023-12-14 10:59:56', '2023-12-14', 'P3995', '23-05515-12-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'San inazio N.17  2.ctro', 'Beasain', 'Gipuzkoa', '20200', 'España', 17.50, 0, '2023-12-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-141223-LXtM+zMz7PguT-253', 'bd88bf4a-6f1f-4e0b-ab27-2c15a140f86a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-LXtM%2BzMz7PguT-253&s=KOL2023&nf=P3995&i=17.50&cr=020', '[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
(4259, 1, 110, 2, 0, NULL, 0, '2023-12-14 09:54:42', '2023-12-14 11:00:30', '2023-12-14', 'P3996', '23-05516-12-14', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 241.40, 0, '2023-12-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-141223-O/RPI/cgaOKy6-222', 'b96662ce-93cf-41fc-b4dc-91c5991efc1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-O%2FRPI%2FcgaOKy6-222&s=KOL2023&nf=P3996&i=241.40&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4260, 1, 259, 2, 0, NULL, 0, '2023-12-14 10:18:18', '2023-12-14 11:31:35', '2023-12-14', 'P3997', '23-05518-12-14', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'GIPUZKOA KALEA 53 bajo', 'Zarautz', 'Gipuzkoa', '20800', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141223-aHnLt1p/K2t5s-133', '440937e2-9f28-4172-8db1-4bbb4cd5d4e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-aHnLt1p%2FK2t5s-133&s=KOL2023&nf=P3997&i=275.88&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4261, 1, 1089, 2, 0, NULL, 0, '2023-12-14 11:21:51', '2023-12-14 12:31:56', '2023-12-14', 'P3998', '23-05520-12-14', 'Me decidí a probar y no lo compro en Amazon, mejor a vosotros, más personalizado y mejor atención. \r\nSi puede ser por favor entregar mañana.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Azafrán, 103 cass', 'Dos Hermanas', 'Sevilla', '41089', 'España', 28.39, 0, '2023-12-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141223-LhP5pKsDjJOaB-029', '9bfa9755-8cb3-48e5-adac-69a2ab6ff9f4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-LhP5pKsDjJOaB-029&s=KOL2023&nf=P3998&i=28.39&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4262, 1, 40, 2, 0, NULL, 0, '2023-12-14 11:23:22', '2023-12-14 12:32:27', '2023-12-14', 'P3999', '23-05519-12-14', 'lunes por la mañana cerrado y martes cerrado todo el dia', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 157.64, 0, '2023-12-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141223-atn0OAjxiSOCV-006', 'b8b60d94-6652-4b5f-b67a-f5e02847fee9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-atn0OAjxiSOCV-006&s=KOL2023&nf=P3999&i=157.63&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4263, 1, 560, 2, 0, NULL, 0, '2023-12-14 11:49:10', '2023-12-14 13:01:11', '2023-12-14', '', '23-05521-12-14', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'balmes 133', 'Barcelona', 'Barcelona', '08008', 'España', 482.79, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4264, 1, 65, 2, 0, NULL, 0, '2023-12-14 13:01:29', '2024-07-17 13:13:49', '2023-12-14', 'P4000', '23-05521-12-14', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 482.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141223-dNlZfU82jxA8h-083', '5710ed79-d221-47c8-9bf8-fd3b88ba2deb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-dNlZfU82jxA8h-083&s=KOL2023&nf=P4000&i=482.79&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4265, 1, 149, 2, 0, NULL, 0, '2023-12-14 12:33:02', '2023-12-14 13:35:14', '2023-12-14', '', '23-05522-12-14', '', 0.00, 113.98, 24.37, 0.00, 0, 0.00, 2.50, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 140.42, 0, '0000-00-00 00:00:00', '', '', 1, 4, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4266, 1, 149, 2, 0, NULL, 0, '2023-12-14 13:35:46', '2023-12-14 13:35:46', '2023-12-14', 'P4001', '23-05522-12-14', '', 0.00, 113.98, 24.37, 0.00, 0, 0.00, 2.50, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 140.42, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-141223-KBYNvfL2koBo/-096', '46fa2840-53b4-4989-8e0b-0987ca39c5a1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-KBYNvfL2koBo%2F-096&s=KOL2023&nf=P4001&i=140.41&cr=095', '[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
(4267, 1, 7, 1, 0, NULL, 0, '2023-12-14 13:42:05', '2023-12-14 13:42:05', '2023-12-14', 'P4002', '2023-12-14', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 275.88, 0, '2023-12-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141223-c+DikHZHryZP6-217', '0e00dc09-e493-40ca-a27f-47b5a14331d4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-c%2BDikHZHryZP6-217&s=KOL2023&nf=P4002&i=275.88&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4268, 1, 1090, 2, 0, NULL, 0, '2023-12-14 14:01:24', '2023-12-15 09:36:16', '2023-12-14', 'P4003', '23-05523-12-14', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ Aiotzategi n15 ático b', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 28.39, 0, '2023-12-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141223-WiZP9DEPfOaH+-131', 'ec7842f2-b79a-4fd2-8329-e95d17f9a652', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-WiZP9DEPfOaH%2B-131&s=KOL2023&nf=P4003&i=28.39&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4269, 1, 1091, 2, 0, NULL, 0, '2023-12-14 15:13:37', '2023-12-15 09:36:31', '2023-12-14', 'P4004', '23-05524-12-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Capelamendi 5', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 17.50, 0, '2023-12-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-141223-Ptovus0uzXOvf-098', '68deee18-4d8f-4d84-b00f-e944cc5b9bef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-Ptovus0uzXOvf-098&s=KOL2023&nf=P4004&i=17.50&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4270, 1, 1092, 2, 0, NULL, 0, '2023-12-14 18:39:27', '2023-12-15 09:39:59', '2023-12-14', 'P4005', '23-05525-12-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Gorbeia Mendia Pasealekua, n° 2, bajo B', 'Salvatierra/Agurain', 'Álava', '01200', 'España', 17.50, 0, '2023-12-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-141223-ZXqtyCkXdFmJc-106', 'c8f2a5bd-ca8b-4cd8-a2c3-ea5c7fad26f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-ZXqtyCkXdFmJc-106&s=KOL2023&nf=P4005&i=17.50&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4271, 1, 456, 2, 0, NULL, 0, '2023-12-14 21:12:34', '2023-12-15 09:40:13', '2023-12-14', 'P4006', '23-05526-12-14', 'Llamar el transportista entes de entregar el pedido al telf. 653665960', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'CALLE ELDA, Nº 3, ESCALERA 2, 3º C IZQUIERDA', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 30.61, 0, '2023-12-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141223-oUXCHM3QLgk3Z-211', 'a4bcf848-03c1-4780-b71e-44aaca744f73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141223-oUXCHM3QLgk3Z-211&s=KOL2023&nf=P4006&i=30.61&cr=210', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4272, 1, 1093, 2, 0, NULL, 0, '2023-12-15 08:24:27', '2023-12-15 09:40:22', '2023-12-15', 'P4007', '23-05528-12-15', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Cristo de la Salud 62 2ºB', 'Valdemoro', 'Madrid', '28342', 'España', 28.39, 0, '2023-12-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151223-BUB5wx14IRCSn-237', 'f5ffbaee-a4d9-4386-a776-b4095377e0ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151223-BUB5wx14IRCSn-237&s=KOL2023&nf=P4007&i=28.39&cr=010', '[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
(4273, 1, 57, 2, 0, NULL, 0, '2023-12-15 08:55:11', '2023-12-15 10:00:18', '2023-12-15', 'P4008', '23-05529-12-15', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 310.37, 0, '2023-12-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151223-lu73QteCyY+AZ-074', 'ea40c259-5841-476d-8797-8408e21214ec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151223-lu73QteCyY%2BAZ-074&s=KOL2023&nf=P4008&i=310.37&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4274, 1, 522, 2, 0, NULL, 0, '2023-12-15 09:45:54', '2023-12-15 11:03:37', '2023-12-15', 'P4009', '23-05530-12-15', '', 0.00, 236.14, 49.59, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 285.73, 0, '2023-12-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151223-CegTTiLpjq95H-068', 'fd245c28-239f-489b-823e-89dd321a2878', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151223-CegTTiLpjq95H-068&s=KOL2023&nf=P4009&i=285.73&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4275, 1, 75, 2, 0, NULL, 0, '2023-12-15 10:42:29', '2023-12-15 11:46:59', '2023-12-15', 'P4010', '23-05531-12-15', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 137.94, 0, '2023-12-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151223-NwhMjomfPuENK-150', '9ff0a86e-60ea-4349-bdc1-3f2488f1f5dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151223-NwhMjomfPuENK-150&s=KOL2023&nf=P4010&i=137.94&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4276, 1, 23, 2, 0, NULL, 0, '2023-12-15 11:01:06', '2023-12-15 12:02:07', '2023-12-15', 'P4011', '23-05532-12-15', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 103.46, 0, '2023-12-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151223-kG5+SEM1dblh4-171', '235ef58b-7272-44d2-8ce5-292da67a98e8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151223-kG5%2BSEM1dblh4-171&s=KOL2023&nf=P4011&i=103.46&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4277, 1, 1094, 2, 0, NULL, 0, '2023-12-15 11:07:11', '2023-12-15 12:08:45', '2023-12-15', 'P4012', '23-05533-12-15', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'carrer sant Jaume, 37', 'Sant Iscle de Vallal', 'Barcelona', '08359', 'España', 28.39, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-151223-iUmxhV15KH35P-127', '0f5d32a1-835b-476a-999e-65f995b9b07d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151223-iUmxhV15KH35P-127&s=KOL2023&nf=P4012&i=28.39&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4278, 1, 1095, 2, 0, NULL, 0, '2023-12-15 11:55:11', '2023-12-15 12:56:33', '2023-12-15', 'P4013', '23-05534-12-15', 'si no estoy, dejar por encima de la valla', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'calle huesca 16', 'Pedrezuela', 'Madrid', '28723', 'España', 17.50, 0, '2023-12-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151223-lYr9amHpWzLm6-109', '9d60ce9b-8102-4bbc-88ab-126f3840c2e0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151223-lYr9amHpWzLm6-109&s=KOL2023&nf=P4013&i=17.50&cr=126', '[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
(4279, 1, 244, 2, 0, NULL, 0, '2023-12-16 17:48:37', '2023-12-18 09:07:45', '2023-12-16', 'P4016', '23-05535-12-16', '', 0.00, 166.92, 35.05, 0.00, 0, 0.00, 0.00, 'Carrer Balmes, 79 Local 3. Maimar', 'Calella', 'Barcelona', '08370', 'España', 201.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-161223-WXRExn4SlF9kE-171', '960c5971-5dbe-4d7a-9ed1-84ae024c4c44', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161223-WXRExn4SlF9kE-171&s=KOL2023&nf=P4016&i=201.97&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4280, 1, 1055, 2, 0, NULL, 0, '2023-12-17 14:08:54', '2023-12-18 09:10:08', '2023-12-17', 'P4014', '23-05536-12-17', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Avenida de la Ribera 44, 2°', 'Lodosa', 'Navarra', '31580', 'España', 43.71, 0, '2023-12-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-171223-cxPZ5l+hOvED1-166', 'fcf30a6a-8199-48af-a030-2636bfc72872', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171223-cxPZ5l%2BhOvED1-166&s=KOL2023&nf=P4014&i=43.71&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4281, 1, 444, 2, 0, NULL, 0, '2023-12-17 18:04:01', '2023-12-18 09:11:26', '2023-12-17', 'P4015', '23-05537-12-17', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Antziola 9,3ºdcha', 'Hernani', 'Gipuzkoa', '20120', 'España', 30.61, 0, '2023-12-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171223-g1rwTE/lZEH66-247', '4962fa2a-64cc-47f9-8dc6-1d8b74fe794d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171223-g1rwTE%2FlZEH66-247&s=KOL2023&nf=P4015&i=30.61&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4282, 1, 397, 2, 0, NULL, 0, '2023-12-18 10:08:07', '2023-12-18 11:12:13', '2023-12-18', 'P4017', '23-05538-12-18', 'Avisad antes de llevar pedido para estar en casa.gracias', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Alberga 69 1° Izda', 'Errenteria', 'Gipuzkoa', '20100', 'España', 43.71, 0, '2023-12-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181223-UXaDL55YPlJop-036', 'f9a9a82a-ac29-47d0-9eca-ad964dc37340', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181223-UXaDL55YPlJop-036&s=KOL2023&nf=P4017&i=43.71&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4283, 1, 53, 2, 0, NULL, 0, '2023-12-18 10:53:43', '2023-12-18 11:55:44', '2023-12-18', 'P4018', '23-05539-12-18', '', 0.00, 179.14, 38.05, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 219.26, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-181223-bAlHv/dKnmDaT-100', 'c7d1e84c-1f25-49a8-8ef9-3575987a6b2c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181223-bAlHv%2FdKnmDaT-100&s=KOL2023&nf=P4018&i=219.26&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4284, 1, 4, 2, 0, NULL, 0, '2023-12-18 12:15:35', '2023-12-18 13:22:46', '2023-12-18', 'P4019', '23-05540-12-18', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 344.85, 0, '2023-12-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181223-ApTmkEJQEQz0I-228', 'cbb44b61-7eec-45cf-9c09-530f78dbdfaf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181223-ApTmkEJQEQz0I-228&s=KOL2023&nf=P4019&i=344.85&cr=141', '[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
(4285, 1, 599, 2, 0, NULL, 0, '2023-12-18 14:31:29', '2023-12-19 09:23:58', '2023-12-18', 'P4020', '23-05541-12-18', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'San martin 4      4 Izquierda', 'Urretxu', 'Gipuzkoa', '20700', 'España', 17.50, 0, '2023-12-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181223-LVd3nlnMpqMtE-174', '8766a859-9bde-4ab4-aeef-b6f390289f68', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181223-LVd3nlnMpqMtE-174&s=KOL2023&nf=P4020&i=17.50&cr=043', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4286, 1, 152, 1, 0, NULL, 0, '2023-12-18 16:31:01', '2023-12-19 09:36:55', '2023-12-18', 'P4021', '2023-12-18', '', 0.00, 60.06, 12.61, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 72.67, 0, '2023-12-18 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-181223-GgUOhRpd5TewD-060', '688a9c64-40a1-47b9-b2e4-8e41b6bf88eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181223-GgUOhRpd5TewD-060&s=KOL2023&nf=P4021&i=72.67&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4287, 1, 565, 2, 0, NULL, 0, '2023-12-18 16:30:04', '2023-12-19 09:28:01', '2023-12-18', 'P4022', '23-05542-12-18', '', 0.00, 122.14, 25.65, 0.00, 1, 6.35, 0.00, 'C/ Perú número 16 Bloq 2 Bajo DH', 'Alicante', 'Alicante', '03008', 'España', 154.14, 0, '2023-12-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181223-kNqZoRTn6retg-222', '5e70e171-c018-4daf-bc8a-3b25d4f1fb20', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181223-kNqZoRTn6retg-222&s=KOL2023&nf=P4022&i=154.13&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4288, 1, 236, 2, 0, NULL, 0, '2023-12-18 22:04:48', '2023-12-19 09:40:51', '2023-12-18', 'P4023', '23-05543-12-18', '\"Antigua Avenida Ronda Intermedia\"', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'AVDA. DE LA POLICÍA NACIONAL, EDF. DONI IVES, 24', 'Antequera', 'Málaga', '29200', 'España', 103.46, 0, '2023-12-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181223-dYCEVi8lKpiNA-120', '944db621-b614-42ee-aff6-57f4d83d1e0f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181223-dYCEVi8lKpiNA-120&s=KOL2023&nf=P4023&i=103.46&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4289, 1, 1097, 2, 0, NULL, 0, '2023-12-18 22:26:32', '2023-12-19 10:33:34', '2023-12-18', 'P4024', '23-05544-12-18', 'Llamar antes de entregar', 0.00, 19.84, 4.93, 0.00, 0, 0.00, 4.40, 'Alejandro Rodríguez de Valcárcel  n 20 2 A', 'Villarcayo de Merind', 'Burgos', '09550', 'España', 28.41, 0, '2023-12-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181223-AnxjtBsGMqYVO-119', 'fc7b3087-2228-47a5-b86f-4fcbfa204b01', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181223-AnxjtBsGMqYVO-119&s=KOL2023&nf=P4024&i=28.39&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4290, 1, 880, 2, 0, NULL, 0, '2023-12-19 08:44:05', '2023-12-19 09:46:26', '2023-12-19', 'P4025', '23-05545-12-19', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'San Martín n5, 2', 'Donostia-San Sebasti', 'Gipuzkoa', '20003', 'España', 17.50, 0, '2023-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191223-gohYt75GuUGZH-018', '4a5dc75b-7b50-42b0-9627-5ba2361d063a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191223-gohYt75GuUGZH-018&s=KOL2023&nf=P4025&i=17.50&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
