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
(4807, 1, 1218, 2, 0, NULL, 0, '2024-03-28 09:59:05', '2024-04-02 09:29:02', '2024-04-02', 'P4500', '24-06117-03-28', 'AVISAR ANTES POR TF. MEJOR MAÑANAS. ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'ALDAPA,12- MUTILVA', 'Aranguren', 'Navarra', '31192', 'España', 28.39, 0, '2024-03-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-Kees4MXvWuPJB-214', '9fa94d44-ead6-4014-be49-c91aea13249e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-Kees4MXvWuPJB-214&s=KOL2024&nf=P4500&i=28.39&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4808, 1, 991, 2, 0, NULL, 0, '2024-03-28 14:05:12', '2024-04-02 09:19:31', '2024-04-02', 'P4501', '24-06118-03-28', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/ Doctor Marañón 12', 'Almonte', 'Huelva', '21730', 'España', 137.94, 0, '2024-03-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-Bwgyqo8TCjKhs-082', '8649f2dc-45ac-46cb-a5d1-33e020b49676', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-Bwgyqo8TCjKhs-082&s=KOL2024&nf=P4501&i=137.94&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4809, 1, 28, 2, 0, NULL, 0, '2024-03-29 15:45:03', '2024-04-02 09:24:13', '2024-04-02', 'P4507', '24-06119-03-29', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020424-PtPiQs6MManDV-039', '9c4e2fbd-ca84-43cd-bb4f-24348d50a88d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-PtPiQs6MManDV-039&s=KOL2024&nf=P4507&i=206.91&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4810, 1, 28, 2, 0, NULL, 0, '2024-03-29 15:45:08', '2024-03-29 15:45:08', '2024-03-29', '', '24-06120-03-29', NULL, 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4811, 1, 28, 2, 0, NULL, 0, '2024-03-29 15:45:11', '2024-03-29 15:45:11', '2024-03-29', '', '24-06121-03-29', NULL, 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4812, 1, 28, 2, 0, NULL, 0, '2024-03-29 15:45:13', '2024-03-29 15:45:13', '2024-03-29', '', '24-06122-03-29', NULL, 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4813, 1, 28, 2, 0, NULL, 0, '2024-03-29 15:45:15', '2024-03-29 15:45:15', '2024-03-29', '', '24-06123-03-29', NULL, 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4814, 1, 1219, 2, 0, NULL, 0, '2024-03-29 16:06:40', '2024-04-02 09:24:27', '2024-04-02', 'P4502', '24-06125-03-29', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Castillo de candanchu 48.  Portal d .piso 4A', 'Madrid', 'Madrid', '28050', 'España', 30.61, 0, '2024-03-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-aa4Gooo5BlKri-186', 'fb52b953-9cb1-4278-b5a2-d67ea30570cf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-aa4Gooo5BlKri-186&s=KOL2024&nf=P4502&i=30.61&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4815, 1, 1220, 2, 0, NULL, 0, '2024-03-29 22:36:10', '2024-04-02 09:27:15', '2024-04-02', 'P4509', '24-06127-03-29', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Ronda Don Bosco 17 4', 'Vigo', 'Pontevedra', '36202', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-020424-Ta3pF6R2w+e/C-105', 'bd645f93-4c67-4e31-a2da-9f78a2d99935', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-Ta3pF6R2w%2Be%2FC-105&s=KOL2024&nf=P4509&i=20.00&cr=054', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4816, 1, 1221, 2, 0, NULL, 0, '2024-03-31 11:32:28', '2024-04-02 12:58:13', '2024-04-02', 'P4508', '24-06128-03-31', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Ramón Nieto 227-3A ', 'Vigo', 'Pontevedra', '36205', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020424-Jg0WbdadLTz1l-234', '1a8d4edd-8bd2-43eb-8b5e-c466177d02f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-Jg0WbdadLTz1l-234&s=KOL2024&nf=P4508&i=30.61&cr=025', '[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
(4817, 1, 444, 2, 0, NULL, 0, '2024-03-31 16:43:41', '2024-04-02 09:25:15', '2024-04-02', 'P4503', '24-06129-03-31', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Antziola 9,3ºdcha', 'Hernani', 'Gipuzkoa', '20120', 'España', 28.39, 0, '2024-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-Ighy71/gFRjY5-219', '3ef61921-d13e-4100-8d5d-2f6462c0ab2c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-Ighy71%2FgFRjY5-219&s=KOL2024&nf=P4503&i=28.39&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4818, 1, 1222, 2, 0, NULL, 0, '2024-03-31 17:20:47', '2024-04-02 09:25:30', '2024-04-02', 'P4504', '24-06130-03-31', 'Entrega por la mañana', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avd de las alpujarras 83', 'Dalías', 'Almería', '04750', 'España', 17.50, 0, '2024-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-jbqBFvlyuI7TL-084', '50ebf7fb-bd90-4e09-abdb-6dfe7c22a719', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-jbqBFvlyuI7TL-084&s=KOL2024&nf=P4504&i=17.50&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4819, 1, 1223, 2, 0, NULL, 0, '2024-04-01 20:52:37', '2024-04-02 09:25:47', '2024-04-02', 'P4505', '24-06134-04-01', 'Si no hay nadie en casa, entregarlo al portero en portería ', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Calle Juan Ramón Jiménez, 6 portal 2 esc C 2-C', 'Rozas de Madrid (Las', 'Madrid', '28232', 'España', 41.50, 0, '2024-04-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-AcBba0wA0QEO3-161', '0f2bb2e2-f986-4360-b140-e0e0666d9b98', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-AcBba0wA0QEO3-161&s=KOL2024&nf=P4505&i=41.50&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4820, 1, 1224, 2, 0, NULL, 0, '2024-04-02 07:07:53', '2024-04-02 09:26:06', '2024-04-02', 'P4506', '24-06135-04-02', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Abeto 7', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 30.61, 0, '2024-04-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-F4j2gWUwzGk8F-084', '715bc893-91d9-4c47-8064-361c0f1e4b0c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-F4j2gWUwzGk8F-084&s=KOL2024&nf=P4506&i=30.61&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4821, 1, 696, 1, 0, NULL, 0, '2024-04-02 09:37:46', '2024-04-02 11:19:10', '2024-04-02', 'P4511', '', '', 0.00, 626.34, 131.53, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 757.87, 0, '2024-04-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020424-aG0Kf1BNGbW+g-038', '32774324-d61d-48d4-8c84-966cf9757fb7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-aG0Kf1BNGbW%2Bg-038&s=KOL2024&nf=P4511&i=757.87&cr=252', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4822, 1, 1050, 2, 0, NULL, 0, '2024-04-02 08:17:09', '2024-04-02 11:12:52', '2024-04-02', 'P4510', '24-06136-04-02', '', 0.00, 114.00, 24.37, 0.00, 1, 6.04, 2.50, 'Carlos caamaño ,3 peluquería ', 'Madrid', 'Madrid', '28016', 'España', 146.48, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-020424-AtzkhJ3DWDb8w-069', '7851c046-d431-4033-b312-cdd51dfd9720', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-AtzkhJ3DWDb8w-069&s=KOL2024&nf=P4510&i=146.47&cr=006', '[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
(4823, 1, 1094, 1, 0, NULL, 0, '2024-04-02 11:22:06', '2024-04-02 11:25:57', '2024-04-02', 'P4512', '', '', 0.00, 19.83, 4.92, 0.00, 0, 0.00, 4.40, 'Carrer sant Jaume, 37', 'Sant Iscle de Vallal', 'Barcelona', '08359', 'España', 28.39, 0, '2024-04-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020424-ValSaiM+LAEms-077', '8c7b4bf0-81c8-407d-950f-c005268737f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-ValSaiM%2BLAEms-077&s=KOL2024&nf=P4512&i=28.39&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4824, 1, 956, 2, 0, NULL, 0, '2024-04-02 09:46:50', '2024-04-02 12:16:10', '2024-04-02', 'P4513', '24-06137-04-02', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1 bajo', 'Vigo', 'Pontevedra', '36204', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020424-VqNDSgfIvgnIX-158', '285d493b-edb3-45f7-b2cf-86586c2f7599', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-VqNDSgfIvgnIX-158&s=KOL2024&nf=P4513&i=172.43&cr=089', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4825, 1, 172, 2, 0, NULL, 0, '2024-04-02 09:59:34', '2024-04-02 12:19:19', '2024-04-02', 'P4514', '24-06138-04-02', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Soldevila, 6 baixos', 'Tremp', 'Lleida', '25620', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020424-TTqkrwWw2YWx9-096', 'adbd3fee-e0f8-4e31-9d17-ec36bc02fa42', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-TTqkrwWw2YWx9-096&s=KOL2024&nf=P4514&i=103.46&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4826, 1, 1110, 2, 0, NULL, 0, '2024-04-02 10:48:50', '2024-04-02 12:52:43', '2024-04-02', 'P4515', '24-06139-04-02', '', 0.00, 65.12, 13.68, 0.00, 0, 0.00, 0.00, 'C/unió N015', 'Lleida', 'Lleida', '25002', 'España', 78.80, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020424-LB/S9ijxpJdh8-031', 'eef14865-ccf2-48d8-b983-44514fc11c4c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-LB%2FS9ijxpJdh8-031&s=KOL2024&nf=P4515&i=78.80&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4827, 1, 280, 2, 0, NULL, 0, '2024-04-02 13:48:26', '2024-04-03 09:31:05', '2024-04-03', 'P4516', '24-06140-04-02', 'lunes cerrado', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'RUA CODESAL Nº2', 'O Pino', 'A Coruña', '15821', 'España', 137.94, 0, '2024-04-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030424-KoDaN9mQeaCBS-195', '8aaebdf0-305f-435e-995b-f869cf1938c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030424-KoDaN9mQeaCBS-195&s=KOL2024&nf=P4516&i=137.94&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4828, 1, 88, 2, 0, NULL, 0, '2024-04-02 15:14:42', '2024-04-03 09:33:09', '2024-04-03', 'P4517', '24-06141-04-02', '', 0.00, 203.56, 42.75, 0.00, 0, 0.00, 0.00, 'Turina 2bj  peluqueria ecologica valderros ', 'Valladolid', 'Valladolid', '47006', 'España', 246.31, 0, '2024-04-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030424-hpWY06yTvJMeV-172', 'a6133848-b39e-4ed5-9e3a-e75ef11df561', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030424-hpWY06yTvJMeV-172&s=KOL2024&nf=P4517&i=246.31&cr=057', '[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
(4829, 1, 226, 2, 0, NULL, 0, '2024-04-02 15:27:48', '2024-04-03 09:34:54', '2024-04-03', 'P4518', '24-06142-04-02', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'CALLE LOGROÑO 5 BAJO', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 68.97, 0, '2024-04-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030424-AE8998LgedsC5-152', '9b5faa95-4815-49d2-b63c-e7265f90401b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030424-AE8998LgedsC5-152&s=KOL2024&nf=P4518&i=68.97&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4830, 1, 40, 1, 0, NULL, 0, '2024-04-03 11:13:07', '2024-04-03 11:17:42', '2024-04-03', 'P4519', '', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'Plaza valencia 7 intxaurrondo ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 147.79, 0, '2024-04-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030424-HbogLycA5oIt3-235', '46e9569d-0394-4572-8917-4e796d50acd3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030424-HbogLycA5oIt3-235&s=KOL2024&nf=P4519&i=147.79&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4831, 1, 152, 1, 0, NULL, 0, '2024-04-03 12:05:05', '2024-04-03 12:05:05', '2024-04-03', 'P4520', '', '', 0.00, 64.35, 13.51, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 77.86, 0, '2024-04-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030424-JgQA4FL9oiHTy-205', '65704c80-9822-41b3-927e-a0049dfe6578', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030424-JgQA4FL9oiHTy-205&s=KOL2024&nf=P4520&i=77.86&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4832, 1, 80, 2, 0, NULL, 0, '2024-04-03 11:44:23', '2024-04-03 13:56:14', '2024-04-03', 'P4521', '24-06144-04-03', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 551.76, 0, '2024-04-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030424-Sz/hNLWYl3fnp-150', 'ce5bd27f-9a6c-4847-ab22-7987c89cbb8d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030424-Sz%2FhNLWYl3fnp-150&s=KOL2024&nf=P4521&i=551.76&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4833, 1, 1011, 2, 0, NULL, 0, '2024-04-03 15:24:35', '2024-04-04 12:19:47', '2024-04-04', 'P4522', '24-06146-04-03', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'AVDA,CONDOMINA,70 ESC 9 6Q BLOQUE 4', 'Alicante/Alacant', 'Alicante', '03540', 'España', 137.94, 0, '2024-04-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040424-mvjBPmJ2SvAyQ-132', 'e3db21c4-db50-4ae0-88ac-ce55c043aaf3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040424-mvjBPmJ2SvAyQ-132&s=KOL2024&nf=P4522&i=137.94&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4834, 1, 688, 2, 0, NULL, 0, '2024-04-03 15:56:47', '2024-04-04 12:21:47', '2024-04-04', 'P4523', '24-06147-04-03', 'Peluqueria Adats ', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Plaza Anzaran entreplanta n 1', 'Irun', 'Gipuzkoa', '20301', 'España', 68.97, 0, '2024-04-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040424-JHifkbDw0SsJc-186', '92c94ba5-48a2-4774-b311-f94024d8925a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040424-JHifkbDw0SsJc-186&s=KOL2024&nf=P4523&i=68.97&cr=015', '[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
(4835, 1, 932, 2, 0, NULL, 0, '2024-04-03 18:52:47', '2024-04-04 12:25:13', '2024-04-04', 'P4524', '24-06148-04-03', 'Llamar antes de entregar, \r\nMándame póster publicitario y folletos, gracias ', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Calle acera del pilar Edificio residencial casa fuerte local 2 peluquería ', 'Almuñécar', 'Granada', '18697', 'España', 241.40, 0, '2024-04-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040424-drNnpV0wiN4zE-141', '9885e678-8afd-41ef-9ee7-4046e9233244', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040424-drNnpV0wiN4zE-141&s=KOL2024&nf=P4524&i=241.40&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4836, 1, 337, 2, 0, NULL, 0, '2024-04-03 19:46:17', '2024-04-04 12:27:25', '2024-04-04', 'P4527', '24-06149-04-03', '', 0.00, 187.22, 39.32, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 226.54, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040424-WGvFD+umPiSH4-040', 'e57c7641-dd64-4cd0-b832-cef4395458a1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040424-WGvFD%2BumPiSH4-040&s=KOL2024&nf=P4527&i=226.54&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4837, 1, 342, 2, 0, NULL, 0, '2024-04-04 06:16:19', '2024-04-04 12:31:49', '2024-04-04', 'P4525', '24-06150-04-04', '', 0.00, 118.98, 24.99, 0.00, 0, 0.00, 0.00, 'Renaixement, 115 bajos 1a', 'Cerdanyola del Vallè', 'Barcelona', '08290', 'España', 143.97, 0, '2024-04-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040424-LZ2E3wRoifDnS-148', '46a65eba-9e1b-45f0-8ee4-6248b881077a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040424-LZ2E3wRoifDnS-148&s=KOL2024&nf=P4525&i=143.97&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4838, 1, 40, 2, 0, NULL, 0, '2024-04-04 08:48:05', '2024-04-05 09:28:37', '2024-04-05', 'P4526', '24-06151-04-04', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 147.79, 0, '2024-04-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050424-APxaVF0GNbcLN-234', 'b71a6531-696f-44b5-aa99-2f9a9bc9de88', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050424-APxaVF0GNbcLN-234&s=KOL2024&nf=P4526&i=147.79&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4839, 1, 23, 2, 0, NULL, 0, '2024-04-04 14:57:19', '2024-04-05 09:30:45', '2024-04-05', 'P4532', '24-06153-04-04', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 137.94, 0, '2024-04-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050424-bO3TjqywVRQ20-238', '8c4d6160-85bf-4e07-9f81-e249a9bc704e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050424-bO3TjqywVRQ20-238&s=KOL2024&nf=P4532&i=137.94&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4840, 1, 120, 2, 0, NULL, 0, '2024-04-04 15:11:07', '2024-04-05 09:29:28', '2024-04-05', 'P4528', '24-06155-04-04', '', 0.00, 183.20, 38.47, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 221.67, 0, '2024-04-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050424-nj5NRXOww25fW-094', '80f57779-3adb-442b-bd6a-8f2545041a0f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050424-nj5NRXOww25fW-094&s=KOL2024&nf=P4528&i=221.67&cr=249', '[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
(4841, 1, 595, 2, 0, NULL, 0, '2024-04-04 15:12:26', '2024-04-05 09:29:47', '2024-04-05', 'P4529', '24-06154-04-04', '9:30 a16:00', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Zurbaranbarri 16 Peluqueria', 'Bilbao', 'Bizkaia', '48007', 'España', 68.97, 0, '2024-04-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-050424-TBvgycehagBp1-063', '1b8bc4a5-516d-43fd-8055-182dc41adfa5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050424-TBvgycehagBp1-063&s=KOL2024&nf=P4529&i=68.97&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4842, 1, 40, 2, 0, NULL, 0, '2024-04-04 16:16:12', '2024-04-05 09:29:59', '2024-04-05', 'P4530', '24-06156-04-04', 'LUNES Y MARTES CERRADO LA SEMANA DEL 8 Y 9 ', 0.00, 44.78, 10.17, 0.00, 0, 0.00, 4.40, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 58.58, 0, '2024-04-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050424-c4yvVrNVA9efR-161', '9aad9a77-d84b-4c5d-8fe1-20f678b601f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050424-c4yvVrNVA9efR-161&s=KOL2024&nf=P4530&i=58.58&cr=247', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4843, 1, 1114, 2, 0, NULL, 0, '2024-04-04 18:21:12', '2024-04-05 09:30:16', '2024-04-05', 'P4531', '24-06157-04-04', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Felipe Gorriti Nº22 bajo', 'Pamplona/Iruña', 'Navarra', '31004', 'España', 65.52, 0, '2024-04-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050424-HQ31n3eRFhRT3-008', '8c0b3628-5087-4fbf-a675-211a9215e251', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050424-HQ31n3eRFhRT3-008&s=KOL2024&nf=P4531&i=65.52&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4844, 1, 77, 1, 0, NULL, 0, '2024-04-05 09:38:35', '2024-04-05 09:39:33', '2024-04-05', 'P4533', '', '', 0.00, 1287.00, 270.27, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1557.27, 0, '2024-04-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050424-RnGlQdBQnjKMf-042', '591744c0-dcf4-4497-8fb5-84b41327b2d6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050424-RnGlQdBQnjKMf-042&s=KOL2024&nf=P4533&i=1557.27&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4845, 1, 40, 2, 1, 'factura duplicada', 4838, '2024-04-05 11:29:03', '2024-04-05 11:29:13', '2024-04-05', 'R75', 'P4526 RECT.', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 147.79, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-050424-QAbJwNhUciwYj-174', '0ca45949-41e9-443c-a1f6-480b75f74895', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050424-QAbJwNhUciwYj-174&s=KOL2024&nf=R75&i=-147.79&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4846, 1, 4, 2, 0, NULL, 0, '2024-04-05 18:12:06', '2024-04-08 09:30:46', '2024-04-08', 'P4534', '24-06158-04-05', '', 0.00, 301.28, 63.27, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 364.55, 0, '2024-04-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080424-caUrF4t40IsYf-051', 'f90da9c2-8cea-41d4-a18a-f4e9ea229393', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080424-caUrF4t40IsYf-051&s=KOL2024&nf=P4534&i=364.55&cr=056', '[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
(4847, 1, 262, 2, 0, NULL, 0, '2024-04-06 07:46:09', '2024-04-08 09:31:15', '2024-04-08', 'P4535', '24-06159-04-06', 'Lunes cerrado', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 123.15, 0, '2024-04-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080424-o6tfQ3mYO4b3j-174', 'a36c00c4-a70c-40f3-8d30-fb0a96897666', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080424-o6tfQ3mYO4b3j-174&s=KOL2024&nf=P4535&i=123.15&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4848, 1, 53, 2, 0, NULL, 0, '2024-04-08 08:02:06', '2024-04-08 10:09:43', '2024-04-08', 'P4536', '24-06161-04-08', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-080424-boy9z7W1QTnmk-174', '6b67a574-bbfe-49af-8370-76cdf3306e46', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080424-boy9z7W1QTnmk-174&s=KOL2024&nf=P4536&i=174.93&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4849, 1, 248, 2, 0, NULL, 0, '2024-04-08 08:31:44', '2024-04-08 10:39:49', '2024-04-08', 'P4537', '24-06162-04-08', 'Cerrado miércoles ', 0.00, 73.26, 15.38, 0.00, 0, 0.00, 0.00, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 88.64, 0, '2024-04-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080424-YhIg1pfB65rX0-165', '778e87dd-8549-4693-bfba-07a22bf25dd2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080424-YhIg1pfB65rX0-165&s=KOL2024&nf=P4537&i=88.64&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4850, 1, 166, 1, 0, NULL, 0, '2024-04-08 10:34:59', '2024-04-08 10:35:59', '2024-04-08', 'P4538', '', '', 0.00, 356.07, 74.77, 0.00, 1, 18.52, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 449.36, 0, '2024-04-08 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080424-F60FmTA31mqST-076', 'bc2e5411-b065-408a-ac4c-82d54e3d3f3c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080424-F60FmTA31mqST-076&s=KOL2024&nf=P4538&i=449.36&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4851, 1, 65, 2, 0, NULL, 0, '2024-04-08 09:49:27', '2024-07-17 13:17:50', '2024-04-08', 'P4539', '24-06163-04-08', '', 0.00, 598.50, 125.69, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 724.19, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080424-iLzmK4/4SJ2jD-255', '07686ee3-f7d4-41d4-ab75-3ca5b4309eb0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080424-iLzmK4%2F4SJ2jD-255&s=KOL2024&nf=P4539&i=724.19&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4852, 1, 1017, 2, 1, '', 4008, '2024-04-08 15:29:25', '2024-04-08 15:29:25', '2024-04-08', 'R76', 'P3764 RECT.', '', 0.00, 67.18, 14.11, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 81.29, 0, '0000-00-00 00:00:00', '', '', 0, 1, 0, 'TBAI-B20930640-080424-d4coCKV4Tasba-121', '2cb43aac-63ff-4638-bc82-50196426f021', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080424-d4coCKV4Tasba-121&s=KOL2024&nf=R76&i=-81.29&cr=237', '[BLOB]', 1, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 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
(4853, 1, 1017, 2, 1, '', 4008, '2024-04-08 15:42:23', '2024-04-08 15:42:23', '2024-04-08', 'R76', 'P3764 RECT.', '', 0.00, 67.18, 14.11, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 81.29, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-080424-QhStYR9SpV13E-237', '1f04e163-d82a-4159-a04e-d1089fdded8a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080424-QhStYR9SpV13E-237&s=KOL2024&nf=R76B&i=-81.29&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4854, 1, 1210, 2, 0, NULL, 0, '2024-04-08 13:50:24', '2024-04-09 09:06:40', '2024-04-09', 'P4540', '24-06165-04-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Rua das Chorimas nº 2', 'Pontes de García Rod', 'A Coruña', '15320', 'España', 17.50, 0, '2024-04-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090424-VepeeHmgG/jqG-070', 'df7e1d15-9b74-4a2a-9a24-a97cd478394b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090424-VepeeHmgG%2FjqG-070&s=KOL2024&nf=P4540&i=17.50&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4855, 1, 97, 2, 0, NULL, 0, '2024-04-08 15:33:14', '2024-04-09 09:09:13', '2024-04-09', 'P4541', '24-06166-04-08', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle Bidasoa 8, Bajo Bera', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 68.97, 0, '2024-04-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090424-VGucfBDnnju/7-199', '647145eb-3ad2-4b82-9211-5cce30995fce', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090424-VGucfBDnnju%2F7-199&s=KOL2024&nf=P4541&i=68.97&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4856, 1, 327, 2, 0, NULL, 0, '2024-04-08 19:07:52', '2024-04-09 09:19:56', '2024-04-09', 'P4542', '24-06167-04-08', 'avisar por telefono para estar en domicilio', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'elizagaina 20 egillor de ollo', 'Ollo', 'Navarra', '31172', 'España', 95.98, 0, '2024-04-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090424-ohtQWwmvEzlri-207', '8d9ed511-20a6-4e66-abb1-8b83a8a7301d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090424-ohtQWwmvEzlri-207&s=KOL2024&nf=P4542&i=95.98&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4857, 1, 617, 2, 0, NULL, 0, '2024-04-08 21:21:05', '2024-04-09 09:20:30', '2024-04-09', 'P4543', '24-06168-04-08', 'Factura \r\n', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Riestra, 14', 'Pontevedra', 'Pontevedra', '36001', 'España', 275.88, 0, '2024-04-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090424-M9Svx4ot+mdlb-106', '7ad24bd4-573f-46ed-b234-ff4365f187c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090424-M9Svx4ot%2Bmdlb-106&s=KOL2024&nf=P4543&i=275.88&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4858, 1, 138, 2, 0, NULL, 0, '2024-04-09 04:10:18', '2024-04-09 09:29:03', '2024-04-09', 'P4545', '24-06169-04-09', '', 0.00, 199.50, 42.33, 0.00, 0, 0.00, 2.50, 'Carretera Valladares 382', 'Vigo', 'Pontevedra', '36315', 'España', 243.90, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-090424-cHdAiCVE898SE-008', '630fb2ab-8ab0-4548-8ee1-e64482425374', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090424-cHdAiCVE898SE-008&s=KOL2024&nf=P4545&i=243.90&cr=082', '[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
(4859, 1, 356, 2, 0, NULL, 0, '2024-04-09 06:53:59', '2024-04-09 09:30:07', '2024-04-09', 'P4544', '24-06170-04-09', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'c/ Mendarozabal, 5 - 2 izq.', 'Mendaro', 'Gipuzkoa', '20850', 'España', 41.50, 0, '2024-04-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090424-ZySVd8xrwQQZF-041', 'dce4d145-2f28-4546-8bc3-85df971f3884', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090424-ZySVd8xrwQQZF-041&s=KOL2024&nf=P4544&i=41.50&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4860, 1, 1047, 2, 0, NULL, 0, '2024-04-09 12:34:30', '2024-04-10 09:45:33', '2024-04-10', 'P4550', '24-06172-04-09', 'Es una empresa (PASCH Y CIA con horario hasta 17h de lunes a jueves y hasta las 14h viernes', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Gran Vía de les Corts Catalanes, 645, 2º-1', 'Barcelona', 'Barcelona', '08010', 'España', 17.50, 0, '2024-04-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100424-aBvbjmb1deP6q-112', 'fe3d7bb5-d0d5-497e-9a76-989ba4bd0237', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100424-aBvbjmb1deP6q-112&s=KOL2024&nf=P4550&i=17.50&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4861, 1, 78, 2, 0, NULL, 0, '2024-04-09 13:16:10', '2024-04-10 09:44:15', '2024-04-10', 'P4549', '24-06173-04-09', '', 0.00, 598.50, 125.69, 0.00, 0, 0.00, 0.00, 'AVNDA. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 724.19, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100424-K8CvUen+WotNM-182', '535e4aaf-521c-4922-b879-990f25595103', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100424-K8CvUen%2BWotNM-182&s=KOL2024&nf=P4549&i=724.19&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4862, 1, 633, 2, 0, NULL, 0, '2024-04-09 16:25:18', '2024-04-10 09:44:35', '2024-04-10', 'P4546', '24-06174-04-09', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle del Abeto, 3. Urbanización Los Robles', 'Torrelodones', 'Madrid', '28250', 'España', 43.71, 0, '2024-04-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100424-M/BAxm8GZm+L1-092', '755323fe-1d64-40b2-8e1d-8968a03bbaee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100424-M%2FBAxm8GZm%2BL1-092&s=KOL2024&nf=P4546&i=43.71&cr=074', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4863, 1, 462, 2, 0, NULL, 0, '2024-04-09 17:37:24', '2024-04-10 09:44:48', '2024-04-10', 'P4547', '24-06175-04-09', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Santa María 12', 'Font-rubí', 'Barcelona', '08736', 'España', 30.61, 0, '2024-04-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100424-FZszrcqw8YLhQ-185', 'f6a75241-42de-4b29-b426-98f578b95a0e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100424-FZszrcqw8YLhQ-185&s=KOL2024&nf=P4547&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),
(4864, 1, 1226, 2, 0, NULL, 0, '2024-04-09 20:55:43', '2024-04-10 09:45:11', '2024-04-10', 'P4548', '24-06176-04-09', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Iberotarren plaza 3, 1d', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 30.61, 0, '2024-04-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100424-YgeJgURourP6u-020', 'b736643b-5d4c-4424-a4a3-8f7a6a541559', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100424-YgeJgURourP6u-020&s=KOL2024&nf=P4548&i=30.61&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
