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
(3322, 1, 193, 2, 0, NULL, 0, '2023-06-08 18:59:48', '2023-06-09 09:39:00', '2023-06-08', 'P3129', '23-04456-06-08', 'Peluqería', 0.00, 109.08, 22.91, 0.00, 0, 0.00, 0.00, 'Ubitarte 6', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 131.99, 0, '2023-06-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080623-kK4AEQbAUU2Xo-037', 'e0581346-1c7c-4cd1-abe0-b14c06e86bf9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080623-kK4AEQbAUU2Xo-037&s=KOL2023&nf=P3129&i=131.99&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3323, 1, 672, 2, 0, NULL, 0, '2023-06-09 05:30:44', '2023-06-09 09:49:16', '2023-06-09', 'P3130', '23-04457-06-09', '', 0.00, 72.72, 15.27, 0.00, 0, 0.00, 0.00, 'México kalea 10, 7 B', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 87.99, 0, '2023-06-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090623-jEkp1cEtE/4BH-016', 'c2247faf-254d-4be3-931e-f9c2179d125b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090623-jEkp1cEtE%2F4BH-016&s=KOL2023&nf=P3130&i=87.99&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3324, 1, 155, 2, 0, NULL, 0, '2023-06-09 07:20:47', '2023-06-09 07:20:47', '2023-06-09', '', '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', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(3325, 1, 389, 2, 0, NULL, 0, '2023-06-09 07:47:05', '2023-06-09 10:46:23', '2023-06-09', 'P3131', '23-04458-06-09', '', 0.00, 35.41, 8.20, 0.00, 0, 0.00, 4.40, 'Aldea de Lamas 81', 'Padrón', 'A Coruña', '15910', 'España', 47.25, 0, '2023-06-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090623-e9iYs9O6qABA1-215', '5a8daa64-e55c-4962-9058-0ec64ad1082c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090623-e9iYs9O6qABA1-215&s=KOL2023&nf=P3131&i=50.19&cr=074', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3326, 1, 392, 2, 0, NULL, 0, '2023-06-09 08:20:46', '2023-06-09 10:39:15', '2023-06-09', 'P3133', '23-04459-06-09', 'por favor, que llame el repartidor antes de venir para asegurar que estoy en casa. ', 0.00, 28.01, 6.65, 0.00, 0, 0.00, 4.40, 'carrer la font, 29', 'Sagra', 'Alicante', '03795', 'España', 38.29, 0, '2023-06-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090623-oKp0HTWNN28ZG-150', 'b13f5daa-8ade-4e1a-8435-8cb553804f20', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090623-oKp0HTWNN28ZG-150&s=KOL2023&nf=P3133&i=38.29&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3327, 1, 43, 2, 0, NULL, 0, '2023-06-09 15:46:44', '2023-06-12 08:59:13', '2023-06-09', 'P3134', '23-04461-06-09', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Nagusia 5', 'Tolosa', 'Gipuzkoa', '20400', 'España', 206.91, 0, '2023-06-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090623-a/vwjkLEaN21P-015', '28f55141-bcb8-442f-a5eb-1e1dbf1211b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090623-a%2FvwjkLEaN21P-015&s=KOL2023&nf=P3134&i=206.91&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3328, 1, 4, 2, 0, NULL, 0, '2023-06-09 17:53:08', '2023-06-12 09:01:46', '2023-06-09', 'P3135', '23-04462-06-09', '', 0.00, 400.10, 84.02, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 484.12, 0, '2023-06-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090623-Ot4+T33LVcSjg-095', '61d0b0a9-5160-47ca-b777-2ef551fb84f4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090623-Ot4%2BT33LVcSjg-095&s=KOL2023&nf=P3135&i=484.12&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
(3329, 1, 668, 2, 0, NULL, 0, '2023-06-10 18:19:12', '2023-06-12 09:04:11', '2023-06-10', 'P3136', '23-04463-06-10', '', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Plaza del boulevard del cream casa 4 puerto sherry ', 'Puerto de Santa Marí', 'Cádiz', '11500', 'España', 40.08, 0, '2023-06-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100623-bpBt7fA1BhWP/-074', '274bdf05-106e-4a2f-86a9-4232aeb29b1f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100623-bpBt7fA1BhWP%2F-074&s=KOL2023&nf=P3136&i=40.08&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3330, 1, 324, 2, 0, NULL, 0, '2023-06-12 05:35:36', '2023-06-12 09:05:48', '2023-06-12', 'P3137', '23-04464-06-12', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'C/Martinez Izquierdo 84, 2º dc', 'Madrid', 'Madrid', '28028', 'España', 55.89, 0, '2023-06-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120623-VmiaZkSh3G6v3-126', '6774fbbf-6752-42ef-a306-1cb4743dd8c9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120623-VmiaZkSh3G6v3-126&s=KOL2023&nf=P3137&i=55.89&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3331, 1, 77, 1, 0, NULL, 0, '2023-06-12 13:57:24', '2023-06-12 13:57:24', '2023-06-12', 'P3138', '2023-06-12', '', 0.00, 760.50, 159.70, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 920.20, 0, '2023-06-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120623-Btz9cdshMVAGX-237', '0b2d6680-ffa7-4664-b33a-0f259d8b85c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120623-Btz9cdshMVAGX-237&s=KOL2023&nf=P3138&i=920.20&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3332, 1, 838, 2, 0, NULL, 0, '2023-06-12 12:53:26', '2023-06-13 08:58:29', '2023-06-12', 'P3139', '23-04465-06-12', 'En caso de ausencia entregar a conserje', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Gaztañeta 1, 2d', 'Bilbao', 'Bizkaia', '48010', 'España', 26.40, 0, '2023-06-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120623-kyfTjcfWOUw+v-138', '05d8de57-5966-422d-82ee-d41cb47bbdde', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120623-kyfTjcfWOUw%2Bv-138&s=KOL2023&nf=P3139&i=26.40&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3333, 1, 386, 2, 0, NULL, 0, '2023-06-12 14:35:24', '2023-06-13 09:02:40', '2023-06-12', 'P3140', '23-04466-06-12', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Calle getaria 21 bajo (lekuona)', 'Donostia-San Sebasti', 'Gipuzkoa', '20005', 'España', 59.47, 0, '2023-06-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120623-MlXw1vyqEnF+W-087', '81e11a84-bbb5-439e-9719-76a41c5c077d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120623-MlXw1vyqEnF%2BW-087&s=KOL2023&nf=P3140&i=59.47&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3334, 1, 533, 2, 0, NULL, 0, '2023-06-12 16:46:00', '2023-06-13 09:06:20', '2023-06-12', 'P3141', '23-04467-06-12', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Clara campoamor, num 2 esc. C  1-4', 'Gavà', 'Barcelona', '08850 ', 'España', 28.19, 0, '2023-06-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120623-G1NnVbEZMGRX8-120', '9a916bd7-f0e7-4875-9f64-8e9cd251318c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120623-G1NnVbEZMGRX8-120&s=KOL2023&nf=P3141&i=28.19&cr=252', '[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
(3335, 1, 839, 2, 0, NULL, 0, '2023-06-12 18:09:43', '2023-06-13 09:08:50', '2023-06-12', 'P3142', '23-04468-06-12', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'AVDA. NACIONES UNIDAS 7 3ºA', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 26.40, 0, '2023-06-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120623-QwmSvbUy0GfW3-200', 'bf76204d-6e2e-4acd-8787-721fd9ede586', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120623-QwmSvbUy0GfW3-200&s=KOL2023&nf=P3142&i=26.40&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3336, 1, 840, 2, 0, NULL, 0, '2023-06-12 19:52:29', '2023-06-13 09:11:11', '2023-06-12', 'P3143', '23-04469-06-12', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Correo 11-2D', 'Tolosa', 'Gipuzkoa', '20400', 'España', 16.29, 0, '2023-06-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120623-g9Hqvk0dK40dr-203', '1a8d20c0-2573-4982-9c28-3b434a5e6bc5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120623-g9Hqvk0dK40dr-203&s=KOL2023&nf=P3143&i=16.29&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3337, 1, 347, 2, 0, NULL, 0, '2023-06-13 06:42:24', '2023-06-13 09:13:56', '2023-06-13', 'P3144', '23-04470-06-13', 'Por favor, llamar antes de entregar.', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'C/Coruña, 56 - 2ºIzquierda', 'Vigo', 'Pontevedra', '36208', 'España', 40.08, 0, '2023-06-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130623-RFzKNf1pV7wEz-159', '2a98efb3-1f4f-406e-be1b-eff02494a4f7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130623-RFzKNf1pV7wEz-159&s=KOL2023&nf=P3144&i=40.08&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3338, 1, 754, 2, 0, NULL, 0, '2023-06-13 09:23:08', '2023-06-13 11:26:44', '2023-06-13', 'P3145', '23-04479-06-13', '', 0.00, 51.80, 10.88, 0.00, 1, 2.69, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '438790', 'España', 65.37, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130623-oWSOYgPAc4YKP-149', '2756c353-043b-4668-9dc1-46d9d3e18e78', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130623-oWSOYgPAc4YKP-149&s=KOL2023&nf=P3145&i=65.37&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3339, 1, 841, 2, 0, NULL, 0, '2023-06-13 12:23:36', '2023-06-13 16:12:32', '2023-06-13', 'P3146', '23-04480-06-13', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Cl. Montflorit 104', 'Gavà', 'Barcelona', '08850', 'España', 16.29, 0, '2023-06-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130623-EmbKpw76QQXN2-047', '317bf2a0-352c-444d-b813-f59eff652038', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130623-EmbKpw76QQXN2-047&s=KOL2023&nf=P3146&i=16.29&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3340, 1, 110, 2, 0, NULL, 0, '2023-06-13 12:28:47', '2023-06-13 16:13:59', '2023-06-13', 'P3147', '23-04481-06-13', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 206.91, 0, '2023-06-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130623-a9jx4N9QiaJmx-065', '8cc9c257-a8fd-45c6-a358-deba4067af9d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130623-a9jx4N9QiaJmx-065&s=KOL2023&nf=P3147&i=206.91&cr=191', '[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
(3341, 1, 703, 2, 0, NULL, 0, '2023-06-13 13:43:12', '2023-06-13 16:17:09', '2023-06-13', 'P3148', '23-04482-06-13', 'A partir d14:30', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Mayor 37 2', 'Entrena', 'La Rioja', '26375', 'España', 26.40, 0, '2023-06-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130623-cB0yowqm2Z/nz-089', '4445a731-8f20-4358-b195-924d4e9f63c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130623-cB0yowqm2Z%2Fnz-089&s=KOL2023&nf=P3148&i=26.40&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3342, 1, 842, 2, 0, NULL, 0, '2023-06-13 19:53:46', '2023-06-14 08:42:25', '2023-06-13', 'P3149', '23-04483-06-13', 'Los lunes está cerrado ', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Antonio Trueba 11 Peluquería Mayje', 'Basauri', 'Bizkaia', '48970', 'España', 28.19, 0, '2023-06-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130623-VUQz23ULcYHJN-031', '31c4a9c2-e053-4f34-82ab-ea82ea08e9f1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130623-VUQz23ULcYHJN-031&s=KOL2023&nf=P3149&i=28.19&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3343, 1, 418, 2, 0, NULL, 0, '2023-06-13 20:56:45', '2023-06-14 08:45:37', '2023-06-13', 'P3150', '23-04484-06-13', 'Lo pueden dejar a cualquier vecino', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Adelfas 4, 3B', 'Alcorcón', 'Madrid', '28925', 'España', 28.19, 0, '2023-06-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130623-JcKzQKGS1K2uF-251', '2efcb493-e62d-4294-a709-9c80d5c95ea1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130623-JcKzQKGS1K2uF-251&s=KOL2023&nf=P3150&i=28.19&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3344, 1, 138, 2, 0, NULL, 0, '2023-06-13 21:13:12', '2023-06-14 08:52:02', '2023-06-13', 'P3151', '23-04486-06-13', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Carretera Valladares 382', 'Vigo', 'Pontevedra', '36315', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130623-V7IpjwEzxTc3J-032', '316eacf8-43d0-4a9b-8b52-1631eecedf1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130623-V7IpjwEzxTc3J-032&s=KOL2023&nf=P3151&i=206.91&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3345, 1, 765, 2, 1, 'Fallo sistema de gestión', 3061, '2023-06-14 13:38:25', '2023-06-14 13:38:25', '2023-06-14', 'R40', 'P2883 RECT.', '', 0.00, 14.80, 3.54, 0.00, 0, 0.00, 2.50, '', '', '', '', '', 20.41, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-140623-jZddDPIK0N6bY-041', '4265b23a-8e62-4b8e-acef-34c02ece843b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140623-jZddDPIK0N6bY-041&s=KOL2023&nf=R40&i=-20.41&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3346, 1, 843, 2, 0, NULL, 0, '2023-06-14 11:42:02', '2023-06-15 08:48:17', '2023-06-14', 'P3152', '23-04488-06-14', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle María de Molina, 5. Piso 10, puerta derecha.', 'Madrid', 'Madrid', '28006', 'España', 16.29, 0, '2023-06-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140623-T2lUBrNn9YpCy-122', 'dfd02a14-a990-4c89-849d-bb6c4efb2f49', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140623-T2lUBrNn9YpCy-122&s=KOL2023&nf=P3152&i=16.29&cr=172', '[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
(3347, 1, 28, 2, 1, 'Pedido duplicado', 3102, '2023-06-14 13:44:03', '2023-06-14 13:44:03', '2023-06-14', 'R41', 'P2923 RECT.', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 137.94, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-140623-iggCeGoQO2QsU-206', 'dea5c51e-944b-455d-8ce6-d1781ff1d7a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140623-iggCeGoQO2QsU-206&s=KOL2023&nf=R41&i=-137.94&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3348, 1, 28, 2, 1, 'pedido duplicado', 3103, '2023-06-14 13:45:24', '2023-06-14 13:45:24', '2023-06-14', 'R42', 'P2924 RECT.', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 137.94, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-140623-EBQ8lUYGpMceP-213', 'f767f73f-35c4-4a4c-ad1f-9f023840e5d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140623-EBQ8lUYGpMceP-213&s=KOL2023&nf=R42&i=-137.94&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3349, 1, 28, 2, 1, 'pedido duplicado', 3104, '2023-06-14 13:46:48', '2023-06-14 13:46:48', '2023-06-14', 'R43', 'P2925 RECT.', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 137.94, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-140623-QUDWIr3JvoB5D-184', '0face992-7a84-4fc2-86cb-e932569783bd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140623-QUDWIr3JvoB5D-184&s=KOL2023&nf=R43&i=-137.94&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3350, 1, 292, 2, 1, 'pedido duplicado', 3161, '2023-06-14 13:52:55', '2023-06-14 13:52:55', '2023-06-14', 'R44', 'P2980 RECT.', '', 0.00, 92.38, 19.40, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 111.78, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-140623-XUft6kSHdAiN0-215', '465abf31-afaf-4c67-a7fc-95a063545dee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140623-XUft6kSHdAiN0-215&s=KOL2023&nf=R44&i=-111.78&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3351, 1, 73, 2, 1, 'pedido duplicado', 3166, '2023-06-14 13:55:10', '2023-06-14 13:55:10', '2023-06-14', 'R45', 'P2985 RECT.', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 241.40, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-140623-cNa7GuEoCZda4-182', '2d12d23a-c758-44bf-a5e2-7023984f49ab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140623-cNa7GuEoCZda4-182&s=KOL2023&nf=R45&i=-241.40&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3352, 1, 65, 2, 1, 'pedido duplicado', 3209, '2023-06-14 13:58:29', '2023-06-14 13:58:29', '2023-06-14', 'R46', 'P3027 RECT.', '', 0.00, 712.50, 149.63, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 862.13, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-140623-TKlmy9JU5UaI0-001', '14b12046-a6e5-45a2-97e5-7734435bf183', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140623-TKlmy9JU5UaI0-001&s=KOL2023&nf=R46&i=-862.13&cr=088', '[BLOB]', 0, '', '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
(3353, 1, 77, 1, 1, 'pedido cancelado', 3231, '2023-06-14 14:00:35', '2023-06-14 14:00:35', '2023-06-14', 'R47', 'P3047 RECT.', '', 0.00, 156.00, 32.76, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 188.76, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-140623-VO3uuk+5K924K-146', '12a06ad2-d64b-47b1-8d44-15ea051fe16e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140623-VO3uuk%2B5K924K-146&s=KOL2023&nf=R47&i=-188.76&cr=092', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3354, 1, 138, 2, 0, NULL, 0, '2023-06-15 08:09:11', '2023-06-15 08:09:11', '2023-06-15', '', '23-04486-06-13', 'Hola, agradezco que me manden este pedido lo antes posible. Muchas gracias\r\nsaludos', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Carretera Valladares 382', 'Vigo', 'Pontevedra', '36315', '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),
(3355, 1, 121, 2, 0, NULL, 0, '2023-06-15 08:12:14', '2023-06-15 10:45:33', '2023-06-15', 'P3153', '23-04493-06-14', 'Lunes cerrado', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 172.43, 0, '2023-06-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150623-T35p+TC4Hf3Jf-212', 'acfde5a6-7f89-452e-a435-4a2950899f00', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150623-T35p%2BTC4Hf3Jf-212&s=KOL2023&nf=P3153&i=172.43&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3356, 1, 323, 2, 0, NULL, 0, '2023-06-15 08:12:35', '2023-06-15 10:35:49', '2023-06-15', 'P3154', '23-04489-06-14', 'Entregar por las tardes ', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Calle Las Camelias N10 1B', 'Alcorcón', 'Madrid', '28925', 'España', 26.40, 0, '2023-06-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150623-HSKcqga05xV1c-094', '7a2202b1-2248-4eab-8fcf-eaf546ffe3d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150623-HSKcqga05xV1c-094&s=KOL2023&nf=P3154&i=26.40&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3357, 1, 160, 2, 0, NULL, 0, '2023-06-15 08:12:49', '2023-06-15 10:39:05', '2023-06-15', 'P3155', '23-04490-06-14', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 103.46, 0, '2023-06-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150623-SV9R7ABXdcTI4-118', '5899cb60-888e-46cc-8ea7-89c78f789093', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150623-SV9R7ABXdcTI4-118&s=KOL2023&nf=P3155&i=103.46&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3358, 1, 114, 2, 0, NULL, 0, '2023-06-15 10:41:18', '2023-06-15 13:25:29', '2023-06-15', 'P3157', '23-04501-06-15', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Catalina de Erauso 10 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 344.85, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150623-BkBWWrevMSFEj-149', 'bcb121f9-0c8a-49bb-a1ce-632bf1e262cc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150623-BkBWWrevMSFEj-149&s=KOL2023&nf=P3157&i=344.85&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3359, 1, 23, 2, 0, NULL, 0, '2023-06-15 11:08:00', '2023-06-15 13:09:43', '2023-06-15', 'P3156', '23-04502-06-15', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 241.40, 0, '2023-06-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150623-ep6ioMRjhnupr-232', 'dae2f650-b58c-43c2-a727-b01e82555a39', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150623-ep6ioMRjhnupr-232&s=KOL2023&nf=P3156&i=241.40&cr=161', '[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
(3360, 1, 844, 2, 0, NULL, 0, '2023-06-15 16:03:11', '2023-06-16 09:23:31', '2023-06-15', 'P3159', '23-04504-06-15', 'Llamar al telefono antes de venir. No hay timbre.', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Camí del coll del perelló, 2', 'Castellvell del Camp', 'Tarragona', '43392', 'España', 16.29, 0, '2023-06-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150623-MFpfGc9ANfXPF-023', 'cc968b97-ded0-4cff-a59f-4988853b22ff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150623-MFpfGc9ANfXPF-023&s=KOL2023&nf=P3159&i=16.29&cr=045', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3361, 1, 845, 2, 0, NULL, 0, '2023-06-15 19:55:23', '2023-06-16 09:27:46', '2023-06-15', 'P3158', '23-04505-06-15', 'Hay principal. El 1° es como un 2°', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Panaderos 68 1 izquierda', 'Valladolid', 'Valladolid', '47004', 'España', 26.40, 0, '2023-06-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150623-ayqTUEaWixehQ-139', '7e8d905e-9049-4bba-8405-22d82abe5c1d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150623-ayqTUEaWixehQ-139&s=KOL2023&nf=P3158&i=26.40&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3362, 1, 75, 2, 0, NULL, 0, '2023-06-16 08:40:39', '2023-06-16 10:48:54', '2023-06-16', 'P3160', '23-04506-06-16', 'Horario de martes a viernes de 10 a 19:00', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 103.46, 0, '2023-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160623-C2/VivoIx6TXr-124', 'ff6a9e69-af62-45b3-85e0-e6622dd833cd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160623-C2%2FVivoIx6TXr-124&s=KOL2023&nf=P3160&i=103.46&cr=227', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3363, 1, 164, 2, 0, NULL, 0, '2023-06-16 09:08:47', '2023-06-16 11:29:17', '2023-06-16', 'P3161', '23-04507-06-16', '', 0.00, 299.80, 62.96, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 362.76, 0, '2023-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160623-BlQhMU3U8bN2X-195', 'f81a7542-90e9-4175-aeb4-23dafe4045bb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160623-BlQhMU3U8bN2X-195&s=KOL2023&nf=P3161&i=362.76&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3364, 1, 280, 2, 0, NULL, 0, '2023-06-16 10:20:09', '2023-06-16 12:29:02', '2023-06-16', 'P3162', '23-04508-06-16', 'lunes cerrado', 0.00, 121.40, 25.49, 0.00, 0, 0.00, 0.00, 'RUA CODESAL Nº2', 'Pino (O)', 'A Coruña', '15821', 'España', 146.89, 0, '2023-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160623-H/B+Pdaa1aWC6-170', 'ef2c3899-5938-410f-a4d2-6fb86be16435', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160623-H%2FB%2BPdaa1aWC6-170&s=KOL2023&nf=P3162&i=146.88&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3365, 1, 846, 2, 0, NULL, 0, '2023-06-16 14:47:03', '2023-06-19 08:48:09', '2023-06-16', 'P3163', '23-04509-06-16', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Pasaje del sanatorio n8 bajo b ', 'Torremolinos', 'Málaga', '29620', 'España', 28.19, 0, '2023-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160623-BglLVdm8QusKs-239', 'b1ad2241-cf52-4b50-bd3f-d153cb287908', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160623-BglLVdm8QusKs-239&s=KOL2023&nf=P3163&i=28.19&cr=252', '[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
(3366, 1, 847, 2, 0, NULL, 0, '2023-06-16 14:49:53', '2023-06-19 08:50:54', '2023-06-16', 'P3164', '23-04510-06-16', 'En caso de no estar dejar donde el portero por favor', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Calle Catalina de erauso 9 5 A, Calle Catalina de erauso 9 5 A', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 59.47, 0, '2023-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160623-FVZgARjvHmObx-182', 'c738b257-c903-4351-8fb2-6da24dcc2e5b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160623-FVZgARjvHmObx-182&s=KOL2023&nf=P3164&i=59.47&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3367, 1, 97, 2, 0, NULL, 0, '2023-06-17 08:41:05', '2023-06-19 08:54:22', '2023-06-17', 'P3165', '23-04512-06-17', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Bidasoa 8, Bajo Bera', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 137.94, 0, '2023-06-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170623-VQmf+a7cDRN/l-241', '15b1b83f-2244-47e5-a2a6-e059d6cf46d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170623-VQmf%2Ba7cDRN%2Fl-241&s=KOL2023&nf=P3165&i=137.94&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3368, 1, 10, 2, 0, NULL, 0, '2023-06-17 10:34:06', '2023-06-19 09:08:43', '2023-06-17', 'P3166', '23-04513-06-17', '', 0.00, 107.70, 22.62, 0.00, 0, 0.00, 0.00, 'Agirre auzunea 1 behea', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 130.32, 0, '2023-06-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170623-CmbvllsnqL1ls-192', '785847d1-b771-4e42-a9dd-2f8e4642056f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170623-CmbvllsnqL1ls-192&s=KOL2023&nf=P3166&i=130.32&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3369, 1, 147, 2, 0, NULL, 0, '2023-06-17 12:45:31', '2023-06-19 09:22:11', '2023-06-17', 'P3167', '23-04514-06-17', 'Horario de lunes a sábado de 10 a 14 y jueves  de 16:30 a 18:30h', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'C/ RÍO DUERO Nº 49   28913-LEGANÉS', 'Leganés', 'Madrid', '28913', 'España', 310.37, 0, '2023-06-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170623-D+iEWIYW4Kd0V-208', '3d6a9308-7ed9-470d-b554-5224ed9e2985', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170623-D%2BiEWIYW4Kd0V-208&s=KOL2023&nf=P3167&i=310.37&cr=247', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3370, 1, 262, 2, 0, NULL, 0, '2023-06-18 15:00:09', '2023-06-19 09:26:05', '2023-06-18', 'P3168', '23-04515-06-18', 'Lunes cerrado', 0.00, 144.70, 30.39, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 175.09, 0, '2023-06-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180623-XC7BWhrsPOoAR-091', '810dc61e-b7ad-4a94-bffa-6b2afd72fb13', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180623-XC7BWhrsPOoAR-091&s=KOL2023&nf=P3168&i=175.09&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3371, 1, 736, 2, 0, NULL, 0, '2023-06-18 15:45:51', '2023-06-19 09:29:21', '2023-06-18', 'P3169', '23-04516-06-18', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'As Teixugueiras 7, portal 4, 7ºO ', 'Vigo', 'Pontevedra', '36201', 'España', 59.47, 0, '2023-06-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180623-hnGh5gwQZaupH-217', '2c95e6b1-0042-4c45-86a0-56d5e738c735', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180623-hnGh5gwQZaupH-217&s=KOL2023&nf=P3169&i=59.47&cr=032', '[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
(3372, 1, 273, 2, 0, NULL, 0, '2023-06-19 08:08:56', '2023-06-19 10:18:36', '2023-06-19', 'P3170', '23-04517-06-19', '', 0.00, 54.54, 11.45, 0.00, 0, 0.00, 0.00, 'Avda. Eduard Maristany, 46-48 (ENDESA)', 'Sant Adrià de Besòs', 'Barcelona', '08930', 'España', 65.99, 0, '2023-06-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190623-JcBp4XKvQ0Bx/-069', '49c10f4c-be76-41da-9196-b286f9440b7d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190623-JcBp4XKvQ0Bx%2F-069&s=KOL2023&nf=P3170&i=65.98&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3373, 1, 144, 2, 0, NULL, 0, '2023-06-19 08:38:53', '2023-06-19 10:47:46', '2023-06-19', 'P3171', '23-04518-06-19', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 103.46, 0, '2023-06-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190623-jto//Cq44KU7v-214', 'b0b7524f-894d-4e02-83e9-56e7ff365fdf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190623-jto%2F%2FCq44KU7v-214&s=KOL2023&nf=P3171&i=103.46&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3374, 1, 248, 2, 0, NULL, 0, '2023-06-19 10:31:06', '2023-06-19 12:34:06', '2023-06-19', 'P3172', '23-04519-06-19', 'Cerrado los miércoles ', 0.00, 96.20, 20.20, 0.00, 0, 0.00, 0.00, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 116.40, 0, '2023-06-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190623-nh+AOfth0REPv-251', '1013caca-6e42-4f3a-9d91-5f535deeeb64', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190623-nh%2BAOfth0REPv-251&s=KOL2023&nf=P3172&i=116.40&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3375, 1, 98, 2, 0, NULL, 0, '2023-06-19 13:39:29', '2023-06-20 09:08:57', '2023-06-19', 'P3176', '23-04520-06-19', '', 0.00, 64.40, 13.96, 0.00, 0, 0.00, 2.50, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 80.42, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-190623-Y2cLGOJRdt4dm-052', 'a9c6b72f-9436-4c32-8d09-cf4cb530a52d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190623-Y2cLGOJRdt4dm-052&s=KOL2023&nf=P3176&i=80.42&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3376, 1, 848, 2, 0, NULL, 0, '2023-06-19 14:57:13', '2023-06-20 09:19:24', '2023-06-19', 'P3173', '23-04525-06-19', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Turriente Numero 15A primero derecha', 'Ausejo', 'La Rioja', '26513', 'España', 16.29, 0, '2023-06-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190623-lrFgIGfLGTvF6-155', '81644a25-8c83-4d0d-a72f-5b87a46f6557', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190623-lrFgIGfLGTvF6-155&s=KOL2023&nf=P3173&i=16.29&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3377, 1, 337, 2, 0, NULL, 0, '2023-06-19 15:28:55', '2023-06-20 09:24:40', '2023-06-19', 'P3177', '23-04528-06-19', '', 0.00, 59.20, 12.43, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 71.63, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190623-HADWRSvL5tEg5-063', '19c75e0a-b213-4f10-937e-ccffe84b8e15', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190623-HADWRSvL5tEg5-063&s=KOL2023&nf=P3177&i=71.63&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
