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
(5371, 1, 1055, 2, 0, NULL, 0, '2024-07-16 14:35:55', '2024-07-17 09:11:42', '2024-07-17', 'P5029', '24-06696-07-16', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avenida de la Ribera 44, 2°', 'Lodosa', 'Navarra', '31580', 'España', 52.39, 0, '2024-07-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170724-joORLD8MFjtsS-185', '3642e822-e265-46b8-afea-249d3fb6a144', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-joORLD8MFjtsS-185&s=KOL2024&nf=P5029&i=52.39&cr=009', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5372, 1, 262, 2, 0, NULL, 0, '2024-07-16 15:44:57', '2024-07-17 09:15:07', '2024-07-17', 'P5030', '24-06697-07-16', 'lunes y sabado tarde cerrado.', 0.00, 215.76, 45.31, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 261.07, 0, '2024-07-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170724-cAcHrqPq8fwF5-081', 'e1e5f4b7-8cf3-4be4-982f-d0b23442ec64', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-cAcHrqPq8fwF5-081&s=KOL2024&nf=P5030&i=261.07&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5373, 1, 1211, 2, 0, NULL, 0, '2024-07-16 16:54:14', '2024-07-17 09:18:28', '2024-07-17', 'P5031', '24-06698-07-16', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Luis Olariaga 3, 5 dcha.', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 43.71, 0, '2024-07-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170724-cMj4i+FoSzgjr-019', '097fd348-8a4e-4931-9e50-de901b2b49f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-cMj4i%2BFoSzgjr-019&s=KOL2024&nf=P5031&i=43.71&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5374, 1, 67, 2, 0, NULL, 0, '2024-07-16 20:45:04', '2024-07-17 09:23:32', '2024-07-17', 'P5033', '24-06699-07-16', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170724-o66+knXWvI7qH-101', 'b3ef2d1a-fb61-46c7-8005-42a68b4e3d96', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-o66%2BknXWvI7qH-101&s=KOL2024&nf=P5033&i=206.91&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5375, 1, 65, 2, 0, NULL, 0, '2024-07-17 09:15:54', '2024-07-17 13:19:22', '2024-07-17', 'P5034', '24-06700-07-17', '', 0.00, 256.50, 53.86, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 310.36, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170724-pCPv9V1nbBVmv-097', '76be17f7-5665-4de0-8f9c-a78739ad1eca', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-pCPv9V1nbBVmv-097&s=KOL2024&nf=P5034&i=310.36&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5376, 1, 144, 2, 0, NULL, 0, '2024-07-17 09:34:38', '2024-07-17 11:39:32', '2024-07-17', 'P5035', '24-06701-07-17', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 241.40, 0, '2024-07-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170724-k89RRAXtgsYsg-142', '19af3888-5112-4777-be96-97a6f1fa0fd2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-k89RRAXtgsYsg-142&s=KOL2024&nf=P5035&i=241.40&cr=106', '[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
(5377, 1, 152, 1, 0, NULL, 0, '2024-07-17 11:55:44', '2024-07-17 11:55:44', '2024-07-17', 'P5036', '', '', 0.00, 25.74, 5.41, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 31.15, 0, '2024-07-17 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170724-ZDtPElEKaDumh-236', 'cf1c1f8f-8ed7-480a-a233-7412ca2f84c5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-ZDtPElEKaDumh-236&s=KOL2024&nf=P5036&i=31.15&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5378, 1, 57, 2, 0, NULL, 0, '2024-07-17 11:05:44', '2024-07-17 13:21:52', '2024-07-17', 'P5037', '24-06702-07-17', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 172.43, 0, '2024-07-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170724-AWbPKVmJNDHnX-081', '580692cc-9cdf-4f9e-a567-75c3df309d85', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-AWbPKVmJNDHnX-081&s=KOL2024&nf=P5037&i=172.43&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5379, 1, 381, 2, 0, NULL, 0, '2024-07-17 11:16:20', '2024-07-17 13:22:36', '2024-07-17', 'P5038', '24-06703-07-17', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ Felipe Abad León Nº 51, Embutidos Mariano Martínez', 'Santa Coloma', 'La Rioja', '26315', 'España', 65.52, 0, '2024-07-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170724-kY3pVsFfSo1jx-170', '5485e67f-3dd5-4509-a680-374b1b981979', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-kY3pVsFfSo1jx-170&s=KOL2024&nf=P5038&i=65.52&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5380, 1, 1333, 2, 0, NULL, 0, '2024-07-17 11:59:09', '2024-07-18 07:51:38', '2024-07-18', 'P5039', '24-06704-07-17', 'Si no estoi dejad en el 1° o en la tienda de al lado', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida de la habana, 109 -3°', 'Pontes de García Rod', 'A Coruña', '15320', 'España', 30.61, 0, '2024-07-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180724-G5a7ygQzbEKCW-248', 'd8c67afb-d50c-4d25-8c28-b2278a17a546', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180724-G5a7ygQzbEKCW-248&s=KOL2024&nf=P5039&i=30.61&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5381, 1, 1033, 2, 0, NULL, 0, '2024-07-17 16:15:07', '2024-07-18 07:59:06', '2024-07-18', 'P5040', '24-06705-07-17', '', 0.00, 32.56, 7.60, 0.00, 0, 0.00, 4.40, 'Lersundi 18 bajo peluqueria', 'Deba', 'Gipuzkoa', '20820', 'España', 43.80, 0, '2024-07-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180724-ZnbJwC+CXw4jD-132', '4f7030ff-c5c1-4bfb-83b3-e93164035c65', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180724-ZnbJwC%2BCXw4jD-132&s=KOL2024&nf=P5040&i=43.80&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5382, 1, 4, 2, 0, NULL, 0, '2024-07-17 16:55:31', '2024-07-18 08:03:11', '2024-07-18', 'P5041', '24-06706-07-17', '', 0.00, 260.56, 54.72, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 315.28, 0, '2024-07-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180724-nby/2n+2no+M5-248', 'c13e3058-3814-44c4-9205-44479295ae37', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180724-nby%2F2n%2B2no%2BM5-248&s=KOL2024&nf=P5041&i=315.27&cr=225', '[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
(5383, 1, 1281, 2, 0, NULL, 0, '2024-07-17 21:36:49', '2024-07-18 08:06:00', '2024-07-18', 'P5042', '24-06708-07-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Joaquín Turina 21, 3B', 'Logroño', 'La Rioja', '26007', 'España', 17.50, 0, '2024-07-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180724-IAhAAuglR37Co-219', 'c49a8ab6-1321-4402-af18-f96b7880e5a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180724-IAhAAuglR37Co-219&s=KOL2024&nf=P5042&i=17.50&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5384, 1, 1174, 2, 0, NULL, 0, '2024-07-18 07:26:05', '2024-07-18 09:43:02', '2024-07-18', 'P5043', '24-06709-07-18', '', 0.00, 61.32, 12.88, 0.00, 0, 0.00, 0.00, 'C/Bizkaia N10 2D', 'Zarautz', 'Gipuzkoa', '20800', 'España', 74.20, 0, '2024-07-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180724-iG4eF5NjqyX3A-081', 'bdffee32-6d4b-487e-afda-fb3c5d158197', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180724-iG4eF5NjqyX3A-081&s=KOL2024&nf=P5043&i=74.20&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5385, 1, 991, 2, 0, NULL, 0, '2024-07-18 08:08:47', '2024-07-18 10:25:39', '2024-07-18', 'P5044', '24-06710-07-18', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'C/ Doctor Marañón 12', 'Almonte', 'Huelva', '21730', 'España', 103.46, 0, '2024-07-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180724-cJyvL4dSUE4jP-037', '7c5e35c8-a37e-4698-99eb-a5fd804f42e4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180724-cJyvL4dSUE4jP-037&s=KOL2024&nf=P5044&i=103.46&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5386, 1, 392, 2, 0, NULL, 0, '2024-07-18 09:16:14', '2024-07-18 11:28:21', '2024-07-18', 'P5045', '24-06711-07-18', 'Por favor que el repartidor llame antes de para asegurarse que estoy en casa. gracias', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'carrer La Font, 29', 'Sagra', 'Alicante', '03795', 'España', 54.60, 0, '2024-07-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180724-iwaoqSoayBH3v-220', 'e9fefbf7-befd-4b0d-b6d8-3a06ba69d23d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180724-iwaoqSoayBH3v-220&s=KOL2024&nf=P5045&i=54.60&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5387, 1, 522, 2, 0, NULL, 0, '2024-07-18 11:47:20', '2024-07-19 09:15:29', '2024-07-19', 'P5046', '24-06713-07-18', 'Abrimos en julio y agosto de lunes a viernes de 10h a 19h', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 206.91, 0, '2024-07-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190724-IAuxrjo34YPaE-155', 'fd4e9b41-62ba-4a50-b354-f13637496143', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-IAuxrjo34YPaE-155&s=KOL2024&nf=P5046&i=206.91&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5388, 1, 110, 2, 0, NULL, 0, '2024-07-18 11:48:18', '2024-07-19 09:19:20', '2024-07-19', 'P5047', '24-06714-07-18', 'Lunes cerrado', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 206.91, 0, '2024-07-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190724-eF+zc0GJ2rMtK-119', '9da85067-f236-4448-a14a-08d96d0b3c2d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-eF%2Bzc0GJ2rMtK-119&s=KOL2024&nf=P5047&i=206.91&cr=049', '[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
(5389, 1, 783, 2, 0, NULL, 0, '2024-07-18 11:58:45', '2024-07-19 09:21:33', '2024-07-19', 'P5048', '24-06715-07-18', '', 0.00, 52.32, 10.99, 0.00, 0, 0.00, 0.00, 'Alvaro Cunqueiro, nº 15, 7º A', 'Vigo', 'Pontevedra', '36211', 'España', 63.31, 0, '2024-07-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190724-TH19qcs41T2u8-162', '72135e4f-3be1-4b51-8f72-dc7f118f300d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-TH19qcs41T2u8-162&s=KOL2024&nf=P5048&i=63.31&cr=227', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5390, 1, 1334, 2, 0, NULL, 0, '2024-07-18 13:44:15', '2024-07-19 09:26:54', '2024-07-19', 'P5052', '24-06718-07-18', '', 0.00, 59.49, 12.93, 0.00, 0, 0.00, 2.50, 'Passeig Torre Valentina 11, Sant Antoni de Calonge', 'Calonge', 'Girona', '17252', 'España', 74.48, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-190724-iW4Pn/S958bnz-053', 'a811cff6-d6d7-48f1-83fa-0b7c4a093963', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-iW4Pn%2FS958bnz-053&s=KOL2024&nf=P5052&i=74.48&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5391, 1, 1335, 2, 0, NULL, 0, '2024-07-18 14:44:48', '2024-07-19 09:31:07', '2024-07-19', 'P5049', '24-06719-07-18', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ albobide 5-3°A dcha', 'Bakio', 'Bizkaia', '48130', 'España', 30.61, 0, '2024-07-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190724-CqPMx6PH+sDOs-111', '05148d7d-6b94-4aca-adb5-3fb644aed921', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-CqPMx6PH%2BsDOs-111&s=KOL2024&nf=P5049&i=30.61&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5392, 1, 1082, 2, 0, NULL, 0, '2024-07-18 17:32:29', '2024-07-19 09:33:39', '2024-07-19', 'P5050', '24-06720-07-18', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Av. Anglaterra, 26 1-2. Urb.Rocamar', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 17.50, 0, '2024-07-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190724-TTLVQ9R4rIPRa-181', '82b28260-e1d8-4af1-8824-2e270fea5a1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-TTLVQ9R4rIPRa-181&s=KOL2024&nf=P5050&i=17.50&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5393, 1, 794, 2, 0, NULL, 0, '2024-07-19 06:10:00', '2024-07-19 09:36:19', '2024-07-19', 'P5051', '24-06721-07-19', 'Factura a nombre de la empresa:\r\nLucía Zabala Peluquería y Maquillaje S.L.U ', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Idoia 4 bajo', 'Zizur Mayor/Zizur Na', 'Navarra', '31180', 'España', 172.43, 0, '2024-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190724-mVgW9ev7YGnwT-157', '30d0843c-e827-4691-ac44-ab47a5b4beb3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-mVgW9ev7YGnwT-157&s=KOL2024&nf=P5051&i=172.43&cr=074', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5394, 1, 1286, 2, 0, NULL, 0, '2024-07-19 08:27:35', '2024-07-19 10:34:14', '2024-07-19', 'P5054', '24-06722-07-19', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'zubiarte 15', 'Huarte/Uharte', 'Navarra', '31620', 'España', 157.64, 0, '2024-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190724-dNX28LAk5RUZQ-204', 'baf4d412-1dcd-4c33-bc5b-fba60ae36c10', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-dNX28LAk5RUZQ-204&s=KOL2024&nf=P5054&i=157.63&cr=189', '[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
(5395, 1, 1336, 2, 0, NULL, 0, '2024-07-19 08:31:30', '2024-07-19 10:36:13', '2024-07-19', 'P5053', '24-06723-07-19', 'Sí no estoy en casa dejar el paquete en la puerta verde ', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Rúa uno Angustia numero84 ', 'Pobra do Caramiñal (', 'A Coruña', '15940', 'España', 43.71, 0, '2024-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190724-lmP2v/Golz5cm-209', 'ed317b0f-bc0c-4724-bca0-21bd989bfc86', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-lmP2v%2FGolz5cm-209&s=KOL2024&nf=P5053&i=43.71&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5396, 1, 40, 2, 0, NULL, 0, '2024-07-19 10:15:58', '2024-07-19 12:41:05', '2024-07-19', 'P5055', '24-06724-07-19', 'dejar el dia 26 viernes por la mañana  otro dia no estoy', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 68.97, 0, '2024-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190724-j0u6QO5w4DUIx-037', '74e39b5f-28f0-4234-830c-015c349ea87f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190724-j0u6QO5w4DUIx-037&s=KOL2024&nf=P5055&i=68.97&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5397, 1, 668, 2, 0, NULL, 0, '2024-07-19 12:28:59', '2024-07-22 09:13:19', '2024-07-22', 'P5056', '24-06725-07-19', 'Llamen primero al número 691404720', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle luna 41', 'Puerto de Santa Marí', 'Cádiz', '11500', 'España', 30.61, 0, '2024-07-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220724-OKXwW6BL4AbKb-101', 'bd8e4715-6d85-48c7-bc84-1a92d7be430c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-OKXwW6BL4AbKb-101&s=KOL2024&nf=P5056&i=30.61&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5398, 1, 686, 2, 0, NULL, 0, '2024-07-19 12:45:38', '2024-07-22 09:15:21', '2024-07-22', 'P5057', '24-06728-07-19', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'calle del parque . Local 3. UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 275.88, 0, '2024-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220724-Z86Af0KQ+MX/g-051', '103f4bea-faf9-447d-9524-f3d64ffcf4e0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-Z86Af0KQ%2BMX%2Fg-051&s=KOL2024&nf=P5057&i=275.88&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5399, 1, 898, 2, 0, NULL, 0, '2024-07-19 12:46:24', '2024-07-22 09:16:58', '2024-07-22', 'P5058', '24-06729-07-19', 'Prefiero que me llegue a la tarde, o a un punto de recogida. A las mañanas no hay nadie en casa.', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'beato tomas de zumarraga nº2 3C', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 43.71, 0, '2024-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220724-X2tT5ZWWai/tf-012', 'e8a2562d-f3ad-4ba3-a3ea-9610a9fecba4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-X2tT5ZWWai%2Ftf-012&s=KOL2024&nf=P5058&i=43.71&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5400, 1, 1282, 2, 0, NULL, 0, '2024-07-20 08:30:08', '2024-07-22 09:24:55', '2024-07-22', 'P5059', '24-06734-07-20', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'somocuevas 5, numero 39', 'Piélagos', 'Cantabria', '39120', 'España', 78.63, 0, '2024-07-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220724-Nc4D9RXe3TaAP-000', '4ff1b2e3-90bc-4306-88d8-84fdeccd5dfc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-Nc4D9RXe3TaAP-000&s=KOL2024&nf=P5059&i=78.63&cr=206', '[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
(5401, 1, 1206, 2, 0, NULL, 0, '2024-07-20 09:47:55', '2024-07-22 09:26:23', '2024-07-22', 'P5060', '24-06735-07-20', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'ainhoarz93@gmail.com', 'Arbizu', 'Navarra', '31839', 'España', 43.71, 0, '2024-07-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220724-Pt4iLXYSgPytA-046', 'bf1896de-7da8-4d0a-8fb8-6fb2b7a6b1c4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-Pt4iLXYSgPytA-046&s=KOL2024&nf=P5060&i=43.71&cr=229', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5402, 1, 241, 2, 0, NULL, 0, '2024-07-20 10:28:14', '2024-07-22 09:28:38', '2024-07-22', 'P5061', '24-06737-07-20', '', 0.00, 154.66, 32.48, 0.00, 1, 8.04, 0.00, 'Morales Hidalgo 4 ( tienda Arume Nature)', 'Ponteareas', 'Pontevedra', '36860', 'España', 195.18, 0, '2024-07-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220724-ZMo+Kbn/7LP3k-199', 'b95844c4-f7bd-4988-93c3-3d78eb751117', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-ZMo%2BKbn%2F7LP3k-199&s=KOL2024&nf=P5061&i=195.18&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5403, 1, 91, 2, 0, NULL, 0, '2024-07-20 16:02:03', '2024-07-22 09:32:13', '2024-07-22', 'P5062', '24-06739-07-20', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 310.37, 0, '2024-07-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220724-T8aNQwVBc2+b+-055', '2760ed8a-cf4f-473c-a115-872572ce06b5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-T8aNQwVBc2%2Bb%2B-055&s=KOL2024&nf=P5062&i=310.37&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5404, 1, 782, 2, 0, NULL, 0, '2024-07-20 19:11:52', '2024-07-22 09:34:49', '2024-07-22', 'P5063', '24-06741-07-20', 'Llamar antes de hacer entrega.\r\nJunto a tien 21 y antigua Caixa', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Ronda Intermedia 2 puerta 26', 'Antequera', 'Málaga', '29200', 'España', 28.39, 0, '2024-07-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220724-SaiSZd8srIvCv-239', 'd55569c2-06be-49ac-94f1-424d2eccf7d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-SaiSZd8srIvCv-239&s=KOL2024&nf=P5063&i=28.39&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5405, 1, 1337, 2, 0, NULL, 0, '2024-07-20 20:41:29', '2024-07-22 09:39:36', '2024-07-22', 'P5064', '24-06742-07-20', 'Si no se encuentra dejar en porteria', 0.00, 72.15, 15.15, 0.00, 0, 0.00, 0.00, 'Avda Santuario de Valverde 53 portal B ático B', 'Madrid', 'Madrid', '28049', 'España', 87.30, 0, '2024-07-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220724-KeWIc9ZObxFRd-040', '488ccdb3-11be-4060-a5ed-361cd85f2f56', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-KeWIc9ZObxFRd-040&s=KOL2024&nf=P5064&i=87.30&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5406, 1, 340, 2, 0, NULL, 0, '2024-07-21 08:56:31', '2024-07-22 09:43:48', '2024-07-22', 'P5065', '24-06746-07-21', 'horario entrega 9.30 a 1.30 t 4.30 a 7.30 lunes martes jueves y viernes \r\nmiercoles cerrado', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'juan carlos 1 17, 17', 'Sesma', 'Navarra', '31293', 'España', 206.91, 0, '2024-07-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220724-Qa0S1njl3Z+GA-199', '6e035002-044c-4cad-ac88-f733ba2358ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-Qa0S1njl3Z%2BGA-199&s=KOL2024&nf=P5065&i=206.91&cr=194', '[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
(5407, 1, 754, 2, 0, NULL, 0, '2024-07-21 10:24:49', '2024-07-22 09:47:32', '2024-07-22', 'P5066', '24-06747-07-21', '6+1 regalo Rubio Arena', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-07-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220724-fx1rCmVeXpYwP-105', 'b824af91-b26e-4aab-a184-df0c79744cf9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-fx1rCmVeXpYwP-105&s=KOL2024&nf=P5066&i=61.64&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5408, 1, 1338, 2, 0, NULL, 0, '2024-07-21 12:31:04', '2024-07-22 09:50:28', '2024-07-22', 'P5067', '24-06748-07-21', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/montserrat,28 2A', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 17.50, 0, '2024-07-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220724-W1f82+WhcuKaQ-130', '5d7bae9b-42e8-4a1b-8ab3-3a6bca9c67dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-W1f82%2BWhcuKaQ-130&s=KOL2024&nf=P5067&i=17.50&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5409, 1, 1339, 2, 0, NULL, 0, '2024-07-22 08:14:11', '2024-07-22 10:35:39', '2024-07-22', 'P5068', '24-06749-07-22', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Murubide 5 - 3 A', 'Aretxabaleta', 'Gipuzkoa', '20550', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220724-nopibsCSxgfSI-009', 'a22e4ff1-154d-43a7-b95f-f6b89ccac314', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220724-nopibsCSxgfSI-009&s=KOL2024&nf=P5068&i=17.50&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5410, 1, 99, 2, 0, NULL, 0, '2024-07-22 16:05:06', '2024-07-23 09:58:43', '2024-07-23', 'P5069', '24-06750-07-22', 'Solo entregar por la mañana ', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Calle Iñigo arista 19 Trasera ', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 310.37, 0, '2024-07-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230724-Vc81SrmAwP/jI-050', '6f9bbb9a-acec-42f6-8899-7b6e5884602f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230724-Vc81SrmAwP%2FjI-050&s=KOL2024&nf=P5069&i=310.37&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5411, 1, 28, 2, 0, NULL, 0, '2024-07-22 16:26:44', '2024-07-23 10:05:42', '2024-07-23', 'P5070', '24-06751-07-22', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 103.46, 0, '2024-07-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230724-RDkRZ2Wz9L8cJ-233', '6d5cde92-b0de-431e-a0cf-c49e8381b319', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230724-RDkRZ2Wz9L8cJ-233&s=KOL2024&nf=P5070&i=103.46&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5412, 1, 28, 2, 0, NULL, 0, '2024-07-22 16:36:37', '2024-07-23 10:06:24', '2024-07-23', 'P5071', '24-06753-07-22', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 103.46, 0, '2024-07-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230724-mrWvnZsBQrxAh-179', 'c753f848-2b58-495b-b738-f47ad9a154cf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230724-mrWvnZsBQrxAh-179&s=KOL2024&nf=P5071&i=103.46&cr=219', '[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
(5413, 1, 566, 2, 0, NULL, 0, '2024-07-22 17:47:50', '2024-07-23 10:08:36', '2024-07-23', 'P5073', '24-06754-07-22', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230724-mH/SCqWFdMnEc-102', 'eee32ac4-23c7-4fae-ae7c-9e09f734d8bb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230724-mH%2FSCqWFdMnEc-102&s=KOL2024&nf=P5073&i=413.82&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5414, 1, 1340, 2, 0, NULL, 0, '2024-07-22 18:01:34', '2024-07-23 10:10:30', '2024-07-23', 'P5072', '24-06755-07-22', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Avda. Vega de acá 115, 2E', 'Almería', 'Almería', '04007', 'España', 43.71, 0, '2024-07-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230724-gWFzpyLucQMib-212', 'f3e273cb-6f0f-4648-b8ae-dfdc0daed1d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230724-gWFzpyLucQMib-212&s=KOL2024&nf=P5072&i=43.71&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5415, 1, 870, 2, 0, NULL, 0, '2024-07-22 20:09:36', '2024-07-23 10:14:17', '2024-07-23', 'P5074', '24-06756-07-22', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Calle López de Aranda 24', 'Madrid', 'Madrid', '28027', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-230724-P/tmV1T8WXkmR-212', '94ccd276-be3b-408c-9699-d33b1a55eb73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230724-P%2FtmV1T8WXkmR-212&s=KOL2024&nf=P5074&i=71.47&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5416, 1, 166, 1, 0, NULL, 0, '2024-07-23 11:27:52', '2024-07-23 11:27:52', '2024-07-23', 'P5075', '', '', 0.00, 141.57, 29.73, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 171.30, 0, '2024-07-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230724-Qf19SFfUGlUm6-210', '7df2c4c7-7aac-422a-9e33-039234a2799d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230724-Qf19SFfUGlUm6-210&s=KOL2024&nf=P5075&i=171.30&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5417, 1, 259, 2, 0, NULL, 0, '2024-07-23 09:57:06', '2024-07-23 12:00:44', '2024-07-23', 'P5076', '24-06757-07-23', 'AVISAR con antelacion al tel.680750573 y entregar de 9.00 a 13:00h.', 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, '2024-07-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230724-OOYsPWIDlfnNy-002', '3f49004f-e711-42a0-8c74-f7bafe1563f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230724-OOYsPWIDlfnNy-002&s=KOL2024&nf=P5076&i=275.88&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5418, 1, 355, 2, 0, NULL, 0, '2024-07-23 11:42:55', '2024-07-24 09:56:59', '2024-07-24', 'P5077', '24-06758-07-23', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Sebastian Fernandez de Leceta 10 7 Izqd', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 61.09, 0, '2024-07-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-HYep31nIOLp74-170', '175e2ffb-5ee5-40ef-b6ab-f466f2b3452f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-HYep31nIOLp74-170&s=KOL2024&nf=P5077&i=61.09&cr=255', '[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
(5419, 1, 155, 2, 0, NULL, 0, '2024-07-23 12:54:29', '2024-07-24 10:01:15', '2024-07-24', 'P5078', '24-06759-07-23', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 379.34, 0, '2024-07-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240724-CPMkVfw4OaElR-108', 'a0935423-4381-45c4-86a7-7ab6610615ee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-CPMkVfw4OaElR-108&s=KOL2024&nf=P5078&i=379.34&cr=158', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5420, 1, 689, 2, 0, NULL, 0, '2024-07-23 14:38:08', '2024-07-24 10:09:08', '2024-07-24', 'P5079', '24-06760-07-23', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Dr Espinosa Oribe 19 bajo', 'Bilbao', 'Bizkaia', '48003', 'España', 78.63, 0, '2024-07-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240724-fuF6VK3G8B3Qr-173', '568aab5d-325c-451c-a87e-370b484fe119', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-fuF6VK3G8B3Qr-173&s=KOL2024&nf=P5079&i=78.63&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5421, 1, 776, 2, 0, NULL, 0, '2024-07-23 15:39:52', '2024-07-24 10:09:33', '2024-07-24', 'P5080', '24-06762-07-23', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Miguel Astrain 18 10°C', 'Pamplona/Iruña', 'Navarra', '31006', 'España', 17.50, 0, '2024-07-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-VYa7DFi5dN0xv-101', '46979107-b326-473e-91e4-24b34732b25a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-VYa7DFi5dN0xv-101&s=KOL2024&nf=P5080&i=17.50&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5422, 1, 120, 2, 0, NULL, 0, '2024-07-23 15:47:48', '2024-07-24 10:12:17', '2024-07-24', 'P5081', '24-06763-07-23', '', 0.00, 244.28, 51.30, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 295.58, 0, '2024-07-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-Un1NYxCA4Eq46-200', 'eb1be9fd-2cc5-4cbb-944b-7ea2acb7769c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-Un1NYxCA4Eq46-200&s=KOL2024&nf=P5081&i=295.58&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5423, 1, 1130, 2, 0, NULL, 0, '2024-07-23 18:40:46', '2024-07-24 10:13:48', '2024-07-24', 'P5082', '24-06764-07-23', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'C/ Ulises, 4', 'Mairena del Aljarafe', 'Sevilla', '41927', 'España', 56.82, 0, '2024-07-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240724-h5+gF2EY5QGFz-248', '5cab1c9e-5664-4a8a-aefd-ceffdfd0c301', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-h5%2BgF2EY5QGFz-248&s=KOL2024&nf=P5082&i=56.82&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5424, 1, 23, 2, 0, NULL, 0, '2024-07-24 06:21:40', '2024-07-24 10:15:53', '2024-07-24', 'P5083', '24-06765-07-24', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 103.46, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-K9RtnUPl+JY9A-054', '9b9057da-8f29-49c0-9b2b-4582e4638db0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-K9RtnUPl%2BJY9A-054&s=KOL2024&nf=P5083&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);
