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
(3439, 1, 122, 2, 0, NULL, 0, '2023-07-01 14:49:26', '2023-07-03 09:11:26', '2023-07-01', 'P3230', '23-04610-07-01', 'de martes a viernes de 10:00 a !8:00', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'nemesio etxaniz nº2 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 68.97, 0, '2023-07-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010723-J47zdjLNH4Ov9-249', '8adf6e65-e30f-4ad2-9118-a8a06a52f240', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010723-J47zdjLNH4Ov9-249&s=KOL2023&nf=P3230&i=68.97&cr=013', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3440, 1, 865, 2, 0, NULL, 0, '2023-07-01 15:41:16', '2023-07-03 09:16:01', '2023-07-01', 'P3233', '23-04611-07-01', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Paseo del Parque Numero 5 1-2 ', 'Sant Sadurní d\'Anoia', 'Barcelona', '08770', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-010723-Wa+NrIngO5ef8-083', '9711ee4d-bb87-4ace-b17e-7b75cc5a367c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010723-Wa%2BNrIngO5ef8-083&s=KOL2023&nf=P3233&i=20.00&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3441, 1, 327, 2, 0, NULL, 0, '2023-07-02 07:16:04', '2023-07-03 09:20:19', '2023-07-02', 'P3231', '23-04615-07-02', 'avisar antes de entrega', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'elizagaina 20 Egillor', 'Ollo', 'Navarra', '31172', 'España', 95.98, 0, '2023-07-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020723-nd3IU9YEzC+KI-154', 'f14dec01-3151-43a8-89c7-e3eead8da621', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020723-nd3IU9YEzC%2BKI-154&s=KOL2023&nf=P3231&i=95.98&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3442, 1, 866, 2, 0, NULL, 0, '2023-07-02 18:58:58', '2023-07-03 09:27:37', '2023-07-02', 'P3234', '2023-07-02', '', 0.00, 19.83, 5.36, 0.00, 0, 0.00, 6.90, 'C/ vial 6 ó Marie Curie 650303555', 'Puebla de Montalbán ', 'Toledo', '45516', 'España', 30.89, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-020723-o5hu7QWRIRIdq-233', '6d5e604c-b4cc-4ac6-9393-2d48035bb8f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020723-o5hu7QWRIRIdq-233&s=KOL2023&nf=P3234&i=30.89&cr=013', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3443, 1, 867, 2, 0, NULL, 0, '2023-07-02 19:38:40', '2023-07-03 09:35:31', '2023-07-02', 'P3232', '23-04617-07-02', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Cerrajería 17', 'Espartinas', 'Sevilla', '41807', 'España', 30.61, 0, '2023-07-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020723-RaTNcxyxplnFR-055', '2fac1045-ef2e-4449-a72d-c80921292e29', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020723-RaTNcxyxplnFR-055&s=KOL2023&nf=P3232&i=30.61&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3444, 1, 108, 2, 0, NULL, 0, '2023-07-02 20:35:40', '2023-07-03 09:39:27', '2023-07-02', 'P3235', '23-04618-07-02', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020723-VwN6eUDp7Hl44-001', '43c85da7-6028-47c4-bda0-6762f1e1bdf1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020723-VwN6eUDp7Hl44-001&s=KOL2023&nf=P3235&i=413.82&cr=014', '[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
(3445, 1, 474, 1, 0, NULL, 0, '2023-07-03 09:48:46', '2023-07-03 10:03:25', '2023-07-03', 'P3236', '2023-07-03', '', 0.00, 48.84, 10.79, 0.00, 0, 0.00, 3.03, 'C Ntra Sra de los clarines 56', 'Beas', 'Huelva', '21630', 'España', 62.13, 0, '2023-07-03 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-030723-G8x24x22cdisQ-210', 'c2bc9f8b-1f54-4493-9516-797ec366a2bf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030723-G8x24x22cdisQ-210&s=KOL2023&nf=P3236&i=62.13&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3446, 1, 474, 2, 0, NULL, 0, '2023-07-03 07:55:31', '2023-07-03 07:55:31', '2023-07-03', '', '23-04619-07-03', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Nuestra Señora de los Clarines 56', 'Beas', 'Huelva', '21630', 'España', 196.56, 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),
(3447, 1, 676, 2, 0, NULL, 0, '2023-07-03 08:20:28', '2023-07-03 11:09:36', '2023-07-03', 'P3237', '23-04620-07-03', 'Piso 5 BEYOND', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo de Gracia 98, piso 5', 'Barcelona', 'Barcelona', '08008', 'España', 17.50, 0, '2023-07-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030723-g9jGeGe1gm/sS-024', 'a2259982-0032-4fcb-b565-0d0c1e063634', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030723-g9jGeGe1gm%2FsS-024&s=KOL2023&nf=P3237&i=17.50&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3448, 1, 868, 2, 0, NULL, 0, '2023-07-03 10:29:47', '2023-07-03 12:41:14', '2023-07-03', 'P3238', '23-04622-07-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Jordi Pujol 9', 'Benavent de Segrià', 'Lleida', '25132', 'España', 30.61, 0, '2023-07-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030723-ddLCLH1NybSEb-153', '45f98f54-5513-4b31-90ea-7c176f0efd25', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030723-ddLCLH1NybSEb-153&s=KOL2023&nf=P3238&i=30.61&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3449, 1, 199, 2, 0, NULL, 0, '2023-07-03 10:36:33', '2023-07-03 10:36:33', '2023-07-03', '', '23-04623-07-03', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Zumaia 17 3 C', 'Bilbao', 'Bizkaia', '48007', 'España', 196.56, 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),
(3450, 1, 24, 2, 0, NULL, 0, '2023-07-03 10:44:17', '2023-07-03 13:54:43', '2023-07-03', 'P3239', '23-04624-07-03', '', 0.00, 28.50, 7.19, 0.00, 0, 0.00, 6.90, 'Zumaia 17 3 C', 'Bilbo', 'BIZKAIA', '48007', 'ESPAÑA', 41.39, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-030723-OLmGG8v6i6MGH-035', 'b442a0bd-940d-483e-a94a-dc52b49190a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030723-OLmGG8v6i6MGH-035&s=KOL2023&nf=P3239&i=41.39&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3451, 1, 687, 1, 0, NULL, 0, '2023-07-03 15:43:37', '2023-07-03 15:45:10', '2023-07-03', 'P3240', '2023-07-03', '', 0.00, 158.78, 33.34, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 192.12, 0, '2023-07-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030723-Hyzu8X3utnWDX-026', 'eb258e83-861b-4b20-a676-a43a92d2d713', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030723-Hyzu8X3utnWDX-026&s=KOL2023&nf=P3240&i=192.12&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3452, 1, 869, 2, 0, NULL, 0, '2023-07-03 19:59:10', '2023-07-04 09:14:52', '2023-07-03', 'P3241', '23-04625-07-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Gabriel Krutzelaegi Kalea', 'Elgoibar', 'Gipuzkoa', '20870', 'España', 30.61, 0, '2023-07-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030723-TiuG+kCYfyKc6-081', '2cb11dab-c5fc-43b8-b65e-938e52e84c4b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030723-TiuG%2BkCYfyKc6-081&s=KOL2023&nf=P3241&i=30.61&cr=152', '[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
(3453, 1, 218, 2, 0, NULL, 0, '2023-07-03 20:04:21', '2023-07-04 09:15:59', '2023-07-03', 'P3244', '23-04626-07-03', '', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'C/ Josefa Amar y Borbon nº 11 ', 'Zaragoza', 'Zaragoza', '50001', 'España', 88.67, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030723-bTZbbiSWQQ1e5-126', 'f8ecd575-6eff-4404-8c6c-64b9e22f8820', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030723-bTZbbiSWQQ1e5-126&s=KOL2023&nf=P3244&i=88.67&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3454, 1, 639, 2, 0, NULL, 0, '2023-07-03 22:04:33', '2023-07-04 09:17:48', '2023-07-03', 'P3242', '23-04627-07-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Plaza Pontevedra, 8 - 6 D', 'Fuenlabrada', 'Madrid', '28942', 'España', 17.50, 0, '2023-07-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030723-QKUEAju3QWoth-226', '4d8086bd-062d-4223-8e2d-80a535dc26a1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030723-QKUEAju3QWoth-226&s=KOL2023&nf=P3242&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),
(3455, 1, 574, 2, 0, NULL, 0, '2023-07-03 22:22:44', '2023-07-04 09:18:42', '2023-07-03', 'P3243', '23-04628-07-03', 'Centro de Atención Primaria', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer Nou de la Rambla 169', 'Barcelona', 'Barcelona', '08004', 'España', 17.50, 0, '2023-07-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030723-Te1bV6Z9hfSu8-231', 'f66f2c83-5e49-4d2d-8a23-f42ad27e5757', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030723-Te1bV6Z9hfSu8-231&s=KOL2023&nf=P3243&i=17.50&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3456, 1, 131, 2, 0, NULL, 0, '2023-07-04 08:28:05', '2023-07-04 10:31:16', '2023-07-04', 'P3245', '23-04629-07-04', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040723-JOH0bIsSvyUTm-202', '7f27c233-6bc8-4aff-9ec0-08b72e205bd1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040723-JOH0bIsSvyUTm-202&s=KOL2023&nf=P3245&i=379.34&cr=160', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3457, 1, 110, 2, 0, NULL, 0, '2023-07-04 09:29:05', '2023-07-04 11:34:24', '2023-07-04', 'P3246', '23-04630-07-04', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-040723-Slkh1hT3E7ud5-165', '2ed86135-36a7-44e4-8011-d2e06f50a867', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040723-Slkh1hT3E7ud5-165&s=KOL2023&nf=P3246&i=209.41&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3458, 1, 870, 2, 0, NULL, 0, '2023-07-04 10:10:14', '2023-07-04 10:10:14', '2023-07-04', '', '23-04632-07-04', NULL, 0.00, 162.45, 34.11, 0.00, 0, 8.45, 0.00, 'Calle Fuente Carrantona 38c 4 izquierda ', 'Madrid', 'Madrid', '28030', 'España', 205.01, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(3459, 1, 174, 2, 0, NULL, 0, '2023-07-04 10:11:22', '2023-07-04 12:20:42', '2023-07-04', 'P3247', '23-04631-07-04', 'hola , quisiera que me borraseis del listado de salones de peluquería que tenéis en vuestra web , aunque seguiré trabajando con vosotros.\r\nNo necesito que me mandéis trípticos, ni nada impreso\r\nmuchas gracias\r\nun saludo \r\nMarga', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 275.88, 0, '2023-07-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040723-kFnxLGS0ON5G+-116', '7d38ab8f-8654-4fa7-a355-2d584cfd85d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040723-kFnxLGS0ON5G%2B-116&s=KOL2023&nf=P3247&i=275.88&cr=041', '[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
(3460, 1, 306, 2, 0, NULL, 0, '2023-07-04 10:45:10', '2023-07-04 12:47:32', '2023-07-04', 'P3248', '23-04633-07-04', 'beq hairstyle', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'calle puigmulto 9', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 137.94, 0, '2023-07-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040723-Rr26coTvEavbC-150', '08e2cdf1-2244-400e-8630-db356efea2c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040723-Rr26coTvEavbC-150&s=KOL2023&nf=P3248&i=137.94&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3461, 1, 403, 2, 0, NULL, 0, '2023-07-04 11:27:26', '2023-07-04 13:33:46', '2023-07-04', 'P3249', '23-04634-07-04', 'Agradecería si me lo puedan entregar lo antes posible.', 0.00, 108.30, 22.74, 0.00, 0, 0.00, 0.00, 'Calle Pintor Verafajardo 9 6D', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 131.04, 0, '2023-07-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040723-QwJJ0iLLZS4O2-031', 'd6911f23-34a3-4e4b-9190-7649c725cafe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040723-QwJJ0iLLZS4O2-031&s=KOL2023&nf=P3249&i=131.04&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3462, 1, 53, 2, 0, NULL, 0, '2023-07-04 13:19:41', '2023-07-04 15:36:04', '2023-07-04', 'P3251', '23-04635-07-04', '', 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-040723-NKXSs2YJ3xmLG-148', 'a96b0fe4-c2e9-4238-945f-b18108c69f98', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040723-NKXSs2YJ3xmLG-148&s=KOL2023&nf=P3251&i=174.93&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3463, 1, 149, 2, 0, NULL, 0, '2023-07-04 13:33:01', '2023-07-04 15:41:23', '2023-07-04', 'P3250', '23-04636-07-04', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 157.64, 0, '2023-07-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040723-NFQsa40P3/xfz-116', 'cc36efe8-d087-4d50-b1af-146ccf9db6d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040723-NFQsa40P3%2Fxfz-116&s=KOL2023&nf=P3250&i=157.63&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3464, 1, 871, 2, 0, NULL, 0, '2023-07-04 16:57:29', '2023-07-05 09:00:45', '2023-07-04', 'P3253', '23-04637-07-04', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'pintor aurelio vera fajardo n 6 4 A', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 17.50, 0, '2023-07-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040723-dbiU3npOQ6TEl-062', 'f362bd0c-d18b-4a6d-9178-a7004ef79beb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040723-dbiU3npOQ6TEl-062&s=KOL2023&nf=P3253&i=17.50&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3465, 1, 872, 2, 0, NULL, 0, '2023-07-05 05:59:03', '2023-07-05 09:03:42', '2023-07-05', 'P3252', '23-04638-07-05', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Antonio Machado N° 7.  3-E', 'Caudete', 'Albacete', '02660', 'España', 41.50, 0, '2023-07-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050723-RveSV/dTiLXoi-019', '1867b639-c57d-48d1-adcf-85acebac3f87', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050723-RveSV%2FdTiLXoi-019&s=KOL2023&nf=P3252&i=41.50&cr=078', '[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
(3466, 1, 80, 2, 0, NULL, 0, '2023-07-05 13:00:18', '2023-07-06 09:11:32', '2023-07-05', 'P3256', '23-04639-07-05', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 241.40, 0, '2023-07-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050723-MOS+1vSyxHulz-169', '892b0fc7-61a8-4487-8e35-860ccb214fad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050723-MOS%2B1vSyxHulz-169&s=KOL2023&nf=P3256&i=241.40&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3467, 1, 4, 2, 0, NULL, 0, '2023-07-05 15:13:14', '2023-07-06 09:15:04', '2023-07-05', 'P3254', '23-04640-07-05', '', 0.00, 280.92, 58.99, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 339.91, 0, '2023-07-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050723-F+vJLidQbQmp0-209', 'bf1fc204-86bd-403f-a74e-72f3602c7191', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050723-F%2BvJLidQbQmp0-209&s=KOL2023&nf=P3254&i=339.91&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3468, 1, 276, 2, 0, NULL, 0, '2023-07-05 17:13:39', '2023-07-06 09:23:36', '2023-07-05', 'P3255', '23-04641-07-05', 'Casa de campo en la carretera general', 0.00, 21.66, 5.97, 0.00, 0, 0.00, 8.19, 'Son Toni Martinet', 'Ciutadella de Menorc', 'Baleares (Illes)', '07760', 'España', 34.40, 0, '2023-07-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050723-WP1o7COs9CNhu-220', '37384bcb-ccee-4dc0-a2d5-a99d219d7ffd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050723-WP1o7COs9CNhu-220&s=KOL2023&nf=P3255&i=34.40&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3469, 1, 696, 1, 0, NULL, 0, '2023-07-06 09:12:51', '2023-07-06 09:15:06', '2023-07-06', 'P3257', '2023-07-06', '', 0.00, 154.44, 32.43, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 186.87, 0, '2023-07-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060723-WV/1Pwx+wWQdb-233', '61767443-42f5-41d2-af47-a0e4fad8a826', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060723-WV%2F1Pwx%2BwWQdb-233&s=KOL2023&nf=P3257&i=186.87&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3470, 1, 65, 2, 0, NULL, 0, '2023-07-06 09:48:26', '2023-07-06 12:40:36', '2023-07-06', 'P3258', '23-04642-07-06', '', 0.00, 883.50, 185.54, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 1069.04, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060723-TeDeZX1zPi+1a-166', '49928777-2aca-4409-916b-e570c3e560b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060723-TeDeZX1zPi%2B1a-166&s=KOL2023&nf=P3258&i=1069.04&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3471, 1, 821, 2, 0, NULL, 0, '2023-07-06 10:55:20', '2023-07-06 12:59:42', '2023-07-06', 'P3259', '23-04643-07-06', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'gurutzeaga 9 bajo, 72438407e', 'Zestoa', 'Gipuzkoa', '20740', 'España', 68.97, 0, '2023-07-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060723-jGgmqtGrbJKQK-107', '7c866ac1-80eb-4b47-9a7c-c165f4ea345f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060723-jGgmqtGrbJKQK-107&s=KOL2023&nf=P3259&i=68.97&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3472, 1, 873, 2, 0, NULL, 0, '2023-07-06 14:48:56', '2023-07-06 14:48:56', '2023-07-06', '', '23-04644-07-06', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Hacienda de Pavones 15', 'Moralzarzal', 'Madrid', '28030', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0);
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
(3473, 1, 874, 2, 0, NULL, 0, '2023-07-06 17:45:13', '2023-07-07 09:18:26', '2023-07-06', 'P3260', '23-04645-07-06', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Tomas Romero de Castilla 3 3C', 'Mérida', 'Badajoz', '07800', 'España', 28.39, 0, '2023-07-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060723-DCzpKI2N0bBta-193', '3474c577-89bd-434f-9131-e860812a403a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060723-DCzpKI2N0bBta-193&s=KOL2023&nf=P3260&i=28.39&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3474, 1, 874, 2, 0, NULL, 0, '2023-07-06 17:47:05', '2023-07-07 09:27:34', '2023-07-06', 'P3261', '23-04648-07-06', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Tomas Romero de Castilla 3 3C', 'Mérida', 'Badajoz', '07800', 'España', 28.39, 0, '2023-07-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060723-C15KBSum0PGoy-041', '8b5b722d-ca25-4c6b-a084-dfc89ebde67d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060723-C15KBSum0PGoy-041&s=KOL2023&nf=P3261&i=28.39&cr=082', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3475, 1, 874, 2, 1, 'Pedido duplicado por error', 3474, '2023-07-07 09:28:05', '2023-07-07 09:28:05', '2023-07-07', 'R48', 'P3261 RECT.', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, '', '', '', '', '', 28.39, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-070723-NzIc21oFZYwsQ-045', 'eaa30781-1097-4242-8daa-44801df09b40', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070723-NzIc21oFZYwsQ-045&s=KOL2023&nf=R48&i=-28.39&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3476, 1, 875, 2, 0, NULL, 0, '2023-07-07 11:07:00', '2023-07-07 13:40:22', '2023-07-07', 'P3262', '2023-07-07', 'Llamar 65927034-', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Lugar Romeiras, 3 B', 'Pobra do Caramiñal (', 'A Coruña', '15940', 'España', 65.52, 0, '2023-07-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070723-VY0qcD44HDSha-117', '63cdbc8c-0a6f-4b02-915b-24fef1a56311', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070723-VY0qcD44HDSha-117&s=KOL2023&nf=P3262&i=65.52&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3477, 1, 873, 2, 0, NULL, 0, '2023-07-07 11:51:07', '2023-07-10 09:27:21', '2023-07-07', 'P3265', '23-04650-07-07', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'Hacienda de Pavones 15', 'Madrid', 'Madrid', '28030', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-070723-V54bVpuXvh07u-119', '5695d6c3-175c-4578-900f-3798675a28f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070723-V54bVpuXvh07u-119&s=KOL2023&nf=P3265&i=105.96&cr=009', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3478, 1, 365, 2, 0, NULL, 0, '2023-07-07 15:06:07', '2023-07-10 09:32:19', '2023-07-07', 'P3263', '23-04652-07-07', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'CONDESA CASA BARCENA 12-10A', 'Vigo', 'Pontevedra', '36204', 'España', 30.61, 0, '2023-07-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070723-ckUc8vKpFpZ8E-109', '38dbbdee-d74d-473c-9c66-9944a735ddd4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070723-ckUc8vKpFpZ8E-109&s=KOL2023&nf=P3263&i=30.61&cr=085', '[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
(3479, 1, 876, 2, 0, NULL, 0, '2023-07-08 14:23:17', '2023-07-10 09:37:02', '2023-07-08', 'P3264', '23-04653-07-08', 'Si no hubiese nadie en casa, dejar en la peluquería, si estuviese abierta.\r\nGracias!', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Baltasar Luengo, 69, 3', 'Alginet', 'Valencia', '46230', 'España', 17.50, 0, '2023-07-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080723-HTKMBlb9tkCwo-091', '8394c638-174b-4723-90d4-fc51d9e31423', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080723-HTKMBlb9tkCwo-091&s=KOL2023&nf=P3264&i=17.50&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3480, 1, 556, 2, 0, NULL, 0, '2023-07-08 22:03:12', '2023-07-10 09:40:26', '2023-07-08', 'P3266', '23-04654-07-08', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-080723-gu9bu3gUiC0+C-221', '12e5e531-8741-46b0-8b17-b35d21ecd9c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080723-gu9bu3gUiC0%2BC-221&s=KOL2023&nf=P3266&i=71.47&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3481, 1, 877, 2, 0, NULL, 0, '2023-07-10 08:48:48', '2023-07-10 11:03:20', '2023-07-10', 'P3267', '23-04657-07-10', 'De 9 a 13.30 y de 16 a 19.30', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avda Sancho el Sabio, 25 bajo  ORTOPEDIA BIDASOA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 30.61, 0, '2023-07-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100723-XhST+Ldxz5ISG-006', '7aac526e-7a91-4904-8d44-9e41cbda4748', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100723-XhST%2BLdxz5ISG-006&s=KOL2023&nf=P3267&i=30.61&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3482, 1, 878, 2, 0, NULL, 0, '2023-07-10 10:10:25', '2023-07-10 12:14:45', '2023-07-10', 'P3268', '23-04658-07-10', 'Avisar antes de entregar por favor.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Plaza Anzaran, 11 - 1Izda', 'Irun', 'Gipuzkoa', '20301', 'España', 17.50, 0, '2023-07-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100723-b4V1wpQVpp2Jp-244', '41a6fac7-5521-4f85-8092-0bb02c704fae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100723-b4V1wpQVpp2Jp-244&s=KOL2023&nf=P3268&i=17.50&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3483, 1, 879, 2, 0, NULL, 0, '2023-07-10 11:43:59', '2023-07-11 08:30:38', '2023-07-10', 'P3269', '23-04660-07-10', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Avenida de Santander, 5, Bajo', 'Camargo', 'Cantabria', '39600', 'España', 41.50, 0, '2023-07-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100723-NX0vqA9FT9O1h-089', '7ed4f234-e3ad-400f-906d-bff96470224b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100723-NX0vqA9FT9O1h-089&s=KOL2023&nf=P3269&i=41.50&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3484, 1, 157, 2, 0, NULL, 0, '2023-07-10 15:48:53', '2023-07-11 08:33:43', '2023-07-10', 'P3270', '23-04662-07-10', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'CALLE APODACA,1 LOCAL', 'Madrid', 'Madrid', '28004', 'España', 103.46, 0, '2023-07-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100723-D9OEyKAK6fSP9-192', '752f1d2f-58a0-4ad2-8156-ec3e8888f64a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100723-D9OEyKAK6fSP9-192&s=KOL2023&nf=P3270&i=103.46&cr=119', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3485, 1, 345, 2, 0, NULL, 0, '2023-07-11 08:44:50', '2023-07-11 11:00:53', '2023-07-11', 'P3271', '2023-07-11', 'Es un negocio de peluquería, estamos abiertos hasta las 19h y los lunes hasta las 17h . Y la peluquería se abre a las 10h Gracias ', 0.00, 73.26, 15.38, 0.00, 0, 0.00, 0.00, 'Espronceda 336', 'Barcelona', 'Barcelona', '08027', 'España', 88.64, 0, '2023-07-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110723-MgJMV3NoocFFK-165', '2e77e3fa-afdf-4ee4-9acf-6aafe9ccc59e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110723-MgJMV3NoocFFK-165&s=KOL2023&nf=P3271&i=88.64&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3486, 1, 23, 2, 0, NULL, 0, '2023-07-11 08:58:19', '2023-07-11 11:04:21', '2023-07-11', 'P3272', '23-04665-07-11', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 172.43, 0, '2023-07-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110723-E7m6yFBRoM3pF-175', '469234cf-b6bd-4328-89bf-a2405b6bc8b4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110723-E7m6yFBRoM3pF-175&s=KOL2023&nf=P3272&i=172.43&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3487, 1, 87, 2, 0, NULL, 0, '2023-07-11 09:38:06', '2023-07-11 11:48:47', '2023-07-11', 'P3273', '23-04666-07-11', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Cc ARCCO local P-17 ', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 123.15, 0, '2023-07-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110723-Du1oY7E4mdQxv-037', 'b30efbfc-a37b-49d0-af5c-1414197af904', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110723-Du1oY7E4mdQxv-037&s=KOL2023&nf=P3273&i=123.15&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3488, 1, 121, 2, 0, NULL, 0, '2023-07-11 10:14:39', '2023-07-11 12:21:15', '2023-07-11', 'P3274', '23-04667-07-11', 'Lunes cerrado', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 310.37, 0, '2023-07-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110723-i6eNtPWZMDRfW-230', 'f4912d09-42e9-42a9-a943-a95a0d15077e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110723-i6eNtPWZMDRfW-230&s=KOL2023&nf=P3274&i=310.37&cr=082', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3489, 1, 145, 2, 0, NULL, 0, '2023-07-11 11:36:39', '2023-07-11 13:38:33', '2023-07-11', 'P3275', '23-04668-07-11', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 140.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-110723-C6h/D6eh5Yp06-011', 'a4ad70c1-981f-4fa8-8cb0-ef1b4f683f0a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110723-C6h%2FD6eh5Yp06-011&s=KOL2023&nf=P3275&i=140.44&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3490, 1, 145, 2, 0, NULL, 0, '2023-07-11 13:38:19', '2023-07-11 13:38:19', '2023-07-11', '', '23-04668-07-11', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 140.44, 0, '0000-00-00 00:00:00', '', '', 1, 4, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3491, 1, 880, 2, 0, NULL, 0, '2023-07-11 15:26:10', '2023-07-12 09:10:40', '2023-07-11', 'P3276', '23-04669-07-11', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'San Martín nº 5, 2', 'Donostia-San Sebasti', 'Gipuzkoa', '20005', 'España', 30.61, 0, '2023-07-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110723-PQqPmWDFDr4Na-255', 'f2679b33-5773-4d5c-bfd0-0c90f41415d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110723-PQqPmWDFDr4Na-255&s=KOL2023&nf=P3276&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);
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
(3492, 1, 694, 2, 0, NULL, 0, '2023-07-12 08:10:45', '2023-07-12 10:34:34', '2023-07-12', 'P3277', '23-04670-07-12', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'DICES 33', 'Rois', 'A Coruña', '15911', 'España', 17.50, 0, '2023-07-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120723-L6LH8S9UGVDpq-027', '96f0abbb-31ba-4a44-be85-65d5a28ab295', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-L6LH8S9UGVDpq-027&s=KOL2023&nf=P3277&i=17.50&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3493, 1, 67, 2, 0, NULL, 0, '2023-07-12 08:26:10', '2023-07-12 10:38:39', '2023-07-12', 'P3278', '23-04671-07-12', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 344.85, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120723-Qqt7TWhlHJ2SD-011', '2bebba25-1640-40eb-a3a4-dcf7c5ef9a83', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-Qqt7TWhlHJ2SD-011&s=KOL2023&nf=P3278&i=344.85&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3494, 1, 576, 2, 0, NULL, 0, '2023-07-12 08:41:13', '2023-07-12 10:44:04', '2023-07-12', 'P3279', '23-04672-07-12', 'Si no estuviéramos en casa dejar en el buzón si entra y si no al portero de las finca !!! Muchas gracias.', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Silicio 32 escalera derecha 1 D ', 'Torrejón de Ardoz', 'Madrid', '28850', 'España', 30.61, 0, '2023-07-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120723-jDutAfGaNLZWv-049', '37cd723c-c1eb-409c-b112-c3217134b266', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-jDutAfGaNLZWv-049&s=KOL2023&nf=P3279&i=30.61&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3495, 1, 566, 2, 0, NULL, 0, '2023-07-12 09:49:47', '2023-07-12 11:54:46', '2023-07-12', 'P3280', '23-04673-07-12', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 310.37, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120723-Lwiq4J/XPVGhC-167', '98615105-773c-4e95-b985-e23aa3e8e388', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-Lwiq4J%2FXPVGhC-167&s=KOL2023&nf=P3280&i=310.37&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3496, 1, 172, 2, 0, NULL, 0, '2023-07-12 10:22:52', '2023-07-12 12:27:53', '2023-07-12', 'P3281', '23-04674-07-12', '', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'Font de Caps, 50', 'Talarn', 'Lleida', '25630', 'España', 133.00, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120723-f4rKXNklYE5pk-023', 'b76303ba-0f38-42fe-8aec-478a008c4ee0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-f4rKXNklYE5pk-023&s=KOL2023&nf=P3281&i=133.00&cr=247', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3497, 1, 102, 2, 0, NULL, 0, '2023-07-12 10:42:34', '2023-07-12 12:46:45', '2023-07-12', 'P3282', '23-04675-07-12', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Riera Lledoners numero 66l', 'Canet de Mar', 'Barcelona', '08360', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-120723-OU0EdBKVMrFxY-114', 'f015bcb0-1f5b-41d7-8336-473a146ee819', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-OU0EdBKVMrFxY-114&s=KOL2023&nf=P3282&i=71.47&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
