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
(3263, 1, 528, 2, 0, NULL, 0, '2023-05-31 06:44:58', '2023-05-31 09:10:36', '2023-05-31', 'P3078', '23-04393-05-31', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Ibaizabal 6-1 Ctro', 'Getxo', 'Bizkaia', '48991', 'España', 16.29, 0, '2023-05-31 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-310523-K9YDJaenZ7sO/-128', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310523-K9YDJaenZ7sO%2F-128&s=KOL2023&nf=P3078&i=16.29&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3264, 1, 821, 2, 0, NULL, 0, '2023-05-31 08:38:35', '2023-05-31 10:44:57', '2023-05-31', 'P3079', '23-04394-05-31', '', 0.00, 43.30, 9.86, 0.00, 0, 0.00, 4.40, 'gurutzeaga 9 bajo, 72438407e', 'Zestoa', 'Gipuzkoa', '20740', 'España', 56.79, 0, '2023-05-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310523-BvPkjp3xr1AEq-171', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310523-BvPkjp3xr1AEq-171&s=KOL2023&nf=P3079&i=56.79&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3265, 1, 634, 2, 0, NULL, 0, '2023-05-31 11:24:24', '2023-06-01 09:06:17', '2023-05-31', 'P3080', '23-04403-05-31', 'Después de las 3,, en caso de no estar tirar el paquete al jardin. Gracias', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Río Duero 52 ; urb el soto', 'Aldeamayor de San Ma', 'Valladolid', '47162', 'España', 40.08, 0, '2023-05-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310523-oFwBJMDCRBMzV-234', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310523-oFwBJMDCRBMzV-234&s=KOL2023&nf=P3080&i=40.08&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3266, 1, 120, 2, 0, NULL, 0, '2023-05-31 16:36:24', '2023-06-01 09:14:02', '2023-05-31', 'P3081', '23-04404-05-31', '', 0.00, 100.30, 21.06, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 121.36, 0, '2023-05-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310523-NSXvMKTN9gWJf-165', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310523-NSXvMKTN9gWJf-165&s=KOL2023&nf=P3081&i=121.36&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3267, 1, 592, 2, 0, NULL, 0, '2023-05-31 17:34:35', '2023-06-01 09:19:00', '2023-05-31', 'P3082', '23-04405-05-31', 'LLAMAR ANTES DE ENTREGA', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'C/ SILVA 17 3-D', 'Madrid', 'Madrid', '28004', 'España', 16.29, 0, '2023-05-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310523-CfoYrSAuTjMbm-025', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310523-CfoYrSAuTjMbm-025&s=KOL2023&nf=P3082&i=16.29&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3268, 1, 162, 2, 0, NULL, 0, '2023-05-31 17:51:20', '2023-06-01 09:21:54', '2023-05-31', 'P3083', '23-04406-05-31', 'Entregar en horario de mañana de 10 a 14h.', 0.00, 152.10, 31.94, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 184.04, 0, '2023-05-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310523-doVVRIxpvcn1i-242', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310523-doVVRIxpvcn1i-242&s=KOL2023&nf=P3083&i=184.04&cr=087', '[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
(3269, 1, 822, 2, 0, NULL, 0, '2023-05-31 20:28:49', '2023-06-01 09:26:30', '2023-05-31', 'P3084', '23-04407-05-31', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Calle caballero de la Rosa 56', 'Logroño', 'La Rioja', '26004', 'España', 59.47, 0, '2023-05-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310523-ozI505tJj2PlL-220', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310523-ozI505tJj2PlL-220&s=KOL2023&nf=P3084&i=59.47&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3270, 1, 663, 2, 0, NULL, 0, '2023-05-31 22:16:49', '2023-06-01 09:30:09', '2023-05-31', 'P3085', '23-04408-05-31', 'Si la cooperativa está cerrada, llamar por teléfono por favor.', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Través San Isidro 1 (cooperativa)', 'Artajona', 'Navarra', '31140', 'España', 40.08, 0, '2023-05-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310523-ckVN+2iFP/3g3-196', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310523-ckVN%2B2iFP%2F3g3-196&s=KOL2023&nf=P3085&i=40.08&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3271, 1, 172, 2, 0, NULL, 0, '2023-06-01 07:50:43', '2023-06-01 10:11:51', '2023-06-01', 'P3086', '23-04409-06-01', '', 0.00, 64.40, 13.52, 0.00, 0, 0.00, 0.00, 'Soldevila, 6 baixos', 'Tremp', 'Lleida', '25620', 'España', 77.92, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010623-gmyOjD9Dk+SBC-116', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010623-gmyOjD9Dk%2BSBC-116&s=KOL2023&nf=P3086&i=77.92&cr=075', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3272, 1, 57, 2, 0, NULL, 0, '2023-06-01 09:01:30', '2023-06-01 11:20:33', '2023-06-01', 'P3087', '23-04410-06-01', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 344.85, 0, '2023-06-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010623-W3GPeqVHO8SI7-013', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010623-W3GPeqVHO8SI7-013&s=KOL2023&nf=P3087&i=344.85&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3273, 1, 192, 2, 0, NULL, 0, '2023-06-01 09:13:00', '2023-06-01 11:24:23', '2023-06-01', 'P3088', '23-04411-06-01', '', 0.00, 64.40, 13.52, 0.00, 0, 0.00, 0.00, 'plaza San Cristobal 3,bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 77.92, 0, '2023-06-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010623-EMprycTzz/w/u-158', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010623-EMprycTzz%2Fw%2Fu-158&s=KOL2023&nf=P3088&i=77.92&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3274, 1, 40, 2, 0, NULL, 0, '2023-06-01 10:15:44', '2023-06-01 12:19:59', '2023-06-01', 'P3089', '23-04412-06-01', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 103.46, 0, '2023-06-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010623-dnIuXNN2Sfkfb-172', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010623-dnIuXNN2Sfkfb-172&s=KOL2023&nf=P3089&i=103.46&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3275, 1, 190, 3, 0, NULL, 0, '2023-06-01 12:23:20', '2023-06-01 12:23:34', '2023-06-01', '', '2023-06-01', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 34.48, 0, '2023-06-01 00:00:00', '', '', 1, 1, 1, '', '', '', '', 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
(3276, 1, 794, 2, 0, NULL, 0, '2023-06-01 17:39:53', '2023-06-02 08:46:45', '2023-06-01', 'P3090', '23-04413-06-01', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'Idoia 4 bajo', 'Zizur Mayor/Zizur Na', 'Navarra', '31180', 'España', 551.76, 0, '2023-06-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010623-RgXCRPxp2GkFw-164', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010623-RgXCRPxp2GkFw-164&s=KOL2023&nf=P3090&i=551.76&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3277, 1, 618, 2, 0, NULL, 0, '2023-06-01 17:49:23', '2023-06-02 08:49:17', '2023-06-01', 'P3091', '23-04415-06-01', '', 0.00, 54.54, 11.45, 0.00, 0, 0.00, 0.00, 'Calle domenec sugrañes y gras n6 bajo7', 'Salou', 'Tarragona', '43840', 'España', 65.99, 0, '2023-06-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-010623-mA4bgUuO7xPhH-207', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010623-mA4bgUuO7xPhH-207&s=KOL2023&nf=P3091&i=65.98&cr=089', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3278, 1, 708, 2, 0, NULL, 0, '2023-06-01 20:26:29', '2023-06-02 08:50:08', '2023-06-01', 'P3092', '23-04416-06-01', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'Calle Emigrantes, 14, 6 C', 'Madrid', 'Madrid', '28043', 'España', 55.89, 0, '2023-06-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010623-OUY3DJFW4RF5/-142', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010623-OUY3DJFW4RF5%2F-142&s=KOL2023&nf=P3092&i=55.89&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3279, 1, 3, 1, 0, NULL, 0, '2023-06-02 08:54:31', '2023-06-02 10:32:24', '2023-06-02', 'P3093', '2023-06-02', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'C/ PINTOR AURELIO VIRAFAJARDO Nº2 B', 'VITORIA', 'ÁLAVA', '01008', 'España', 413.82, 0, '2023-06-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020623-CURTN6IpOp36R-141', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020623-CURTN6IpOp36R-141&s=KOL2023&nf=P3093&i=413.82&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3280, 1, 525, 2, 0, NULL, 0, '2023-06-02 10:29:55', '2023-06-02 12:42:06', '2023-06-02', 'P3094', '23-04417-06-02', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Paseo del Prior 73 3B ', 'Logroño', 'La Rioja', '26004', 'España', 28.19, 0, '2023-06-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020623-HO1ZUT2axuhMV-001', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020623-HO1ZUT2axuhMV-001&s=KOL2023&nf=P3094&i=28.19&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3281, 1, 823, 2, 0, NULL, 0, '2023-06-02 11:28:23', '2023-06-02 13:35:50', '2023-06-02', 'P3095', '23-04419-06-02', 'Solo deje el envío al conserje o en la\r\nMisma casa.\r\nTengo una vecina que roba los paquetes ', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Calle Del Marqués De Mondéjar 16, 2A', 'Madrid', 'Madrid', '28028', 'España', 28.19, 0, '2023-06-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020623-Kd9FN41QySlM2-137', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020623-Kd9FN41QySlM2-137&s=KOL2023&nf=P3095&i=28.19&cr=060', '[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
(3282, 1, 824, 2, 0, NULL, 0, '2023-06-02 15:29:38', '2023-06-05 08:56:24', '2023-06-02', 'P3096', '23-04420-06-02', 'El telefonillo no va bien. Llamar al 666765576. Gracias!', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Calle Tafalla 3, 1° B', 'Olite', 'Navarra', '31390', 'España', 28.19, 0, '2023-06-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020623-IhIvMRNd19cHW-043', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020623-IhIvMRNd19cHW-043&s=KOL2023&nf=P3096&i=28.19&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3283, 1, 825, 2, 0, NULL, 0, '2023-06-03 08:21:01', '2023-06-05 09:00:03', '2023-06-03', 'P3097', '23-04423-06-03', 'Óptica San Mateo ', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'C/ San Mateo,24 bajo', 'Alicante/Alacant', 'Alicante', '03013', 'España', 16.29, 0, '2023-06-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030623-AJXXED4rSqNBQ-208', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030623-AJXXED4rSqNBQ-208&s=KOL2023&nf=P3097&i=16.29&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3284, 1, 67, 2, 0, NULL, 0, '2023-06-03 09:35:56', '2023-06-05 09:41:21', '2023-06-03', 'P3098', '23-04424-06-03', '', 0.00, 349.40, 73.37, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 422.77, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030623-mMqtfVggPrZCJ-036', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030623-mMqtfVggPrZCJ-036&s=KOL2023&nf=P3098&i=422.77&cr=092', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3285, 1, 490, 2, 0, NULL, 0, '2023-06-03 09:54:25', '2023-06-05 09:04:07', '2023-06-03', 'P3099', '23-04425-06-03', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Aiotzategi Kalea 11 - 1F', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 28.19, 0, '2023-06-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030623-HQE0B3KFkB/Gx-187', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030623-HQE0B3KFkB%2FGx-187&s=KOL2023&nf=P3099&i=28.19&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3286, 1, 270, 2, 0, NULL, 0, '2023-06-03 12:08:53', '2023-06-05 09:06:47', '2023-06-03', 'P3100', '23-04426-06-03', '', 0.00, 28.01, 6.65, 0.00, 0, 0.00, 4.40, 'Juan Bautista Zabala 9 (Comercio Gaurko)', 'Getxo', 'Bizkaia', '48991', 'España', 38.29, 0, '2023-06-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030623-DSx6Lcsfq7UNs-214', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030623-DSx6Lcsfq7UNs-214&s=KOL2023&nf=P3100&i=38.29&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3287, 1, 826, 2, 0, NULL, 0, '2023-06-03 20:47:56', '2023-06-05 09:10:19', '2023-06-03', 'P3101', '23-04427-06-03', 'Preferentemente la entrega en horario de mañanas. En ausencia, dejarlo bajo el felpudo de la puerta C del piso 4. Bajo mi responsabilidad, nunca desaparece nada. Muchas gracias. Larraitz', 0.00, 39.32, 9.02, 0.00, 0, 0.00, 4.40, 'Calle Gelasio Aramburu 3, 4C', 'Pasaia', 'Gipuzkoa', '20110', 'España', 51.98, 0, '2023-06-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030623-ZPS5OzxXiy048-203', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030623-ZPS5OzxXiy048-203&s=KOL2023&nf=P3101&i=51.98&cr=066', '[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
(3288, 1, 827, 2, 0, NULL, 0, '2023-06-04 15:57:32', '2023-06-05 09:20:30', '2023-06-04', 'P3102', '23-04428-06-04', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Francia 41 6C', 'Vitoria-Gasteiz', 'Álava', '01002', 'España', 16.29, 0, '2023-06-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040623-gUB+zS/WhSPpk-174', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040623-gUB%2BzS%2FWhSPpk-174&s=KOL2023&nf=P3102&i=16.29&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3289, 1, 571, 2, 0, NULL, 0, '2023-06-04 21:43:22', '2023-06-05 09:26:28', '2023-06-04', 'P3103', '23-04429-06-04', '', 0.00, 36.36, 8.40, 0.00, 0, 0.00, 4.40, 'AMAROZ 30. 1B', 'Tolosa', 'Gipuzkoa', '20400', 'España', 48.40, 0, '2023-06-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040623-S0V92TpOY8LEg-154', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040623-S0V92TpOY8LEg-154&s=KOL2023&nf=P3103&i=48.40&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3290, 1, 828, 2, 0, NULL, 0, '2023-06-05 05:12:00', '2023-06-05 09:28:56', '2023-06-05', 'P3104', '23-04430-06-05', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Avenida Carlos I 1 7A', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 16.29, 0, '2023-06-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050623-kJCL1p038EdkN-143', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050623-kJCL1p038EdkN-143&s=KOL2023&nf=P3104&i=16.29&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3291, 1, 190, 3, 0, NULL, 0, '2023-06-05 09:36:53', '2023-06-05 09:36:53', '2023-06-05', '', '2023-06-05', '', 0.00, 64.40, 13.52, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 77.92, 0, '2023-06-05 00:00:00', '', '', 1, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3292, 1, 696, 1, 0, NULL, 0, '2023-06-05 10:24:17', '2023-06-05 10:24:17', '2023-06-05', 'P3105', '2023-06-05', '', 0.00, 390.00, 81.90, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 471.90, 0, '2023-06-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050623-D1RW0ufDucKIr-118', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050623-D1RW0ufDucKIr-118&s=KOL2023&nf=P3105&i=471.90&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3293, 1, 829, 2, 0, NULL, 0, '2023-06-05 12:04:47', '2023-06-06 09:37:22', '2023-06-05', 'P3106', '23-04431-06-05', 'Tienda de tattoos', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Plaza Iralabarri 1 bajo', 'Aretxabaleta', 'Gipuzkoa', '20550', 'España', 16.29, 0, '2023-06-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050623-fpcFSr7fw/6TZ-111', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050623-fpcFSr7fw%2F6TZ-111&s=KOL2023&nf=P3106&i=16.29&cr=184', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3294, 1, 337, 2, 0, NULL, 0, '2023-06-05 16:46:51', '2023-06-06 09:42:26', '2023-06-05', 'P3107', '23-04432-06-05', '', 0.00, 66.60, 13.99, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 80.59, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050623-mZFDrcF/O3wfH-078', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050623-mZFDrcF%2FO3wfH-078&s=KOL2023&nf=P3107&i=80.59&cr=121', '[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
(3295, 1, 830, 2, 0, NULL, 0, '2023-06-05 21:36:53', '2023-06-06 09:56:25', '2023-06-05', 'P3108', '23-04433-06-05', 'Si el repartidor no me encuentra en casa, puede dejar el paquete en la frutería de debajo del portal (Frutería Logroño). Muchas gracias.', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'C/ Rosa Chacel, 26, 3C', 'Logroño', 'La Rioja', '26007', 'España', 40.08, 0, '2023-06-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050623-cXw5agEkhKPjb-010', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050623-cXw5agEkhKPjb-010&s=KOL2023&nf=P3108&i=40.08&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3296, 1, 831, 2, 0, NULL, 0, '2023-06-05 21:46:26', '2023-06-06 10:01:07', '2023-06-05', 'P3109', '23-04434-06-05', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Barrio Menocal p22', 'Polanco', 'Cantabria', '39313', 'España', 28.19, 0, '2023-06-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050623-f+f+CgGar9yyj-232', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050623-f%2Bf%2BCgGar9yyj-232&s=KOL2023&nf=P3109&i=28.19&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3297, 1, 832, 2, 0, NULL, 0, '2023-06-06 07:13:25', '2023-06-06 10:03:36', '2023-06-06', 'P3110', '23-04435-06-06', 'Horario de lunes a jueves \r\nDe 10.00 a 13.00 \r\nDe 16.00 a 20.00', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Cami capellans 18- 20, Planta baja clínica dental', 'Sitges', 'Barcelona', '08870', 'España', 26.40, 0, '2023-06-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060623-ZXzZ5laNUWOZS-018', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060623-ZXzZ5laNUWOZS-018&s=KOL2023&nf=P3110&i=26.40&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3298, 1, 833, 2, 0, NULL, 0, '2023-06-06 09:01:21', '2023-06-06 11:14:13', '2023-06-06', 'P3111', '23-04436-06-06', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Rambla nova 84', 'Tarragona', 'Tarragona', '43003', 'España', 16.29, 0, '2023-06-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060623-PNSNI2J3FFHMs-098', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060623-PNSNI2J3FFHMs-098&s=KOL2023&nf=P3111&i=16.29&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3299, 1, 253, 2, 0, NULL, 0, '2023-06-06 10:45:18', '2023-06-06 12:46:21', '2023-06-06', 'P3112', '23-04437-06-06', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'camino del molino sn', 'Villamayor de Gálleg', 'Zaragoza', '50162', 'España', 28.19, 0, '2023-06-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-060623-bJmWpZguOKQNk-109', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060623-bJmWpZguOKQNk-109&s=KOL2023&nf=P3112&i=28.19&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3300, 1, 523, 2, 0, NULL, 0, '2023-06-06 11:13:48', '2023-06-07 13:10:24', '2023-06-06', 'P3113', '23-04438-06-06', '', 0.00, 28.50, 6.74, 0.00, 1, 1.67, 4.40, 'Avda Alonso Martín 7, local C', 'Don Benito', 'Badajoz', '06400', 'España', 40.55, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060623-VTCF1050Idthe-120', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060623-VTCF1050Idthe-120&s=KOL2023&nf=P3113&i=38.89&cr=030', '[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
(3301, 1, 75, 2, 0, NULL, 0, '2023-06-07 06:25:49', '2023-06-07 09:42:09', '2023-06-07', 'P3114', '23-04439-06-07', 'Horario de martes a viernes de 10:00 a 19:00', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 68.97, 0, '2023-06-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070623-ELap69oC4bkTz-113', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070623-ELap69oC4bkTz-113&s=KOL2023&nf=P3114&i=68.97&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3302, 1, 115, 2, 0, NULL, 0, '2023-06-07 06:56:27', '2023-06-07 09:45:54', '2023-06-07', 'P3115', '23-04440-06-07', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'MONASTERIO DE URDAX NR. 38', 'Pamplona/Iruña', 'Navarra', '31011', 'España', 172.43, 0, '2023-06-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070623-kSNkpJyCUrQaE-014', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070623-kSNkpJyCUrQaE-014&s=KOL2023&nf=P3115&i=172.43&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3303, 1, 834, 2, 0, NULL, 0, '2023-06-07 07:14:30', '2023-06-07 09:49:49', '2023-06-07', 'P3116', '23-04442-06-07', 'Dejo tel. Fijo del lugar de entrega 93 633 08 18', 0.00, 36.36, 8.40, 0.00, 0, 0.00, 4.40, 'Av.de Europa,103 Esc.1 Puerta 2', 'Gavà', 'Barcelona', '08850', 'España', 48.40, 0, '2023-06-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070623-RdrQ903nQJKaR-066', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070623-RdrQ903nQJKaR-066&s=KOL2023&nf=P3116&i=48.40&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3304, 1, 835, 2, 0, NULL, 0, '2023-06-07 07:44:54', '2023-06-07 10:21:47', '2023-06-07', 'P3117', '23-04443-06-07', '', 0.00, 54.54, 11.45, 0.00, 0, 0.00, 0.00, 'Rúa San Roque, Portal 19, piso 4B', 'Ponteareas', 'Pontevedra', '36860', 'España', 65.99, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070623-E1ClCnqpKYbzm-100', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070623-E1ClCnqpKYbzm-100&s=KOL2023&nf=P3117&i=65.98&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3305, 1, 131, 2, 0, NULL, 0, '2023-06-07 08:16:52', '2023-06-07 11:12:46', '2023-06-07', 'P3118', '23-04444-06-07', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070623-k65tbEYHLXldG-024', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070623-k65tbEYHLXldG-024&s=KOL2023&nf=P3118&i=68.97&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3306, 1, 65, 2, 0, NULL, 0, '2023-06-07 10:18:19', '2023-06-07 12:35:04', '2023-06-07', 'P3119', '23-04446-06-07', '', 0.00, 798.00, 167.58, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '8008', 'ESPAÑA', 965.58, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070623-WjRu3WipDkmUP-122', 'd8adfb52-3c80-4de8-9945-7bd2e6d0a539', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070623-WjRu3WipDkmUP-122&s=KOL2023&nf=P3119&i=965.58&cr=110', '[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
(3307, 1, 174, 2, 0, NULL, 0, '2023-06-08 08:35:58', '2023-06-08 10:38:25', '2023-06-08', 'P3120', '23-04447-06-07', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 206.91, 0, '2023-06-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080623-ox1UDwqPkstaD-099', 'a3279014-49e0-43cf-ab39-29bc39c0cbd6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-ox1UDwqPkstaD-099&s=KOL2023&nf=P3120&i=206.91&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3308, 1, 568, 2, 0, NULL, 0, '2023-06-08 08:36:36', '2023-06-08 10:42:46', '2023-06-08', 'P3121', '23-04448-06-07', 'peluquería el marco blanco', 0.00, 71.80, 15.08, 0.00, 0, 0.00, 0.00, 'larramendi 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 86.88, 0, '2023-06-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080623-lcWb5k9Co9WpW-032', '13cc5d0a-e631-4ab0-8b72-6364b564943c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-lcWb5k9Co9WpW-032&s=KOL2023&nf=P3121&i=86.88&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3309, 1, 17, 2, 0, NULL, 0, '2023-06-08 08:36:46', '2023-06-08 10:47:53', '2023-06-08', 'P3122', '23-04449-06-07', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 137.94, 0, '2023-06-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080623-jARo1dVFyrEur-152', 'ca257c4c-b3da-401d-833b-50422b0922ae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-jARo1dVFyrEur-152&s=KOL2023&nf=P3122&i=137.94&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3310, 1, 137, 2, 0, NULL, 0, '2023-06-08 08:37:25', '2023-06-08 11:07:44', '2023-06-08', 'P3123', '23-04450-06-07', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Pº ERMITA, 10', 'Madrid', 'Madrid', '28023', 'España', 241.40, 0, '2023-06-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080623-Z8ucWuh/9oDyZ-011', '9c4e0cdf-87a3-4059-af96-66d2d2ff7e6e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-Z8ucWuh%2F9oDyZ-011&s=KOL2023&nf=P3123&i=241.40&cr=158', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3311, 1, 687, 1, 0, NULL, 0, '2023-06-08 10:51:30', '2023-06-08 10:51:30', '2023-06-08', '', '2023-06-08', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 103.46, 0, '2023-06-08 00:00:00', '', '', 1, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3312, 1, 687, 1, 0, NULL, 0, '2023-06-08 10:56:40', '2023-06-08 10:56:40', '2023-06-08', '', '2023-06-08', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 103.46, 0, '2023-06-08 00:00:00', '', '', 1, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3313, 1, 687, 1, 0, NULL, 0, '2023-06-08 10:58:13', '2023-06-08 10:58:13', '2023-06-08', '', '2023-06-08', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 103.46, 0, '2023-06-08 00:00:00', '', '', 1, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3314, 1, 687, 1, 0, NULL, 0, '2023-06-08 11:00:56', '2023-06-08 11:00:56', '2023-06-08', 'P3124', '2023-06-08', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 103.46, 0, '2023-06-08 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080623-Fb0O+9bqzEMdt-214', 'a83b0bd0-1e52-4a8a-858e-daa3bb88fef4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-Fb0O%2B9bqzEMdt-214&s=KOL2023&nf=P3124&i=103.46&cr=208', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3315, 1, 765, 2, 1, 'Rectificativa por pedido duplicado', 3060, '2023-06-08 11:31:06', '2023-06-08 11:31:06', '2023-06-08', 'R38', 'P2882 RECT.', '', 0.00, 230.20, 48.78, 0.00, 0, 0.00, 2.50, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 281.04, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-080623-Fvpc8iTYjyfJt-007', '0b49025f-5e54-4e91-ae0e-7dbdd5fe5207', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-Fvpc8iTYjyfJt-007&s=KOL2023&nf=R38&i=-281.04&cr=054', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(3316, 1, 601, 2, 1, 'Rectificativa por pago de más mediante transferencia', 3220, '2023-06-08 12:01:57', '2023-06-08 12:01:57', '2023-06-08', 'R39', 'P3038 RECT.', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'KAMIÑAZPI, 61-3 DCHA', 'Ondarroa', 'Bizkaia', '48700', 'España', 59.47, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-080623-l0s9rvvqVKiVs-071', 'e258c826-6eb3-4071-83ec-583b946d2e32', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-l0s9rvvqVKiVs-071&s=KOL2023&nf=R39&i=-59.47&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3317, 1, 836, 2, 0, NULL, 0, '2023-06-08 11:14:20', '2023-06-08 13:15:30', '2023-06-08', 'P3125', '23-04451-06-08', 'Lla', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Das devesas 1 3B', 'Pontevedra', 'Pontevedra', '36004', 'España', 16.29, 0, '2023-06-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080623-VcRM2mfMx7bvO-104', 'd2bbe70d-4e3f-452b-998d-e6d1c261f12a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-VcRM2mfMx7bvO-104&s=KOL2023&nf=P3125&i=16.29&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3318, 1, 236, 2, 0, NULL, 0, '2023-06-08 12:20:27', '2023-06-09 09:23:00', '2023-06-08', 'P3126', '23-04452-06-08', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'Avda. de la Policía Nacional. Edf. D. Ives, 24', 'Antequera', 'Málaga', '29200', 'España', 620.73, 0, '2023-06-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080623-fvfh1RsIqm4QQ-105', '2ff6bfd7-63fb-42bc-966e-ff4a4ed00f19', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-fvfh1RsIqm4QQ-105&s=KOL2023&nf=P3126&i=620.73&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3319, 1, 155, 2, 0, NULL, 0, '2023-06-08 12:24:43', '2023-06-09 10:12:38', '2023-06-08', 'P3132', '23-04453-06-08', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080623-Cu/eDKbmvR/mH-011', '3cf05a04-5966-444d-8434-e62418d10cfc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-Cu%2FeDKbmvR%2FmH-011&s=KOL2023&nf=P3132&i=275.88&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3320, 1, 837, 2, 0, NULL, 0, '2023-06-08 14:13:11', '2023-06-09 09:30:35', '2023-06-08', 'P3127', '23-04454-06-08', 'También se puede entregar el pedido en el 1ºB o en el 6ºC (avisarme primero)', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'C/ Virgen de África 29, 5ºB', 'Madrid', 'Madrid', '28027', 'España', 28.19, 0, '2023-06-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080623-npKjEJeoYscFZ-207', '5ca171c3-d7ae-416f-a372-80ae6d8d94de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-npKjEJeoYscFZ-207&s=KOL2023&nf=P3127&i=28.19&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3321, 1, 522, 2, 0, NULL, 0, '2023-06-08 16:07:11', '2023-06-09 09:35:29', '2023-06-08', 'P3128', '23-04455-06-08', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 275.88, 0, '2023-06-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080623-EamqV+q0y58cH-211', 'e178d872-e5fd-43b0-aab2-9b8a19eabbb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-EamqV%2Bq0y58cH-211&s=KOL2023&nf=P3128&i=275.88&cr=227', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
