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
(4584, 1, 976, 1, 1, 'falta lote', 4583, '2024-02-14 10:54:12', '2024-03-20 10:30:05', '2024-03-20', 'R69', 'P4289 RECT.', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 34.48, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-200324-iy4JO7zn4BQIT-036', '9fd17a9c-f4a7-418b-acd0-267ca981d2ae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200324-iy4JO7zn4BQIT-036&s=KOL2024&nf=R69&i=-34.47&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4585, 1, 976, 1, 0, NULL, 0, '2024-02-14 10:57:04', '2024-02-14 10:57:04', '2024-02-14', 'P4290', '2024-02-14', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'calle bolivia n 1 bajo puerta 3', 'Coruña (A)', 'A Coruña', '15004', 'España', 34.48, 0, '2024-02-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140224-NuDS4sKoaRVDW-200', '62c6487c-7656-43ff-a4e4-db33d7e3c5b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140224-NuDS4sKoaRVDW-200&s=KOL2024&nf=P4290&i=34.47&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4586, 1, 99, 2, 0, NULL, 0, '2024-02-14 11:32:10', '2024-02-14 12:40:28', '2024-02-14', 'P4291', '24-05869-02-14', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Calle Iñigo arista 19 Trasera ', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 206.91, 0, '2024-02-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140224-U8IIA/UxL+wJt-042', 'f1807342-081d-41ee-81b4-1cf41b941d74', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140224-U8IIA%2FUxL%2BwJt-042&s=KOL2024&nf=P4291&i=206.91&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4587, 1, 664, 2, 0, NULL, 0, '2024-02-14 14:16:01', '2024-02-15 08:56:28', '2024-02-14', 'P4292', '24-05870-02-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Aranerreka 32, 3 izquierda', 'Bergara', 'Gipuzkoa', '20570', 'España', 17.50, 0, '2024-02-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140224-YoF2gxiPFANw9-079', '458c8519-55a1-4f3f-8c50-cf0e91ad40f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140224-YoF2gxiPFANw9-079&s=KOL2024&nf=P4292&i=17.50&cr=212', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4588, 1, 53, 2, 0, NULL, 0, '2024-02-14 15:46:02', '2024-02-15 08:59:04', '2024-02-14', 'P4293', '24-05871-02-14', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 140.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-140224-n+bUnsTF/txfx-114', '8779442c-87b5-41e5-a0e7-f9fd699ffd70', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140224-n%2BbUnsTF%2Ftxfx-114&s=KOL2024&nf=P4293&i=140.44&cr=040', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4589, 1, 77, 1, 0, NULL, 0, '2024-02-15 09:31:51', '2024-02-15 09:31:51', '2024-02-15', 'P4294', '2024-02-15', '', 0.00, 879.45, 184.68, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1064.13, 0, '2024-02-15 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150224-LwqAer0Ryp7U1-020', '437fc6c0-cd45-4c60-8c84-6a1580441954', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150224-LwqAer0Ryp7U1-020&s=KOL2024&nf=P4294&i=1064.13&cr=183', '[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
(4590, 1, 1090, 2, 0, NULL, 0, '2024-02-15 13:25:21', '2024-02-16 09:14:39', '2024-02-15', 'P4295', '24-05872-02-15', '', 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, '2024-02-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150224-A/m6fnZrZd3yW-132', '7728236d-c786-448c-b909-7e2ede48085b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150224-A%2Fm6fnZrZd3yW-132&s=KOL2024&nf=P4295&i=28.39&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4591, 1, 1171, 2, 0, NULL, 0, '2024-02-15 20:30:46', '2024-02-16 09:15:34', '2024-02-15', 'P4296', '24-05873-02-15', 'Dejar en buzòn si el timbre da error', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Illa de Tambo 18 Boavista', 'Poio', 'Pontevedra', '36163', 'España', 28.39, 0, '2024-02-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150224-SgYeLDFUxM3zn-004', '9d37a0cd-232d-4bdf-bcf2-fc780944709d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150224-SgYeLDFUxM3zn-004&s=KOL2024&nf=P4296&i=28.39&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4592, 1, 190, 3, 0, NULL, 0, '2024-02-16 09:37:43', '2024-10-15 16:06:32', '2024-02-16', '', 'Consumo interno', '', 0.00, 1343.40, 282.11, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 1625.51, 0, '2024-02-16 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),
(4593, 1, 262, 2, 0, NULL, 0, '2024-02-16 10:28:42', '2024-02-16 11:43:11', '2024-02-16', 'P4297', '24-05874-02-16', 'Lunes cerrado', 0.00, 69.20, 14.53, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 83.73, 0, '2024-02-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160224-FNJs/KTu5SYVT-038', '64c7f6d2-413e-4e17-bbef-592b91d96548', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160224-FNJs%2FKTu5SYVT-038&s=KOL2024&nf=P4297&i=83.73&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4594, 1, 668, 2, 0, NULL, 0, '2024-02-16 10:39:38', '2024-02-16 11:45:12', '2024-02-16', 'P4298', '24-05875-02-16', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Eduardo y felipe Osborne 112', 'Puerto de Santa Marí', 'Cádiz', '11500', 'España', 30.61, 0, '2024-02-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160224-NOjvVG6UB6EmA-101', '8834dd7f-5a3b-4d27-a50f-15f560b117f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160224-NOjvVG6UB6EmA-101&s=KOL2024&nf=P4298&i=30.61&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4595, 1, 262, 2, 1, 'falta lote', 4593, '2024-02-16 11:44:35', '2024-02-16 11:44:35', '2024-02-16', 'R70', 'P4297 RECT.', 'Lunes cerrado', 0.00, 69.20, 14.53, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 83.73, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-160224-NY8NqEXVL31W6-160', '8dd6e237-1486-4f95-9e0d-879737a6bd52', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160224-NY8NqEXVL31W6-160&s=KOL2024&nf=R70&i=-83.73&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(4596, 1, 262, 1, 0, NULL, 0, '2024-02-16 11:49:51', '2024-02-16 11:49:51', '2024-02-16', 'P4299', '2024-02-16', '', 0.00, 69.20, 14.53, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 83.73, 0, '2024-02-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160224-UEKffuMKDGl+J-186', 'd436a4d2-0e55-4c85-9879-97871215967f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160224-UEKffuMKDGl%2BJ-186&s=KOL2024&nf=P4299&i=83.73&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
(4597, 1, 80, 2, 0, NULL, 0, '2024-02-16 13:11:19', '2024-02-19 09:18:34', '2024-02-16', 'P4300', '24-05876-02-16', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 517.28, 0, '2024-02-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160224-JQ6XxOd+pdxXK-095', '0b37ed1e-7961-4ac9-aaa0-603de6b67db1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160224-JQ6XxOd%2BpdxXK-095&s=KOL2024&nf=P4300&i=517.28&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4598, 1, 145, 2, 0, NULL, 0, '2024-02-16 13:19:03', '2024-02-19 09:22:18', '2024-02-16', 'P4310', '24-05877-02-16', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-160224-j6jXgEZiS42Ft-153', 'e84ce67d-a51c-41cd-9c86-02cf9c88691b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160224-j6jXgEZiS42Ft-153&s=KOL2024&nf=P4310&i=209.41&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4599, 1, 1172, 2, 0, NULL, 0, '2024-02-16 13:25:52', '2024-02-19 09:33:50', '2024-02-16', 'P4301', '24-05878-02-16', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Joaquín Velasco Martín, 28', 'Valladolid', 'Valladolid', '47014', 'España', 30.61, 0, '2024-02-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160224-mP9yxYJR3qgm7-028', 'e7d30928-d623-420b-bffe-80bdae53f782', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160224-mP9yxYJR3qgm7-028&s=KOL2024&nf=P4301&i=30.61&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4600, 1, 280, 2, 0, NULL, 0, '2024-02-16 14:16:14', '2024-02-19 09:33:25', '2024-02-16', 'P4302', '24-05879-02-16', 'LUNES CERRADO', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'RUA CODESAL Nº2', 'O Pino', 'A Coruña', '15821', 'España', 206.91, 0, '2024-02-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160224-MGPrZCxIk7m1N-184', '5e3ce7c7-3037-47b4-890b-f4d238a8b67a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160224-MGPrZCxIk7m1N-184&s=KOL2024&nf=P4302&i=206.91&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4601, 1, 1174, 2, 0, NULL, 0, '2024-02-17 07:12:00', '2024-02-19 09:37:18', '2024-02-17', 'P4303', '24-05880-02-17', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Bizkaia N10 2D ', 'Zarautz', 'Gipuzkoa', '20800', 'España', 28.39, 0, '2024-02-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170224-CVlAhwbGRsLmW-047', '17d8f6db-0954-4cb5-ad29-880e72a6ef75', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170224-CVlAhwbGRsLmW-047&s=KOL2024&nf=P4303&i=28.39&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4602, 1, 17, 2, 0, NULL, 0, '2024-02-17 09:56:54', '2024-02-19 09:43:45', '2024-02-17', 'P4304', '24-05881-02-17', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 206.91, 0, '2024-02-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170224-cPpnL31fbo/Gp-010', 'bb39ed0e-984f-4e33-8595-59f3f0952735', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170224-cPpnL31fbo%2FGp-010&s=KOL2024&nf=P4304&i=206.91&cr=139', '[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
(4603, 1, 1175, 2, 0, NULL, 0, '2024-02-17 11:06:50', '2024-02-19 09:46:54', '2024-02-17', 'P4305', '24-05883-02-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Lasao kalea, 15, Gure-toki etxea', 'Zestoa', 'Gipuzkoa', '20740', 'España', 17.50, 0, '2024-02-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170224-eTNZO5sBnHYWb-171', '6c2e5bb1-d31c-4dfc-9a9b-cfaf4cd37492', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170224-eTNZO5sBnHYWb-171&s=KOL2024&nf=P4305&i=17.50&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4604, 1, 1176, 2, 0, NULL, 0, '2024-02-17 13:28:14', '2024-02-19 09:49:37', '2024-02-17', 'P4306', '24-05884-02-17', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'C/ Salvador Mundi, 20, 1ó-1a', 'Barcelona', 'Barcelona', '08017', 'España', 52.39, 0, '2024-02-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170224-aSTd0drNZrYL5-136', '8baf9e65-bd8a-4b30-8d5b-6653b4a7ed3e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170224-aSTd0drNZrYL5-136&s=KOL2024&nf=P4306&i=52.39&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4605, 1, 1177, 2, 0, NULL, 0, '2024-02-17 13:42:54', '2024-02-19 09:51:54', '2024-02-17', 'P4307', '24-05885-02-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Rua S.D.Compostela n° 24 A°', 'Santiago de Composte', 'A Coruña', '15707', 'España', 17.50, 0, '2024-02-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170224-exlbH8UVSuV0T-223', '4a89f937-42bc-4693-8015-efa63b384290', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170224-exlbH8UVSuV0T-223&s=KOL2024&nf=P4307&i=17.50&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4606, 1, 605, 2, 0, NULL, 0, '2024-02-18 09:56:46', '2024-02-19 09:54:17', '2024-02-18', 'P4308', '24-05886-02-18', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'PASEO DE LOS OLMOS  30 - 8º DCHA', 'Donostia-San Sebasti', 'Gipuzkoa', '20016', 'España', 71.98, 0, '2024-02-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180224-WOvbYPX42KCzm-118', '97f9d960-ff20-496f-b239-2501e132b5b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180224-WOvbYPX42KCzm-118&s=KOL2024&nf=P4308&i=71.98&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4607, 1, 267, 2, 0, NULL, 0, '2024-02-18 19:51:32', '2024-02-19 09:55:21', '2024-02-18', 'P4309', '24-05887-02-18', 'Llamar antes de entregar, por la mañana por favor, gracias ', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'camiño do Carballar 2 Vilar de Arriba Pedornes ', 'Oia', 'Pontevedra', '36309', 'España', 43.71, 0, '2024-02-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180224-Qnz8NYmHf/HAw-155', '29db77be-2865-40e0-8f97-d4a21b3798fa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180224-Qnz8NYmHf%2FHAw-155&s=KOL2024&nf=P4309&i=43.71&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4608, 1, 1178, 2, 0, NULL, 0, '2024-02-19 08:59:50', '2024-02-19 11:53:32', '2024-02-19', 'P4314', '24-05888-02-19', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida del Manzanares, 106, 3A', 'Madrid', 'Madrid', '28019', 'España', 30.61, 0, '2024-02-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190224-SwiXg3mkUyhOL-063', '20ccbc2b-a832-4d77-9e1e-da7aabb6133f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190224-SwiXg3mkUyhOL-063&s=KOL2024&nf=P4314&i=30.61&cr=088', '[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
(4609, 1, 635, 2, 0, NULL, 0, '2024-02-19 09:41:43', '2024-02-19 10:47:30', '2024-02-19', 'P4311', '24-05889-02-19', 'SI EL LOCAL ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703. GRACIAS.', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 137.94, 0, '2024-02-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190224-Vp68WWA/jIuUE-175', 'e4f8361b-8473-4fe1-85ab-d2f4bce48a0e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190224-Vp68WWA%2FjIuUE-175&s=KOL2024&nf=P4311&i=137.94&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4610, 1, 568, 2, 0, NULL, 0, '2024-02-19 10:14:27', '2024-02-19 11:36:44', '2024-02-19', 'P4312', '24-05890-02-19', 'peluquería el marco blanco', 0.00, 138.42, 29.07, 0.00, 0, 0.00, 0.00, 'larramendi 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 167.49, 0, '2024-02-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190224-N+xBQU7s1gPMv-080', '5b3db094-e607-4895-9e9a-280bdf646c37', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190224-N%2BxBQU7s1gPMv-080&s=KOL2024&nf=P4312&i=167.49&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4611, 1, 296, 2, 0, NULL, 0, '2024-02-19 10:50:20', '2024-02-19 11:54:57', '2024-02-19', 'P4313', '24-05891-02-19', 'DE LUNES A VIERNES DE 10 A 19 HORS\r\nNO FINES DE SEMANA', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'Via Laietana, 23, ENTRESUELO-C', 'Barcelona', 'Barcelona', '08003', 'España', 54.60, 0, '2024-02-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190224-El/gasRUFOuYz-130', '473e3b03-a374-4e4f-8a99-6dc9a4755af8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190224-El%2FgasRUFOuYz-130&s=KOL2024&nf=P4313&i=54.60&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4612, 1, 1179, 2, 0, NULL, 0, '2024-02-19 11:13:36', '2024-02-19 12:41:06', '2024-02-19', 'P4315', '24-05893-02-19', 'Soy cliente de peluqueria Izko desde hace muchos años. Me gusta el producto y por circunstancias que dificultan el desplazamiento me gustaría ver si puedo hacerme el color  yo misma. \r\nUtilizo Bizum desde hace mucho tiempo sin problemas y en cambio aquí  impide el pago. No lo entiendo. Pagaré con tarjeta\r\n\r\nGracias', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida Pio XII, 1, Torre 3, 4º C', 'Pamplona/Iruña', 'Navarra', '31002', 'España', 30.61, 0, '2024-02-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190224-ZZ0tA0YmjlNue-116', '5c6657af-e65c-47dc-b339-c32f3d0844a5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190224-ZZ0tA0YmjlNue-116&s=KOL2024&nf=P4315&i=30.61&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4613, 1, 222, 2, 0, NULL, 0, '2024-02-19 20:24:51', '2024-02-20 09:11:48', '2024-02-19', 'P4316', '24-05894-02-19', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Cartagena 296 ', 'Barcelona', 'Barcelona', '08025', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190224-oNBDVpyGd2iuB-011', 'b0ff8024-da45-4df2-af3c-a77af15e7e4e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190224-oNBDVpyGd2iuB-011&s=KOL2024&nf=P4316&i=206.91&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4614, 1, 696, 1, 0, NULL, 0, '2024-02-20 11:58:37', '2024-02-20 11:59:08', '2024-02-20', 'P4317', '2024-02-20', '', 0.00, 437.58, 91.89, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 529.47, 0, '2024-02-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200224-cwEOj5ZCwjhl7-213', '891d31a9-9f22-42ca-ad76-9a99fc9a5cd8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-cwEOj5ZCwjhl7-213&s=KOL2024&nf=P4317&i=529.47&cr=187', '[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
(4615, 1, 519, 1, 0, NULL, 0, '2024-02-20 13:08:52', '2024-02-20 13:08:52', '2024-02-20', 'P4318', '2024-02-20', '', 0.00, 52.92, 11.11, 0.00, 0, 0.00, 0.00, 'CALLE DE SAN AGUSTÍN \'EL VIEJO\' 25', 'TALAVERA DE LA REINA', 'TOLEDO', '45600', 'España', 64.03, 0, '2024-02-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200224-G7RZYkmk8sBgT-122', 'a3ebd984-3680-471e-b710-9a517b2056ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-G7RZYkmk8sBgT-122&s=KOL2024&nf=P4318&i=64.03&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4616, 1, 821, 2, 0, NULL, 0, '2024-02-20 12:13:23', '2024-02-20 13:16:16', '2024-02-20', 'P4319', '24-05895-02-20', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'gurutzeaga 9 bajo, 72438407e', 'Zestoa', 'Gipuzkoa', '20740', 'España', 103.46, 0, '2024-02-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200224-eKIsNLVrZesBz-199', '513d45b1-8037-4094-af98-e8987158f964', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-eKIsNLVrZesBz-199&s=KOL2024&nf=P4319&i=103.46&cr=138', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4617, 1, 1181, 2, 0, NULL, 0, '2024-02-20 12:34:47', '2024-02-20 13:35:14', '2024-02-20', 'P4320', '24-05896-02-20', '', 0.00, 43.32, 13.57, 0.00, 0, 0.00, 25.77, '8 TOWN MEADOWS', 'Woolsery ', 'Bideford ', 'EX39 5TS', 'Reino Unido', 78.19, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200224-m00O6maoWpn5C-017', 'b79360e3-994e-4f7f-a8fa-063c4203077e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-m00O6maoWpn5C-017&s=KOL2024&nf=P4320&i=78.19&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4618, 1, 556, 2, 0, NULL, 0, '2024-02-20 15:45:54', '2024-02-21 09:10:52', '2024-02-20', '', '24-05897-02-20', '', 0.00, 24.42, 6.33, 0.00, 0, 0.00, 6.90, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 36.45, 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),
(4619, 1, 1182, 2, 0, NULL, 0, '2024-02-20 16:29:45', '2024-02-21 09:11:46', '2024-02-20', 'P4327', '24-05898-02-20', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'jose Arana, N14, peluquería Adoceta', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 517.28, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200224-DiPeEKhdOsphQ-066', 'ca511b68-ab1e-4726-b3b1-916cfafe903b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-DiPeEKhdOsphQ-066&s=KOL2024&nf=P4327&i=517.28&cr=075', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4620, 1, 1183, 2, 0, NULL, 0, '2024-02-20 17:03:56', '2024-02-21 09:12:15', '2024-02-20', 'P4321', '24-05899-02-20', 'Si no hay nadie en el domicilio se puede dejar en panaderia Herminia', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'José loureiro González  n6   2i', 'Laracha (A)', 'A Coruña', '15145', 'España', 28.39, 0, '2024-02-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200224-h/WSgLaUfh2Jh-095', 'a5539f08-98d9-4e32-8c56-16540f179e88', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-h%2FWSgLaUfh2Jh-095&s=KOL2024&nf=P4321&i=28.39&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4621, 1, 4, 2, 0, NULL, 0, '2024-02-20 19:19:53', '2024-02-21 09:12:47', '2024-02-20', 'P4322', '24-05900-02-20', '', 0.00, 248.34, 52.15, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 300.49, 0, '2024-02-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200224-VWtur+PoLz5D2-254', 'e3708036-4af9-4a4e-b590-e3da8b862c68', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-VWtur%2BPoLz5D2-254&s=KOL2024&nf=P4322&i=300.49&cr=243', '[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
(4622, 1, 398, 2, 0, NULL, 0, '2024-02-20 21:07:09', '2024-02-21 09:12:57', '2024-02-20', 'P4323', '24-05901-02-20', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo De La Verneda 111/3/3', 'Barcelona', 'Barcelona', '08020', 'España', 17.50, 0, '2024-02-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-200224-YI+EgaIx/4yHl-177', '8edb0810-ac41-4e4c-8809-8123d52855ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-YI%2BEgaIx%2F4yHl-177&s=KOL2024&nf=P4323&i=17.50&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4623, 1, 477, 2, 0, NULL, 0, '2024-02-20 21:29:40', '2024-02-21 09:13:13', '2024-02-20', 'P4324', '24-05902-02-20', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Pedro Elejalde 12,4. ezk', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 56.82, 0, '2024-02-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200224-WCKYLFEdg1XkC-056', 'd82935c6-7506-4ab0-b28f-134f135e39ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-WCKYLFEdg1XkC-056&s=KOL2024&nf=P4324&i=56.82&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4624, 1, 556, 2, 0, NULL, 0, '2024-02-21 09:11:07', '2024-02-21 09:13:27', '2024-02-20', 'P4325', '24-05897-02-20', '', 0.00, 24.42, 6.33, 0.00, 0, 0.00, 6.90, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 36.45, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-200224-k2HcR0sc6yvC3-098', 'f4e98d91-76b7-4f2e-a4d4-2b2b84bab348', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-k2HcR0sc6yvC3-098&s=KOL2024&nf=P4325&i=36.45&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4625, 1, 556, 2, 0, NULL, 0, '2024-02-21 09:11:17', '2024-02-21 09:11:17', '2024-02-20', 'P4326', '24-05897-02-20', '', 0.00, 24.42, 6.33, 0.00, 0, 0.00, 6.90, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 36.45, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-200224-Q5orhyjYZKtCg-067', 'af366897-ef86-40d6-a149-ba707d37a59f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200224-Q5orhyjYZKtCg-067&s=KOL2024&nf=P4326&i=36.45&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4626, 1, 556, 2, 1, 'Pedido duplicado', 4625, '2024-02-21 09:19:47', '2024-02-21 09:19:47', '2024-02-21', 'R71', 'P4326 RECT.', '', 0.00, 24.42, 6.33, 0.00, 0, 0.00, 6.90, '', '', '', '', '', 36.45, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-210224-nprY5E5w4/rs8-147', 'a8955d9d-190b-4e95-9406-87bf788acb10', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210224-nprY5E5w4%2Frs8-147&s=KOL2024&nf=R71&i=-36.45&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(4627, 1, 160, 2, 0, NULL, 0, '2024-02-21 09:27:28', '2024-02-21 11:02:12', '2024-02-21', 'P4328', '24-05903-02-21', '', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 113.30, 0, '2024-02-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210224-H0cGPMsr92IgH-236', '2aca1543-17e5-47fc-87b2-864025cae31f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210224-H0cGPMsr92IgH-236&s=KOL2024&nf=P4328&i=113.30&cr=111', '[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
(4628, 1, 1110, 2, 0, NULL, 0, '2024-02-21 09:52:15', '2024-02-21 11:05:42', '2024-02-21', 'P4329', '24-05904-02-21', '', 0.00, 56.98, 11.97, 0.00, 0, 0.00, 0.00, 'C/unió N015', 'Lleida', 'Lleida', '25002', 'España', 68.95, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210224-kRTYuHTJmha/f-218', '990682e5-c522-478e-9348-f85dc3429378', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210224-kRTYuHTJmha%2Ff-218&s=KOL2024&nf=P4329&i=68.95&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4629, 1, 149, 2, 0, NULL, 0, '2024-02-21 11:27:15', '2024-02-21 12:28:05', '2024-02-21', 'P4330', '24-05905-02-21', '', 0.00, 81.42, 17.53, 0.00, 0, 0.00, 2.50, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 101.02, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-210224-Vz4Fl6OvqWzND-231', 'b52b4d46-8dec-4efd-83b2-d7d53f82e25c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210224-Vz4Fl6OvqWzND-231&s=KOL2024&nf=P4330&i=101.02&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4630, 1, 55, 2, 0, NULL, 0, '2024-02-21 11:40:37', '2024-02-21 12:49:37', '2024-02-21', 'P4331', '24-05907-02-21', '', 0.00, 73.28, 15.82, 0.00, 0, 0.00, 2.50, 'San Pedro De Mezonzo 17 bajo derch', 'Santiago de Composte', 'A Coruña', '15701', 'España', 91.17, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-210224-Ua7BECjwu68Tg-161', '9d07a5e6-5f08-4b25-b3cb-6084af944149', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210224-Ua7BECjwu68Tg-161&s=KOL2024&nf=P4331&i=91.17&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4631, 1, 106, 1, 0, NULL, 0, '2024-02-21 13:18:01', '2024-02-21 13:18:17', '2024-02-21', 'P4332', '', '', 0.00, 61.06, 12.82, 0.00, 0, 0.00, 0.00, 'Hipódromo 10 bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'ESPAÑA', 73.88, 0, '2024-02-21 00:00:00', '', '', 3, 6, 1, 'TBAI-B20930640-210224-n11Uep7BFDPhi-165', '2fa2db79-e58a-4ffb-a6fc-38e9a489958b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210224-n11Uep7BFDPhi-165&s=KOL2024&nf=P4332&i=73.88&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4632, 1, 85, 2, 0, NULL, 0, '2024-02-21 12:22:29', '2024-02-21 13:24:34', '2024-02-21', 'P4333', '24-05908-02-21', '', 0.00, 179.12, 37.61, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 216.74, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210224-QX2NZCnV3kKzp-028', '11f0123f-00c9-442b-8fa0-c37379d15791', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210224-QX2NZCnV3kKzp-028&s=KOL2024&nf=P4333&i=216.74&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4633, 1, 78, 2, 0, NULL, 0, '2024-02-21 13:30:29', '2024-02-22 09:28:27', '2024-02-21', 'P4334', '24-05909-02-21', '', 0.00, 484.50, 101.75, 0.00, 0, 0.00, 0.00, 'AVD, SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '2008', 'España', 586.25, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210224-o3U80GmJpg9PB-160', '69c32174-7b21-4cb9-9383-0634b24f0a98', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210224-o3U80GmJpg9PB-160&s=KOL2024&nf=P4334&i=586.25&cr=119', '[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
(4634, 1, 65, 2, 0, NULL, 0, '2024-02-21 16:25:00', '2024-07-17 13:17:33', '2024-02-21', 'P4335', '24-05910-02-21', '', 0.00, 427.50, 89.77, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 517.27, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210224-g2wHNClF+Utm0-156', 'c11c783f-496a-4c82-b0f7-98bfaa8fabf4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210224-g2wHNClF%2BUtm0-156&s=KOL2024&nf=P4335&i=517.28&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4635, 1, 242, 1, 0, NULL, 0, '2024-02-22 09:37:56', '2024-02-22 09:37:56', '2024-02-22', 'P4336', '2024-02-22', '<p>3 en pre color dorados en promoción</p>', 0.00, 146.52, 30.77, 0.00, 1, 7.62, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 184.91, 0, '2024-02-22 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220224-E7nbyC9uVEDDS-115', '36cf9fe9-3906-4703-a319-54e37785ad15', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220224-E7nbyC9uVEDDS-115&s=KOL2024&nf=P4336&i=184.91&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4636, 1, 152, 1, 0, NULL, 0, '2024-02-22 10:08:49', '2024-02-22 10:12:04', '2024-02-22', 'P4337', '2024-02-22', '', 0.00, 141.57, 29.73, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 171.30, 0, '2024-02-22 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220224-ktqJhFVek4Jik-062', '4c17b4c6-070e-4d3c-bcd9-e0f47d8e8d6a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220224-ktqJhFVek4Jik-062&s=KOL2024&nf=P4337&i=171.30&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4637, 1, 1089, 2, 0, NULL, 0, '2024-02-22 11:40:58', '2024-02-22 12:48:38', '2024-02-22', 'P4338', '24-05911-02-22', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Azafrán, 103', 'Dos Hermanas', 'Sevilla', '41089', 'España', 61.09, 0, '2024-02-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220224-ZIDUGBhUrz9Y6-165', '430155f6-a8fc-4a61-901a-15755fc00975', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220224-ZIDUGBhUrz9Y6-165&s=KOL2024&nf=P4338&i=61.09&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4638, 1, 68, 2, 0, NULL, 0, '2024-02-22 13:34:48', '2024-02-23 09:36:40', '2024-02-22', 'P4340', '24-05912-02-22', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'murgis 45', 'Ejido (El)', 'Almería', '04700', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-220224-IJwOtaJDuo0Hi-171', 'fa43f940-956a-463b-9970-017b16985d90', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220224-IJwOtaJDuo0Hi-171&s=KOL2024&nf=P4340&i=105.96&cr=160', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4639, 1, 113, 2, 0, NULL, 0, '2024-02-22 15:53:58', '2024-02-23 09:37:48', '2024-02-22', 'P4341', '24-05913-02-22', '', 0.00, 130.28, 27.79, 0.00, 0, 0.00, 2.50, 'Avda labradores 5 Local3', 'Tres Cantos', 'Madrid', '28760', 'España', 160.14, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-220224-muijOYLAC32cv-149', '6211693c-0c1b-4077-99d6-bbec07333214', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220224-muijOYLAC32cv-149&s=KOL2024&nf=P4341&i=160.13&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
