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
(5041, 1, 1269, 2, 0, NULL, 0, '2024-05-12 11:55:44', '2024-05-13 09:37:09', '2024-05-13', 'P4710', '24-06361-05-12', 'Lunes cerrado por descanso semanal', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'LA PAZ, 21, LOCAL DERECHA', 'Zaragoza', 'Zaragoza', '50008', 'España', 196.56, 0, '2024-05-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130524-afMpYHaULVl1k-032', 'afe13d07-0276-429b-92a8-e918ff3e4cc9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-afMpYHaULVl1k-032&s=KOL2024&nf=P4710&i=196.56&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5042, 1, 793, 2, 0, NULL, 0, '2024-05-12 15:37:20', '2024-05-13 09:44:00', '2024-05-13', 'P4711', '24-06362-05-12', 'Entrada por Martin Luther King, 33', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'C/ Igualdad, 54 ', 'Alcorcón', 'Madrid', '28922', 'España', 71.98, 0, '2024-05-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130524-nsDfpMhbshTBh-172', 'd8330111-5507-4d3d-b5d8-27490c9ad46f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-nsDfpMhbshTBh-172&s=KOL2024&nf=P4711&i=71.98&cr=146', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5043, 1, 671, 2, 0, NULL, 0, '2024-05-12 20:52:30', '2024-05-13 09:46:23', '2024-05-13', 'P4712', '24-06363-05-12', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Carrer Tossal del Coro, 9, Apartament', 'Manresa', 'Barcelona', '08243', 'España', 28.39, 0, '2024-05-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130524-Ydr8NYO6IVK0M-076', '8f820256-7c00-4867-8389-6b562a6a7ad9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-Ydr8NYO6IVK0M-076&s=KOL2024&nf=P4712&i=28.39&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5044, 1, 102, 2, 0, NULL, 0, '2024-05-13 07:36:20', '2024-05-13 09:49:25', '2024-05-13', 'P4714', '24-06364-05-13', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Riera Lledoners 66, casa', 'Canet de Mar', 'Barcelona', '08360', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130524-fOBNVAO/ydvIH-101', 'b4cf3e05-3df2-4f1e-a236-651a4dcac91f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-fOBNVAO%2FydvIH-101&s=KOL2024&nf=P4714&i=71.47&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5045, 1, 202, 1, 0, NULL, 0, '2024-05-13 10:16:22', '2024-05-13 10:18:26', '2024-05-13', 'P4715', '', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '1008', 'España', 206.91, 0, '2024-05-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130524-SIMCZ+db/kdOc-038', '0ba9c40b-4895-4db7-a39f-b10cebf734ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-SIMCZ%2Bdb%2FkdOc-038&s=KOL2024&nf=P4715&i=206.91&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5046, 1, 65, 2, 0, NULL, 0, '2024-05-13 10:47:45', '2024-07-17 13:18:33', '2024-05-13', 'P4716', '24-06365-05-13', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130524-M12jsmVHLjbfn-192', '0a4c0845-03a8-444d-920f-7be88010c98d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-M12jsmVHLjbfn-192&s=KOL2024&nf=P4716&i=206.91&cr=108', '[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
(5047, 1, 1270, 2, 0, NULL, 0, '2024-05-13 14:53:30', '2024-05-14 09:15:14', '2024-05-14', 'P4717', '24-06366-05-13', 'Horario 9:30 a 18 de martes a viernes lunes cerrado.sabado de 9 a 13h\r\n', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Calle príncipe Felipe núm 18', 'Daganzo de Arriba', 'Madrid', '28814', 'España', 41.50, 0, '2024-05-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140524-DvuKEk83cOzVa-126', 'be24d475-f5cd-44f2-a3ae-85900cba62a7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140524-DvuKEk83cOzVa-126&s=KOL2024&nf=P4717&i=41.50&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5048, 1, 17, 1, 0, NULL, 0, '2024-05-14 09:18:18', '2024-05-14 09:18:43', '2024-05-14', 'P4718', '', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 137.94, 0, '2024-05-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140524-XJzcdSPy7CIB8-107', 'baadce05-84e4-4dde-9d3f-445720e0d794', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140524-XJzcdSPy7CIB8-107&s=KOL2024&nf=P4718&i=137.94&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5049, 1, 754, 2, 0, NULL, 0, '2024-05-14 08:02:12', '2024-05-14 10:05:18', '2024-05-14', 'P4719', '24-06367-05-14', 'tal como quedamos 6+1 de regalo RUBIO EXTRACLARO', 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-05-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140524-UnzESn7b/vLqz-197', '0bd11953-d0a0-4e5d-a47a-f7a117b911c8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140524-UnzESn7b%2FvLqz-197&s=KOL2024&nf=P4719&i=61.64&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5050, 1, 522, 2, 0, NULL, 0, '2024-05-14 08:36:48', '2024-05-14 10:46:30', '2024-05-14', 'P4720', '24-06368-05-14', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 241.40, 0, '2024-05-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140524-IRgUYm+9D6un9-092', '1899dbab-6583-4669-a70d-59264360803b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140524-IRgUYm%2B9D6un9-092&s=KOL2024&nf=P4720&i=241.40&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5051, 1, 720, 2, 0, NULL, 0, '2024-05-14 08:56:09', '2024-05-14 11:07:34', '2024-05-14', 'P4721', '24-06369-05-14', 'So no hay nadie, intentar con cualquier vecino que esté y sino dejar en felpudo.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sipiri 18 2D', 'Sopelana', 'Bizkaia', '48600', 'España', 28.39, 0, '2024-05-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140524-m4ou9cXC7Httu-223', '7ed1f6c4-15bc-4b83-a2ef-f08160cd3ed9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140524-m4ou9cXC7Httu-223&s=KOL2024&nf=P4721&i=28.39&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5052, 1, 1134, 1, 0, NULL, 0, '2024-05-14 13:02:41', '2024-05-14 13:04:22', '2024-05-14', 'P4722', '', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Aoiz 14, bajo.   ', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 68.97, 0, '2024-05-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140524-TmG6rPFgp0n95-154', '6d11660d-6a12-4c23-92a1-ca5f469f986d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140524-TmG6rPFgp0n95-154&s=KOL2024&nf=P4722&i=68.97&cr=056', '[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
(5053, 1, 468, 2, 0, NULL, 0, '2024-05-14 11:23:08', '2024-05-15 09:36:34', '2024-05-15', 'P4723', '24-06370-05-14', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Rof Carballo 1', 'Lugo', 'Lugo', '27002', 'España', 103.46, 0, '2024-05-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150524-TRJ0fOC5mcXre-054', '688682de-8138-4cee-8eb3-b364d1713473', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150524-TRJ0fOC5mcXre-054&s=KOL2024&nf=P4723&i=103.46&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5054, 1, 1271, 2, 0, NULL, 0, '2024-05-14 13:06:45', '2024-05-15 09:39:27', '2024-05-15', 'P4724', '24-06371-05-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'c/Muntadas, 8-10, 1r 3a', 'Barcelona', 'Barcelona', '08014', 'España', 17.50, 0, '2024-05-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150524-Ojq62qMP+o2kL-190', '46ff8a17-d61f-40dd-837a-456f289c41aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150524-Ojq62qMP%2Bo2kL-190&s=KOL2024&nf=P4724&i=17.50&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5055, 1, 1272, 2, 0, NULL, 0, '2024-05-14 19:57:24', '2024-05-15 09:42:21', '2024-05-15', 'P4725', '24-06372-05-14', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Karrika nagusia 15', 'Arantza', 'Navarra', '31790', 'España', 30.61, 0, '2024-05-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150524-GyzVHtZjoCWuw-058', 'df073a71-d1b9-4109-b9a2-ba065d609e32', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150524-GyzVHtZjoCWuw-058&s=KOL2024&nf=P4725&i=30.61&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5056, 1, 77, 1, 0, NULL, 0, '2024-05-15 09:31:28', '2024-05-15 09:31:28', '2024-05-15', 'P4726', '', '', 0.00, 214.50, 45.05, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 259.55, 0, '2024-05-15 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150524-HZqmmq2qhVWMI-173', '5fe02f4d-cc50-43dd-9e11-cfdcb0f72b02', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150524-HZqmmq2qhVWMI-173&s=KOL2024&nf=P4726&i=259.55&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5057, 1, 3, 1, 0, NULL, 0, '2024-05-15 09:47:34', '2024-05-15 09:47:34', '2024-05-15', 'P4727', '', '', 0.00, 370.50, 77.80, 0.00, 0, 0.00, 0.00, 'C/ PINTOR AURELIO VIRAFAJARDO Nº2 B', 'VITORIA', 'ÁLAVA', '01008', 'España', 448.30, 0, '2024-05-15 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150524-g4f+0FfTEfaKq-145', '7a1372ae-0024-4f73-a4be-47b4918680f1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150524-g4f%2B0FfTEfaKq-145&s=KOL2024&nf=P4727&i=448.30&cr=247', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5058, 1, 280, 2, 0, NULL, 0, '2024-05-15 08:24:52', '2024-05-15 10:59:45', '2024-05-15', 'P4728', '24-06374-05-15', 'LOS LUNES CERRADO', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'RUA CODESAL Nº2', 'O Pino', 'A Coruña', '15821', 'España', 137.94, 0, '2024-05-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150524-jmEs0leos5WiO-073', 'a6dfee0b-cf1e-4e1a-9443-c40d61dc2d69', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150524-jmEs0leos5WiO-073&s=KOL2024&nf=P4728&i=137.94&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
(5059, 1, 1020, 2, 0, NULL, 0, '2024-05-15 09:59:55', '2024-05-15 12:05:50', '2024-05-15', 'P4729', '24-06376-05-15', 'llamar antes de la entrega', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/pescaderia 14, c/san martin 14 2d', 'Donostia-San Sebasti', 'Gipuzkoa', '20003', 'España', 137.94, 0, '2024-05-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150524-b2u+xk7lyL5V/-055', '3caf92b5-f1a6-4458-91f0-309ad27ba417', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150524-b2u%2Bxk7lyL5V%2F-055&s=KOL2024&nf=P4729&i=137.94&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5060, 1, 623, 1, 0, NULL, 0, '2024-05-15 12:20:56', '2024-05-15 12:21:45', '2024-05-15', 'P4730', '', '', 0.00, 256.50, 53.86, 0.00, 0, 0.00, 0.00, 'La Gaiteira 66 bajo', 'Coruña (A)', 'A Coruña', '15006', 'España', 310.36, 0, '2024-05-15 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150524-JwuDWYyCinlIz-227', '0e5561d9-3828-436a-8229-10f350eb11d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150524-JwuDWYyCinlIz-227&s=KOL2024&nf=P4730&i=310.36&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5061, 1, 1110, 2, 0, NULL, 0, '2024-05-15 10:35:13', '2024-05-15 12:52:16', '2024-05-15', 'P4731', '24-06377-05-15', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'C/unió N015', 'Lleida', 'Lleida', '2502', 'España', 59.10, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150524-XbUuDhDoJSAhs-077', 'cb6d4570-5883-444b-82c1-934f38b2f98a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150524-XbUuDhDoJSAhs-077&s=KOL2024&nf=P4731&i=59.10&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5062, 1, 1274, 2, 0, NULL, 0, '2024-05-15 14:06:08', '2024-05-16 09:15:26', '2024-05-16', 'P4732', '24-06378-05-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Parque Erreniega n7 1 A', 'Zizur Mayor/Zizur Na', 'Navarra', '31180', 'España', 17.50, 0, '2024-05-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160524-ng9D8Z4n9io+S-136', 'eeed3956-7251-4ca2-bd44-0effa0aaf701', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160524-ng9D8Z4n9io%2BS-136&s=KOL2024&nf=P4732&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),
(5063, 1, 192, 2, 0, NULL, 0, '2024-05-15 15:24:57', '2024-05-16 09:18:10', '2024-05-16', 'P4733', '24-06379-05-15', '', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'plaza San Cristobal 3,bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 88.67, 0, '2024-05-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160524-mkKyHLAQasmDq-082', 'd983237e-4954-4eff-8725-41de9eaf2853', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160524-mkKyHLAQasmDq-082&s=KOL2024&nf=P4733&i=88.67&cr=026', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5064, 1, 1012, 2, 0, NULL, 0, '2024-05-16 04:19:30', '2024-05-16 09:19:40', '2024-05-16', 'P4734', '24-06380-05-16', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Josep de Peray, 17 bxs 1', 'Sant Cugat del Vallè', 'Barcelona', '08173', 'España', 17.50, 0, '2024-05-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160524-ZYXVNUy+2JSuQ-191', 'aaf77f60-f257-429f-86b5-6bc2b0f72294', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160524-ZYXVNUy%2B2JSuQ-191&s=KOL2024&nf=P4734&i=17.50&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5065, 1, 190, 3, 0, NULL, 0, '2024-05-16 09:14:10', '2024-10-15 16:04:10', '2024-05-16', '', 'Consumo interno', '', 0.00, 855.00, 179.55, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 1034.55, 0, '2024-05-16 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 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
(5066, 1, 154, 2, 0, NULL, 0, '2024-05-16 09:45:36', '2024-05-16 11:50:29', '2024-05-16', 'P4735', '24-06381-05-16', '', 0.00, 244.28, 51.30, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 295.58, 0, '2024-05-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160524-aMvEMWNEDxkT6-221', '385748c0-daf3-4756-a219-aafe93a4822f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160524-aMvEMWNEDxkT6-221&s=KOL2024&nf=P4735&i=295.58&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5067, 1, 108, 2, 0, NULL, 0, '2024-05-16 09:55:45', '2024-05-16 12:01:26', '2024-05-16', 'P4736', '24-06382-05-16', '', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 88.67, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-160524-SWOFeOxUIM+uk-083', '69ac5113-48bd-475d-87f5-0042572a1c25', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160524-SWOFeOxUIM%2Buk-083&s=KOL2024&nf=P4736&i=88.67&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5068, 1, 4, 2, 0, NULL, 0, '2024-05-16 17:54:07', '2024-05-17 09:29:44', '2024-05-17', 'P4737', '24-06383-05-16', '', 0.00, 293.14, 61.56, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 354.70, 0, '2024-05-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170524-YMiFybsvUaC13-144', '94c88884-06d8-4d0d-ba3f-288586af7947', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170524-YMiFybsvUaC13-144&s=KOL2024&nf=P4737&i=354.70&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5069, 1, 164, 2, 0, NULL, 0, '2024-05-16 18:11:04', '2024-05-17 09:31:33', '2024-05-17', 'P4738', '24-06384-05-16', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 275.88, 0, '2024-05-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170524-X5ORA6PcBLeYO-103', '51d3ca83-3b66-48b0-845f-91bea2fe7dbc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170524-X5ORA6PcBLeYO-103&s=KOL2024&nf=P4738&i=275.88&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5070, 1, 1275, 2, 0, NULL, 0, '2024-05-17 09:57:20', '2024-05-17 12:11:34', '2024-05-17', 'P4739', '24-06385-05-17', '', 0.00, 10.83, 3.79, 0.00, 0, 0.00, 8.76, 'Calle Pujol 20 - Sant Jordi ', 'Salines (Ses)', 'Baleares (Illes)', '07817', 'España', 21.86, 0, '2024-05-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170524-o9SVGGaQLWi4H-098', '5588be1a-2191-4a9c-a814-0d59458a8f48', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170524-o9SVGGaQLWi4H-098&s=KOL2024&nf=P4739&i=21.86&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5071, 1, 1276, 2, 0, NULL, 0, '2024-05-17 17:39:03', '2024-05-20 09:08:37', '2024-05-20', 'P4740', '24-06386-05-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'plaza del Renacimiento nº11 2º decha', 'Vitoria-Gasteiz', 'Álava', '01004', 'España', 17.50, 0, '2024-05-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200524-UwW35Efxg61cI-027', 'dd7eabaf-a314-4299-bebd-1d5a1b295e4c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-UwW35Efxg61cI-027&s=KOL2024&nf=P4740&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);
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
(5072, 1, 1277, 2, 0, NULL, 0, '2024-05-17 18:39:50', '2024-05-20 09:12:39', '2024-05-20', 'P4741', '24-06387-05-17', 'Llamar al 617370488 o 617456401', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida República Argentina 37 7b', 'Sevilla', 'Sevilla', '41011', 'España', 17.50, 0, '2024-05-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200524-HpPnFQK+ZBJ0w-228', '9969129a-4c8a-4591-824d-eb322bbc4154', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-HpPnFQK%2BZBJ0w-228&s=KOL2024&nf=P4741&i=17.50&cr=119', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5073, 1, 640, 2, 0, NULL, 0, '2024-05-18 09:38:26', '2024-05-20 09:15:16', '2024-05-20', 'P4742', '24-06388-05-18', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Alcover, 2-12 Casa 12', 'Castelldefels', 'Barcelona', '08860', 'España', 65.52, 0, '2024-05-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200524-VmTbq3XCW11Fe-111', '8b5dc3df-e7c0-4038-8445-9d3d4ad31ea2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-VmTbq3XCW11Fe-111&s=KOL2024&nf=P4742&i=65.52&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5074, 1, 522, 2, 0, NULL, 0, '2024-05-19 10:04:42', '2024-05-20 09:17:22', '2024-05-20', 'P4743', '24-06389-05-19', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 206.91, 0, '2024-05-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200524-Qaam78b0f5ODx-185', 'cf959299-0d5c-46b1-9d34-2e4de62543c5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-Qaam78b0f5ODx-185&s=KOL2024&nf=P4743&i=206.91&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5075, 1, 1278, 2, 0, NULL, 0, '2024-05-19 23:41:30', '2024-05-20 09:19:44', '2024-05-20', 'P4744', '24-06390-05-19', '', 0.00, 52.32, 10.99, 0.00, 0, 0.00, 0.00, 'C/Golondrina 4', 'Arahal', 'Sevilla', '41600', 'España', 63.31, 0, '2024-05-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-200524-i+ohb7zdtp8QR-039', '846f0376-863a-4c04-b4a0-ae6ec5457f8a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-i%2Bohb7zdtp8QR-039&s=KOL2024&nf=P4744&i=63.31&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5076, 1, 118, 1, 0, NULL, 0, '2024-05-20 09:03:57', '2024-05-20 10:39:28', '2024-05-20', 'P4745', '', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/Amezketa , 7 bajo , peluquería Yulane', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 137.94, 0, '2024-05-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200524-fTm9/RhS1Kh5v-076', '2dd623ea-f5f0-4ea6-a72f-d698f0ffb702', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-fTm9%2FRhS1Kh5v-076&s=KOL2024&nf=P4745&i=137.94&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5077, 1, 77, 1, 1, 'error en lo productos', 5056, '2024-05-20 09:23:59', '2024-05-20 09:24:11', '2024-05-20', 'R79', 'P4726 RECT.', '', 0.00, 214.50, 45.05, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 259.55, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-200524-I7RY/Hz9zB1nJ-036', '24da5c3f-474c-45c7-8d5f-cb8475a613f4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-I7RY%2FHz9zB1nJ-036&s=KOL2024&nf=R79&i=-259.55&cr=020', '[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
(5078, 1, 77, 1, 0, NULL, 0, '2024-05-20 09:26:28', '2024-05-20 09:26:28', '2024-05-20', 'P4746', '', '', 0.00, 214.50, 45.05, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 259.55, 0, '2024-05-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200524-XzULJLMoI6GRt-184', 'bcebf6d1-939f-4937-944c-3fe555c8f2cd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-XzULJLMoI6GRt-184&s=KOL2024&nf=P4746&i=259.55&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5079, 1, 77, 1, 0, NULL, 0, '2024-05-20 09:55:10', '2024-05-20 10:34:03', '2024-05-20', 'P4747', '', '', 0.00, 557.70, 117.12, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 674.82, 0, '2024-05-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200524-S6FbWB7DUr/nV-081', '38deb648-2db2-47f1-a42e-dfd89529ad63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-S6FbWB7DUr%2FnV-081&s=KOL2024&nf=P4747&i=674.82&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5080, 1, 1279, 2, 0, NULL, 0, '2024-05-20 09:06:10', '2024-05-20 12:15:08', '2024-05-20', 'P4748', '24-06391-05-20', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Moll de ponent s/n', 'Vilanova i la Geltrú', 'Barcelona', '08800', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200524-hse9ZFI4L7B5f-020', 'b883c589-5bd0-449e-8c7b-2d6906efada5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-hse9ZFI4L7B5f-020&s=KOL2024&nf=P4748&i=30.61&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5081, 1, 696, 1, 0, NULL, 0, '2024-05-20 12:43:44', '2024-05-20 12:43:44', '2024-05-20', 'P4749', '', '', 0.00, 257.40, 54.05, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 311.45, 0, '2024-05-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200524-S9Cle0SFVRUVo-159', 'd19dfaac-0641-4f90-9343-06b96dd44f1f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-S9Cle0SFVRUVo-159&s=KOL2024&nf=P4749&i=311.45&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5082, 1, 67, 2, 0, NULL, 0, '2024-05-20 10:57:41', '2024-05-20 13:15:01', '2024-05-20', 'P4750', '24-06392-05-20', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200524-A6IAlIv6Yffp0-121', 'f8992ca6-ec0d-4904-b547-8bd5835acdb7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200524-A6IAlIv6Yffp0-121&s=KOL2024&nf=P4750&i=172.43&cr=158', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5083, 1, 142, 2, 0, NULL, 0, '2024-05-20 20:00:46', '2024-05-21 08:56:59', '2024-05-21', 'P4751', '24-06393-05-20', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'C/ Manzanedo 12', 'Santoña', 'Cantabria', '39740', 'España', 172.43, 0, '2024-05-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210524-Vyg1pmoMgbkjZ-231', '00541cfd-5314-44e8-878f-fbe26672e685', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210524-Vyg1pmoMgbkjZ-231&s=KOL2024&nf=P4751&i=172.43&cr=068', '[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
(5084, 1, 1026, 2, 0, NULL, 0, '2024-05-20 21:21:58', '2024-05-21 08:59:44', '2024-05-21', 'P4752', '24-06394-05-20', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paseo María Agustin 15-17-19', 'Zaragoza', 'Zaragoza', '50004', 'España', 30.61, 0, '2024-05-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210524-GGgVNQH6sVpa5-008', '927bd048-a776-4a27-a705-301ed0393562', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210524-GGgVNQH6sVpa5-008&s=KOL2024&nf=P4752&i=30.61&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5085, 1, 1280, 2, 0, NULL, 0, '2024-05-21 06:58:00', '2024-05-21 09:02:24', '2024-05-21', 'P4753', '24-06395-05-21', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'C/Joan Alsina, 27 bxs 2a', 'Girona', 'Girona', '17003', 'España', 52.39, 0, '2024-05-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210524-NoVPRTwAajwFR-008', '8d51d3fe-9b69-4a52-a665-4e999877f7d6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210524-NoVPRTwAajwFR-008&s=KOL2024&nf=P4753&i=52.39&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5086, 1, 131, 2, 0, NULL, 0, '2024-05-21 08:05:54', '2024-05-21 10:51:57', '2024-05-21', 'P4755', '24-06396-05-21', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'C / general eguia frente al 31, Peluqueria bilbo', 'Bilbao', 'Bizkaia', '48013', 'España', 517.28, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210524-ZD+a2YrrgbSyP-032', '32d6a796-d27f-4e56-9b1a-4e2e3149c478', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210524-ZD%2Ba2YrrgbSyP-032&s=KOL2024&nf=P4755&i=517.28&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5087, 1, 160, 2, 0, NULL, 0, '2024-05-21 08:07:53', '2024-05-21 10:55:34', '2024-05-21', 'P4754', '24-06397-05-21', '', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 88.67, 0, '2024-05-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210524-jrRD7Gx9T15QA-014', '9be14cd9-e208-4c98-bce8-08eeec197f71', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210524-jrRD7Gx9T15QA-014&s=KOL2024&nf=P4754&i=88.67&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5088, 1, 65, 2, 0, NULL, 0, '2024-05-21 08:54:21', '2024-07-17 13:18:40', '2024-05-21', 'P4756', '24-06398-05-21', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 344.85, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210524-c2fvDg7e/QwLh-142', 'f5c30b8e-53d4-41ee-ac3a-75773d767106', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210524-c2fvDg7e%2FQwLh-142&s=KOL2024&nf=P4756&i=344.85&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5089, 1, 979, 2, 0, NULL, 0, '2024-05-21 11:35:56', '2024-05-22 09:21:02', '2024-05-22', 'P4759', '24-06399-05-21', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'calle palma 58 local 1', 'Madrid', 'Madrid', '28015', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220524-YKu/PFh6yXXDV-131', 'ff940b56-d735-43cf-a91a-dba9266aa5db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220524-YKu%2FPFh6yXXDV-131&s=KOL2024&nf=P4759&i=241.40&cr=235', '[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
(5090, 1, 1188, 2, 0, NULL, 0, '2024-05-21 12:21:47', '2024-05-22 09:23:58', '2024-05-22', 'P4757', '24-06400-05-21', 'jiaNa PELUQUERÍA ORGÁNICA', 0.00, 28.50, 6.75, 0.00, 0, 0.00, 4.40, 'Baíñas Calle C número 3', 'Vimianzo', 'A Coruña', '15127', 'España', 38.89, 0, '2024-05-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220524-LPFhK8HX54XqX-017', 'e0ad94cb-22a5-4f59-be91-bcf8832c1d67', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220524-LPFhK8HX54XqX-017&s=KOL2024&nf=P4757&i=38.89&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5091, 1, 23, 2, 0, NULL, 0, '2024-05-22 07:11:05', '2024-05-22 09:25:53', '2024-05-22', 'P4758', '24-06401-05-22', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 206.91, 0, '2024-05-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220524-JnBHK0fgJhfOq-221', '528e6b8d-04cd-4e70-a2ed-e095d6ef9936', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220524-JnBHK0fgJhfOq-221&s=KOL2024&nf=P4758&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),
(5092, 1, 166, 1, 0, NULL, 0, '2024-05-22 09:30:15', '2024-05-22 09:31:51', '2024-05-22', 'P4760', '', '', 0.00, 180.18, 37.84, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 218.02, 0, '2024-05-22 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220524-D6fLtQq1grcc4-112', '1ede90fa-04c7-43a3-8ad3-dcc354ccf714', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220524-D6fLtQq1grcc4-112&s=KOL2024&nf=P4760&i=218.02&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5093, 1, 1138, 2, 0, NULL, 0, '2024-05-22 09:11:27', '2024-05-22 11:27:50', '2024-05-22', 'P4761', '24-06402-05-22', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carretera De santibañez 29c', 'Aller', 'Asturias', '33680', 'España', 17.50, 0, '2024-05-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220524-hX85JiXvgr2dA-107', '54ebb0b3-906f-4425-80f6-fde57c294446', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220524-hX85JiXvgr2dA-107&s=KOL2024&nf=P4761&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),
(5094, 1, 898, 2, 0, NULL, 0, '2024-05-22 10:19:59', '2024-05-22 12:42:17', '2024-05-22', 'P4762', '24-06403-05-22', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'beato tomas de zumarraga nº2 3C', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 17.50, 0, '2024-05-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220524-Zw0RkaNV0x5BB-247', '6bb3692c-acd0-403d-80ce-fab410c9a141', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220524-Zw0RkaNV0x5BB-247&s=KOL2024&nf=P4762&i=17.50&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5095, 1, 337, 2, 0, NULL, 0, '2024-05-22 12:49:11', '2024-05-23 09:35:31', '2024-05-23', 'P4764', '24-06404-05-22', '', 0.00, 97.68, 20.51, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 118.19, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230524-ieyNiuim5m/fG-159', '45a27b3c-7ca5-4926-9ee5-a9691797b8d6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230524-ieyNiuim5m%2FfG-159&s=KOL2024&nf=P4764&i=118.19&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
