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
(6417, 1, 701, 2, 0, NULL, 0, '2025-01-07 22:10:55', '2025-01-08 12:20:44', '2025-01-08', 'P6033', '25-07866-01-07', 'PELUQUERÍA ANA', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Rúa Palamios 21', 'Pontevedra', 'Pontevedra', '36001', 'España', 65.52, 0, '2025-01-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080125-ONzsqspgC8DA3-253', '8e0aec32-b7aa-41dd-81e8-f748e814fec9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-ONzsqspgC8DA3-253&s=KOL2025&nf=P6033&i=65.52&cr=217', '[BLOB]', 0, 'PRANHY071000003N', '2025-01-08 12:19:29', '[BLOB]', 2, '', '2025-01-08', 'S0235', 20, 10, 15, 500, 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
(6418, 1, 73, 2, 0, NULL, 0, '2025-01-08 07:10:25', '2025-01-08 09:22:16', '2025-01-08', 'P6035', '25-07867-01-08', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Zapatari 2A peluqueria', 'Beasain', 'Gipuzkoa', '20200', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080125-Jnjlp1NtfRRlv-096', '9eeaf27b-8398-43f7-a243-25100dd1a120', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-Jnjlp1NtfRRlv-096&s=KOL2025&nf=P6035&i=206.91&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6419, 1, 127, 2, 0, NULL, 0, '2025-01-08 08:21:31', '2025-01-08 09:22:58', '2025-01-08', 'P6034', '25-07868-01-08', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 206.91, 0, '2025-01-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080125-KIP0BIypiZvVh-161', 'f03071b2-dfc3-41bc-958f-16282cf59f7c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-KIP0BIypiZvVh-161&s=KOL2025&nf=P6034&i=206.91&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6420, 1, 696, 1, 0, NULL, 0, '2025-01-08 11:19:01', '2025-01-09 10:13:30', '2025-01-09', 'P6047', '', '', 0.00, 1784.64, 374.77, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 2159.41, 0, '2025-01-08 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090125-I9WdCeJEIcl/j-153', '7a7ba6b1-1ca5-4b85-8b6d-94adcbe30011', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-I9WdCeJEIcl%2Fj-153&s=KOL2025&nf=P6047&i=2159.41&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6421, 1, 574, 2, 0, NULL, 0, '2025-01-08 10:21:56', '2025-01-08 12:21:25', '2025-01-08', 'P6036', '25-07869-01-08', 'Centro de Atención Primaria (dejar en recepción)', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Carrer Nou de la Rambla 169', 'Barcelona', 'Barcelona', '08026', 'España', 43.71, 0, '2025-01-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080125-Ng/Pt0NUgSlwB-033', '7843a6a5-c2c5-4aef-bb16-b7c8089daf46', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-Ng%2FPt0NUgSlwB-033&s=KOL2025&nf=P6036&i=43.71&cr=214', '[BLOB]', 0, 'PKANHY071000150P', '2025-01-08 12:21:31', '[BLOB]', 2, '', '2025-01-08', 'S0235', 20, 10, 15, 100, 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
(6422, 1, 1604, 2, 0, NULL, 0, '2025-01-08 11:17:07', '2025-01-08 12:26:48', '2025-01-08', 'P6037', '25-07870-01-08', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'urbieta 57, bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 157.64, 0, '2025-01-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080125-Qc6KW2u5j0ubT-232', '85989758-0b32-4879-b1d2-e82e0abcce65', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-Qc6KW2u5j0ubT-232&s=KOL2025&nf=P6037&i=157.63&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6423, 1, 1605, 2, 0, NULL, 0, '2025-01-08 11:45:08', '2025-01-08 12:47:02', '2025-01-08', 'P6038', '25-07871-01-08', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'San Joan 19. Esparreguera.  Barcelona', 'Esparreguera', 'Barcelona', '08092', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080125-MruRthwirb6QQ-064', '7ebc7457-bcb0-4076-a10d-6565fddb4f5e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-MruRthwirb6QQ-064&s=KOL2025&nf=P6038&i=196.56&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6424, 1, 1388, 2, 0, NULL, 0, '2025-01-08 11:56:13', '2025-01-08 11:56:13', '2025-01-08', '', '25-07872-01-08', NULL, 0.00, 151.62, 31.84, 0.00, 0, 0.00, 0.00, 'hondarribi 26', 'Donostia-San Sebasti', 'Gipuzkoa', '20005', 'España', 183.46, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6425, 1, 1388, 2, 0, NULL, 0, '2025-01-08 12:04:55', '2025-01-08 13:08:10', '2025-01-08', 'P6039', '25-07873-01-08', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Hondarribia 26', 'Donostia-San Sebasti', 'Gipuzkoa', '20005', 'España', 123.15, 0, '2025-01-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080125-U2UY9UiA8jlZZ-064', '451a4c5a-5307-4731-85b6-ab8d0f11ffbb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-U2UY9UiA8jlZZ-064&s=KOL2025&nf=P6039&i=123.15&cr=182', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6426, 1, 1495, 2, 0, NULL, 0, '2025-01-08 12:06:23', '2025-01-08 13:08:33', '2025-01-08', 'P6040', '25-07874-01-08', 'TIENDA NOMBRE ALEGRIA', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Manuel de sandobal 10', 'Córdoba', 'Córdoba', '14008', 'España', 30.61, 0, '2025-01-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080125-JezQmAVFmOYs0-115', 'ea7437d0-a164-40c5-8a25-5ba453eda89e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-JezQmAVFmOYs0-115&s=KOL2025&nf=P6040&i=30.61&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6427, 1, 1055, 2, 0, NULL, 0, '2025-01-08 13:27:49', '2025-01-08 15:38:00', '2025-01-08', 'P6041', '25-07878-01-08', '', 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, '2025-01-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080125-aOdU8DusPJnXx-120', '9057d05b-6221-4121-b69b-daab01a21130', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-aOdU8DusPJnXx-120&s=KOL2025&nf=P6041&i=43.71&cr=182', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6428, 1, 167, 2, 0, NULL, 0, '2025-01-08 20:17:11', '2025-01-09 09:24:17', '2025-01-09', 'P6044', '25-07879-01-08', '', 0.00, 223.92, 47.02, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 270.94, 0, '2025-01-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090125-Rh2tPyC0OBMnh-255', 'ded6095d-fe22-483d-9973-689a2d9212c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-Rh2tPyC0OBMnh-255&s=KOL2025&nf=P6044&i=270.94&cr=237', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
