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
(5755, 1, 810, 2, 0, NULL, 0, '2024-09-17 08:39:11', '2024-09-17 10:44:09', '2024-09-17', 'P5403', '24-07132-09-17', '', 0.00, 84.81, 17.81, 0.00, 0, 0.00, 0.00, 'Calle El Sol 14 1C', 'Tordesillas', 'Valladolid', '47100', 'España', 102.62, 0, '2024-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170924-h+s982K9/bPyD-110', '81ea320d-c928-4c27-94a8-d1a68342a67b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170924-h%2Bs982K9%2FbPyD-110&s=KOL2024&nf=P5403&i=102.62&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5756, 1, 190, 3, 0, NULL, 0, '2024-09-17 12:52:30', '2024-09-18 09:12:54', '2024-09-17', '', 'Consumo interno', '', 0.00, 1270.20, 266.74, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 1536.94, 0, '2024-09-17 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),
(5757, 1, 1416, 2, 0, NULL, 0, '2024-09-17 11:18:03', '2024-09-17 13:19:55', '2024-09-17', 'P5404', '24-07133-09-17', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle del Monte Urgull 12 . Piso B', 'Madrid', 'Madrid', '28038', 'España', 30.61, 0, '2024-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170924-BdRs+SOT8UJhR-158', '524687d8-00ea-42cb-b4ba-c121453fb8d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170924-BdRs%2BSOT8UJhR-158&s=KOL2024&nf=P5404&i=30.61&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5758, 1, 17, 2, 0, NULL, 0, '2024-09-17 13:35:32', '2024-09-18 09:15:37', '2024-09-18', 'P5405', '24-07134-09-17', '', 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-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180924-dnHVpfja4Guuh-231', '829f760f-cb91-438b-966d-f221a6de9350', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180924-dnHVpfja4Guuh-231&s=KOL2024&nf=P5405&i=137.94&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5759, 1, 190, 3, 0, NULL, 0, '2024-09-17 17:11:28', '2024-09-17 17:11:28', '2024-09-17', '', 'Consumo interno', '<p>pruebas para nuevos colores</p>', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 413.82, 0, '2024-09-17 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),
(5760, 1, 547, 2, 0, NULL, 0, '2024-09-17 15:22:48', '2024-09-18 09:17:34', '2024-09-18', 'P5406', '24-07135-09-17', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Humboldt 2, 1°dcha.', 'Oleiros', 'A Coruña', '15172', 'España', 30.61, 0, '2024-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180924-GPKsunwBShsRU-212', 'f44e75da-81d6-472a-9c8a-63123877822c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180924-GPKsunwBShsRU-212&s=KOL2024&nf=P5406&i=30.61&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5761, 1, 172, 2, 0, NULL, 0, '2024-09-17 16:10:39', '2024-09-18 09:19:34', '2024-09-18', 'P5409', '24-07136-09-17', '', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'Font de Caps, 50', 'Talarn', 'Lleida', '25630', 'España', 113.30, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180924-L5/kAGN7cI9M5-158', 'd18c3238-d807-4b8b-8abb-ec849ba5769e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180924-L5%2FkAGN7cI9M5-158&s=KOL2024&nf=P5409&i=113.30&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5762, 1, 120, 2, 0, NULL, 0, '2024-09-17 17:01:59', '2024-09-18 09:23:16', '2024-09-18', 'P5407', '24-07137-09-17', '', 0.00, 28.50, 6.75, 0.00, 0, 0.00, 4.40, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 38.89, 0, '2024-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180924-a2Ot8NxId9Bly-022', 'e7d2aef3-1e9d-4aa4-80a5-3656cba32b38', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180924-a2Ot8NxId9Bly-022&s=KOL2024&nf=P5407&i=38.89&cr=187', '[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
(5763, 1, 170, 2, 0, NULL, 0, '2024-09-18 07:08:17', '2024-09-18 09:24:35', '2024-09-18', 'P5408', '24-07138-09-18', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Plaza de las agustinas N°5  ', 'Hernani', 'Gipuzkoa', '20120', 'España', 206.91, 0, '2024-09-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180924-kXjWyAfk80pPs-057', 'fd426fca-3f9e-4c85-a00b-cb880a6d3c7d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180924-kXjWyAfk80pPs-057&s=KOL2024&nf=P5408&i=206.91&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5764, 1, 149, 2, 0, NULL, 0, '2024-09-18 07:25:46', '2024-09-18 09:29:15', '2024-09-18', 'P5410', '24-07139-09-18', '', 0.00, 158.78, 33.78, 0.00, 0, 0.00, 2.50, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 194.62, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-180924-jcqMu9J8bsv2h-106', '7fde2c7d-1cf7-45a8-9e64-c1e6a3dabea0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180924-jcqMu9J8bsv2h-106&s=KOL2024&nf=P5410&i=194.62&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5765, 1, 115, 2, 0, NULL, 0, '2024-09-18 07:56:05', '2024-09-18 10:17:10', '2024-09-18', 'P5411', '24-07140-09-18', '', 0.00, 40.70, 9.31, 0.00, 0, 0.00, 4.40, 'MONASTERIO DE URDAX NR. 38', 'Pamplona/Iruña', 'Navarra', '31011', 'España', 53.65, 0, '2024-09-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180924-nsLRJ3A+6Nrm2-223', '3450cbb4-f213-49dc-9a45-f5fb034b5ba6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180924-nsLRJ3A%2B6Nrm2-223&s=KOL2024&nf=P5411&i=53.65&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5766, 1, 34, 2, 0, NULL, 0, '2024-09-18 09:03:27', '2024-09-18 11:24:19', '2024-09-18', 'P5412', '24-07141-09-18', 'Factura en papel. Entregar de Martes a viernes hasta las 13.00', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'peluqueria Marzo21 calle iparraguirre34 plaza trasera   Leioa Bizkaia', 'Leioa', 'Bizkaia', '48940', 'España', 517.28, 0, '2024-09-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180924-XbE6QEnU5laf+-239', '066baf42-33b9-4aa7-8af8-fcd5bfbe713d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180924-XbE6QEnU5laf%2B-239&s=KOL2024&nf=P5412&i=517.28&cr=154', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5767, 1, 11, 2, 0, NULL, 0, '2024-09-18 11:15:16', '2024-09-18 13:20:30', '2024-09-18', 'P5414', '24-07142-09-18', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'calle Colomeres 36 local 2', 'Gavà', 'Barcelona', '08840', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180924-bNoeAilLgsZEK-174', '73d2763b-1cb3-45c6-8881-4d9099156aa2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180924-bNoeAilLgsZEK-174&s=KOL2024&nf=P5414&i=103.46&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5768, 1, 77, 1, 0, NULL, 0, '2024-09-18 13:19:20', '2024-09-18 13:19:20', '2024-09-19', 'P5413', '2024-09-18', '', 0.00, 1287.00, 270.27, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1557.27, 0, '2024-09-18 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190924-pBmQUXY8QUsQ4-243', '5c941ed3-25fe-49aa-8ac2-c58d49ac4563', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190924-pBmQUXY8QUsQ4-243&s=KOL2024&nf=P5413&i=1557.27&cr=014', '[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
(5769, 1, 1418, 2, 0, NULL, 0, '2024-09-18 12:56:15', '2024-09-19 08:33:48', '2024-09-19', 'P5417', '24-07143-09-18', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Leonor de Aquitania 40, 4B', 'Berrioplano', 'Navarra', '31013', 'España', 17.50, 0, '2024-09-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190924-BRGogKcnVWF/1-130', '09d2603c-0cd5-463e-a118-df4949119538', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190924-BRGogKcnVWF%2F1-130&s=KOL2024&nf=P5417&i=17.50&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5770, 1, 345, 2, 0, NULL, 0, '2024-09-18 14:33:59', '2024-09-19 08:35:58', '2024-09-19', 'P5415', '24-07144-09-18', 'El salón de peluquería los lunes por la tarde está cerrado ', 0.00, 81.40, 17.09, 0.00, 0, 0.00, 0.00, 'Espronceda 336', 'Barcelona', 'Barcelona', '08027', 'España', 98.49, 0, '2024-09-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190924-T7X2jh20uCgbg-111', '1358b4b8-e6d0-481c-8a3f-515b79ab5337', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190924-T7X2jh20uCgbg-111&s=KOL2024&nf=P5415&i=98.49&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5771, 1, 1419, 2, 0, NULL, 0, '2024-09-18 19:24:28', '2024-09-19 08:39:45', '2024-09-19', 'P5416', '24-07145-09-18', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Joaquín Velasco Martín, 28', 'Valladolid', 'Valladolid', '47014', 'España', 52.39, 0, '2024-09-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190924-gOFDIjowBQWRB-090', '5f29edba-2c2a-4721-b90d-17144c733b8c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190924-gOFDIjowBQWRB-090&s=KOL2024&nf=P5416&i=52.39&cr=009', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5772, 1, 1417, 1, 0, NULL, 0, '2024-09-19 08:42:38', '2024-09-19 08:46:55', '2024-09-19', 'P5418', '', '', 0.00, 300.30, 63.06, 0.00, 0, 0.00, 0.00, 'c/ Hispanidad 23', 'Sevilla la Nueva', 'Madrid', '28609', 'España', 363.36, 0, '2024-09-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190924-BbwR1ITLFTqdP-204', '85f08520-af68-4220-a83c-4bfe71fdb0bf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190924-BbwR1ITLFTqdP-204&s=KOL2024&nf=P5418&i=363.36&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(5773, 1, 241, 2, 0, NULL, 0, '2024-09-19 09:39:06', '2024-09-19 11:40:53', '2024-09-19', 'P5419', '24-07153-09-19', '', 0.00, 97.68, 20.51, 0.00, 1, 5.08, 0.00, 'C/Morales Hidalgo, 4 bajo', 'Ponteareas', 'Pontevedra', '36860', 'España', 123.27, 0, '2024-09-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190924-Xw27PPxNpufT8-120', '1e310ac1-085f-49df-a5f7-0fabf1f21133', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190924-Xw27PPxNpufT8-120&s=KOL2024&nf=P5419&i=123.27&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5774, 1, 445, 1, 0, NULL, 0, '2024-09-19 12:19:06', '2024-09-19 12:19:06', '2024-09-19', 'P5420', '', '', 0.00, 40.70, 8.98, 0.00, 0, 0.00, 2.50, 'AMETZAGAÑA  66 BAJO, (ARTE MARMOL)', 'Donostia-San Sebasti', 'Gipuzkoa', '20012', 'España', 51.75, 0, '2024-09-19 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-190924-VoamO4gRGj8jq-250', '98778e8e-8884-415f-b641-cd2b58ba94eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190924-VoamO4gRGj8jq-250&s=KOL2024&nf=P5420&i=51.75&cr=238', '[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
(5775, 1, 1143, 2, 0, NULL, 0, '2024-09-20 06:19:48', '2024-09-20 09:04:56', '2024-09-20', 'P5421', '24-07154-09-20', 'Si no estoy en casa, podeis dejarlo tras la puerta de al lado (contadores).', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avda. Los Huetos 1, 8A', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 17.50, 0, '2024-09-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200924-ghHr0VJc3ApVg-249', '7ada6511-70a5-4719-ae43-d0db34203e72', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200924-ghHr0VJc3ApVg-249&s=KOL2024&nf=P5421&i=17.50&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5776, 1, 696, 1, 0, NULL, 0, '2024-09-20 09:11:21', '2024-09-20 09:49:38', '2024-09-20', 'P5422', '2024-09-20', '', 0.00, 806.52, 169.37, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 975.89, 0, '2024-09-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200924-l4AYKG+pt52aX-045', 'b01b3ad6-8eee-4679-a320-1ba6060f39aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200924-l4AYKG%2Bpt52aX-045&s=KOL2024&nf=P5422&i=975.89&cr=138', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5777, 1, 4, 2, 0, NULL, 0, '2024-09-20 08:24:17', '2024-09-20 10:33:09', '2024-09-20', 'P5423', '24-07155-09-20', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 379.34, 0, '2024-09-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200924-Jh9n0ItFdEOQE-196', '76a26718-099a-4461-8f1f-55a211fff359', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200924-Jh9n0ItFdEOQE-196&s=KOL2024&nf=P5423&i=379.34&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5778, 1, 1317, 2, 0, NULL, 0, '2024-09-20 13:05:07', '2024-09-23 08:44:31', '2024-09-23', 'P5424', '24-07156-09-20', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Jaca 4. Casa 2', 'Cuarte de Huerva', 'Zaragoza', '50410', 'España', 17.50, 0, '2024-09-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230924-WhkqNNlvfnHLK-251', 'b3e10e33-ee63-4f88-95d6-93013a146939', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230924-WhkqNNlvfnHLK-251&s=KOL2024&nf=P5424&i=17.50&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5779, 1, 1417, 1, 0, NULL, 0, '2024-09-23 08:52:34', '2024-09-23 08:52:34', '2024-09-23', 'P5425', '', '', 0.00, 85.80, 18.02, 0.00, 0, 0.00, 0.00, 'c/ Hispanidad 23', 'Sevilla la Nueva', 'Madrid', '28609', 'España', 103.82, 0, '2024-09-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230924-Hme5YGZ6gFHXD-152', '1cde85fb-14e5-42d4-828c-4c236501accd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230924-Hme5YGZ6gFHXD-152&s=KOL2024&nf=P5425&i=103.82&cr=074', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5780, 1, 152, 1, 0, NULL, 0, '2024-09-23 09:19:37', '2024-09-23 09:21:03', '2024-09-23', 'P5426', '', '', 0.00, 265.98, 55.86, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 321.84, 0, '2024-09-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230924-PdcGBHH5D6F9l-196', '2f08f9f5-967b-4c1a-a908-57dfed9309b5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230924-PdcGBHH5D6F9l-196&s=KOL2024&nf=P5426&i=321.83&cr=165', '[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
(5781, 1, 1050, 2, 0, NULL, 0, '2024-09-23 07:23:04', '2024-09-23 09:51:32', '2024-09-23', 'P5427', '24-07157-09-23', '', 0.00, 57.00, 12.40, 0.00, 1, 3.07, 2.50, 'Carlos caamaño,3', 'Madrid', 'Madrid', '28016', 'España', 74.54, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-230924-EbZRMUk0FkZ6J-255', 'dc1ef24f-47c5-46df-8e7e-145ec3b34e02', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230924-EbZRMUk0FkZ6J-255&s=KOL2024&nf=P5427&i=74.54&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5782, 1, 1420, 2, 0, NULL, 0, '2024-09-23 09:04:20', '2024-09-23 11:12:30', '2024-09-23', 'P5428', '24-07158-09-23', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Mayor 12', 'Asteasu', 'Gipuzkoa', '20159', 'España', 30.61, 0, '2024-09-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230924-LF3hHEsqcQO4p-150', '2b989706-0145-4a1c-8eff-043bb0b44b6a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230924-LF3hHEsqcQO4p-150&s=KOL2024&nf=P5428&i=30.61&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5783, 1, 199, 2, 0, NULL, 0, '2024-09-23 15:19:17', '2024-09-23 17:26:06', '2024-09-23', 'P5429', '24-07159-09-23', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Zumaia 17 3 C', 'Bilbao', 'Bizkaia', '48007', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-230924-XhMOpFKJRnrm8-186', 'a9d895dd-1643-4cdc-9bdb-c7022dc2c659', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230924-XhMOpFKJRnrm8-186&s=KOL2024&nf=P5429&i=71.47&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5784, 1, 1249, 2, 0, NULL, 0, '2024-09-23 18:30:55', '2024-09-24 08:37:27', '2024-09-24', 'P5430', '24-07160-09-23', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle de Jorge Guillén, 15, 6B', 'Zaragoza', 'Zaragoza', '50018', 'España', 56.82, 0, '2024-09-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240924-T69M339C3J158-158', '042aa602-4cd0-4a94-b87b-b91f57b0e788', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-T69M339C3J158-158&s=KOL2024&nf=P5430&i=56.82&cr=162', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5785, 1, 522, 2, 0, NULL, 0, '2024-09-23 19:39:32', '2024-09-24 08:42:23', '2024-09-24', 'P5431', '24-07161-09-23', '', 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-09-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240924-o4Gpxs2FlZX5U-240', 'daf65c0e-9f3b-457d-bf8b-b3ab899fd218', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-o4Gpxs2FlZX5U-240&s=KOL2024&nf=P5431&i=241.40&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5786, 1, 1248, 2, 0, NULL, 0, '2024-09-23 21:16:17', '2024-09-24 08:43:28', '2024-09-24', 'P5432', '24-07162-09-23', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer de Sardenya 398 5°2°', 'Barcelona', 'Barcelona', '08025', 'España', 17.50, 0, '2024-09-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240924-OotYFv4GyQgkt-240', '5ec29f43-aff8-4066-81ad-bfa125b5651d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-OotYFv4GyQgkt-240&s=KOL2024&nf=P5432&i=17.50&cr=118', '[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
(5787, 1, 1162, 2, 0, NULL, 0, '2024-09-23 22:40:51', '2024-09-24 08:44:20', '2024-09-24', 'P5433', '24-07164-09-23', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Calle del Pilar 27', 'Casinos', 'Valencia', '46171', 'España', 61.09, 0, '2024-09-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240924-cFQ8qmsyn9ZW8-097', '81228d4f-7d1b-4e4f-8797-91b4b5d44e9e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-cFQ8qmsyn9ZW8-097&s=KOL2024&nf=P5433&i=61.09&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5788, 1, 1043, 2, 0, NULL, 0, '2024-09-24 08:07:23', '2024-09-24 10:32:53', '2024-09-24', 'P5434', '24-07165-09-24', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Larrakotorre 18- 2 drch', 'Bilbao', 'Bizkaia', '48015', 'España', 43.71, 0, '2024-09-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240924-g6vcPUlXB46Xi-021', '96ee07bd-6c82-4516-8848-e6facfd46e52', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-g6vcPUlXB46Xi-021&s=KOL2024&nf=P5434&i=43.71&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5789, 1, 244, 2, 0, NULL, 0, '2024-09-24 08:10:22', '2024-09-24 10:36:05', '2024-09-24', 'P5435', '24-07167-09-24', 'Si no estoy, dejar en la barbería', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'Carrer Balmes 79 Local 3 Peluquería Maimar', 'Calella', 'Barcelona', '08370', 'España', 157.64, 0, '2024-09-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240924-Hf7JsSs8sUIjv-034', 'f479e298-2c1b-4761-a0e9-b3bbe149e45a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-Hf7JsSs8sUIjv-034&s=KOL2024&nf=P5435&i=157.63&cr=230', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5790, 1, 932, 2, 0, NULL, 0, '2024-09-24 08:37:26', '2024-09-24 11:01:31', '2024-09-24', 'P5437', '24-07168-09-24', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'Calle acera del pilar, edificio residencial casa fuerte local 2 peluquería ', 'Almuñécar', 'Granada', '18697', 'España', 140.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-240924-Y2flgWkK2Jkmo-020', 'ab99c28b-66be-4f0d-9103-bfe1047487ab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-Y2flgWkK2Jkmo-020&s=KOL2024&nf=P5437&i=140.44&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5791, 1, 721, 2, 0, NULL, 0, '2024-09-24 08:53:04', '2024-09-24 11:03:45', '2024-09-24', 'P5436', '24-07169-09-24', 'ESCALERA DERECHA', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ AIOTZATEGI 18 ESCALERA DERECHA 4C', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 30.61, 0, '2024-09-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240924-J2bPorRLdbV/q-085', '567d6987-713a-4783-b167-7659ce3fb885', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-J2bPorRLdbV%2Fq-085&s=KOL2024&nf=P5436&i=30.61&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5792, 1, 166, 1, 0, NULL, 0, '2024-09-24 11:39:43', '2024-09-24 11:40:52', '2024-09-24', 'P5438', '2024-09-24', '', 0.00, 137.28, 28.83, 0.00, 1, 7.14, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 173.25, 0, '2024-09-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240924-m7BRQlY22lzyr-027', 'b3bf4618-3bca-41a4-aad6-a3725ba2f630', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-m7BRQlY22lzyr-027&s=KOL2024&nf=P5438&i=173.25&cr=075', '[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
(5793, 1, 87, 2, 0, NULL, 0, '2024-09-24 09:55:16', '2024-09-24 12:11:24', '2024-09-24', 'P5439', '24-07170-09-24', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Cc arcco local p 17', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 206.91, 0, '2024-09-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240924-WgSKzH+BoICMS-146', '0eee8597-1da1-4c62-94fe-51e9e3f6d3a2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-WgSKzH%2BBoICMS-146&s=KOL2024&nf=P5439&i=206.91&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5794, 1, 28, 2, 0, NULL, 0, '2024-09-24 10:15:40', '2024-09-24 12:19:28', '2024-09-24', 'P5440', '24-07171-09-24', 'MANDAR PANFLETOS DE LA COLORACION HERBAL PARA DAR A LAS CLIENTAS,  GRACIAS', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'gorbea n8 bajo', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 310.37, 0, '2024-09-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240924-GOACcBVpsyq02-154', '546fee15-3a5c-42de-96df-ab1629a78140', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-GOACcBVpsyq02-154&s=KOL2024&nf=P5440&i=310.37&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5795, 1, 686, 2, 0, NULL, 0, '2024-09-24 10:43:24', '2024-09-24 12:48:14', '2024-09-24', 'P5441', '24-07172-09-24', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'CALLE DEL PARQUE 3 . UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 172.43, 0, '2024-09-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240924-AttiB+KAsfRyq-128', '5f239f35-9a87-494d-a95a-2b4b79ff6465', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240924-AttiB%2BKAsfRyq-128&s=KOL2024&nf=P5441&i=172.43&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5796, 1, 1421, 2, 0, NULL, 0, '2024-09-24 20:03:38', '2024-09-25 10:28:34', '2024-09-25', 'P5442', '24-07173-09-24', 'Horario comercial ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Juan XXIII, 6, Bajo', 'Logroño', 'La Rioja', '26003', 'España', 17.50, 0, '2024-09-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-250924-a3oAbXOM49uSl-193', 'd1a2965f-1ecd-4b8c-813b-8313d85297b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250924-a3oAbXOM49uSl-193&s=KOL2024&nf=P5442&i=17.50&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '2024-09-27', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5797, 1, 1424, 1, 0, NULL, 0, '2024-09-25 08:11:58', '2024-09-27 09:05:34', '2024-09-27', 'P5458', '', '', 0.00, 431.42, 90.60, 0.00, 0, 0.00, 0.00, 'Calle Hernani 25-4º', 'Donostia-San Sebasti', 'Gipuzkoa', '20004', 'España', 522.02, 0, '2024-09-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-270924-M0UpvuJkO6ewH-130', 'ba324c27-688a-4d76-aaa2-9ded16324de2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270924-M0UpvuJkO6ewH-130&s=KOL2024&nf=P5458&i=522.02&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5798, 1, 468, 2, 0, NULL, 0, '2024-09-25 07:39:22', '2024-09-25 10:30:52', '2024-09-25', 'P5443', '24-07174-09-25', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Rof Carballo 1', 'Lugo', 'Lugo', '27002', 'España', 68.97, 0, '2024-09-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-250924-EQqoQDxwJm/ed-209', '30d3110a-3033-4462-bc63-643325862e99', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250924-EQqoQDxwJm%2Fed-209&s=KOL2024&nf=P5443&i=68.97&cr=000', '[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
(5799, 1, 1033, 2, 0, NULL, 0, '2024-09-25 08:32:31', '2024-09-25 11:01:22', '2024-09-25', 'P5444', '24-07175-09-25', '', 0.00, 48.84, 10.69, 0.00, 0, 0.00, 2.50, 'Lersundi 18 bajo peluqueria Ilea', 'Deba', 'Gipuzkoa', '20820', 'España', 61.60, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-250924-K0zfGhXhOh/As-241', '72ee4b4b-e877-4bb5-b974-2f4722c3b643', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250924-K0zfGhXhOh%2FAs-241&s=KOL2024&nf=P5444&i=61.60&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5800, 1, 1423, 2, 0, NULL, 0, '2024-09-25 08:34:06', '2024-09-25 11:02:21', '2024-09-25', 'P5445', '24-07176-09-25', '', 0.00, 321.64, 67.54, 0.00, 0, 0.00, 0.00, 'general eguia frente al 31', 'Bilbao', 'Bizkaia', '48013', 'España', 389.18, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250924-ZpdmsFfmBlaZK-111', '7a45f205-3ca3-4c9f-a01e-f781804e80b0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250924-ZpdmsFfmBlaZK-111&s=KOL2024&nf=P5445&i=389.18&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5801, 1, 1417, 1, 1, 'la clienta se confundió en el pedido al añadir 10 artículos de más del PTD06', 5772, '2024-09-25 11:53:12', '2024-09-25 11:53:12', '2024-09-25', 'R90', 'P5418 RECT.', '', 0.00, 300.30, 63.06, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 363.36, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-250924-Qkpao665L5CWt-054', 'ae4b15d6-5349-4afa-918b-18998143f1d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250924-Qkpao665L5CWt-054&s=KOL2024&nf=R90&i=-363.36&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(5802, 1, 1417, 1, 0, NULL, 0, '2024-09-25 11:57:31', '2024-09-25 11:57:31', '2024-09-25', 'P5446', '', '', 0.00, 257.40, 54.05, 0.00, 0, 0.00, 0.00, 'c/ Hispanidad 23', 'Sevilla la Nueva', 'Madrid', '28609', 'España', 311.45, 0, '2024-09-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250924-DlSaoifEpjy64-009', 'a4cd0718-1483-4bf6-89c1-25e22a8ebaed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250924-DlSaoifEpjy64-009&s=KOL2024&nf=P5446&i=311.45&cr=123', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5803, 1, 1130, 2, 0, NULL, 0, '2024-09-25 12:43:16', '2024-09-26 08:19:36', '2024-09-26', 'P5447', '24-07177-09-25', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Ulises, 4', 'Mairena del Aljarafe', 'Sevilla', '41927', 'España', 17.50, 0, '2024-09-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260924-Yh2CNaSJpE1ZM-008', 'a68cc628-1298-49f1-9f0e-55d06b6e3061', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260924-Yh2CNaSJpE1ZM-008&s=KOL2024&nf=P5447&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),
(5804, 1, 1424, 2, 0, NULL, 0, '2024-09-25 12:59:29', '2024-09-25 12:59:29', '2024-09-25', '', '24-07178-09-25', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Calle Hernani 25-4º', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(5805, 1, 1424, 2, 0, NULL, 0, '2024-09-25 13:24:38', '2024-09-25 13:24:38', '2024-09-25', '', '24-07179-09-25', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Hernani  25-4º', 'Donostia-San Sebasti', 'Gipuzkoa', '20003', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(5806, 1, 57, 2, 0, NULL, 0, '2024-09-25 14:15:09', '2024-09-26 08:25:03', '2024-09-26', 'P5448', '24-07182-09-25', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 137.94, 0, '2024-09-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260924-W1Pf4NOSpDN5T-104', 'b2059199-80d1-4e62-8b45-001acffce75f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260924-W1Pf4NOSpDN5T-104&s=KOL2024&nf=P5448&i=137.94&cr=039', '[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
(5807, 1, 1069, 2, 0, NULL, 0, '2024-09-25 19:31:46', '2024-09-26 08:25:34', '2024-09-26', 'P5449', '24-07183-09-25', 'Llamar a mi tlf para la entrega por si no localizan la calle, a veces cuesta.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'camí fondo de somella 7 bx', 'Vilanova i la Geltrú', 'Barcelona', '08800', 'España', 28.39, 0, '2024-09-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260924-b+S0Irgx8AJ7l-254', '56bc3961-0d43-4911-8976-c804e2f0bd46', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260924-b%2BS0Irgx8AJ7l-254&s=KOL2024&nf=P5449&i=28.39&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5808, 1, 204, 2, 0, NULL, 0, '2024-09-26 08:16:52', '2024-09-26 10:24:27', '2024-09-26', 'P5450', '24-07184-09-26', 'lunes cerrado', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'nou 23 local 1', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 103.46, 0, '2024-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260924-QPrqO4YBS9pHy-040', '38bb9296-02a6-43cf-9829-e043df96ccff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260924-QPrqO4YBS9pHy-040&s=KOL2024&nf=P5450&i=103.46&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5809, 1, 956, 2, 0, NULL, 0, '2024-09-26 08:59:16', '2024-09-26 11:05:03', '2024-09-26', 'P5451', '24-07185-09-26', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1 bajo ', 'Vigo', 'Pontevedra', '36204', 'España', 147.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260924-X+KewR3Ifgjyw-190', 'aa0deffb-93aa-49f1-9d68-6a38d10605fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260924-X%2BKewR3Ifgjyw-190&s=KOL2024&nf=P5451&i=147.79&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5810, 1, 40, 2, 0, NULL, 0, '2024-09-26 09:47:28', '2024-09-26 11:51:46', '2024-09-26', 'P5452', '24-07187-09-26', 'lunes por la mañana cerrado y martes cerrado todo el dia', 0.00, 28.50, 6.75, 0.00, 0, 0.00, 4.40, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 38.89, 0, '2024-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260924-QL8JChfCPKH9W-115', '6e761f58-b232-4f92-a705-06daf4c7816e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260924-QL8JChfCPKH9W-115&s=KOL2024&nf=P5452&i=38.89&cr=187', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5811, 1, 754, 2, 0, NULL, 0, '2024-09-26 10:05:17', '2024-09-26 12:08:26', '2024-09-26', 'P5453', '24-07188-09-26', '6+1 Regalo CASTAÑO CLARO', 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-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260924-LoJ1dv0Z3zeZd-092', '0e5d9d6a-f00b-4cd2-a74e-55dec242c1a1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260924-LoJ1dv0Z3zeZd-092&s=KOL2024&nf=P5453&i=61.64&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5812, 1, 696, 1, 0, NULL, 0, '2024-09-26 12:09:10', '2024-09-26 12:14:54', '2024-09-26', 'P5454', '2024-09-26', '', 0.00, 669.24, 140.54, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 809.78, 0, '2024-09-26 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260924-B3ropwZmT/XaJ-245', 'a46b3949-246b-4cdc-b192-9ce06a27d6f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260924-B3ropwZmT%2FXaJ-245&s=KOL2024&nf=P5454&i=809.78&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
