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
(5983, 1, 1485, 2, 0, NULL, 0, '2024-10-25 08:00:35', '2024-10-25 11:08:15', '2024-10-25', 'P5617', '24-07380-10-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Urbanización Ammonites 9, 1-D', 'Santa Cruz de Bezana', 'Cantabria', '39110', 'España', 30.61, 0, '2024-10-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-251024-HK1vBxGid97QR-198', '72552aa4-5e9d-480b-b598-ed592408dc17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251024-HK1vBxGid97QR-198&s=KOL2024&nf=P5617&i=30.61&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5984, 1, 896, 1, 0, NULL, 0, '2024-10-25 11:55:36', '2024-10-25 11:55:36', '2024-10-25', 'P5618', '', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Marrutxipi 24', 'Donostia-San Sebasti', 'Gipuzkoa', '20013', 'España', 34.48, 0, '2024-10-25 00:00:00', '', '', 3, 6, 1, 'TBAI-B20930640-251024-LDNmahhakfPIM-080', '9205d81a-8541-4286-acb8-078ace883595', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251024-LDNmahhakfPIM-080&s=KOL2024&nf=P5618&i=34.47&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5985, 1, 1442, 2, 0, NULL, 0, '2024-10-25 14:08:23', '2024-10-28 09:10:34', '2024-10-28', 'P5619', '24-07381-10-25', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avenida de la flota n3 1B ', 'Murcia', 'Murcia', '30008', 'España', 28.39, 0, '2024-10-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281024-CWAsYcpeSoIX+-162', 'f47c335f-1ae3-421d-93e1-36af1ee74154', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-CWAsYcpeSoIX%2B-162&s=KOL2024&nf=P5619&i=28.39&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5986, 1, 1486, 2, 0, NULL, 0, '2024-10-25 16:57:50', '2024-10-28 09:11:14', '2024-10-28', 'P5620', '24-07382-10-25', '', 0.00, 19.83, 5.68, 0.00, 0, 0.00, 8.76, 'valencia 7, 1º', 'Manacor', 'Baleares (Illes)', '07500', 'España', 32.75, 0, '2024-10-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281024-PjFUO95v11qC4-051', '37daaa06-8143-4e0a-ad40-242fb6acfe3c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-PjFUO95v11qC4-051&s=KOL2024&nf=P5620&i=32.75&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5987, 1, 1293, 2, 0, NULL, 0, '2024-10-25 21:16:21', '2024-10-28 09:11:54', '2024-10-28', 'P5621', '24-07383-10-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida Ocho de marzo 29 2°A ', 'Vitoria-Gasteiz', 'Álava', '01002', 'España', 30.61, 0, '2024-10-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-281024-VqSg+xQdyaB3b-174', '4b60e009-b3bf-4b6f-8aaa-22306a31b9e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-VqSg%2BxQdyaB3b-174&s=KOL2024&nf=P5621&i=30.61&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5988, 1, 1487, 2, 0, NULL, 0, '2024-10-25 21:25:30', '2024-10-28 09:12:54', '2024-10-28', 'P5622', '24-07384-10-25', 'Si no me encuentro en el domicilio, entregar al portero', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Don Ramon de la Cruz 88 escalera 2, 3C', 'Madrid', 'Madrid', '28006', 'España', 17.50, 0, '2024-10-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-281024-CUA9GvLPOUUXo-006', '5b33a3c1-ffa8-42fa-8e4e-46a4a8f3010d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-CUA9GvLPOUUXo-006&s=KOL2024&nf=P5622&i=17.50&cr=067', '[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
(5989, 1, 53, 2, 0, NULL, 0, '2024-10-26 07:57:33', '2024-10-28 09:14:01', '2024-10-28', 'P5628', '24-07385-10-26', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-281024-gW/w19Capuhad-129', 'e0eabe29-7166-41a9-a6fd-1972bb4820af', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-gW%2Fw19Capuhad-129&s=KOL2024&nf=P5628&i=105.96&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5990, 1, 236, 2, 0, NULL, 0, '2024-10-26 09:35:36', '2024-10-28 09:14:41', '2024-10-28', 'P5623', '24-07386-10-26', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'AVDA. DE LA POLICÍA NACIONAL, EDF. DONI IVES, 24', 'Antequera', 'Málaga', '29200', 'España', 206.91, 0, '2024-10-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281024-UBQNy53Uo2SST-115', 'ff0dc575-5390-4fd2-b4ca-4c2ac9057100', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-UBQNy53Uo2SST-115&s=KOL2024&nf=P5623&i=206.91&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5991, 1, 1488, 2, 0, NULL, 0, '2024-10-26 11:41:33', '2024-10-28 09:16:27', '2024-10-28', 'P5624', '24-07388-10-26', 'POR FAVOR, AVISAR TELEFONICAMENTE ANTES DE LA ENTREGA.', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'URB. EL MONTICO. PARCELA 159', 'Tordesillas', 'Valladolid', '47100', 'España', 65.52, 0, '2024-10-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281024-eEzDVNPYFq/Kp-027', '7d0008ea-c98f-4f84-aeca-f9b2cdeec07c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-eEzDVNPYFq%2FKp-027&s=KOL2024&nf=P5624&i=65.52&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5992, 1, 1489, 2, 0, NULL, 0, '2024-10-26 12:17:02', '2024-10-28 09:17:37', '2024-10-28', 'P5625', '24-07389-10-26', 'Entrega de lunes a viernes en horario de oficina ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer Ravella 10 ', 'Barcelona', 'Barcelona', '08021', 'España', 30.61, 0, '2024-10-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281024-JwzCuED3qe8jm-221', '1bc43693-a53c-4344-bd35-c751e4959f98', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-JwzCuED3qe8jm-221&s=KOL2024&nf=P5625&i=30.61&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5993, 1, 1263, 2, 0, NULL, 0, '2024-10-26 14:03:10', '2024-10-28 09:18:14', '2024-10-28', 'P5626', '24-07390-10-26', 'Pueden dejar el paquete en la puerta de casa, en caso de que no haya nadie. ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'sagardia 41', 'Urdiain', 'Navarra', '31810', 'España', 28.39, 0, '2024-10-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281024-WPviB5H349LUJ-053', '77525e1e-1c14-4339-bb1c-1a3c9c20648e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-WPviB5H349LUJ-053&s=KOL2024&nf=P5626&i=28.39&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5994, 1, 1490, 2, 0, NULL, 0, '2024-10-27 11:57:10', '2024-10-28 09:18:50', '2024-10-28', 'P5627', '24-07391-10-27', 'Direccion de lugar de trabajo de mi pareja. a Nombre de Jose Ignacio Rodriguez Carracedo.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Ezurriki Kalea 14. POLIGONO ARRECHE UGALDE', 'Irun', 'Gipuzkoa', '20305', 'España', 28.39, 0, '2024-10-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-281024-J5NTHJrQKezZO-016', '5904e97b-302a-4852-9db2-2de6802d9db2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281024-J5NTHJrQKezZO-016&s=KOL2024&nf=P5627&i=28.39&cr=151', '[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
(5995, 1, 1491, 2, 0, NULL, 0, '2024-10-28 16:39:48', '2024-10-29 09:02:07', '2024-10-29', 'P5631', '24-07392-10-28', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Rivero,2-San Claudio', 'Oviedo', 'Asturias', '33191', 'España', 17.50, 0, '2024-10-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-291024-EegOFEqkJZSG4-150', '6c841beb-7b9a-4e5f-96fb-8f70f9fdf338', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291024-EegOFEqkJZSG4-150&s=KOL2024&nf=P5631&i=17.50&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5996, 1, 1492, 2, 0, NULL, 0, '2024-10-28 16:50:55', '2024-10-29 09:05:08', '2024-10-29', 'P5629', '24-07393-10-28', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Concepción arenal 10 4c ', 'Guarda (A)', 'Pontevedra', '36780', 'España', 17.50, 0, '2024-10-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291024-KQK5AKOHL5a3I-230', 'a29239f7-8062-4cdf-8dc3-fd137dd963c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291024-KQK5AKOHL5a3I-230&s=KOL2024&nf=P5629&i=17.50&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5997, 1, 1493, 2, 0, NULL, 0, '2024-10-28 20:47:49', '2024-10-29 09:07:08', '2024-10-29', 'P5630', '24-07394-10-28', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ Doctor Juan Nicolás Márquez, 9 Portal 2 5B', 'Huelva', 'Huelva', '21005', 'España', 28.39, 0, '2024-10-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-291024-UwP5Msw4MUfrL-049', 'c2072ddb-3b8f-4d3c-af3a-07c8e5943e31', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291024-UwP5Msw4MUfrL-049&s=KOL2024&nf=P5630&i=28.39&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5998, 1, 25, 2, 0, NULL, 0, '2024-10-29 08:03:40', '2024-10-29 09:09:42', '2024-10-29', 'P5632', '24-07396-10-29', '', 0.00, 28.50, 6.75, 0.00, 0, 0.00, 4.40, 'araba kalea 1 bajo 20240 ordizia ', 'Ordizia', 'Gipuzkoa', '20240', 'España', 38.89, 0, '2024-10-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291024-HChBFf+sRnKuS-041', '2e4236db-2c72-47e1-a7e7-53a139f73e36', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291024-HChBFf%2BsRnKuS-041&s=KOL2024&nf=P5632&i=38.89&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5999, 1, 23, 2, 0, NULL, 0, '2024-10-29 12:05:57', '2024-10-29 13:08:14', '2024-10-29', 'P5633', '24-07397-10-29', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 172.43, 0, '2024-10-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291024-IvW4ST+ZFja8z-118', '1b3517f8-cd8d-4cb0-9cb2-2f3c92c6a6fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291024-IvW4ST%2BZFja8z-118&s=KOL2024&nf=P5633&i=172.43&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6000, 1, 1494, 2, 0, NULL, 0, '2024-10-29 13:59:24', '2024-10-30 08:59:34', '2024-10-30', 'P5634', '24-07398-10-29', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'c/La Noguera nº31', 'Font-rubí', 'Barcelona', '08736', 'España', 43.71, 0, '2024-10-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301024-eAmYUfSFE5J5L-215', 'a66608da-0be2-4ae3-a814-ec65a8007798', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301024-eAmYUfSFE5J5L-215&s=KOL2024&nf=P5634&i=43.71&cr=140', '[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
(6001, 1, 28, 2, 0, NULL, 0, '2024-10-29 15:22:18', '2024-10-30 09:02:00', '2024-10-30', 'P5635', '24-07399-10-29', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, '01008, 8 Bajo', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 172.43, 0, '2024-10-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-301024-d5IHRgv4/DUEr-148', '5b87e92a-9b53-436f-ab7c-bf624f5666f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301024-d5IHRgv4%2FDUEr-148&s=KOL2024&nf=P5635&i=172.43&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6002, 1, 1495, 2, 0, NULL, 0, '2024-10-29 16:46:14', '2024-10-30 09:03:11', '2024-10-30', 'P5636', '24-07400-10-29', 'Local tienda.  \"ALEGRIA\"', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Manuel de sandobal 10', 'Córdoba', 'Córdoba', '14008', 'España', 17.50, 0, '2024-10-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301024-d/Gd5A20lVIUl-238', 'cee31e29-ef0e-471b-9ee9-d03991c9e66c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301024-d%2FGd5A20lVIUl-238&s=KOL2024&nf=P5636&i=17.50&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6003, 1, 754, 2, 0, NULL, 0, '2024-10-29 17:15:32', '2024-10-30 09:06:41', '2024-10-30', 'P5637', '24-07401-10-29', '6+1 GRATIS. COLOR ARENA.\r\nGRACIAS ', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradelles 166 2°1°', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-10-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301024-DMVdhhpf/YJ9+-233', '741c1281-1fc5-4912-a443-9c5963405ec5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301024-DMVdhhpf%2FYJ9%2B-233&s=KOL2024&nf=P5637&i=61.64&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6004, 1, 1496, 2, 0, NULL, 0, '2024-10-30 08:55:42', '2024-10-30 10:01:19', '2024-10-30', 'P5638', '24-07402-10-30', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Calle Gordoniz 64, 3 izquierda ', 'Bilbao', 'Bizkaia', '48002', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-301024-MhVYr8VSFHAKY-000', '9f6e98a2-ada4-4b63-b44f-699f245fea9b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301024-MhVYr8VSFHAKY-000&s=KOL2024&nf=P5638&i=20.00&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6005, 1, 154, 2, 0, NULL, 0, '2024-10-30 09:01:43', '2024-10-30 10:04:21', '2024-10-30', 'P5639', '24-07403-10-30', 'entregar a partir de las 11:00', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 206.91, 0, '2024-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301024-PFS3Ji1JURc8g-246', '0715dc73-191c-436e-9221-d3fd127554a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301024-PFS3Ji1JURc8g-246&s=KOL2024&nf=P5639&i=206.91&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6006, 1, 77, 1, 0, NULL, 0, '2024-10-30 12:11:33', '2024-10-30 13:00:40', '2024-10-30', 'P5640', '', '', 0.00, 836.55, 175.68, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1012.23, 0, '2024-10-30 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-301024-Jr2moLraub9y3-213', '8613aadc-e7b2-4f62-b3a9-488998a2d6ba', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301024-Jr2moLraub9y3-213&s=KOL2024&nf=P5640&i=1012.23&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6007, 1, 190, 3, 0, NULL, 0, '2024-10-30 13:42:05', '2024-11-14 08:21:01', '2024-10-30', '', 'Consumo interno', '', 0.00, 2523.82, 530.00, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 3053.82, 0, '2024-10-30 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);
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
(6008, 1, 754, 2, 0, NULL, 0, '2024-10-30 16:06:05', '2024-10-31 08:17:47', '2024-10-31', 'P5641', '24-07404-10-30', '6+1 GRATIS CASTAÑO CLARO\r\nGRACIAS', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellaas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-311024-daa6RSd0ctUPn-105', '838938e3-141e-46e4-a1ed-8f4ce7bbd198', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311024-daa6RSd0ctUPn-105&s=KOL2024&nf=P5641&i=61.64&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6009, 1, 979, 2, 0, NULL, 0, '2024-10-30 16:17:32', '2024-10-31 08:20:52', '2024-10-31', 'P5643', '24-07405-10-30', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'calle palma 58 local 1', 'Madrid', 'Madrid', '28015', 'España', 551.76, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-311024-gLucG6wSiMfs2-205', 'a0edb8ff-f45b-4f94-a467-1efe4de9759f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311024-gLucG6wSiMfs2-205&s=KOL2024&nf=P5643&i=551.76&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6010, 1, 1497, 2, 0, NULL, 0, '2024-10-30 16:22:43', '2024-10-31 08:31:00', '2024-10-31', 'P5644', '24-07406-10-30', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Carrer Avenir 67', 'Barcelona', 'Barcelona', '08021', 'España', 28.39, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-311024-d5hh6gCsn5pO2-240', 'c87919a5-becf-4ce2-a0d7-fe2e6165032c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311024-d5hh6gCsn5pO2-240&s=KOL2024&nf=P5644&i=28.39&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6011, 1, 784, 2, 0, NULL, 0, '2024-10-30 19:27:18', '2024-10-31 08:31:39', '2024-10-31', 'P5642', '24-07407-10-30', '', 0.00, 73.28, 15.39, 0.00, 1, 3.81, 0.00, 'Calle san francisco 30 bis bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20002', 'España', 92.48, 0, '2024-10-30 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-311024-S6PjvczBjnB6e-118', '30f57306-0c33-4583-8d14-ca3dda02048f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311024-S6PjvczBjnB6e-118&s=KOL2024&nf=P5642&i=92.48&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6012, 1, 4, 2, 0, NULL, 0, '2024-10-31 09:36:43', '2024-10-31 11:04:24', '2024-10-31', 'P5645', '24-07408-10-31', '', 0.00, 187.28, 39.33, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 226.61, 0, '2024-10-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-311024-QB+LurGq7dSTN-040', 'a1bf16a1-b508-4822-964a-6e28bf0cd21c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311024-QB%2BLurGq7dSTN-040&s=KOL2024&nf=P5645&i=226.61&cr=212', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6013, 1, 1327, 1, 0, NULL, 0, '2024-10-31 13:15:34', '2024-10-31 13:15:34', '2024-10-31', 'P5646', '2024-10-31', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Ilargi plaza 2, baxua', 'Aretxabaleta', 'Gipuzkoa', '20550', '', 68.97, 0, '2024-10-31 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-311024-Yewn8lC8whk+U-018', '1187ffcc-a7cf-4be2-ab9e-d9d95352e7a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311024-Yewn8lC8whk%2BU-018&s=KOL2024&nf=P5646&i=68.97&cr=222', '[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
(6014, 1, 1498, 2, 0, NULL, 0, '2024-11-01 00:19:10', '2024-11-04 08:40:09', '2024-11-04', 'P5647', '24-07410-11-01', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'O picoto 19 AREAS', 'Ponteareas', 'Pontevedra', '36861', 'España', 28.39, 0, '2024-11-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-041124-Fz4ZLUnbilSSm-065', 'c12bdfd3-8f20-49db-af27-0fac0ea497fd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-Fz4ZLUnbilSSm-065&s=KOL2024&nf=P5647&i=28.39&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6015, 1, 1499, 2, 0, NULL, 0, '2024-11-01 09:06:22', '2024-11-04 08:42:26', '2024-11-04', 'P5648', '24-07411-11-01', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Carrer Sallarès i Pla, 142, 3º 1ª', 'Sabadell', 'Barcelona', '08202', 'España', 28.39, 0, '2024-11-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-SVY0fhj/3mLrn-204', '2f7d859c-853b-4d15-8eff-13ef4bf0b2b5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-SVY0fhj%2F3mLrn-204&s=KOL2024&nf=P5648&i=28.39&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6016, 1, 576, 2, 0, NULL, 0, '2024-11-01 16:33:55', '2024-11-04 08:45:01', '2024-11-04', 'P5649', '24-07412-11-01', 'En caso de no estar en el domicilio dejar en portería gracias. ', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle silicio n° 32 , 1° D escalera derecha ', 'Torrejón de Ardoz', 'Madrid', '28850', 'España', 56.82, 0, '2024-11-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-aqQYljxry9QQT-007', '9d3b7fcf-ca85-4f6c-b898-88d7a8276714', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-aqQYljxry9QQT-007&s=KOL2024&nf=P5649&i=56.82&cr=119', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6017, 1, 337, 2, 0, NULL, 0, '2024-11-02 09:23:12', '2024-11-04 08:46:27', '2024-11-04', 'P5656', '24-07413-11-02', '', 0.00, 56.98, 11.97, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 68.95, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-041124-QtwmIoKD4Cegj-104', '543a51df-6e99-4f42-942e-8dbef80960d4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-QtwmIoKD4Cegj-104&s=KOL2024&nf=P5656&i=68.95&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6018, 1, 1500, 2, 0, NULL, 0, '2024-11-03 12:36:21', '2024-11-04 08:48:05', '2024-11-04', 'P5650', '24-07415-11-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Toledo 74 ', 'Burujón', 'Toledo', '45521', 'España', 17.50, 0, '2024-11-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-E2SUA5ifOZyne-108', '1649bdd2-f84b-4bdd-8ae0-3e63f6731879', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-E2SUA5ifOZyne-108&s=KOL2024&nf=P5650&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),
(6019, 1, 1501, 2, 0, NULL, 0, '2024-11-03 17:44:14', '2024-11-04 08:50:22', '2024-11-04', 'P5651', '24-07416-11-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paseo Ubarburu, 83 planta 1', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 30.61, 0, '2024-11-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-ardxgYVXHx6U1-172', 'ae9a3160-af5b-4772-b708-fdc28c391957', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-ardxgYVXHx6U1-172&s=KOL2024&nf=P5651&i=30.61&cr=018', '[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
(6020, 1, 1434, 2, 0, NULL, 0, '2024-11-03 18:29:07', '2024-11-04 08:52:20', '2024-11-04', 'P5652', '24-07417-11-03', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Avda. Gotarra num. 4 Bajos 1A', 'Llagostera', 'Girona', '17240', 'España', 65.52, 0, '2024-11-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-041124-WLcsPJuyveVIV-191', '5b3bfad1-2ccf-4843-9f92-68988bc7e438', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-WLcsPJuyveVIV-191&s=KOL2024&nf=P5652&i=65.52&cr=252', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6021, 1, 1502, 2, 0, NULL, 0, '2024-11-03 20:52:34', '2024-11-04 08:54:35', '2024-11-04', 'P5653', '24-07419-11-03', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle colibrí nº 6', 'Tres Cantos', 'Madrid', '28760', 'España', 28.39, 0, '2024-11-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-KwG7/BUZpmMyK-060', '317df975-1dc8-4639-b5b6-345cbc92961d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-KwG7%2FBUZpmMyK-060&s=KOL2024&nf=P5653&i=28.39&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6022, 1, 1503, 2, 0, NULL, 0, '2024-11-03 21:18:05', '2024-11-04 08:56:58', '2024-11-04', 'P5654', '24-07420-11-03', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/Alejandro de la Sota nº2 portal 4 Bajo B', 'Boadilla del Monte', 'Madrid', '28660', 'España', 28.39, 0, '2024-11-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-GQqPRq/NyGjMR-221', '13e46840-5725-47d7-94cf-a514129a9a92', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-GQqPRq%2FNyGjMR-221&s=KOL2024&nf=P5654&i=28.39&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6023, 1, 1504, 2, 0, NULL, 0, '2024-11-03 22:19:15', '2024-11-04 08:59:28', '2024-11-04', 'P5655', '24-07421-11-03', '', 0.00, 21.66, 6.07, 0.00, 0, 0.00, 8.76, 'Calle Pérez Muñoz, 112, ', 'Palmas de Gran Canar', 'Las Palmas', '35009', 'España', 34.97, 0, '2024-11-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-FGuCtDCY7AUK9-147', 'dba1c3f6-3275-4940-9b45-420d53c77f2a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-FGuCtDCY7AUK9-147&s=KOL2024&nf=P5655&i=34.97&cr=089', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6024, 1, 592, 2, 0, NULL, 0, '2024-11-04 07:57:25', '2024-11-04 09:10:21', '2024-11-04', 'P5658', '24-07422-11-04', 'Llamar antes de entrega', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Silva 17. 3-D', 'Madrid', 'Madrid', '28004', 'España', 17.50, 0, '2024-11-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-UYDXQ6V0eQDBD-231', 'cf8b9185-751f-44eb-a5aa-d2c991a69447', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-UYDXQ6V0eQDBD-231&s=KOL2024&nf=P5658&i=17.50&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6025, 1, 522, 2, 0, NULL, 0, '2024-11-04 08:07:32', '2024-11-04 09:13:08', '2024-11-04', 'P5657', '24-07423-11-04', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 172.43, 0, '2024-11-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-fuo/G0aQpioZx-090', 'f3e3d7d0-0ba1-4476-a009-0dbc68e854c8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-fuo%2FG0aQpioZx-090&s=KOL2024&nf=P5657&i=172.43&cr=101', '[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
(6026, 1, 1505, 2, 0, NULL, 0, '2024-11-04 09:31:29', '2024-11-04 10:58:09', '2024-11-04', 'P5659', '24-07424-11-04', 'También se puede entrar en la peluquería de al lado ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Levante, 8 Gea y Truyols', 'Murcia', 'Murcia', '30590', 'España', 17.50, 0, '2024-11-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-Z/WotebwB2B9N-035', 'f0e90fb6-ac21-48c0-a3ff-f6237455a2f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-Z%2FWotebwB2B9N-035&s=KOL2024&nf=P5659&i=17.50&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6027, 1, 754, 2, 0, NULL, 0, '2024-11-04 10:57:00', '2024-11-04 12:13:56', '2024-11-04', 'P5660', '24-07425-11-04', '6+1 REGALO castaño\r\ngracias', 0.00, 56.98, 11.97, 0.00, 1, 2.96, 0.00, 'Josep tarradelals 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 71.91, 0, '2024-11-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-KWfVHIvjxFEMz-182', '0c1ac159-8c2e-434c-9b94-abfb212f6ff1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-KWfVHIvjxFEMz-182&s=KOL2024&nf=P5660&i=71.91&cr=040', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(6028, 1, 1506, 2, 0, NULL, 0, '2024-11-04 11:02:12', '2024-11-04 12:18:32', '2024-11-04', 'P5661', '24-07426-11-04', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Zuberoa 16 5D', 'Galdakao', 'Bizkaia', '48960', 'España', 43.71, 0, '2024-11-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-041124-Ddvaug91QOYpH-075', '52502a17-0102-4429-845f-91b2b058d132', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-Ddvaug91QOYpH-075&s=KOL2024&nf=P5661&i=43.71&cr=160', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6029, 1, 754, 2, 1, 'se le ha cobrado un producto que va sin coste', 6027, '2024-11-04 12:15:04', '2024-11-04 12:15:04', '2024-11-04', 'R92', 'P5660 RECT.', '6+1 REGALO castaño\r\ngracias', 0.00, 56.98, 11.97, 0.00, 0, 2.96, 0.00, '', '', '', '', '', 71.91, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6030, 1, 754, 1, 0, NULL, 0, '2024-11-04 12:17:10', '2024-11-04 12:17:10', '2024-11-04', 'P5662', '', '', 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-11-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-RKCygxKw5K3Uy-057', '9bd2896f-231c-4c24-a248-3fdfa5ff4843', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-RKCygxKw5K3Uy-057&s=KOL2024&nf=P5662&i=61.64&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6031, 1, 615, 2, 0, NULL, 0, '2024-11-04 14:58:41', '2024-11-04 16:31:49', '2024-11-04', 'P5663', '24-07427-11-04', 'Llamar antes de la entrga', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'San Martin, 2', 'Atez', 'Navarra', '31193', 'España', 78.63, 0, '2024-11-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041124-G2x6r9fKooWT2-140', '4c747b74-7fc7-43d7-9604-e5dc35a0b3a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041124-G2x6r9fKooWT2-140&s=KOL2024&nf=P5663&i=78.63&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6032, 1, 1507, 2, 0, NULL, 0, '2024-11-04 21:08:46', '2024-11-05 08:31:17', '2024-11-05', 'P5664', '24-07430-11-04', 'Entregar al portero si no estoy en casa. Gracias ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Plaza Arteijo 8,12-4', 'Madrid', 'Madrid', '28029', 'España', 28.39, 0, '2024-11-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051124-cQ/ixLDaYx/Im-151', '4cfd3b3f-a4ae-4098-a41f-b92ffc4bbad8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-cQ%2FixLDaYx%2FIm-151&s=KOL2024&nf=P5664&i=28.39&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
(6033, 1, 67, 2, 0, NULL, 0, '2024-11-04 22:26:11', '2024-11-05 08:33:39', '2024-11-05', 'P5665', '24-07431-11-04', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 310.37, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-051124-BdwYvY6cHsFe6-057', '09b40888-6440-4c6d-b058-155bad86f740', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-BdwYvY6cHsFe6-057&s=KOL2024&nf=P5665&i=310.37&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6034, 1, 259, 2, 0, NULL, 0, '2024-11-05 09:04:22', '2024-11-05 10:11:22', '2024-11-05', 'P5666', '24-07432-11-05', 'entregar de 9 a 13.00 avisar al tel.680750573', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'GIPUZKOA KALEA 53bajo', 'Zarautz', 'Gipuzkoa', '20800', 'España', 206.91, 0, '2024-11-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051124-OmF3OJMdyBVkm-100', '57f0d764-10cb-4ccf-bb2c-c651d4ac76b9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-OmF3OJMdyBVkm-100&s=KOL2024&nf=P5666&i=206.91&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6035, 1, 568, 1, 0, NULL, 0, '2024-11-05 11:46:10', '2024-11-05 11:46:10', '2024-11-05', 'P5667', '', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'Larramendi 8', 'Donostia', 'Gipuzkoa', '20006', '', 172.42, 0, '2024-11-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-051124-ePewyZcOJ02sL-123', 'cf146bc8-819c-4d62-9984-e8c3ce69f2f3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-ePewyZcOJ02sL-123&s=KOL2024&nf=P5667&i=172.42&cr=234', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6036, 1, 397, 2, 0, NULL, 0, '2024-11-05 11:13:10', '2024-11-05 12:29:31', '2024-11-05', 'P5668', '24-07448-11-05', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Alaberga...69..!° izda', 'Errenteria', 'Gipuzkoa', '20100', 'España', 56.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-051124-LVNMggyOVs8rR-245', 'ac7728c9-9de2-4e45-b338-eb6722cd6062', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-LVNMggyOVs8rR-245&s=KOL2024&nf=P5668&i=56.82&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6037, 1, 689, 2, 0, NULL, 0, '2024-11-05 11:29:48', '2024-11-05 12:37:07', '2024-11-05', 'P5669', '24-07449-11-05', 'mediodia cerrado', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Dr Espinosa Oribe 19 bajo', 'Bilbao', 'Bizkaia', '48003', 'España', 65.52, 0, '2024-11-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-051124-FgGz71f2P/AFS-066', '65af171f-17d2-4454-9549-d6a707ab6540', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-FgGz71f2P%2FAFS-066&s=KOL2024&nf=P5669&i=65.52&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6038, 1, 252, 2, 0, NULL, 0, '2024-11-05 13:45:58', '2024-11-05 15:44:47', '2024-11-05', 'P5670', '24-07450-11-05', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Pl. Pedro Astigarraga N°2 6° PTA 613', 'Bilbao', 'Bizkaia', '48015', 'España', 43.71, 0, '2024-11-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-051124-gg90cwzgnfD4j-163', '4a54ddcc-9df0-4fd8-852c-b6d460a46737', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-gg90cwzgnfD4j-163&s=KOL2024&nf=P5670&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);
