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
(5701, 1, 248, 2, 0, NULL, 0, '2024-09-09 16:44:18', '2024-09-10 09:50:12', '2024-09-10', 'P5349', '24-07065-09-09', '', 0.00, 89.54, 19.24, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 110.84, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-100924-l/6Qem7RZwOGP-001', 'dc318dae-e660-45fd-b970-2695d42feee3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100924-l%2F6Qem7RZwOGP-001&s=KOL2024&nf=P5349&i=110.84&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5702, 1, 23, 2, 0, NULL, 0, '2024-09-10 08:05:51', '2024-09-10 10:11:23', '2024-09-10', 'P5350', '24-07066-09-10', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 103.46, 0, '2024-09-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100924-FN+0DAsTqKt1S-069', 'ba74376b-1b1f-4d68-aaef-39ab967b9503', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100924-FN%2B0DAsTqKt1S-069&s=KOL2024&nf=P5350&i=103.46&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5703, 1, 262, 2, 0, NULL, 0, '2024-09-10 09:22:52', '2024-09-10 11:24:37', '2024-09-10', 'P5351', '24-07067-09-10', '', 0.00, 61.06, 12.82, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura, peluquería), Local', 'Girona', 'Girona', '17003', 'España', 73.88, 0, '2024-09-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100924-PtkPM2SpAJPoC-232', 'b197ba6d-fe1c-4b44-9b92-050359895f2a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100924-PtkPM2SpAJPoC-232&s=KOL2024&nf=P5351&i=73.88&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5704, 1, 1403, 2, 0, NULL, 0, '2024-09-10 10:56:23', '2024-09-10 12:58:50', '2024-09-10', 'P5352', '24-07068-09-10', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avd Linea electrica nº23 3º2', 'Cornellà de Llobrega', 'Barcelona', '08940', 'España', 28.39, 0, '2024-09-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100924-a7+3NEAeoZZJV-104', '2843dbba-e9ab-4029-9376-c00bbe8699f1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100924-a7%2B3NEAeoZZJV-104&s=KOL2024&nf=P5352&i=28.39&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5705, 1, 1404, 2, 0, NULL, 0, '2024-09-10 11:59:19', '2024-09-10 14:00:14', '2024-09-10', 'P5353', '24-07069-09-10', '', 0.00, 30.66, 7.64, 0.00, 0, 0.00, 6.90, 'Avenida de Marín Nº 5   3º G', 'Pontevedra', 'Pontevedra', '36003', 'España', 44.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-100924-heywAcQxxYDf6-000', '6a880809-83bb-4a30-85c0-783bf5184d64', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100924-heywAcQxxYDf6-000&s=KOL2024&nf=P5353&i=44.00&cr=229', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5706, 1, 391, 2, 0, NULL, 0, '2024-09-10 12:42:46', '2024-09-11 09:07:58', '2024-09-11', 'P5354', '24-07070-09-10', 'Jueves cierre a mediodía,lunes cerrado ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Paseo Santxiki num14', 'Pamplona/Iruña', 'Navarra', '31192', 'España', 137.94, 0, '2024-09-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-110924-CbHe168dsrbE4-224', 'a12d9fe9-a5be-4bd3-928e-2489c4b93e69', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110924-CbHe168dsrbE4-224&s=KOL2024&nf=P5354&i=137.94&cr=011', '[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
(5707, 1, 1405, 2, 0, NULL, 0, '2024-09-10 13:07:35', '2024-09-11 09:10:28', '2024-09-11', 'P5355', '24-07071-09-10', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Luis Taboada, 55', 'Málaga', 'Málaga', '29017', 'España', 28.39, 0, '2024-09-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110924-F0ANSK8T7fJ5o-091', '8eb9c7f9-927e-4559-a8cf-aed5bc96f0a9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110924-F0ANSK8T7fJ5o-091&s=KOL2024&nf=P5355&i=28.39&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5708, 1, 560, 2, 0, NULL, 0, '2024-09-10 15:45:06', '2024-09-11 09:12:27', '2024-09-11', 'P5358', '24-07072-09-10', '', 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-110924-dWWBxLt8sdQ4l-098', 'cfdc4ecf-ec8c-4e66-b88e-e925b6ff5ed5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110924-dWWBxLt8sdQ4l-098&s=KOL2024&nf=P5358&i=344.85&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5709, 1, 1406, 2, 0, NULL, 0, '2024-09-10 15:54:20', '2024-09-11 09:13:58', '2024-09-11', 'P5356', '24-07073-09-10', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Pere Martell 11 B 1-1', 'Salou', 'Tarragona', '43840', 'España', 17.50, 0, '2024-09-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110924-Wvpk4Sr5I9Uus-156', '78d915d6-d432-4b13-8fef-cc0d5d626276', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110924-Wvpk4Sr5I9Uus-156&s=KOL2024&nf=P5356&i=17.50&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5710, 1, 1407, 2, 0, NULL, 0, '2024-09-10 18:29:07', '2024-09-11 09:16:55', '2024-09-11', 'P5357', '24-07074-09-10', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Carrer de Castelló Nº 3', 'Gavà', 'Barcelona', '08850', 'España', 43.71, 0, '2024-09-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110924-GSPiBBp9buKH7-053', 'fdf2f046-fb31-451e-a136-8aa07b9839df', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110924-GSPiBBp9buKH7-053&s=KOL2024&nf=P5357&i=43.71&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5711, 1, 215, 1, 0, NULL, 0, '2024-09-11 09:22:44', '2024-09-11 09:26:14', '2024-09-11', 'P5359', '', '', 0.00, 285.00, 60.28, 0.00, 0, 0.00, 2.50, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 347.35, 0, '2024-09-11 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-110924-em5KLCA9izDj8-128', '8039a6f5-d17e-4da8-a5d1-4b4562182d10', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110924-em5KLCA9izDj8-128&s=KOL2024&nf=P5359&i=347.35&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5712, 1, 152, 1, 0, NULL, 0, '2024-09-11 10:37:14', '2024-09-11 10:37:14', '2024-09-11', 'P5360', '', '', 0.00, 248.82, 52.25, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 301.07, 0, '2024-09-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110924-MyCQYHncx9GlA-051', '1480d285-f313-4f0d-9331-f6f1871fb31d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110924-MyCQYHncx9GlA-051&s=KOL2024&nf=P5360&i=301.07&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
(5713, 1, 754, 2, 0, NULL, 0, '2024-09-11 10:10:21', '2024-09-11 12:18:32', '2024-09-11', 'P5361', '24-07077-09-11', '6+1 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-09-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110924-hPzlRh4DlOzPc-049', 'f7e6e569-81ea-4a7f-a1d1-e263def1a2c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110924-hPzlRh4DlOzPc-049&s=KOL2024&nf=P5361&i=61.64&cr=092', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5714, 1, 28, 2, 0, NULL, 0, '2024-09-11 13:13:24', '2024-09-12 09:44:31', '2024-09-12', 'P5362', '24-07083-09-11', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, '01008, 8 Bajo', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 137.94, 0, '2024-09-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120924-CUTL8Gzi0CAQs-036', '17170731-c7c6-42d5-ac27-105a2379507f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-CUTL8Gzi0CAQs-036&s=KOL2024&nf=P5362&i=137.94&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5715, 1, 439, 2, 0, NULL, 0, '2024-09-11 14:48:16', '2024-09-12 09:45:41', '2024-09-12', 'P5363', '24-07085-09-11', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Kukutza 4', 'Laudio/Llodio', 'Álava', '01400', 'España', 43.71, 0, '2024-09-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120924-eRsLXENxmOiIu-161', 'd23f7497-0466-48b2-ab01-59280fa2e954', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-eRsLXENxmOiIu-161&s=KOL2024&nf=P5363&i=43.71&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5716, 1, 1156, 2, 0, NULL, 0, '2024-09-12 06:49:30', '2024-09-12 09:46:21', '2024-09-12', 'P5364', '24-07087-09-12', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo Lazkano 49 - 1 Izda', 'Donostia-San Sebasti', 'Gipuzkoa', '20009', 'España', 17.50, 0, '2024-09-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120924-NKjjpOPJwnrnh-024', 'ca044665-e95e-4968-ae2a-4ffbd479789a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-NKjjpOPJwnrnh-024&s=KOL2024&nf=P5364&i=17.50&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5717, 1, 337, 2, 0, NULL, 0, '2024-09-12 06:55:41', '2024-09-12 09:47:41', '2024-09-12', 'P5365', '24-07088-09-12', '', 0.00, 65.12, 13.68, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 78.80, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120924-kWdHnlMNmwoGt-223', '90108a65-db56-4356-b4b1-b0c293c5387b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-kWdHnlMNmwoGt-223&s=KOL2024&nf=P5365&i=78.80&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5718, 1, 76, 1, 0, NULL, 0, '2024-09-12 10:22:53', '2024-09-12 10:22:53', '2024-09-12', 'P5366', '', '', 0.00, 180.18, 37.84, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 218.02, 0, '2024-09-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120924-CaG+49B6ddci7-232', '73b076e9-4cab-4000-9d31-85eb88004df7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-CaG%2B49B6ddci7-232&s=KOL2024&nf=P5366&i=218.02&cr=076', '[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
(5719, 1, 1161, 1, 0, NULL, 0, '2024-09-12 10:28:13', '2024-09-12 10:28:42', '2024-09-12', 'P5367', '', '', 0.00, 85.50, 18.38, 0.00, 0, 0.00, 2.50, 'Plaza Aldabe 6, bajo. Gasteiz.', 'Vitoria-Gasteiz', 'Álava', '01012', 'España', 105.95, 0, '2024-09-12 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-120924-PPJdAHVmhzTUg-242', '4a01f928-0103-49b5-a433-6aeee8426fa6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-PPJdAHVmhzTUg-242&s=KOL2024&nf=P5367&i=105.95&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5720, 1, 259, 2, 0, NULL, 0, '2024-09-12 09:14:50', '2024-09-12 11:21:04', '2024-09-12', 'P5368', '24-07089-09-12', 'ENTREGAR 9 A 13:00 AVISAR CON ANTELACION AL \r\n680750573', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'GUIPUZKOA KALEA 53', 'Zarautz', 'Gipuzkoa', '20800', 'España', 172.43, 0, '2024-09-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120924-NgI0PuelnMOD3-087', 'eeb462df-a21e-4bc6-9b34-e32165782128', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-NgI0PuelnMOD3-087&s=KOL2024&nf=P5368&i=172.43&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5721, 1, 1408, 2, 0, NULL, 0, '2024-09-12 09:40:46', '2024-09-12 11:51:07', '2024-09-12', 'P5369', '24-07090-09-12', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle Zamora Nª 54  1ª D', 'Vigo', 'Pontevedra', '36203', 'España', 43.71, 0, '2024-09-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120924-dw4trULiC2wOs-122', '00a41378-71dc-49a4-b20b-510231ff06de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-dw4trULiC2wOs-122&s=KOL2024&nf=P5369&i=43.71&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5722, 1, 43, 2, 0, NULL, 0, '2024-09-12 10:01:33', '2024-09-12 12:06:53', '2024-09-12', 'P5370', '24-07091-09-12', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Nagusia 5', 'Tolosa', 'Gipuzkoa', '20400', 'España', 137.94, 0, '2024-09-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120924-avrBAHMo0FWYi-083', '9a581b39-312f-42dd-a0c1-a0b1f142fdf9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-avrBAHMo0FWYi-083&s=KOL2024&nf=P5370&i=137.94&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5723, 1, 226, 2, 0, NULL, 0, '2024-09-12 10:22:17', '2024-09-12 12:22:38', '2024-09-12', 'P5371', '24-07084-09-11', 'no entregar en lunes,esta cerrado', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'CALLE LOGROÑO 5 BAJO', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120924-BDR1HSX0DOWMm-226', '88076d3f-f78d-43ca-9d7d-ebf1ce9c28e8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-BDR1HSX0DOWMm-226&s=KOL2024&nf=P5371&i=68.97&cr=011', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5724, 1, 754, 2, 0, NULL, 0, '2024-09-12 10:27:37', '2024-09-12 12:32:59', '2024-09-12', 'P5372', '24-07093-09-12', '6+1 REGALO PREBASE DORADA', 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-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120924-JW81jhLaBQpRv-239', '4a27df55-7075-4e89-9edf-f10afa6b7e58', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120924-JW81jhLaBQpRv-239&s=KOL2024&nf=P5372&i=61.64&cr=173', '[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
(5725, 1, 595, 2, 0, NULL, 0, '2024-09-12 11:48:29', '2024-09-13 09:53:45', '2024-09-13', 'P5373', '24-07094-09-12', '9:30 a 16:00', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Zurbanbarri 16 Lonja', 'Bilbao', 'Bizkaia', '48007', 'España', 103.46, 0, '2024-09-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130924-Z7ck4h/S8gRRR-218', '06ed8e5d-4183-4c65-aba1-53e39f089558', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130924-Z7ck4h%2FS8gRRR-218&s=KOL2024&nf=P5373&i=103.46&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5726, 1, 98, 2, 0, NULL, 0, '2024-09-12 12:29:34', '2024-09-13 09:57:54', '2024-09-13', 'P5374', '24-07095-09-12', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 68.97, 0, '2024-09-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130924-k+UPOVZBRCvSP-156', 'fe0e9585-a8fd-451f-97cf-d883a9cbee90', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130924-k%2BUPOVZBRCvSP-156&s=KOL2024&nf=P5374&i=68.97&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5727, 1, 1326, 2, 0, NULL, 0, '2024-09-13 06:26:05', '2024-09-13 10:01:30', '2024-09-13', 'P5375', '24-07100-09-13', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'INAZIO IRIARTE MARGOLARIA 17/5A', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 28.39, 0, '2024-09-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130924-Ppq1d73tCQThP-208', 'a1bc23ca-6fa9-4958-be4c-4e152afe162b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130924-Ppq1d73tCQThP-208&s=KOL2024&nf=P5375&i=28.39&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5728, 1, 192, 2, 0, NULL, 0, '2024-09-13 11:42:17', '2024-09-16 09:04:05', '2024-09-16', 'P5376', '24-07101-09-13', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'plaza San Cristobal 3,bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 147.79, 0, '2024-09-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-iJ0oAhNGGOcbd-065', '816b5729-b0d2-4e38-a65c-1611d7a7c1c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-iJ0oAhNGGOcbd-065&s=KOL2024&nf=P5376&i=147.79&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5729, 1, 1133, 2, 0, NULL, 0, '2024-09-13 12:58:24', '2024-09-16 09:04:43', '2024-09-16', 'P5377', '24-07102-09-13', 'Contactar en la entrega al 655848478', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Passeig de la terracuita 1-5 Esc. A   piso  4 puerta 1, Riera de les prats 7', 'Gavà', 'Barcelona', '08850', 'España', 71.98, 0, '2024-09-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160924-NISKYKTRZdrVt-059', 'c36c4142-084c-4726-8a41-6d23ede99b22', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-NISKYKTRZdrVt-059&s=KOL2024&nf=P5377&i=71.98&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5730, 1, 120, 2, 0, NULL, 0, '2024-09-13 13:37:08', '2024-09-16 09:06:18', '2024-09-16', 'P5378', '24-07103-09-13', '', 0.00, 146.56, 30.78, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 177.34, 0, '2024-09-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-bTF61zJSjPRZj-221', '5c68f217-9555-4e16-b123-d450e3aedaec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-bTF61zJSjPRZj-221&s=KOL2024&nf=P5378&i=177.34&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
(5731, 1, 1409, 2, 0, NULL, 0, '2024-09-14 15:55:36', '2024-09-16 09:07:28', '2024-09-16', 'P5379', '24-07104-09-14', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Ciudad jardín número 8 bloque 1 esc 1 piso 7 puerta 2 i, Piso 7 puerta 2 i', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 30.61, 0, '2024-09-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-DQdTGEFiLp6C8-212', '15ddcbff-8c98-44bd-ac31-b256394e6607', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-DQdTGEFiLp6C8-212&s=KOL2024&nf=P5379&i=30.61&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5732, 1, 711, 2, 0, NULL, 0, '2024-09-15 14:27:36', '2024-09-16 09:07:45', '2024-09-16', 'P5380', '24-07105-09-15', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Av.Cataluña,291-esc19-4A', 'Zaragoza', 'Zaragoza', '50014', 'España', 43.71, 0, '2024-09-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160924-LLFP47wv1elm0-145', '9c7b57e8-6f4b-4a56-a783-da43707f117b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-LLFP47wv1elm0-145&s=KOL2024&nf=P5380&i=43.71&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5733, 1, 1410, 2, 0, NULL, 0, '2024-09-15 18:03:00', '2024-09-16 09:08:08', '2024-09-16', 'P5381', '24-07106-09-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida Constitución, 17, Escalera 2ª - 4ºC', 'Talavera de la Reina', 'Toledo', '45600', 'España', 17.50, 0, '2024-09-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160924-jO8IQaTpb2Wo5-137', '2817ecd9-daf0-4eb0-8abb-17b36ad9dc3a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-jO8IQaTpb2Wo5-137&s=KOL2024&nf=P5381&i=17.50&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5734, 1, 121, 2, 0, NULL, 0, '2024-09-15 18:37:24', '2024-09-16 09:08:31', '2024-09-16', 'P5382', '24-07107-09-15', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 241.40, 0, '2024-09-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160924-PB0dbg9MMttzA-002', '7cb6ae51-f512-49f8-ad33-98be09ae6a61', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-PB0dbg9MMttzA-002&s=KOL2024&nf=P5382&i=241.40&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5735, 1, 754, 2, 0, NULL, 0, '2024-09-16 06:21:43', '2024-09-16 09:09:16', '2024-09-16', 'P5383', '24-07109-09-16', '6+1 REGALO RUBIO EXTRACLARO\r\nDe forma puntual enviar a CALLE MALLORCA Nª5 LOCAL.\r\n43870 aMPOSTA tARRAGONA\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-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-OtkHsnmBofSec-204', '2e895e63-1d7d-446b-94a0-47c0e593939b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-OtkHsnmBofSec-204&s=KOL2024&nf=P5383&i=61.64&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5736, 1, 162, 2, 0, NULL, 0, '2024-09-16 08:15:34', '2024-09-16 10:18:20', '2024-09-16', 'P5384', '24-07112-09-16', 'Entrega en horario de mañana. 9.30 a 14h.', 0.00, 126.20, 26.50, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 152.70, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-LhTrC9LoUsS84-230', '627b060d-a98b-4008-93e3-d228bd58e245', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-LhTrC9LoUsS84-230&s=KOL2024&nf=P5384&i=152.69&cr=109', '[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
(5737, 1, 1047, 2, 0, NULL, 0, '2024-09-16 09:05:07', '2024-09-16 11:18:53', '2024-09-16', 'P5385', '24-07113-09-16', 'Es una empresa (Pasch) Horario hasta las 17h', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Gran Vía de les Corts Catalanes, 645, 2º-1', 'Barcelona', 'Barcelona', '08010', 'España', 43.71, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-k4dSO8DKh7+CY-131', 'bf809c25-bdca-4e40-bfb0-13cb74dbd7e5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-k4dSO8DKh7%2BCY-131&s=KOL2024&nf=P5385&i=43.71&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5738, 1, 307, 2, 0, NULL, 0, '2024-09-16 10:48:50', '2024-09-16 12:51:55', '2024-09-16', 'P5386', '24-07114-09-16', 'Preferiblemente en horario de 8 a 15 h', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle Joaquin Costa, 13', 'Zaragoza', 'Zaragoza', '50001', 'España', 56.82, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-YocejP8RwKvCG-131', 'd52b3a16-ab85-406c-ad43-f23c673b871a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-YocejP8RwKvCG-131&s=KOL2024&nf=P5386&i=56.82&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5739, 1, 425, 2, 0, NULL, 0, '2024-09-16 11:17:58', '2024-09-16 13:30:35', '2024-09-16', 'P5387', '24-07115-09-16', 'oficinas de Ingeteam, hasta las 16.00 ', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'C/ Camino de Labiano 45B, bajo dcha.', 'Aranguren', 'Navarra', '31192', 'España', 71.98, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-Olf2Wx6eVeA7D-055', 'bd6a0e99-2dfc-443a-b2a4-25ef4b933787', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-Olf2Wx6eVeA7D-055&s=KOL2024&nf=P5387&i=71.98&cr=084', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5740, 1, 1048, 2, 0, NULL, 0, '2024-09-16 13:39:38', '2024-09-16 21:46:38', '2024-09-16', 'P5388', '24-07116-09-16', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Gipuzkoa 4, bajo b', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 65.52, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-F0z5G/LwZ8iZu-157', 'f274a08e-6529-45b9-bfe9-0c2221e19372', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-F0z5G%2FLwZ8iZu-157&s=KOL2024&nf=P5388&i=65.52&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5741, 1, 1411, 2, 0, NULL, 0, '2024-09-16 13:45:13', '2024-09-16 21:56:12', '2024-09-16', 'P5389', '24-07117-09-16', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle travesía la encina 1 entreplanta', 'Ponferrada', 'León', '24401', 'España', 28.39, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-PzhQufotMZhqI-133', 'e5b709f6-c4c5-4cb6-ae86-fbe152d91afd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-PzhQufotMZhqI-133&s=KOL2024&nf=P5389&i=28.39&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5742, 1, 1412, 2, 0, NULL, 0, '2024-09-16 14:33:28', '2024-09-16 22:01:32', '2024-09-16', 'P5390', '24-07118-09-16', 'Tocar campana', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle San Cristóbal, 1', 'Rozas de Madrid (Las', 'Madrid', '28290', 'España', 17.50, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-N+hl7BveL7BNg-050', '83160e2e-4c4c-400b-8440-1d49e89f90f3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-N%2Bhl7BveL7BNg-050&s=KOL2024&nf=P5390&i=17.50&cr=160', '[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
(5743, 1, 1213, 2, 0, NULL, 0, '2024-09-16 14:35:34', '2024-09-16 22:12:19', '2024-09-16', 'P5391', '24-07119-09-16', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Emili Grahit, 58, 4-1', 'Girona', 'Girona', '17003', 'España', 30.61, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-iFFiqrzTmXQG2-185', '5003c9de-af34-413e-a3e2-9b848c640b18', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-iFFiqrzTmXQG2-185&s=KOL2024&nf=P5391&i=30.61&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5744, 1, 53, 2, 0, NULL, 0, '2024-09-16 14:51:33', '2024-09-16 22:15:18', '2024-09-16', 'P5397', '24-07120-09-16', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-160924-LX/c91tewaTxw-211', '6920905b-18fe-4d29-99ec-0759eb9de24d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-LX%2Fc91tewaTxw-211&s=KOL2024&nf=P5397&i=174.93&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5745, 1, 4, 2, 0, NULL, 0, '2024-09-16 15:48:35', '2024-09-16 22:18:32', '2024-09-16', 'P5392', '24-07121-09-16', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 275.88, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-WmrFHcRT7egJk-246', 'e1d2ada1-dd38-4b69-9da2-9a07fab1fd84', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-WmrFHcRT7egJk-246&s=KOL2024&nf=P5392&i=275.88&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5746, 1, 1413, 2, 0, NULL, 0, '2024-09-16 17:17:33', '2024-09-16 22:20:34', '2024-09-16', 'P5393', '24-07122-09-16', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Tomás zubiría Ibarra n2 6b', 'Bilbao', 'Bizkaia', '48007', 'España', 28.39, 0, '2024-09-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160924-FhAY1NcxFk6Do-130', '6d077203-d94d-4fe3-83fa-7bf32bcb10cb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-FhAY1NcxFk6Do-130&s=KOL2024&nf=P5393&i=28.39&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5747, 1, 1414, 2, 0, NULL, 0, '2024-09-16 17:44:17', '2024-09-16 22:23:16', '2024-09-16', 'P5394', '24-07123-09-16', 'Prefiero que lo manden a un punto de recogida', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Tomás Urquijo, 4 1 izq', 'Getxo', 'Bizkaia', '48992', 'España', 30.61, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-ecir+wNdus+Vx-228', '2515bd07-2036-4708-b3f8-a6e6e4aae9f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-ecir%2BwNdus%2BVx-228&s=KOL2024&nf=P5394&i=30.61&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5748, 1, 116, 2, 0, NULL, 0, '2024-09-16 18:28:12', '2024-09-16 22:25:53', '2024-09-16', 'P5395', '24-07124-09-16', '', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'C/Valle de Zuriza18', 'Zaragoza', 'Zaragoza', '50015', 'España', 88.67, 0, '2024-09-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160924-OkaQaOZhKCO7/-142', '96a294f5-4b7f-46f0-be7b-1702a99df444', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-OkaQaOZhKCO7%2F-142&s=KOL2024&nf=P5395&i=88.67&cr=110', '[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
(5749, 1, 1050, 2, 0, NULL, 0, '2024-09-16 18:58:30', '2024-09-16 22:31:19', '2024-09-16', 'P5398', '24-07125-09-16', '', 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-160924-Y5QDqlOWWz/0w-107', '2177b58f-62c1-49fc-9465-5dd9bb2393de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-Y5QDqlOWWz%2F0w-107&s=KOL2024&nf=P5398&i=74.54&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5750, 1, 1415, 2, 0, NULL, 0, '2024-09-16 19:46:29', '2024-09-16 22:31:57', '2024-09-16', 'P5396', '24-07126-09-16', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Coros y Danzas 2, , Edificio Montecarlo 1, 6E', 'Molina de Segura', 'Murcia', '30500', 'España', 30.61, 0, '2024-09-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160924-OYokMCrfP/3BJ-177', 'e1022443-4412-42d4-8100-90fd86c90e48', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-OYokMCrfP%2F3BJ-177&s=KOL2024&nf=P5396&i=30.61&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5751, 1, 969, 2, 0, NULL, 0, '2024-09-16 20:29:14', '2024-09-16 22:34:18', '2024-09-16', 'P5399', '24-07128-09-16', 'Dejármelo en el buzon', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Travesía de ollerias altas,n11,2c', 'Bilbao', 'Bizkaia', '48006', 'España', 17.50, 0, '2024-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160924-S++XMu6B2U0ol-238', '11461a11-4fdd-49a0-8b28-041881ea89f4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160924-S%2B%2BXMu6B2U0ol-238&s=KOL2024&nf=P5399&i=17.50&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5752, 1, 764, 2, 0, NULL, 0, '2024-09-17 06:51:17', '2024-09-17 08:56:13', '2024-09-17', 'P5400', '24-07129-09-17', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Calle Badalona, 102, 4 A', 'Madrid', 'Madrid', '28034', 'España', 61.09, 0, '2024-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170924-DK3aOO1b9wwMU-211', 'd6397909-cc88-42c8-b4a7-40e3d8683c4e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170924-DK3aOO1b9wwMU-211&s=KOL2024&nf=P5400&i=61.09&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5753, 1, 76, 1, 0, NULL, 0, '2024-09-17 09:15:10', '2024-09-17 09:15:27', '2024-09-17', 'P5401', '', '', 0.00, 171.60, 36.04, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 207.64, 0, '2024-09-17 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170924-BdThve5WqhYGp-128', '100d87a7-6645-4190-9341-b659456680b0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170924-BdThve5WqhYGp-128&s=KOL2024&nf=P5401&i=207.64&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5754, 1, 174, 1, 0, NULL, 0, '2024-09-17 09:38:42', '2024-09-25 09:00:54', '2024-09-17', 'P5402', '', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Calle Cervantes 13', 'Santander', 'CANTABRIA', '39001', '', 241.40, 0, '2024-09-17 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170924-O/TSRF1pMD+IA-096', '096713f4-1a67-4c6e-987a-ea872401a1fa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170924-O%2FTSRF1pMD%2BIA-096&s=KOL2024&nf=P5402&i=241.40&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
