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
(4409, 1, 1128, 2, 0, NULL, 0, '2024-01-16 16:58:48', '2024-01-17 09:29:46', '2024-01-16', 'P4134', '24-05679-01-16', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Labeaga 36 1 ezk', 'Urretxu', 'Gipuzkoa', '20700', 'España', 30.61, 0, '2024-01-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160124-PIJ1xj+i3m7OG-120', 'bb164111-d729-4f88-8fee-1dfba6e38ff4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160124-PIJ1xj%2Bi3m7OG-120&s=KOL2024&nf=P4134&i=30.61&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4410, 1, 167, 2, 0, NULL, 0, '2024-01-16 18:18:45', '2024-01-17 09:33:07', '2024-01-16', 'P4135', '24-05680-01-16', '', 0.00, 451.92, 94.90, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 546.82, 0, '2024-01-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160124-OGqnoDCvoRD3t-253', '8a2b861f-fc52-4240-835d-a74f87f39041', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160124-OGqnoDCvoRD3t-253&s=KOL2024&nf=P4135&i=546.82&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4411, 1, 77, 1, 0, NULL, 0, '2024-01-17 09:29:17', '2024-01-17 09:29:17', '2024-01-17', 'P4136', '2024-01-17', '', 0.00, 579.15, 121.62, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 700.77, 0, '2024-01-17 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170124-TAk96gzmqOkC5-013', '8bedecd7-a576-4228-85f3-293d96576d7d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170124-TAk96gzmqOkC5-013&s=KOL2024&nf=P4136&i=700.77&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4412, 1, 601, 2, 0, NULL, 0, '2024-01-17 09:04:22', '2024-01-17 10:07:41', '2024-01-17', 'P4137', '24-05682-01-17', 'Llamadme antes por favor. Gracias!', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Iturribarri, 11,-1 (puerta granate)', 'Ondarroa', 'Bizkaia', '48700', 'España', 65.52, 0, '2024-01-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170124-PGEse7evhABv7-255', 'c9a7d708-0b86-4f33-a055-cf55f4fb6a33', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170124-PGEse7evhABv7-255&s=KOL2024&nf=P4137&i=65.52&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4413, 1, 1011, 2, 0, NULL, 0, '2024-01-17 10:59:57', '2024-01-17 12:04:21', '2024-01-17', 'P4138', '24-05683-01-17', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'AVDA,CONDOMINA,70 ESC 9 6Q BLOQUE 4', 'Alicante/Alacant', 'Alicante', '03540', 'España', 137.94, 0, '2024-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170124-Z5gvdnZ0HpD9p-230', '029c9e70-7f9d-4359-bd8a-aa1207eb8d5a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170124-Z5gvdnZ0HpD9p-230&s=KOL2024&nf=P4138&i=137.94&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4414, 1, 220, 2, 0, NULL, 0, '2024-01-17 11:31:44', '2024-01-17 12:37:11', '2024-01-17', 'P4139', '24-05684-01-17', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 137.94, 0, '2024-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170124-d/MT0iMO4LEDA-156', '52c70e26-3fc7-493e-966c-6062a4182c9e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170124-d%2FMT0iMO4LEDA-156&s=KOL2024&nf=P4139&i=137.94&cr=093', '[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
(4415, 1, 1129, 2, 0, NULL, 0, '2024-01-17 11:36:00', '2024-01-17 12:39:38', '2024-01-17', 'P4140', '24-05685-01-17', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Cll aldaia 1-1d', 'Orkoien', 'Navarra', '31160', 'España', 30.61, 0, '2024-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170124-NXBojbncfddMp-025', 'f0548b05-50ef-45b2-b696-3cc7e6e7b731', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170124-NXBojbncfddMp-025&s=KOL2024&nf=P4140&i=30.61&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4416, 1, 696, 1, 0, NULL, 0, '2024-01-17 12:36:05', '2024-01-17 12:36:05', '2024-01-17', 'P4141', '2024-01-17', '', 0.00, 300.30, 63.06, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 363.36, 0, '2024-01-17 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170124-ZqqXHxYjBtRKz-009', 'b3a60758-37ad-4f63-b1c4-752f1de6a534', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170124-ZqqXHxYjBtRKz-009&s=KOL2024&nf=P4141&i=363.36&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4417, 1, 403, 2, 0, NULL, 0, '2024-01-17 12:01:17', '2024-01-17 13:06:20', '2024-01-17', 'P4142', '24-05686-01-17', '', 0.00, 108.30, 22.74, 0.00, 0, 0.00, 0.00, 'Pintor Vera Fajardo 9 6 D', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 131.04, 0, '2024-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170124-YULi16n1j6Kpt-086', 'a244f0fe-9d31-4156-ba07-2603693e85f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170124-YULi16n1j6Kpt-086&s=KOL2024&nf=P4142&i=131.04&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4418, 1, 1005, 2, 0, NULL, 0, '2024-01-17 19:18:05', '2024-01-18 09:14:59', '2024-01-17', 'P4143', '24-05687-01-17', 'local  puerta verde', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'San Isidro Labrador 19 local A', 'Madrid', 'Madrid', '28005', 'España', 30.61, 0, '2024-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170124-T+nvSKx/+2OXJ-188', 'fc7080b6-625e-4f17-94ad-856406c783c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170124-T%2BnvSKx%2F%2B2OXJ-188&s=KOL2024&nf=P4143&i=30.61&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4419, 1, 135, 2, 1, 'Confusión en el formato del producto', 4408, '2024-01-18 09:15:31', '2024-01-18 09:15:31', '2024-01-18', 'R63', 'P4133 RECT.', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 59.10, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-180124-fyXEQJGiXVwSO-252', '6f00a19f-9572-45e1-b570-473150062e05', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180124-fyXEQJGiXVwSO-252&s=KOL2024&nf=R63&i=-59.10&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4420, 1, 135, 2, 0, NULL, 0, '2024-01-18 09:14:34', '2024-01-18 10:27:46', '2024-01-18', 'P4144', '24-05688-01-18', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'C/ Moraza N15', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180124-W78v3qdq4HJtp-193', '548b0f33-dda4-4c2a-85bf-c2a33f68c6e5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180124-W78v3qdq4HJtp-193&s=KOL2024&nf=P4144&i=206.91&cr=084', '[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
(4421, 1, 946, 2, 0, NULL, 0, '2024-01-18 10:02:43', '2024-01-18 11:14:23', '2024-01-18', 'P4145', '24-05693-01-18', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'AURELIANO VALLE Nº5 3º IZQ, BILBAO', 'Bilbao', 'Bizkaia', '48010', 'España', 52.39, 0, '2024-01-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180124-B8nMqIJFi/7D0-129', '24a46691-bd9e-4f61-b21a-34944382fa64', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180124-B8nMqIJFi%2F7D0-129&s=KOL2024&nf=P4145&i=52.39&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4422, 1, 1110, 2, 0, NULL, 0, '2024-01-18 12:51:03', '2024-01-19 09:24:45', '2024-01-18', 'P4146', '24-05697-01-18', '', 0.00, 32.56, 7.60, 0.00, 1, 1.88, 4.40, 'C/unió N015', 'Lleida', 'Lleida', '25002', 'España', 45.68, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180124-IknuCDE3ZJqk7-020', 'e76ae0f4-3b07-4655-a3c1-692fbaf882fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180124-IknuCDE3ZJqk7-020&s=KOL2024&nf=P4146&i=45.68&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4423, 1, 242, 1, 0, NULL, 0, '2024-01-19 09:32:31', '2024-01-19 09:32:31', '2024-01-19', 'P4147', '2024-01-19', '', 0.00, 195.36, 41.03, 0.00, 1, 10.16, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 246.55, 0, '2024-01-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190124-JuEL82Xf0FKBF-191', 'fa3729ab-939e-44ef-a2aa-9fa9e023402d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190124-JuEL82Xf0FKBF-191&s=KOL2024&nf=P4147&i=246.55&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4424, 1, 17, 2, 0, NULL, 0, '2024-01-19 09:10:18', '2024-01-19 10:11:40', '2024-01-19', 'P4148', '24-05699-01-19', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 172.43, 0, '2024-01-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190124-jxIEeijEeqOtr-003', '9c53ba8f-2e18-402d-9a2a-d7a1b146b4fb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190124-jxIEeijEeqOtr-003&s=KOL2024&nf=P4148&i=172.43&cr=084', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4425, 1, 1130, 2, 0, NULL, 0, '2024-01-19 10:45:02', '2024-01-19 11:50:27', '2024-01-19', 'P4149', '24-05700-01-19', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ Ulises, 4', 'Mairena del Aljarafe', 'Sevilla', '41927', 'España', 30.61, 0, '2024-01-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190124-UOMALAPJMNgIL-141', '5b01a7e1-209e-4b2b-aa7f-d0ffc309734e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190124-UOMALAPJMNgIL-141&s=KOL2024&nf=P4149&i=30.61&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4426, 1, 1078, 2, 0, NULL, 0, '2024-01-19 13:18:04', '2024-01-22 09:50:37', '2024-01-19', 'P4150', '24-05701-01-19', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Ronda de las ventas 5-6º izquierda', 'Burlada/Burlata', 'Navarra', '31600', 'España', 17.50, 0, '2024-01-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190124-QGbylS+mIVxva-188', '0b9dcc78-69c2-4b3d-a1fd-992f78167e6d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190124-QGbylS%2BmIVxva-188&s=KOL2024&nf=P4150&i=17.50&cr=233', '[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
(4427, 1, 1131, 2, 0, NULL, 0, '2024-01-19 16:24:29', '2024-01-22 13:15:54', '2024-01-19', 'P4158', '24-05702-01-19', '', 0.00, 19.83, 5.59, 0.00, 0, 0.00, 8.19, 'Joan Alcover, 18 - 2°', 'Palma de Mallorca', 'Baleares (Illes)', '07006', 'España', 32.18, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190124-AJ0cTEN0TELUp-007', 'cfa24de7-2ecb-458c-b65d-4ac31fb4c7d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190124-AJ0cTEN0TELUp-007&s=KOL2024&nf=P4158&i=32.18&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4428, 1, 589, 2, 0, NULL, 0, '2024-01-20 09:19:55', '2024-01-22 09:51:27', '2024-01-20', 'P4155', '24-05703-01-20', '', 0.00, 64.98, 14.08, 0.00, 0, 0.00, 2.50, 'Avenida Constitución 184, esc 5, 1  E . ', 'Torrejón de Ardoz', 'Madrid', '28850 ', 'España', 81.13, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-200124-pOG6NoM9wqevx-158', '8b12ffde-7d0e-4834-b914-06e05fc51c4e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200124-pOG6NoM9wqevx-158&s=KOL2024&nf=P4155&i=81.13&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(4429, 1, 1132, 2, 0, NULL, 0, '2024-01-20 11:13:14', '2024-01-22 09:51:39', '2024-01-20', 'P4151', '24-05704-01-20', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Pilar, 26 1° C', 'San Sebastián de los', 'Madrid', '28701', 'España', 17.50, 0, '2024-01-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200124-XByzphqeDh4E1-161', '28381c9f-cab9-44d8-a8cf-67332c2b5583', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200124-XByzphqeDh4E1-161&s=KOL2024&nf=P4151&i=17.50&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4430, 1, 1133, 2, 0, NULL, 0, '2024-01-20 14:00:27', '2024-01-23 10:28:20', '2024-01-20', 'P4164', '24-05705-01-20', '', 0.00, 120.81, 25.37, 0.00, 0, 0.00, 0.00, 'Passeig de la terracuita 1-5 Esc. A   piso  4 puerta 1, Riera de les prats 7', 'Gavà', 'Barcelona', '08850', 'España', 146.18, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200124-kpzAie2zClLu4-208', '1d0ff116-883d-42c8-8eed-fb2743290eb3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200124-kpzAie2zClLu4-208&s=KOL2024&nf=P4164&i=146.18&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4431, 1, 262, 2, 0, NULL, 0, '2024-01-21 07:33:32', '2024-01-22 09:57:55', '2024-01-21', 'P4152', '24-05706-01-21', 'Lunes cerrado', 0.00, 56.98, 11.97, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 68.95, 0, '2024-01-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210124-LyyMhiNeg1iq8-129', '71286662-4b16-4fed-b505-0ef0b105a1b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210124-LyyMhiNeg1iq8-129&s=KOL2024&nf=P4152&i=68.95&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4432, 1, 538, 2, 0, NULL, 0, '2024-01-21 08:03:35', '2024-01-22 09:58:08', '2024-01-21', 'P4153', '24-05707-01-21', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/Raval n24', 'Olesa de Bonesvalls', 'Barcelona', '08795', 'España', 43.71, 0, '2024-01-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210124-i1pW184M3x9o4-210', '58a46fa4-c8c0-4fe5-8fed-6b320c108c51', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210124-i1pW184M3x9o4-210&s=KOL2024&nf=P4153&i=43.71&cr=063', '[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
(4433, 1, 757, 2, 0, NULL, 0, '2024-01-22 07:51:26', '2024-01-22 09:58:28', '2024-01-22', 'P4154', '24-05714-01-22', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Carretera de Soutomaior 22, 3ºD', 'Soutomaior', 'Pontevedra', '36690', 'España', 41.50, 0, '2024-01-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220124-jgV6hBa6AI7kv-240', 'cf6a0b61-d9d3-43a3-91fa-adff06dae512', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220124-jgV6hBa6AI7kv-240&s=KOL2024&nf=P4154&i=41.50&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4434, 1, 65, 2, 0, NULL, 0, '2024-01-22 09:42:01', '2024-07-17 13:14:15', '2024-01-22', 'P4156', '24-05715-01-22', '', 0.00, 684.00, 143.64, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 827.64, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220124-MRKBZIRGUA1um-248', 'e3b13eb3-dd2d-450f-b5a4-19279d2de3b3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220124-MRKBZIRGUA1um-248&s=KOL2024&nf=P4156&i=827.64&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4435, 1, 444, 2, 0, NULL, 0, '2024-01-22 11:33:55', '2024-01-22 12:39:16', '2024-01-22', 'P4157', '24-05716-01-22', '', 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, '2024-01-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220124-CyS5TOxJ1YcP6-098', '4b7dabef-9bd7-40c1-aa44-65e38c0a5450', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220124-CyS5TOxJ1YcP6-098&s=KOL2024&nf=P4157&i=30.61&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4436, 1, 142, 2, 0, NULL, 0, '2024-01-22 13:58:51', '2024-01-23 09:30:34', '2024-01-22', 'P4162', '24-05717-01-22', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'C/ Manzanedo 12', 'Santoña', 'Cantabria', '39740', 'España', 147.79, 0, '2024-01-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220124-jbpgdZiArjYoJ-106', '4e51c8a4-cd2c-46a9-83b7-1541f63d0788', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220124-jbpgdZiArjYoJ-106&s=KOL2024&nf=P4162&i=147.79&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4437, 1, 1134, 2, 0, NULL, 0, '2024-01-22 15:18:49', '2024-01-23 09:27:29', '2024-01-22', 'P4161', '24-05718-01-22', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Aoiz 14, bajo.   ', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220124-AXuhw4UYXJCG0-192', '4b85fb68-a9cf-48a2-904d-674f058ee126', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220124-AXuhw4UYXJCG0-192&s=KOL2024&nf=P4161&i=196.56&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4438, 1, 973, 2, 0, NULL, 0, '2024-01-22 19:37:49', '2024-01-23 09:27:46', '2024-01-22', 'P4159', '24-05720-01-22', 'Horario de entrega de 9:00 a 16:00', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Calle Alejandro Dumas, 4', 'Madrid', 'Madrid', '28005', 'España', 71.98, 0, '2024-01-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220124-mSAbAEk2Fv7zw-095', 'c951a973-ae1c-4b02-b1f4-2e9afe8dfa16', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220124-mSAbAEk2Fv7zw-095&s=KOL2024&nf=P4159&i=71.98&cr=238', '[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
(4439, 1, 1135, 2, 0, NULL, 0, '2024-01-23 08:04:08', '2024-01-23 09:27:55', '2024-01-23', 'P4160', '24-05721-01-23', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Almagro,3, 2°C', 'Torrejón de Ardoz', 'Madrid', '28850', 'España', 17.50, 0, '2024-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230124-hMBXjGl7cfiIF-121', 'fc65e2cc-59dc-4d8b-9e06-bb66764d09f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-hMBXjGl7cfiIF-121&s=KOL2024&nf=P4160&i=17.50&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4440, 1, 1136, 2, 0, NULL, 0, '2024-01-23 08:51:43', '2024-01-23 09:57:38', '2024-01-23', 'P4163', '24-05722-01-23', 'Horario 8.30 -17.30', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Luis Taboada 13 Bajo, Agencia  Marítima Davimar Sa', 'Vigo', 'Pontevedra', '36201', 'España', 30.61, 0, '2024-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230124-Iw9McXVRfM06f-182', '1fc923b7-8580-4120-959f-2dca57853fdc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-Iw9McXVRfM06f-182&s=KOL2024&nf=P4163&i=30.61&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4441, 1, 108, 2, 0, NULL, 0, '2024-01-23 09:27:44', '2024-01-23 10:34:45', '2024-01-23', 'P4165', '24-05724-01-23', '', 0.00, 268.70, 56.43, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 325.13, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230124-TUnfH0i5edwwW-197', '078d23fd-243a-419d-afe6-448011c4555f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-TUnfH0i5edwwW-197&s=KOL2024&nf=P4165&i=325.13&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4442, 1, 1137, 2, 0, NULL, 0, '2024-01-23 09:28:02', '2024-01-23 10:49:56', '2024-01-23', 'P4166', '24-05723-01-23', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'CALLE CAN PAU BIROL, 32, TONI PONS', 'Girona', 'Girona', '17005', 'España', 30.61, 0, '2024-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230124-mdmBSWMVBhM6k-231', 'de68e36a-3876-4043-a5da-aea57a51cedb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-mdmBSWMVBhM6k-231&s=KOL2024&nf=P4166&i=30.61&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4443, 1, 720, 2, 0, NULL, 0, '2024-01-23 09:41:58', '2024-01-23 10:53:36', '2024-01-23', 'P4167', '24-05725-01-23', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sipiri 18, 2D', 'Sopelana', 'Bizkaia', '48600', 'España', 28.39, 0, '2024-01-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230124-horRQRPHkmTNE-166', '8caa5224-a4c6-4040-849a-64e097f0b1a2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-horRQRPHkmTNE-166&s=KOL2024&nf=P4167&i=28.39&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4444, 1, 114, 2, 0, NULL, 0, '2024-01-23 09:56:43', '2024-01-23 11:02:08', '2024-01-23', 'P4168', '24-05726-01-23', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Catalina de Erauso 10 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230124-WqpCwIBALf7lX-224', 'e46b4ba8-fab8-471d-b55b-728a117c32a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-WqpCwIBALf7lX-224&s=KOL2024&nf=P4168&i=379.34&cr=113', '[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
(4445, 1, 1138, 2, 0, NULL, 0, '2024-01-23 11:26:22', '2024-01-23 12:28:01', '2024-01-23', 'P4169', '24-05727-01-23', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Carretera de Santibañez 29 c', 'Aller', 'Asturias', '33680', 'España', 52.39, 0, '2024-01-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230124-dxfaqHYD79pnb-252', '7d3304b5-13fc-491d-8fcf-6930d39984f8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-dxfaqHYD79pnb-252&s=KOL2024&nf=P4169&i=52.39&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4446, 1, 1094, 2, 0, NULL, 0, '2024-01-23 12:38:34', '2024-01-23 13:45:37', '2024-01-23', 'P4170', '24-05728-01-23', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Carrer Sant Jaume n. 37 (casa)', 'Sant Iscle de Vallal', 'Barcelona', '08359', 'España', 28.39, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230124-PlBtqtA/34zVr-254', 'c7039a5d-c305-43b5-b27e-a212da7eab23', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-PlBtqtA%2F34zVr-254&s=KOL2024&nf=P4170&i=28.39&cr=158', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4447, 1, 28, 2, 0, NULL, 0, '2024-01-23 14:40:20', '2024-01-23 14:40:20', '2024-01-23', '', '24-05735-01-23', NULL, 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 275.88, 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),
(4448, 1, 28, 2, 0, NULL, 0, '2024-01-23 14:44:22', '2024-01-24 09:49:19', '2024-01-23', 'P4175', '24-05736-01-23', '', 0.00, 244.28, 51.30, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 295.58, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230124-eO4313GI+oOoF-000', '156bb57b-3954-408c-87c0-d2c49167f4cd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-eO4313GI%2BoOoF-000&s=KOL2024&nf=P4175&i=295.58&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4449, 1, 283, 2, 0, NULL, 0, '2024-01-23 15:10:04', '2024-01-24 09:05:05', '2024-01-23', 'P4171', '24-05737-01-23', 'Horario lu-vie 8:00-16:00h', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/de l\'enginy 17 ', 'Viladecans', 'Barcelona', '08840', 'España', 65.52, 0, '2024-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230124-Q8ivle4qrnevc-033', '010cbd0a-7b07-4f5c-b075-68f68f528e73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-Q8ivle4qrnevc-033&s=KOL2024&nf=P4171&i=65.52&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4450, 1, 110, 2, 0, NULL, 0, '2024-01-23 16:40:44', '2024-01-24 09:14:30', '2024-01-23', 'P4172', '24-05738-01-23', 'lunes cerrado', 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, '2024-01-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230124-BY45FPJIJRypL-194', '9859fbc0-b09c-46ab-97e7-ed558a9f58c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-BY45FPJIJRypL-194&s=KOL2024&nf=P4172&i=275.88&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4451, 1, 571, 2, 0, NULL, 0, '2024-01-23 19:21:32', '2024-01-24 09:16:09', '2024-01-23', 'P4173', '24-05739-01-23', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'AMAROZ 30, 1B', 'Tolosa', 'Gipuzkoa', '20400', 'España', 52.39, 0, '2024-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230124-E7gfji/R3T2ts-132', '6b103bf0-7d71-484c-869e-d963cbc47781', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230124-E7gfji%2FR3T2ts-132&s=KOL2024&nf=P4173&i=52.39&cr=028', '[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
(4452, 1, 1139, 2, 0, NULL, 0, '2024-01-24 06:43:35', '2024-01-24 09:23:05', '2024-01-24', 'P4174', '24-05740-01-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Av castrelos, 9,3d', 'Vigo', 'Pontevedra', '36210', 'España', 30.61, 0, '2024-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240124-Kri3mZHeWj7+v-069', 'dccfa7be-b717-4efc-99eb-17bd611934d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240124-Kri3mZHeWj7%2Bv-069&s=KOL2024&nf=P4174&i=30.61&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4453, 1, 34, 2, 0, NULL, 0, '2024-01-24 11:07:42', '2024-01-24 12:10:22', '2024-01-24', 'P4176', '24-05741-01-24', 'Enviar factura en papel martes a viernes hasta las 12', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'peluqueria Marzo21 calle iparraguirre34 plaza trasera   Leioa Bizkaia', 'Leioa', 'Bizkaia', '48940', 'España', 482.79, 0, '2024-01-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240124-oVOlLaBR571GC-231', '7638c8d9-51ff-4da7-8047-f2ef0a4a6677', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240124-oVOlLaBR571GC-231&s=KOL2024&nf=P4176&i=482.79&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4454, 1, 190, 3, 0, NULL, 0, '2024-01-24 12:16:47', '2024-10-15 16:05:55', '2024-01-24', '', 'Consumo interno', '', 0.00, 1058.40, 222.26, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 1280.66, 0, '2024-01-24 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),
(4455, 1, 75, 2, 0, NULL, 0, '2024-01-24 11:31:41', '2024-01-24 12:37:40', '2024-01-24', 'P4177', '24-05742-01-24', 'Horario de martes a viernes de 10 a 19:00', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 241.40, 0, '2024-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240124-USlNPshdqfmNO-015', '254f7fd5-ae95-408e-a632-95eda6c376db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240124-USlNPshdqfmNO-015&s=KOL2024&nf=P4177&i=241.40&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4456, 1, 1140, 2, 0, NULL, 0, '2024-01-24 12:01:54', '2024-01-24 13:07:28', '2024-01-24', 'P4178', '24-05743-01-24', 'Si no estoy en domicilio entregar en portería. Gracias', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/Limonita 7 3A', 'Madrid', 'Madrid', '28021', 'España', 43.71, 0, '2024-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240124-RnTcCBffINdzD-255', '3e1c678c-a9ce-46bf-b17a-7cf2587903bc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240124-RnTcCBffINdzD-255&s=KOL2024&nf=P4178&i=43.71&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4457, 1, 155, 2, 0, NULL, 0, '2024-01-24 13:22:36', '2024-01-25 09:26:01', '2024-01-24', '', '24-05744-01-24', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(4458, 1, 94, 2, 0, NULL, 0, '2024-01-24 13:55:11', '2024-01-25 09:27:27', '2024-01-24', 'P4179', '24-05745-01-24', '', 0.00, 317.52, 66.68, 0.00, 0, 0.00, 0.00, 'C/mayor número 11', 'Ausejo', 'La Rioja', '26513', 'España', 384.20, 0, '2024-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240124-mLGW0kG0RLYNa-039', '9982a6dc-5903-4a49-a2c3-ea15ccd9d8b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240124-mLGW0kG0RLYNa-039&s=KOL2024&nf=P4179&i=384.20&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4459, 1, 406, 2, 0, NULL, 0, '2024-01-24 21:05:01', '2024-01-25 09:27:55', '2024-01-24', 'P4180', '24-05747-01-24', 'Si no estamos en casa, se puede entregar el paquete al portero. Por las mañanas está hasta las 13h.', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ Blas de Otero 32 5A', 'Bilbao', 'Bizkaia', '48014', 'España', 30.61, 0, '2024-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240124-MR2WbHnS3ENvq-040', 'a93e8962-ad26-468d-825d-5a2794428b3c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240124-MR2WbHnS3ENvq-040&s=KOL2024&nf=P4180&i=30.61&cr=170', '[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
(4460, 1, 76, 1, 0, NULL, 0, '2024-01-25 08:26:23', '2024-01-25 10:24:58', '2024-01-25', 'P4181', '2024-01-25', '', 0.00, 210.21, 44.14, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 254.35, 0, '2024-01-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250124-TbOmVfdkKSKME-174', '7b286fbe-d642-4114-bac8-406581e31f8c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250124-TbOmVfdkKSKME-174&s=KOL2024&nf=P4181&i=254.35&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4461, 1, 155, 2, 0, NULL, 0, '2024-01-25 09:26:18', '2024-01-25 09:29:09', '2024-01-24', 'P4182', '24-05744-01-24', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240124-gtsbMnsi4L2b2-013', '1f5969e9-c148-4c39-b11c-6650827ced22', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240124-gtsbMnsi4L2b2-013&s=KOL2024&nf=P4182&i=206.91&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4462, 1, 589, 2, 1, 'La clienta no paga el contra reembolso y el pedido es devuelto', 4428, '2024-01-25 10:44:43', '2024-01-25 10:44:53', '2024-01-25', 'R64', 'P4155 RECT.', '', 0.00, 64.98, 14.08, 0.00, 0, 0.00, 2.50, '', '', '', '', '', 81.13, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-250124-KYZM/fhVE08kT-033', '302f2406-6fbc-41f6-b0f4-f29e9045daed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250124-KYZM%2FfhVE08kT-033&s=KOL2024&nf=R64&i=-81.13&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4463, 1, 687, 1, 0, NULL, 0, '2024-01-25 10:48:29', '2024-01-25 10:48:55', '2024-01-25', 'P4183', '2024-01-25', '', 0.00, 89.56, 18.81, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 108.37, 0, '2024-01-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250124-SYRo1Rrf0wM7v-242', 'e7fec56a-2f7b-4f98-8aea-60b476098996', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250124-SYRo1Rrf0wM7v-242&s=KOL2024&nf=P4183&i=108.37&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4464, 1, 1141, 2, 0, NULL, 0, '2024-01-25 12:42:10', '2024-01-25 13:45:00', '2024-01-25', 'P4184', '24-05748-01-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Lorenzo Areilza 2C 1A ', 'Getxo', 'Bizkaia', '48993', 'España', 30.61, 0, '2024-01-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250124-ZZSkkZgxKji3G-081', 'b4bd6245-1422-4418-8dee-adba95a6b313', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250124-ZZSkkZgxKji3G-081&s=KOL2024&nf=P4184&i=30.61&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4465, 1, 154, 2, 0, NULL, 0, '2024-01-25 13:54:03', '2024-01-26 09:28:56', '2024-01-25', 'P4185', '24-05749-01-25', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 147.79, 0, '2024-01-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250124-XglS7FnkK9ayi-147', 'a7baf16f-5dbe-4cb0-89eb-9a465de70c37', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250124-XglS7FnkK9ayi-147&s=KOL2024&nf=P4185&i=147.79&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
