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
(3151, 1, 319, 2, 0, NULL, 0, '2023-05-05 11:18:47', '2023-05-05 13:46:33', '2023-05-05', 'P2970', '23-04256-05-05', 'AVISAR ANTES DE ENVIAR. GRACIAS', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'SEGUNDO IZPIZUA NÚMERO 14 3D', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 26.40, 0, '2023-05-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050523-An8K6TB6xW14h-015', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050523-An8K6TB6xW14h-015&s=KOL2023&nf=P2970&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),
(3152, 1, 795, 2, 0, NULL, 0, '2023-05-05 13:57:33', '2023-05-08 09:23:48', '2023-05-05', 'P2971', '23-04259-05-05', 'En caso de no estar avisar al teléfono 646228333', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Carretera Villacarrillo, N°50', 'Navas de San Juan', 'Jaén', '23240', 'España', 16.29, 0, '2023-05-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050523-iEwjY7GkqMRKS-016', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050523-iEwjY7GkqMRKS-016&s=KOL2023&nf=P2971&i=16.29&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3153, 1, 653, 2, 0, NULL, 0, '2023-05-05 20:37:54', '2023-05-08 09:27:22', '2023-05-05', 'P2972', '23-04260-05-05', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'C. de Juan María Guelbenzu Kalea, 4', 'Pamplona/Iruña', 'Navarra', '31005', 'España', 26.40, 0, '2023-05-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050523-OHlajrGdR+MK/-237', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050523-OHlajrGdR%2BMK%2F-237&s=KOL2023&nf=P2972&i=26.40&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3154, 1, 157, 2, 0, NULL, 0, '2023-05-06 16:24:43', '2023-05-08 09:31:19', '2023-05-06', 'P2973', '23-04261-05-06', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'CALLE APODACA,1 LOCAL', 'Madrid', 'Madrid', '28004', 'España', 172.43, 0, '2023-05-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060523-HBUafEE+iUjVc-175', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060523-HBUafEE%2BiUjVc-175&s=KOL2023&nf=P2973&i=172.43&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3155, 1, 796, 2, 0, NULL, 0, '2023-05-06 17:44:15', '2023-05-08 09:37:39', '2023-05-06', 'P2974', '23-04262-05-06', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'C/ Santa Llúcia 8, bajos', 'Canet de Mar', 'Barcelona', '08360', 'España', 28.19, 0, '2023-05-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060523-KHU3omUWbQ7Iv-048', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060523-KHU3omUWbQ7Iv-048&s=KOL2023&nf=P2974&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),
(3156, 1, 797, 2, 0, NULL, 0, '2023-05-07 06:31:59', '2023-05-08 09:40:47', '2023-05-07', 'P2975', '23-04263-05-07', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'C/ Xavier Puig Andreu, 28', 'Lleida', 'Lleida', '25005', 'España', 16.29, 0, '2023-05-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070523-axOfjAGGfA3eu-037', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070523-axOfjAGGfA3eu-037&s=KOL2023&nf=P2975&i=16.29&cr=053', '[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
(3157, 1, 215, 2, 0, NULL, 0, '2023-05-07 06:51:24', '2023-05-08 09:45:55', '2023-05-07', 'P2976', '23-04264-05-07', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 379.34, 0, '2023-05-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070523-N1o1Vx/4gKumE-195', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070523-N1o1Vx%2F4gKumE-195&s=KOL2023&nf=P2976&i=379.34&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3158, 1, 321, 2, 0, NULL, 0, '2023-05-07 17:32:56', '2023-05-08 09:49:31', '2023-05-07', 'P2977', '23-04265-05-07', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Carrer Sant Joan, 21 Pis', 'Canet de Mar', 'Barcelona', '08360', 'España', 28.19, 0, '2023-05-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070523-daomFupQ6WuPq-208', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070523-daomFupQ6WuPq-208&s=KOL2023&nf=P2977&i=28.19&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3159, 1, 161, 2, 0, NULL, 0, '2023-05-07 19:53:19', '2023-05-08 09:53:47', '2023-05-07', 'P2978', '23-04266-05-07', 'Salón Peluquería Arte&Cabello', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Av/Goleta n23-25 local 7 ', 'Alicante/Alacant', 'Alicante', '03540', 'España', 103.46, 0, '2023-05-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070523-LM7TFphc8yyd8-193', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070523-LM7TFphc8yyd8-193&s=KOL2023&nf=P2978&i=103.46&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3160, 1, 798, 2, 0, NULL, 0, '2023-05-07 21:21:51', '2023-05-08 10:03:11', '2023-05-07', 'P2979', '23-04267-05-07', '', 0.00, 19.66, 5.55, 0.00, 0, 0.00, 8.19, 'Avenida 8 de agosto, 15/17 esc B 5°1a, Edificio Fiesta 1', 'Eivissa', 'Baleares (Illes)', '07800', 'España', 31.98, 0, '2023-05-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070523-isMMbEBQPfhQe-010', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070523-isMMbEBQPfhQe-010&s=KOL2023&nf=P2979&i=31.98&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3161, 1, 292, 2, 0, NULL, 0, '2023-05-08 09:21:37', '2023-06-14 13:52:34', '2023-05-08', 'P2980', '23-04270-05-08', '', 0.00, 92.38, 19.40, 0.00, 0, 0.00, 0.00, 'Paseig de la terracuita A N°1-5,  4° 1°', 'Gavà', 'Barcelona', '08850', 'España', 111.78, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080523-iYmNY1NBhRVt7-223', '1666d11f-fb0a-4985-aeea-009fa6cd4978', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080523-iYmNY1NBhRVt7-223&s=KOL2023&nf=P2980&i=111.78&cr=009', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3162, 1, 292, 2, 0, NULL, 0, '2023-05-08 09:28:07', '2023-05-08 11:33:05', '2023-05-08', 'P2981', '23-04271-05-08', 'AVISAR HORA DE LA ENTREGA ', 0.00, 92.38, 19.40, 0.00, 0, 0.00, 0.00, 'Passeig de la terracuita 1-5 Esc. A   piso  4 puerta 1, Riera de les prats 7', 'Gavà', 'Barcelona', '08850', 'España', 111.78, 0, '2023-05-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080523-hEF4bWeTBG2UV-156', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080523-hEF4bWeTBG2UV-156&s=KOL2023&nf=P2981&i=111.78&cr=158', '[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
(3163, 1, 121, 2, 0, NULL, 0, '2023-05-08 10:06:14', '2023-05-08 12:30:50', '2023-05-08', 'P2982', '23-04277-05-08', '', 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-05-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080523-I7XLfotc5XwDE-222', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080523-I7XLfotc5XwDE-222&s=KOL2023&nf=P2982&i=310.37&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3164, 1, 644, 2, 0, NULL, 0, '2023-05-08 11:08:38', '2023-05-08 13:14:37', '2023-05-08', 'P2983', '23-04278-05-08', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'CALLE CALDERA DE TABURIENTE 7, 2B', 'Ciempozuelos', 'Madrid', '28350', 'España', 55.89, 0, '2023-05-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080523-VL5+gXCFlnAgn-102', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080523-VL5%2BgXCFlnAgn-102&s=KOL2023&nf=P2983&i=55.89&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3165, 1, 73, 2, 0, NULL, 0, '2023-05-09 05:44:53', '2023-05-09 09:16:45', '2023-05-09', 'P2984', '23-04279-05-09', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'zapatari 2a', 'Beasain', 'Gipuzkoa', '20200', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090523-aBs+MpmJMxJCu-236', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090523-aBs%2BMpmJMxJCu-236&s=KOL2023&nf=P2984&i=241.40&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3166, 1, 73, 2, 0, NULL, 0, '2023-05-09 05:44:56', '2023-06-14 13:54:40', '2023-05-09', 'P2985', '23-04280-05-09', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'zapatari 2a', 'Beasain', 'Gipuzkoa', '20200', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090523-fD32OsACTZQYr-050', '208c5595-167e-40e1-8c78-a6553ef4d4ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090523-fD32OsACTZQYr-050&s=KOL2023&nf=P2985&i=241.40&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3167, 1, 624, 2, 0, NULL, 0, '2023-05-09 07:50:44', '2023-05-09 10:00:30', '2023-05-09', 'P2986', '23-04281-05-09', '', 0.00, 49.15, 10.76, 0.00, 0, 0.00, 2.50, 'Avenida Constitución 184 , portal 3 , escalera 5 , 1E . ', 'Torrejón de Ardoz', 'Madrid', '28850', 'España', 61.97, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-090523-PXwiGRdYI3jJm-115', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090523-PXwiGRdYI3jJm-115&s=KOL2023&nf=P2986&i=61.97&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3168, 1, 498, 2, 0, NULL, 0, '2023-05-09 11:51:32', '2023-05-10 09:38:35', '2023-05-09', 'P2987', '23-04282-05-09', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Manel farres 107 1-1', 'Sant Cugat del Vallè', 'Barcelona', '08173', 'España', 16.29, 0, '2023-05-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090523-PWYjWaeZ3Wt+N-032', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090523-PWYjWaeZ3Wt%2BN-032&s=KOL2023&nf=P2987&i=16.29&cr=181', '[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
(3169, 1, 111, 2, 0, NULL, 0, '2023-05-09 12:54:42', '2023-05-10 09:42:17', '2023-05-09', 'P2988', '23-04283-05-09', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'c/ Loza, nº1 piso 7b', 'Ansoáin', 'Navarra', '31013', 'España', 172.43, 0, '2023-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090523-JQyCIIXIrdhZO-054', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090523-JQyCIIXIrdhZO-054&s=KOL2023&nf=P2988&i=172.43&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3170, 1, 280, 2, 0, NULL, 0, '2023-05-09 12:55:50', '2023-05-10 09:44:04', '2023-05-09', 'P2989', '23-04284-05-09', 'lunes cerrado', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'RUA CODESAL Nº2', 'Pino (O)', 'A Coruña', '15821', 'España', 68.97, 0, '2023-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090523-PN+6pFa6D3vm7-157', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090523-PN%2B6pFa6D3vm7-157&s=KOL2023&nf=P2989&i=68.97&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3171, 1, 98, 2, 0, NULL, 0, '2023-05-09 15:07:11', '2023-05-10 10:18:56', '2023-05-09', 'P2990', '23-04285-05-09', '', 0.00, 50.70, 11.08, 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', 63.85, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-090523-c5sSrtSNM43Yv-135', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090523-c5sSrtSNM43Yv-135&s=KOL2023&nf=P2990&i=63.85&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3172, 1, 799, 2, 0, NULL, 0, '2023-05-10 04:39:10', '2023-05-10 10:25:59', '2023-05-10', 'P2991', '23-04286-05-10', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Paseo lluis companys 20 primero cuarta', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 16.29, 0, '2023-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100523-FpCWZUxU5zc5J-209', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100523-FpCWZUxU5zc5J-209&s=KOL2023&nf=P2991&i=16.29&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3173, 1, 800, 2, 0, NULL, 0, '2023-05-10 08:08:51', '2023-05-10 10:30:58', '2023-05-10', 'P2992', '23-04287-05-10', '', 0.00, 37.84, 9.14, 0.00, 0, 0.00, 6.90, 'calle velazquez  peluqueria', 'Talavera de la Reina', 'Toledo', '45600', 'España', 52.69, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-100523-Eja/lkaRUOSba-104', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100523-Eja%2FlkaRUOSba-104&s=KOL2023&nf=P2992&i=52.69&cr=023', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3174, 1, 696, 1, 0, NULL, 0, '2023-05-10 11:02:09', '2023-05-10 12:17:31', '2023-05-10', 'P2993', '2023-05-10', '', 0.00, 195.00, 40.95, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 235.95, 0, '2023-05-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100523-FuuXsrf+Howfk-077', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100523-FuuXsrf%2BHowfk-077&s=KOL2023&nf=P2993&i=235.95&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3175, 1, 696, 1, 0, NULL, 0, '2023-05-10 11:02:27', '2023-05-10 12:01:49', '2023-05-10', '', '2023-05-10', '', 0.00, 195.00, 40.95, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 235.95, 0, '2023-05-10 00:00:00', '', '', 3, 3, 0, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(3176, 1, 468, 2, 0, NULL, 0, '2023-05-10 09:32:34', '2023-05-10 11:46:01', '2023-05-10', 'P2995', '23-04289-05-10', 'Por fa, enviadme un poster de publicidad. Hice un rincón koloreko en la pelu y le falta algo jajajja. ', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Rof carballo 1 peluqueria', 'Lugo', 'Lugo', '27002', 'España', 103.46, 0, '2023-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100523-hFt/fUGSd/2ZC-109', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100523-hFt%2FfUGSd%2F2ZC-109&s=KOL2023&nf=P2995&i=103.46&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3177, 1, 99, 2, 0, NULL, 0, '2023-05-10 11:48:58', '2023-05-11 10:02:49', '2023-05-10', 'P2994', '23-04290-05-10', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Iñigo arista 19 Trasera ', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 137.94, 0, '2023-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100523-mrT+xz4KyowRV-160', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100523-mrT%2Bxz4KyowRV-160&s=KOL2023&nf=P2994&i=137.94&cr=175', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3178, 1, 94, 2, 0, NULL, 0, '2023-05-10 12:34:32', '2023-05-11 11:26:51', '2023-05-10', 'P2999', '23-04291-05-10', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/mayor número 11', 'Ausejo', 'La Rioja', '26513', 'España', 137.94, 0, '2023-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100523-H5T/UAYEU4UyR-246', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100523-H5T%2FUAYEU4UyR-246&s=KOL2023&nf=P2999&i=137.94&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3179, 1, 754, 2, 0, NULL, 0, '2023-05-10 13:22:26', '2023-05-11 10:33:06', '2023-05-10', 'P2996', '23-04293-05-10', '', 0.00, 51.80, 10.88, 0.00, 1, 2.69, 0.00, 'josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 65.37, 0, '2023-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100523-igJ9E0sQUgyBf-200', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100523-igJ9E0sQUgyBf-200&s=KOL2023&nf=P2996&i=65.37&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3180, 1, 722, 2, 0, NULL, 0, '2023-05-10 13:35:48', '2023-05-11 10:35:16', '2023-05-10', 'P2997', '23-04294-05-10', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Avenida de Sagi Barba 18, 3º Izquierda ', 'Polop', 'Alicante', '03520', 'España', 26.40, 0, '2023-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100523-LrowiPtLUPgkt-201', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100523-LrowiPtLUPgkt-201&s=KOL2023&nf=P2997&i=26.40&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3181, 1, 591, 2, 0, NULL, 0, '2023-05-10 20:16:19', '2023-05-11 10:48:29', '2023-05-10', 'P2998', '23-04295-05-10', 'Llamar al teléfono 651997393 antes de entregar', 0.00, 64.37, 13.52, 0.00, 0, 0.00, 0.00, 'Av Doctor Fleming, 10 2 D', 'Leganés', 'Madrid', '28912', 'España', 77.89, 0, '2023-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100523-BD2V+3EN4NlKb-153', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100523-BD2V%2B3EN4NlKb-153&s=KOL2023&nf=P2998&i=77.89&cr=250', '[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
(3182, 1, 78, 2, 0, NULL, 0, '2023-05-11 09:29:44', '2023-05-11 12:05:16', '2023-05-11', 'P3000', '23-04296-05-11', '', 0.00, 712.50, 149.63, 0.00, 0, 0.00, 0.00, 'AVND. DE SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 862.13, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110523-KOYHELrxZWkaP-164', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110523-KOYHELrxZWkaP-164&s=KOL2023&nf=P3000&i=862.13&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3183, 1, 749, 2, 0, NULL, 0, '2023-05-11 12:35:55', '2023-05-12 09:08:07', '2023-05-11', 'P3001', '23-04297-05-11', 'Horario Porteria: 9:00 a 14:00 y de 17:00 a 20:00', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'CALLE LUIS PEIDRO 4 A 4 C', 'Madrid', 'Madrid', '28007', 'España', 16.29, 0, '2023-05-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110523-Jrxrl/0iV+aIV-217', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110523-Jrxrl%2F0iV%2BaIV-217&s=KOL2023&nf=P3001&i=16.29&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3184, 1, 571, 2, 0, NULL, 0, '2023-05-11 12:55:55', '2023-05-12 09:12:13', '2023-05-11', 'P3002', '23-04298-05-11', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Amaroz .30 1B', 'Tolosa', 'Gipuzkoa', '20400', 'España', 26.40, 0, '2023-05-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110523-WsWuo4hygovan-150', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110523-WsWuo4hygovan-150&s=KOL2023&nf=P3002&i=26.40&cr=225', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3185, 1, 801, 2, 0, NULL, 0, '2023-05-11 18:10:46', '2023-05-12 09:16:35', '2023-05-11', 'P3003', '23-04299-05-11', 'A veces el telefonillo no sirve, en caso que no responda mi móvil es 611446674. Gracias', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Calle de la Ronda 2, Piso 6-B', 'Castro-Urdiales', 'Cantabria', '39700', 'España', 26.40, 0, '2023-05-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110523-cZLBwIwPFj7Bx-047', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110523-cZLBwIwPFj7Bx-047&s=KOL2023&nf=P3003&i=26.40&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3186, 1, 685, 2, 0, NULL, 0, '2023-05-12 07:15:35', '2023-05-12 09:19:30', '2023-05-12', 'P3004', '23-04300-05-12', 'Si no hay nadie en casa , dejarlo en el primero A ', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Terol Nº5, 5p/1ª', 'Amposta', 'Tarragona', '43870', 'España', 40.08, 0, '2023-05-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120523-ZxLDs83HD+61a-165', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120523-ZxLDs83HD%2B61a-165&s=KOL2023&nf=P3004&i=40.08&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3187, 1, 77, 1, 0, NULL, 0, '2023-05-12 09:29:33', '2023-05-12 09:29:39', '2023-05-12', 'P3005', '2023-05-12', '', 0.00, 838.50, 176.08, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1014.58, 0, '2023-05-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120523-ic2Un9ftkF0Jn-056', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120523-ic2Un9ftkF0Jn-056&s=KOL2023&nf=P3005&i=1014.58&cr=021', '[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
(3188, 1, 477, 2, 0, NULL, 0, '2023-05-12 14:22:10', '2023-05-15 09:07:33', '2023-05-12', 'P3006', '23-04301-05-12', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'Pedro Elejalde 12 4 ezk ', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 55.89, 0, '2023-05-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120523-ZTUgPFkWs9RcJ-203', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120523-ZTUgPFkWs9RcJ-203&s=KOL2023&nf=P3006&i=55.89&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3189, 1, 355, 2, 0, NULL, 0, '2023-05-13 16:54:06', '2023-05-15 09:14:59', '2023-05-13', 'P3007', '23-04302-05-13', '', 0.00, 36.36, 8.40, 0.00, 0, 0.00, 4.40, 'Sebastián Fernández de Leceta 10 7 Izq', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 48.40, 0, '2023-05-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130523-otw/ypTHBGS3s-214', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130523-otw%2FypTHBGS3s-214&s=KOL2023&nf=P3007&i=48.40&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3190, 1, 802, 2, 0, NULL, 0, '2023-05-13 17:27:16', '2023-05-15 09:19:28', '2023-05-13', 'P3008', '23-04303-05-13', '', 0.00, 29.49, 7.39, 0.00, 0, 0.00, 6.90, 'Calle Poeta Blas de Otero, 14, 3ºB', 'Madrid', 'Madrid', '28017', 'España', 42.58, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130523-SVOXGd8mi2tPn-145', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130523-SVOXGd8mi2tPn-145&s=KOL2023&nf=P3008&i=42.58&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3191, 1, 803, 2, 0, NULL, 0, '2023-05-14 08:47:26', '2023-05-15 09:22:45', '2023-05-14', 'P3009', '23-04304-05-14', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Calle de Piscis 17, 2C', 'Zaragoza', 'Zaragoza', '50012', 'España', 59.47, 0, '2023-05-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140523-GM/M3sMB9/DPj-006', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140523-GM%2FM3sMB9%2FDPj-006&s=KOL2023&nf=P3009&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),
(3192, 1, 192, 2, 0, NULL, 0, '2023-05-14 08:53:31', '2023-05-15 09:25:38', '2023-05-14', 'P3010', '23-04305-05-14', '', 0.00, 14.80, 3.87, 0.00, 0, 0.00, 4.40, 'plaza San Cristobal 3,bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 22.31, 0, '2023-05-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140523-CFT+ZN1Uf3vBd-097', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140523-CFT%2BZN1Uf3vBd-097&s=KOL2023&nf=P3010&i=22.31&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3193, 1, 118, 1, 0, NULL, 0, '2023-05-15 10:02:53', '2023-05-15 12:16:55', '2023-05-15', 'P3011', '2023-05-15', '', 0.00, 85.50, 17.96, 0.00, 1, 4.45, 0.00, 'C/Amezketa , 7 bajo , peluquería Yulane', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 107.91, 0, '2023-05-15 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-150523-IcALUqW0kRqqI-153', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150523-IcALUqW0kRqqI-153&s=KOL2023&nf=P3011&i=107.91&cr=228', '[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
(3194, 1, 244, 2, 0, NULL, 0, '2023-05-15 08:12:19', '2023-05-15 11:07:49', '2023-05-15', 'P3012', '23-04306-05-15', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Balmes 79 Local 3 ', 'Calella', 'Barcelona', '08370', 'España', 103.46, 0, '2023-05-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150523-iQw9bqBBC1idT-197', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150523-iQw9bqBBC1idT-197&s=KOL2023&nf=P3012&i=103.46&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3195, 1, 522, 2, 0, NULL, 0, '2023-05-15 10:55:21', '2023-05-15 13:09:17', '2023-05-15', 'P3013', '23-04308-05-15', '', 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-05-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150523-BRM9LrmoVR1As-114', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150523-BRM9LrmoVR1As-114&s=KOL2023&nf=P3013&i=275.88&cr=198', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3196, 1, 677, 2, 0, NULL, 0, '2023-05-15 11:31:26', '2023-05-16 09:06:31', '2023-05-15', 'P3014', '23-04309-05-15', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'VOLVO ARREGUI (OSCAR ARAGUNDE)  PORTAL DE BETOÑO 13', 'Vitoria-Gasteiz', 'Álava', '01013', 'España', 59.47, 0, '2023-05-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150523-ArkwI55wDia3j-230', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150523-ArkwI55wDia3j-230&s=KOL2023&nf=P3014&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),
(3197, 1, 565, 2, 0, NULL, 0, '2023-05-15 18:34:21', '2023-05-16 09:13:58', '2023-05-15', 'P3015', '23-04310-05-15', '', 0.00, 228.00, 47.88, 0.00, 1, 11.86, 0.00, 'C/ Perú número 16 Bloq 2 Bajo DH', 'Alicante', 'Alicante', '03008', 'España', 287.74, 0, '2023-05-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-150523-PkdTUGT9nhATh-057', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150523-PkdTUGT9nhATh-057&s=KOL2023&nf=P3015&i=287.74&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3198, 1, 805, 2, 0, NULL, 0, '2023-05-15 19:22:26', '2023-05-16 09:16:11', '2023-05-15', 'P3016', '23-04311-05-15', 'Avisar antes de entregar, por favor ', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Zabalbide 7 1° izquierda ', 'Bilbao', 'Bizkaia', '48006', 'España', 28.19, 0, '2023-05-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-150523-Sf5z9vxWs16dx-190', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150523-Sf5z9vxWs16dx-190&s=KOL2023&nf=P3016&i=28.19&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3199, 1, 806, 2, 0, NULL, 0, '2023-05-15 20:58:28', '2023-05-16 09:19:09', '2023-05-15', 'P3017', '23-04312-05-15', 'Dejar al portero, 24h', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Churruca, 2, 3º puerta 5', 'Madrid', 'Madrid', '28004', 'España', 16.29, 0, '2023-05-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150523-S5xY7LSfefNRV-146', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150523-S5xY7LSfefNRV-146&s=KOL2023&nf=P3017&i=16.29&cr=115', '[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
(3200, 1, 631, 2, 0, NULL, 0, '2023-05-16 11:17:44', '2023-05-17 09:02:52', '2023-05-16', 'P3018', '23-04313-05-16', 'ABIERTO DE LUNES A VIERNES DE 10 HORAS DE LA MAÑANA A 18 HORAS DE LA TARDE. ES UNA PELUQUERÍA, KARMEN PELUQUEROS', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'CALLE LA HACIENDA DE PAVONES 15', 'Madrid', 'Madrid', '28030', 'España', 28.19, 0, '2023-05-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160523-R8PU/MlHmWDY+-091', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160523-R8PU%2FMlHmWDY%2B-091&s=KOL2023&nf=P3018&i=28.19&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3201, 1, 807, 2, 0, NULL, 0, '2023-05-16 14:51:08', '2023-05-17 09:06:09', '2023-05-16', 'P3019', '23-04320-05-16', '(Oficina Riojampleo)', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Avenida Club Deportivo nº50 piso1ºA', 'Logroño', 'La Rioja', '26007', 'España', 16.29, 0, '2023-05-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160523-JVhUuSngvtALt-133', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160523-JVhUuSngvtALt-133&s=KOL2023&nf=P3019&i=16.29&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3202, 1, 566, 2, 0, NULL, 0, '2023-05-16 17:22:51', '2023-05-17 09:09:31', '2023-05-16', 'P3020', '23-04322-05-16', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-160523-mQRrQja4hYcdX-035', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160523-mQRrQja4hYcdX-035&s=KOL2023&nf=P3020&i=275.88&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3203, 1, 4, 2, 0, NULL, 0, '2023-05-16 17:24:23', '2023-05-17 09:25:46', '2023-05-16', 'P3021', '23-04321-05-16', '', 0.00, 299.80, 62.96, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 362.76, 0, '2023-05-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160523-cGGakbyEHaOL3-255', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160523-cGGakbyEHaOL3-255&s=KOL2023&nf=P3021&i=362.76&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3204, 1, 563, 2, 0, NULL, 0, '2023-05-16 22:30:44', '2023-05-17 09:27:40', '2023-05-16', 'P3022', '23-04323-05-16', 'Lun-Jue:  8:00 - 17:30\r\nVie:  8:00-14:00', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Elkarmedia · Aingeru Kale 9 atzekaldea', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 26.40, 0, '2023-05-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160523-RDud1MxgnTh6a-082', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160523-RDud1MxgnTh6a-082&s=KOL2023&nf=P3022&i=26.40&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3205, 1, 154, 2, 0, NULL, 0, '2023-05-17 07:21:06', '2023-05-17 09:32:40', '2023-05-17', 'P3023', '23-04324-05-17', '', 0.00, 178.40, 37.46, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 215.86, 0, '2023-05-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170523-LnONSJLsXuK+p-147', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-LnONSJLsXuK%2Bp-147&s=KOL2023&nf=P3023&i=215.86&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
