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
(6094, 1, 223, 2, 0, NULL, 0, '2024-11-13 12:40:23', '2024-11-13 17:06:37', '2024-11-13', 'P5723', '24-07502-11-13', 'LUNES CERRADO', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'c/damas apostolicas,8 -bajo D.  A Ramallosa', 'Nigrán', 'Pontevedra', '36370', 'España', 137.94, 0, '2024-11-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131124-U+luQe331EbpZ-213', '9cf82929-3463-40d5-9164-0d3603c1f37c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-U%2BluQe331EbpZ-213&s=KOL2024&nf=P5723&i=137.94&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6095, 1, 1520, 2, 0, NULL, 0, '2024-11-13 13:08:37', '2024-11-13 17:11:25', '2024-11-13', 'P5724', '24-07503-11-13', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'AV. Brasil 19, 3A', 'Madrid', 'Madrid', '28020', 'España', 17.50, 0, '2024-11-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-131124-UhWubJQHReLjM-013', '9db4a5e6-ddee-4dec-975a-bcaa55f81c44', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-UhWubJQHReLjM-013&s=KOL2024&nf=P5724&i=17.50&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6096, 1, 114, 2, 0, NULL, 0, '2024-11-13 15:59:04', '2024-11-13 17:17:22', '2024-11-13', 'P5726', '24-07504-11-13', '', 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-131124-ESYGyvMCuAasW-042', 'be4f1470-3ebe-49f6-a353-1ddb71790698', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-ESYGyvMCuAasW-042&s=KOL2024&nf=P5726&i=344.85&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6097, 1, 145, 2, 0, NULL, 0, '2024-11-13 16:03:16', '2024-11-13 17:18:02', '2024-11-13', 'P5727', '24-07505-11-13', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-131124-ZNFy0QX2TBl1p-145', '998f2657-1a55-4808-902d-8756b17b6320', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-ZNFy0QX2TBl1p-145&s=KOL2024&nf=P5727&i=209.41&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6098, 1, 4, 2, 0, NULL, 0, '2024-11-13 17:15:52', '2024-11-14 07:11:40', '2024-11-14', 'P5728', '24-07506-11-13', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 103.46, 0, '2024-11-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141124-B9njSCSGNSJck-237', '65134a8d-d463-4a0c-92d8-5c29837190d7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141124-B9njSCSGNSJck-237&s=KOL2024&nf=P5728&i=103.46&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6099, 1, 115, 2, 0, NULL, 0, '2024-11-13 18:23:36', '2024-11-14 07:14:13', '2024-11-14', 'P5729', '24-07507-11-13', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'MONASTERIO DE URDAX NR. 38', 'Pamplona/Iruña', 'Navarra', '31011', 'España', 310.37, 0, '2024-11-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141124-MXrPbnKfhVrBz-127', 'f0be8286-a595-45a8-a2e8-74ac27982622', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141124-MXrPbnKfhVrBz-127&s=KOL2024&nf=P5729&i=310.37&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
(6100, 1, 1521, 2, 0, NULL, 0, '2024-11-14 07:40:54', '2024-11-14 09:10:10', '2024-11-14', 'P5730', '24-07508-11-14', 'Calle Lili Alvarez número 36, chalet 3', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Lili Alvarez número 36, chalet 3', 'Valdemoro', 'Madrid', '28342', 'España', 17.50, 0, '2024-11-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141124-FAXLCxigBZTIN-128', 'aa968c1f-53b1-4768-a995-406fe819fde3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141124-FAXLCxigBZTIN-128&s=KOL2024&nf=P5730&i=17.50&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6101, 1, 1522, 2, 0, NULL, 0, '2024-11-14 07:41:54', '2024-11-14 07:41:54', '2024-11-14', '', '24-07509-11-14', NULL, 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avd Bruselas, 7-4C', 'Vitoria-Gasteiz', 'Álava', '01002', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6102, 1, 306, 1, 0, NULL, 0, '2024-11-14 11:10:18', '2024-11-14 11:10:18', '2024-11-14', 'P5731', '', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'c/ Puigmolto nº 9, bajos', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 172.42, 0, '2024-11-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141124-BcqigI/mkybMy-135', 'c1f82e22-231e-4c90-9518-6ae126d9a317', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141124-BcqigI%2FmkybMy-135&s=KOL2024&nf=P5731&i=172.42&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6103, 1, 696, 1, 0, NULL, 0, '2024-11-14 11:21:08', '2024-11-14 11:21:08', '2024-11-14', 'P5732', '', '', 0.00, 1072.50, 225.23, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 1297.73, 0, '2024-11-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141124-OP7qDwEjBl+/K-184', '38043490-62fe-4ed6-bb81-cc7f7c8c8130', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141124-OP7qDwEjBl%2B%2FK-184&s=KOL2024&nf=P5732&i=1297.73&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6104, 1, 754, 2, 0, NULL, 0, '2024-11-14 13:50:56', '2024-11-15 06:31:44', '2024-11-15', 'P5733', '24-07510-11-14', '6+1 REGALO PRECOLOR CENIZA\r\nGRACIAS', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-11-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151124-DoP4Vrh5rnJen-029', 'f91c06c9-8d07-40fc-8937-27bbeda4c636', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151124-DoP4Vrh5rnJen-029&s=KOL2024&nf=P5733&i=61.64&cr=087', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6105, 1, 1523, 2, 0, NULL, 0, '2024-11-14 17:09:31', '2024-11-15 06:33:16', '2024-11-15', 'P5734', '24-07513-11-14', 'Puede abrir el portón del jardín y dejar el paquete en el interior del recinto.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer de la Tordera 12', 'Calonge', 'Girona', '17251', 'España', 17.50, 0, '2024-11-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-151124-XAhs49XQ8y5Gg-085', '15c9d5a7-6968-4ac2-bc17-601a91932d4c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151124-XAhs49XQ8y5Gg-085&s=KOL2024&nf=P5734&i=17.50&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6106, 1, 1524, 2, 0, NULL, 0, '2024-11-14 17:27:20', '2024-11-15 06:33:42', '2024-11-15', 'P5735', '24-07515-11-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Camino de la Marquesa 13 urb la santa', 'Espartinas', 'Sevilla', '41807', 'España', 17.50, 0, '2024-11-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151124-L3rCqfAPQ9btg-147', 'be1c21f4-9c21-4e92-9840-d3900e04e95f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151124-L3rCqfAPQ9btg-147&s=KOL2024&nf=P5735&i=17.50&cr=038', '[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
(6107, 1, 1286, 2, 0, NULL, 0, '2024-11-14 17:27:58', '2024-11-15 06:34:20', '2024-11-15', 'P5736', '24-07516-11-14', 'peluqueria Salon Gorraiz horario martes a viernes de 9:00 a 18:00\r\n sabados 9:00 a 14:00', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'zubiarte 15', 'Huarte/Uharte', 'Navarra', '31620', 'España', 113.30, 0, '2024-11-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151124-L7MeaTOPhxWIB-069', '480a4f26-cb72-4c40-b13f-710a98bcdd0a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151124-L7MeaTOPhxWIB-069&s=KOL2024&nf=P5736&i=113.30&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6108, 1, 1525, 2, 0, NULL, 0, '2024-11-15 08:27:21', '2024-11-15 09:32:51', '2024-11-15', 'P5737', '24-07517-11-15', 'Si no hay gente en casa en el momento del reparto, se puede dejar junto a la puerta ', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avenida da Liberdade, 11, Escalera A, 5-A', 'Santiago de Composte', 'A Coruña', '15706', 'España', 52.39, 0, '2024-11-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-151124-QGp1ChTUC/Jdg-221', '58eef405-ac35-40d3-aedc-9c586a21efb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151124-QGp1ChTUC%2FJdg-221&s=KOL2024&nf=P5737&i=52.39&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6109, 1, 120, 2, 0, NULL, 0, '2024-11-15 08:38:24', '2024-11-15 11:25:37', '2024-11-15', 'P5738', '24-07518-11-15', '', 0.00, 215.78, 45.31, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 261.09, 0, '2024-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151124-Nf3RWX0IwAJbd-040', '7444853e-9c22-4ccf-a872-706a136f78bd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151124-Nf3RWX0IwAJbd-040&s=KOL2024&nf=P5738&i=261.08&cr=011', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6110, 1, 172, 2, 0, NULL, 0, '2024-11-15 10:32:24', '2024-11-15 11:34:14', '2024-11-15', 'P5739', '24-07519-11-15', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Soldevila, 6 baixos', 'Tremp', 'Lleida', '25620', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-151124-JzMqRw2zULWUT-227', 'c5e32ffe-b4b2-4e5d-ab10-bcf5748c0357', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151124-JzMqRw2zULWUT-227&s=KOL2024&nf=P5739&i=103.46&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6111, 1, 77, 1, 0, NULL, 0, '2024-11-15 11:59:17', '2024-11-15 12:02:35', '2024-11-15', 'P5740', '', '', 0.00, 2145.00, 450.45, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 2595.45, 0, '2024-11-15 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-151124-N30V4WmNTf4vN-104', 'f54506bd-accb-4a1d-9f1d-9ba4e1f14808', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151124-N30V4WmNTf4vN-104&s=KOL2024&nf=P5740&i=2595.44&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6112, 1, 1060, 2, 0, NULL, 0, '2024-11-15 16:12:29', '2024-11-18 08:41:26', '2024-11-18', 'P5741', '24-07521-11-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'DR. AUGUST PI Y SUNYER 2, 5-1A', 'Barcelona', 'Barcelona', '08034', 'España', 17.50, 0, '2024-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181124-Ka4pe2eLLJaMw-080', '07c052fa-3915-41cc-bbe7-13ca14975577', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-Ka4pe2eLLJaMw-080&s=KOL2024&nf=P5741&i=17.50&cr=199', '[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
(6113, 1, 1450, 2, 0, NULL, 0, '2024-11-15 16:35:24', '2024-11-18 08:44:41', '2024-11-18', 'P5742', '24-07522-11-15', 'Entregar a partir de  las tres de la tarde.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Francisco Javier Landaburu 78 5º C', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 28.39, 0, '2024-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181124-Pc4sC4CTrIjT5-144', 'f8edf7cc-ce05-489f-ace5-b8ae36d2b21f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-Pc4sC4CTrIjT5-144&s=KOL2024&nf=P5742&i=28.39&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6114, 1, 731, 2, 0, NULL, 0, '2024-11-15 21:17:58', '2024-11-18 08:50:47', '2024-11-18', 'P5743', '24-07523-11-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'CALLE NAGUSIA 3 (CITYPAQ CORREOS)', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 17.50, 0, '2024-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181124-WKfYAlhGsAc+x-224', 'a5883e38-fc90-46fe-941f-f3364153e6fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-WKfYAlhGsAc%2Bx-224&s=KOL2024&nf=P5743&i=17.50&cr=230', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6115, 1, 1302, 2, 0, NULL, 0, '2024-11-16 09:08:49', '2024-11-18 08:51:39', '2024-11-18', 'P5744', '24-07524-11-16', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Avda. Vega de acá 115 2E', 'Almería', 'Almería', '04007', 'España', 65.52, 0, '2024-11-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181124-GfoiSx3fo115V-102', 'fea4dd66-8aa9-4d6e-b320-034f8241f6d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-GfoiSx3fo115V-102&s=KOL2024&nf=P5744&i=65.52&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6116, 1, 55, 2, 0, NULL, 0, '2024-11-16 12:54:25', '2024-11-18 08:52:42', '2024-11-18', 'P5745', '24-07525-11-16', 'Lunes cerrado', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'San Pedro De Mezonzo 17 bajo derch', 'Santiago de Composte', 'A Coruña', '15701', 'España', 147.79, 0, '2024-11-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181124-Baa5CMTO6Q+/Q-058', '1a66f5e2-cf1a-4b3a-ba30-fe8bf5f6d1a1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-Baa5CMTO6Q%2B%2FQ-058&s=KOL2024&nf=P5745&i=147.79&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6117, 1, 1526, 2, 0, NULL, 0, '2024-11-16 16:30:57', '2024-11-18 08:53:28', '2024-11-18', 'P5746', '24-07526-11-16', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'As Cancelas 54-2A ', 'Santiago de Composte', 'A Coruña', '15703 ', 'España', 28.39, 0, '2024-11-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181124-cpVxpp/uqACI6-203', '147f484a-ecbf-41e2-b298-625b9cb67b98', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-cpVxpp%2FuqACI6-203&s=KOL2024&nf=P5746&i=28.39&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6118, 1, 1527, 2, 0, NULL, 0, '2024-11-17 08:34:00', '2024-11-18 08:54:18', '2024-11-18', 'P5747', '24-07527-11-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida Central n°6 piso 4 puerta 4', 'Barañain', 'Navarra', '31010', 'España', 17.50, 0, '2024-11-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181124-G7W8KI0giYPFR-185', 'facdb9fc-0cff-4ec0-a448-c1acccdd7684', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-G7W8KI0giYPFR-185&s=KOL2024&nf=P5747&i=17.50&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
(6119, 1, 121, 2, 0, NULL, 0, '2024-11-17 11:00:28', '2024-11-18 08:54:58', '2024-11-18', 'P5748', '24-07528-11-17', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 275.88, 0, '2024-11-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181124-FHPzlSnTeQghK-059', '719f2733-3ca9-44b9-a405-daba8e01540d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-FHPzlSnTeQghK-059&s=KOL2024&nf=P5748&i=275.88&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6120, 1, 1528, 2, 0, NULL, 0, '2024-11-18 06:56:12', '2024-11-18 08:55:44', '2024-11-18', 'P5749', '24-07529-11-18', 'TIENDA PLUME', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'República Argentina, 6', 'Badajoz', 'Badajoz', '06005', 'España', 17.50, 0, '2024-11-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181124-Ca36EQEFEFOc0-073', '12c0f97e-a824-4cfa-8cd6-30fe8eb42828', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-Ca36EQEFEFOc0-073&s=KOL2024&nf=P5749&i=17.50&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6121, 1, 106, 1, 0, NULL, 0, '2024-11-18 09:09:02', '2024-11-18 09:09:12', '2024-11-18', 'P5750', '', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Hipódromo 10 bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'ESPAÑA', 123.15, 0, '2024-11-18 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-181124-GW8dNvA4laXHs-177', '84da3c5b-c34f-4a1b-a1b4-129084893e8f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-GW8dNvA4laXHs-177&s=KOL2024&nf=P5750&i=123.15&cr=210', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6122, 1, 1514, 2, 0, NULL, 0, '2024-11-18 12:24:17', '2024-11-18 13:26:13', '2024-11-18', 'P5751', '24-07530-11-18', 'Llamar al telefonillo que está en blanco, TATIANA Y PABLO NO!! GRACIAS ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Urbanización Casquero Calle N 4 C', 'Dos Hermanas', 'Sevilla', '41703', 'España', 17.50, 0, '2024-11-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181124-Rtm5RVSE7Lisx-234', 'bc218c7a-0dd4-4617-9cff-e57662d9bade', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-Rtm5RVSE7Lisx-234&s=KOL2024&nf=P5751&i=17.50&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6123, 1, 88, 2, 0, NULL, 0, '2024-11-18 13:56:08', '2024-11-18 16:36:17', '2024-11-18', 'P5752', '24-07531-11-18', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Turina 2bj  peluqueria ecologica valderros ', 'Valladolid', 'Valladolid', '47006', 'España', 137.94, 0, '2024-11-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181124-MzP51jIUWilAB-172', '7a3fb156-e0cc-469a-ac44-cdc0ede2e810', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181124-MzP51jIUWilAB-172&s=KOL2024&nf=P5752&i=137.94&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6124, 1, 4, 2, 0, NULL, 0, '2024-11-18 18:17:18', '2024-11-19 08:13:03', '2024-11-19', 'P5753', '24-07532-11-18', '', 0.00, 203.56, 42.75, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 246.31, 0, '2024-11-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191124-Seoyh3Qj673kz-073', 'd75f5ab7-0caa-49a9-a861-dc756c01cde3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191124-Seoyh3Qj673kz-073&s=KOL2024&nf=P5753&i=246.31&cr=208', '[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
(6125, 1, 1529, 2, 0, NULL, 0, '2024-11-19 12:21:04', '2024-11-19 13:50:16', '2024-11-19', 'P5754', '24-07533-11-19', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'AV. INDUSTRIA  53   ESC. A   1.2', 'Sant Just Desvern', 'Barcelona', '08960', 'España', 28.39, 0, '2024-11-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-191124-fonetiT1nfzWk-204', '5476b0c5-dc05-4e02-8376-0b13cddf2383', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191124-fonetiT1nfzWk-204&s=KOL2024&nf=P5754&i=28.39&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6126, 1, 1158, 2, 0, NULL, 0, '2024-11-19 12:32:53', '2024-11-19 13:52:40', '2024-11-19', 'P5755', '24-07534-11-19', 'peluquería Marai', 0.00, 73.26, 15.39, 0.00, 0, 0.00, 0.00, 'republica argentina 3, bajo 2', 'Irun', 'Gipuzkoa', '20302', 'España', 88.64, 0, '2024-11-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191124-It49Zh5oxj5Xv-231', '3fc12124-0856-42b5-b975-18d8f32020af', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191124-It49Zh5oxj5Xv-231&s=KOL2024&nf=P5755&i=88.64&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6127, 1, 147, 2, 0, NULL, 0, '2024-11-19 12:35:10', '2024-11-19 13:54:11', '2024-11-19', 'P5756', '24-07535-11-19', 'TC salón de belleza natural.\r\nHorario de 10 a 17:30 de martes a viernes ', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'Calle de la palmera 23 ', 'Leganés', 'Madrid', '28918', 'España', 413.82, 0, '2024-11-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191124-fe9REM/TB+WPa-127', 'c16d55da-07f6-47c8-ac2b-ebb00c514f2c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191124-fe9REM%2FTB%2BWPa-127&s=KOL2024&nf=P5756&i=413.82&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6128, 1, 110, 2, 0, NULL, 0, '2024-11-19 14:40:33', '2024-11-19 16:03:49', '2024-11-19', 'P5757', '24-07536-11-19', '', 0.00, 228.00, 48.31, 0.00, 0, 0.00, 2.50, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 278.38, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-191124-Y2aNuepZHvERr-212', 'c37448cb-db94-4c30-a56d-d5cc28c47aac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191124-Y2aNuepZHvERr-212&s=KOL2024&nf=P5757&i=278.38&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6129, 1, 23, 2, 0, NULL, 0, '2024-11-19 15:55:42', '2024-11-19 17:02:57', '2024-11-19', 'P5758', '24-07537-11-19', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 172.43, 0, '2024-11-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191124-WONwgiDe7KTJX-030', 'ebf1d258-d3ed-4234-9e3b-6d708237be99', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191124-WONwgiDe7KTJX-030&s=KOL2024&nf=P5758&i=172.43&cr=074', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6130, 1, 7, 1, 0, NULL, 0, '2024-11-20 08:55:03', '2024-11-20 08:55:03', '2024-11-20', 'P5759', '', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 413.82, 0, '2024-11-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-201124-brU7Mfr2yIVn0-055', 'a3b57fc4-d759-49e8-be3c-159c960be4fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201124-brU7Mfr2yIVn0-055&s=KOL2024&nf=P5759&i=413.82&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
(6131, 1, 754, 2, 0, NULL, 0, '2024-11-20 09:55:15', '2024-11-20 11:20:05', '2024-11-20', 'P5760', '24-07538-11-20', '6+1 GRATIS COLOR CASTAÑO\r\nGRACIAS', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201124-fGO2AQ9WZSDLX-008', 'c426519d-9749-4970-8030-fcfe12da6695', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201124-fGO2AQ9WZSDLX-008&s=KOL2024&nf=P5760&i=61.64&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6132, 1, 1530, 2, 0, NULL, 0, '2024-11-20 10:28:37', '2024-11-20 11:33:02', '2024-11-20', 'P5761', '24-07539-11-20', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carlos I, 30 Esc. Dch 4º B', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 17.50, 0, '2024-11-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-201124-Dm4QF+92qXo3z-159', '90870f9f-44e6-417a-8219-01baa23a6429', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201124-Dm4QF%2B92qXo3z-159&s=KOL2024&nf=P5761&i=17.50&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6133, 1, 1531, 2, 0, NULL, 0, '2024-11-20 14:02:04', '2024-11-20 16:14:53', '2024-11-20', 'P5762', '24-07540-11-20', 'Parroquia de lianz ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Concepción Arenal 6 - 1° izquierda. Santa Cruz.', 'Oleiros', 'A Coruña', '15179', 'España', 30.61, 0, '2024-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201124-GHw4m2yRUDQ8p-241', 'b0389e92-0946-41d2-851b-da28de616573', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201124-GHw4m2yRUDQ8p-241&s=KOL2024&nf=P5762&i=30.61&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6134, 1, 61, 2, 0, NULL, 0, '2024-11-20 14:40:40', '2024-11-20 16:15:42', '2024-11-20', 'P5763', '24-07541-11-20', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Maestro Gozalbo 4 bajo', 'Valencia', 'Valencia', '46005', 'España', 137.94, 0, '2024-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201124-L3zXFDfzcEaVz-214', '9edf991a-4754-41fa-9eac-018406f4cee7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201124-L3zXFDfzcEaVz-214&s=KOL2024&nf=P5763&i=137.94&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6135, 1, 97, 2, 0, NULL, 0, '2024-11-20 15:15:07', '2024-11-20 16:17:14', '2024-11-20', 'P5764', '24-07543-11-20', '', 0.00, 28.50, 6.75, 0.00, 0, 0.00, 4.40, 'Calle Bidasoa 8, Bajo Bera', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 38.89, 0, '2024-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201124-VsTg7H1Vxe4Gi-110', '2c906a92-5fb6-412f-9537-a2d1097779f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201124-VsTg7H1Vxe4Gi-110&s=KOL2024&nf=P5764&i=38.89&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6136, 1, 1050, 2, 0, NULL, 0, '2024-11-20 16:38:06', '2024-11-21 08:21:00', '2024-11-21', 'P5766', '24-07544-11-20', '', 0.00, 85.50, 18.39, 0.00, 1, 4.55, 2.50, 'Carlos caamaño ,3', 'Madrid', 'Madrid', '28016', 'España', 110.51, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-211124-F5QDhi8jN5jHz-122', '0f82c386-1f75-4aee-92c1-aaaeba30c6ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211124-F5QDhi8jN5jHz-122&s=KOL2024&nf=P5766&i=110.51&cr=230', '[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
(6137, 1, 1532, 2, 0, NULL, 0, '2024-11-20 19:20:53', '2024-11-21 08:21:13', '2024-11-21', 'P5765', '24-07545-11-20', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Carmen Conde n 9 2-A', 'Valdemoro', 'Madrid', '28342', 'España', 28.39, 0, '2024-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211124-H1Gp3ETFKZT1T-034', '57e3491c-44fb-405c-b0e7-6e69f64741f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211124-H1Gp3ETFKZT1T-034&s=KOL2024&nf=P5765&i=28.39&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6138, 1, 1533, 2, 0, NULL, 0, '2024-11-21 10:13:58', '2024-11-21 11:16:32', '2024-11-21', 'P5767', '24-07548-11-21', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/CASTILLO DE CANDANCHU 48D 4ºB', 'Madrid', 'Madrid', '28050', 'España', 43.71, 0, '2024-11-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211124-BI2ryCKjC5bLX-089', '4aa5a57d-c031-45c1-b6fc-5097e023b703', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211124-BI2ryCKjC5bLX-089&s=KOL2024&nf=P5767&i=43.71&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6139, 1, 28, 1, 0, NULL, 0, '2024-11-21 11:26:35', '2024-11-21 11:26:35', '2024-11-21', 'P5768', '', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 137.94, 0, '2024-11-21 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-211124-R/aMOL5jbUS0p-103', '888f9189-d6da-47cd-a099-95edf59652a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211124-R%2FaMOL5jbUS0p-103&s=KOL2024&nf=P5768&i=137.94&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6140, 1, 1534, 2, 0, NULL, 0, '2024-11-21 12:05:27', '2024-11-21 13:08:21', '2024-11-21', 'P5769', '24-07549-11-21', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'Calle Antonio Royo s/n, bajo', 'Zaragoza', 'Zaragoza', '20014', 'España', 482.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-211124-OTJ+cUSntVODF-156', '4c7d227c-8776-4a47-b111-c8bcbab4231f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211124-OTJ%2BcUSntVODF-156&s=KOL2024&nf=P5769&i=482.79&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6141, 1, 1535, 2, 0, NULL, 0, '2024-11-21 14:26:54', '2024-11-21 16:03:41', '2024-11-21', 'P5770', '24-07550-11-21', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle bustamante 43, 1C', 'Madrid', 'Madrid', '28045', 'España', 17.50, 0, '2024-11-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-211124-IyvZ5aXnbCcZl-009', 'b44dfb24-93a9-4bbc-8d8c-bbc634129334', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211124-IyvZ5aXnbCcZl-009&s=KOL2024&nf=P5770&i=17.50&cr=146', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6142, 1, 1433, 1, 0, NULL, 0, '2024-11-21 16:07:31', '2024-11-21 16:07:31', '2024-11-21', 'P5771', '', '', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'Calle boters local 2 ', 'Vilafranca  del Pene', 'BARCELONA', '08720', 'España', 78.82, 0, '2024-11-21 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-211124-KzwNvlwYwe6r0-142', '16b50315-4506-479a-ab0d-2d7443064d66', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211124-KzwNvlwYwe6r0-142&s=KOL2024&nf=P5771&i=78.81&cr=055', '[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
(6143, 1, 342, 2, 0, NULL, 0, '2024-11-21 16:06:46', '2024-11-22 07:43:59', '2024-11-22', 'P5772', '24-07551-11-21', '', 0.00, 129.81, 27.26, 0.00, 0, 0.00, 0.00, 'Renaixement, 115 bajos 1a', 'Cerdanyola del Vallè', 'Barcelona', '08290', 'España', 157.07, 0, '2024-11-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221124-X1V4RDSDCGHG4-078', 'c42a3e3f-8c1e-42f5-a4d6-41ef1545c32c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221124-X1V4RDSDCGHG4-078&s=KOL2024&nf=P5772&i=157.07&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6144, 1, 1536, 2, 0, NULL, 0, '2024-11-21 16:53:25', '2024-11-22 07:33:08', '2024-11-22', 'P5773', '24-07552-11-21', 'entrega en horario comercial. INMOBILIARIA', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'octavio cuartero 70 bajo', 'Albacete', 'Albacete', '02003', 'España', 30.61, 0, '2024-11-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-221124-X6xTG0dfeVN9U-127', '3135fbec-409c-42e0-b195-544a3335e1f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221124-X6xTG0dfeVN9U-127&s=KOL2024&nf=P5773&i=30.61&cr=040', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6145, 1, 1537, 2, 0, NULL, 0, '2024-11-21 20:47:00', '2024-11-22 07:35:25', '2024-11-22', 'P5774', '24-07553-11-21', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Camí Ral, 190, 2', 'Tordera', 'Barcelona', '08490', 'España', 65.52, 0, '2024-11-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221124-QuubEqCXX+fzQ-159', '14eec767-13ca-49b9-bea7-b7b02c57dbde', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221124-QuubEqCXX%2BfzQ-159&s=KOL2024&nf=P5774&i=65.52&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6146, 1, 1147, 2, 0, NULL, 0, '2024-11-21 20:51:49', '2024-11-22 07:37:29', '2024-11-22', 'P5775', '24-07554-11-21', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avenida Aragón 14, Primero C', 'Teruel', 'Teruel', '44002', 'España', 61.09, 0, '2024-11-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221124-DIhbbaHtqkLrE-066', '3987c799-6516-45eb-8f83-ab17fb440425', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221124-DIhbbaHtqkLrE-066&s=KOL2024&nf=P5775&i=61.09&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6147, 1, 665, 1, 0, NULL, 0, '2024-11-22 09:30:54', '2024-11-22 09:37:25', '2024-11-22', 'P5776', '', '', 0.00, 40.70, 8.55, 0.00, 0, 0.00, 0.00, 'C/Hacienda de Pavones, 97. 3ºD', 'Madrid', 'Madrid', '28030', 'España', 49.25, 0, '2024-11-22 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-221124-TIcq47jFS7vWk-138', '71dc910d-065d-4963-952f-d2aa703c0bb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221124-TIcq47jFS7vWk-138&s=KOL2024&nf=P5776&i=49.25&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6148, 1, 1538, 2, 0, NULL, 0, '2024-11-22 08:43:51', '2024-11-22 10:24:13', '2024-11-22', 'P5777', '24-07555-11-22', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avenida diputacion edificio arosa 68  ático H ', 'Calpe/Calp', 'Alicante', '03710', 'España', 28.39, 0, '2024-11-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221124-WYhyd4WfQNcNK-236', '916f4d70-543a-4493-8ea9-13c0a3532b17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221124-WYhyd4WfQNcNK-236&s=KOL2024&nf=P5777&i=28.39&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
