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
(6374, 1, 1479, 2, 0, NULL, 0, '2024-12-31 06:16:19', '2025-01-02 08:51:22', '2025-01-02', 'P5992', '24-07824-12-31', 'Si no estoy, dejar en el felpudo. Gracias!', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Zumalakarregi 8A, 5 izquierda', 'Zarautz', 'Gipuzkoa', '20800', 'España', 30.61, 0, '2024-12-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020125-FoAm237DkRQd+-176', 'c3f7b5cf-a177-4241-9e52-df9a4090778d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-FoAm237DkRQd%2B-176&s=KOL2025&nf=P5992&i=30.61&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6375, 1, 1526, 2, 0, NULL, 0, '2024-12-31 15:48:16', '2025-01-02 08:52:07', '2025-01-02', 'P5993', '24-07825-12-31', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'As Cancelas, 54 - 2A', 'Santiago de Composte', 'A Coruña', '15703', 'España', 41.50, 0, '2024-12-31 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020125-RlXI/8dmf24Da-242', '5095d34d-ed69-4923-a3e9-af2c2e986cdd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-RlXI%2F8dmf24Da-242&s=KOL2025&nf=P5993&i=41.50&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6376, 1, 1029, 2, 0, NULL, 0, '2025-01-01 00:28:38', '2025-01-02 08:52:47', '2025-01-02', 'P5994', '25-07826-01-01', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Periodista Quesada Chacon N°2..bloque 3,4°f', 'Córdoba', 'Córdoba', '14005', 'España', 28.39, 0, '2025-01-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020125-DI5lTvi+uw04C-227', '916da551-8d9e-452e-b66d-35528f0b3cce', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-DI5lTvi%2Buw04C-227&s=KOL2025&nf=P5994&i=28.39&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6377, 1, 1410, 2, 0, NULL, 0, '2025-01-01 15:30:56', '2025-01-02 08:53:31', '2025-01-02', 'P5995', '25-07827-01-01', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avenida Constitución, 17, Escalera 2ª - 4ºC', 'Talavera de la Reina', 'Toledo', '45600', 'España', 28.39, 0, '2025-01-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020125-NJvlx0vhj3XtQ-014', '84c6b8ac-64c2-4a33-8c77-2e708bfc3e5c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-NJvlx0vhj3XtQ-014&s=KOL2025&nf=P5995&i=28.39&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6378, 1, 1089, 2, 0, NULL, 0, '2025-01-01 21:24:12', '2025-01-02 08:54:18', '2025-01-02', 'P5996', '25-07828-01-01', 'Llamar antes', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Acuario, 9 Urb. Los pinos del nevero ', 'Alcalá de Guadaíra', 'Sevilla', '41500', 'España', 43.71, 0, '2025-01-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020125-VpG1vGqXzZ9tY-136', '5436fa45-e557-44ea-9aa6-446bad6f0f37', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-VpG1vGqXzZ9tY-136&s=KOL2025&nf=P5996&i=43.71&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6379, 1, 779, 2, 0, NULL, 0, '2025-01-01 23:10:38', '2025-01-02 08:56:00', '2025-01-02', 'P5997', '25-07829-01-01', 'Preferencia entrega MAÑANAS', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'PLAZA ARSENIOFERNANDEZ ,23', 'Villaquejida', 'León', '24235', 'España', 52.39, 0, '2025-01-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020125-Q2b6U18A+knBW-131', 'ffba7f7e-a1ac-4a69-b7d4-ee2fe1ce290d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-Q2b6U18A%2BknBW-131&s=KOL2025&nf=P5997&i=52.39&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6380, 1, 80, 2, 0, NULL, 0, '2025-01-02 08:32:53', '2025-01-02 09:57:59', '2025-01-02', 'P5998', '25-07830-01-02', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 482.79, 0, '2025-01-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020125-WusvxSkOlC+XN-248', '04b95a94-dac9-4568-a04b-c878ccb02752', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-WusvxSkOlC%2BXN-248&s=KOL2025&nf=P5998&i=482.79&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6381, 1, 1593, 2, 0, NULL, 0, '2025-01-02 10:37:30', '2025-01-02 12:01:24', '2025-01-02', 'P5999', '25-07831-01-02', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'C/ Ventosilla 6 ', 'San Agustín del Guad', 'Madrid', '28750', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020125-E5N4DUZJzWKTr-028', '3a40d882-fcb3-4bb7-98cd-fa633f68be34', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-E5N4DUZJzWKTr-028&s=KOL2025&nf=P5999&i=196.56&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6382, 1, 152, 1, 0, NULL, 0, '2025-01-02 12:48:16', '2025-01-02 12:48:16', '2025-01-02', 'P6000', '', '', 0.00, 60.06, 12.61, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 72.67, 0, '2025-01-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020125-SeN9s6pxHsrvw-199', 'ded24246-fdf2-41b4-997e-47740c01381b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-SeN9s6pxHsrvw-199&s=KOL2025&nf=P6000&i=72.67&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6383, 1, 77, 1, 0, NULL, 0, '2025-01-02 13:21:45', '2025-01-03 11:16:22', '2025-01-09', 'P6001', '', '', 0.00, 879.45, 184.68, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1064.13, 0, '2025-01-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090125-DPYbKF67VA86p-203', '23229a48-455e-4fd1-bc02-1ba6a8061821', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-DPYbKF67VA86p-203&s=KOL2025&nf=P6001&i=1064.13&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6384, 1, 160, 2, 0, NULL, 0, '2025-01-02 16:51:15', '2025-01-03 09:00:40', '2025-01-03', 'P6002', '25-07832-01-02', '', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 113.30, 0, '2025-01-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030125-R94Qp2wvsVnu7-250', '5e71c414-e738-4499-9c0f-790dd5e7ac83', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030125-R94Qp2wvsVnu7-250&s=KOL2025&nf=P6002&i=113.30&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6385, 1, 1594, 2, 0, NULL, 0, '2025-01-02 17:25:53', '2025-01-03 09:01:29', '2025-01-03', 'P6003', '25-07833-01-02', 'Bar botiga casal\r\nÉs una tienda. ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Carrer Sant Vicenç, 10 ', 'Maià de Montcal', 'Girona', '17851', 'España', 28.39, 0, '2025-01-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030125-C7ZG5bVIqsik9-135', '3ea17191-2591-45ed-b39b-207383546251', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030125-C7ZG5bVIqsik9-135&s=KOL2025&nf=P6003&i=28.39&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6386, 1, 1148, 2, 0, NULL, 0, '2025-01-02 17:32:22', '2025-01-03 09:02:14', '2025-01-03', 'P6004', '25-07834-01-02', 'En el portal nº 6 hay portero 24X7', 0.00, 86.64, 18.19, 0.00, 0, 0.00, 0.00, 'Travesía de Téllez 8, 1ºT', 'Madrid', 'Madrid', '28007', 'España', 104.83, 0, '2025-01-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030125-OvP0emurRt3to-196', '13c8ad12-4819-4a4d-8956-ed9ca4690322', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030125-OvP0emurRt3to-196&s=KOL2025&nf=P6004&i=104.83&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6387, 1, 1595, 2, 0, NULL, 0, '2025-01-03 07:52:35', '2025-01-03 09:02:59', '2025-01-03', 'P6005', '25-07836-01-03', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle Señora Cornelia, 1 Portal 8 2ºA', 'Getafe', 'Madrid', '28906', 'España', 65.52, 0, '2025-01-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030125-DImdM398+mIic-099', '79f9a6b1-6ec8-42d5-9f55-8994413dc7e5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030125-DImdM398%2BmIic-099&s=KOL2025&nf=P6005&i=65.52&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6388, 1, 1596, 2, 0, NULL, 0, '2025-01-03 08:26:52', '2025-01-03 10:05:57', '2025-01-03', 'P6006', '25-07837-01-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Av PIO XII 17-8', 'Valencia', 'Valencia', '46009', 'España', 30.61, 0, '2025-01-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030125-JF4odpbm705+N-132', '55e404fe-6e47-454e-a243-bd1ea74a520d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030125-JF4odpbm705%2BN-132&s=KOL2025&nf=P6006&i=30.61&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6389, 1, 1597, 2, 0, NULL, 0, '2025-01-03 09:59:40', '2025-01-03 11:17:06', '2025-01-03', 'P6007', '25-07838-01-03', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Rio Tambre,30', 'Oleiros', 'A Coruña', '15173', 'España', 28.39, 0, '2025-01-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030125-EZA+EkKV3MDmd-203', '9d4c0b0b-d4ad-443f-b681-14e3f1ccb1dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030125-EZA%2BEkKV3MDmd-203&s=KOL2025&nf=P6007&i=28.39&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6390, 1, 190, 3, 0, NULL, 0, '2025-01-03 11:29:26', '2025-01-03 11:29:26', '2025-01-03', '', 'Consumo interno', '', 0.00, 2035.20, 427.39, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2462.59, 0, '2025-01-03 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6391, 1, 1598, 2, 0, NULL, 0, '2025-01-03 13:50:33', '2025-01-07 09:01:50', '2025-01-07', 'P6008', '25-07839-01-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Mare de Déu de Montserrat 61, 2°2', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 30.61, 0, '2025-01-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-IDKCyh78FnvRq-031', '67b0e862-485f-45da-9299-36413d4c282d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-IDKCyh78FnvRq-031&s=KOL2025&nf=P6008&i=30.61&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6392, 1, 1599, 2, 0, NULL, 0, '2025-01-03 15:37:04', '2025-01-07 09:03:43', '2025-01-07', 'P6009', '25-07841-01-03', 'Tardes de semana, mañanas de sábado, si hay punto de entrega mejor', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Teixugueiras 19, portal 1, 8 A', 'Vigo', 'Pontevedra', '36212', 'España', 71.98, 0, '2025-01-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-az+2QyDHgtoei-223', 'f6df687f-fbe3-441a-9d15-837ad65abd45', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-az%2B2QyDHgtoei-223&s=KOL2025&nf=P6009&i=71.98&cr=210', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6393, 1, 1050, 2, 0, NULL, 0, '2025-01-03 18:34:14', '2025-01-07 09:04:52', '2025-01-07', 'P6021', '25-07842-01-03', '', 0.00, 85.50, 18.39, 0.00, 1, 4.55, 2.50, 'Carlos Caamaño,3, Peluquería ', 'Madrid', 'Madrid', '28016', 'España', 110.51, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-070125-dSVRW2LufQKNg-056', '36474055-4836-4128-aa04-59b33fb4fd98', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-dSVRW2LufQKNg-056&s=KOL2025&nf=P6021&i=110.51&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6394, 1, 32, 2, 0, NULL, 0, '2025-01-03 19:06:55', '2025-01-07 09:06:16', '2025-01-07', 'P6010', '25-07843-01-03', 'Es una peluqueria llamada \"Juncal Aracama\"', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'C/José Eguino,  numero 20, bajo', 'Irun', 'Gipuzkoa', '20302', 'España', 206.91, 0, '2025-01-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-Wu+Y4ujt2BSXQ-092', 'd6cbf552-7f0b-407d-8897-4121635e301d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-Wu%2BY4ujt2BSXQ-092&s=KOL2025&nf=P6010&i=206.91&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6395, 1, 270, 2, 0, NULL, 0, '2025-01-04 12:29:48', '2025-01-07 09:07:18', '2025-01-07', 'P6011', '25-07844-01-04', 'Horario laboral', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Juan Bautista Zabala 9 (Comercio Gaurko)', 'Getxo', 'Bizkaia', '48991', 'España', 30.61, 0, '2025-01-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-EyWtAbI+Yqr0a-076', '8728d4b0-6015-4222-ae7c-8c82f6ef38c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-EyWtAbI%2BYqr0a-076&s=KOL2025&nf=P6011&i=30.61&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6396, 1, 1158, 2, 0, NULL, 0, '2025-01-05 07:46:55', '2025-01-07 09:08:13', '2025-01-07', 'P6012', '25-07845-01-05', 'Peluquería Marai', 0.00, 56.98, 11.97, 0.00, 0, 0.00, 0.00, 'Kosta 45, bajo A', 'Irun', 'Gipuzkoa', '20302', 'España', 68.95, 0, '2025-01-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-SLWLuETtBeWf6-142', '12a8af04-712e-4d1b-980e-819debb12939', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-SLWLuETtBeWf6-142&s=KOL2025&nf=P6012&i=68.95&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6397, 1, 872, 2, 0, NULL, 0, '2025-01-05 12:11:18', '2025-01-07 09:09:06', '2025-01-07', 'P6013', '25-07846-01-05', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle Antonio Machado, 7, 3', 'Caudete', 'Albacete', '02660', 'España', 43.71, 0, '2025-01-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-Qv5enn194dfWl-097', '438edc99-aa97-447d-84ae-8327fbbeef45', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-Qv5enn194dfWl-097&s=KOL2025&nf=P6013&i=43.71&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6398, 1, 1600, 2, 0, NULL, 0, '2025-01-05 18:21:20', '2025-01-07 09:10:04', '2025-01-07', 'P6014', '25-07847-01-05', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle Sapporo 18 esc. Izq. 4C', 'Alcorcón', 'Madrid', '28922', 'España', 65.52, 0, '2025-01-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070125-b3Y59gr73YMC/-029', 'c19544ab-0a76-41f6-bb27-7012ccceadb0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-b3Y59gr73YMC%2F-029&s=KOL2025&nf=P6014&i=65.52&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6399, 1, 1538, 2, 0, NULL, 0, '2025-01-05 19:03:02', '2025-01-07 09:10:50', '2025-01-07', 'P6015', '25-07848-01-05', 'Llamar por si no estamos en casa primero 636880238', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avenida diputación edificio arosa 68 7H', 'Calpe/Calp', 'Alicante', '03710', 'España', 52.39, 0, '2025-01-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-LOFOJt7jLG+wd-056', '1b124ef9-25ca-4073-bec8-9e257ea6b02e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-LOFOJt7jLG%2Bwd-056&s=KOL2025&nf=P6015&i=52.39&cr=162', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6400, 1, 754, 2, 0, NULL, 0, '2025-01-06 11:26:19', '2025-01-07 09:12:08', '2025-01-07', 'P6016', '25-07849-01-06', '6+1 GRATIS \r\nREGALO COLOR ARENA\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, '2025-01-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-IRKyn2/SFxctI-016', 'f7d81604-c823-4e56-a639-533531df9c87', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-IRKyn2%2FSFxctI-016&s=KOL2025&nf=P6016&i=61.64&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6401, 1, 1435, 2, 0, NULL, 0, '2025-01-06 16:48:16', '2025-01-07 09:13:04', '2025-01-07', 'P6017', '25-07850-01-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Nafarroa 20, 1.eskubi', 'Zarautz', 'Gipuzkoa', '20800', 'España', 17.50, 0, '2025-01-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-QP6GAa4wFkcEQ-165', 'e9f35dfa-b7d6-4754-a643-12af3db913e1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-QP6GAa4wFkcEQ-165&s=KOL2025&nf=P6017&i=17.50&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6402, 1, 480, 2, 0, NULL, 0, '2025-01-06 18:50:28', '2025-01-07 09:13:47', '2025-01-07', 'P6018', '25-07851-01-06', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle Mayor 38', 'Tiedra', 'Valladolid', '47870', 'España', 43.71, 0, '2025-01-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-Rdb+KGfck/Igb-038', '1cb98dda-45d9-4a1e-b2c0-ede88c63f823', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-Rdb%2BKGfck%2FIgb-038&s=KOL2025&nf=P6018&i=43.71&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6403, 1, 566, 2, 0, NULL, 0, '2025-01-06 19:23:27', '2025-01-07 09:15:25', '2025-01-07', 'P6022', '25-07852-01-06', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070125-EmieqWw7eCTvw-000', 'de2df01c-4d61-4b1a-a1ab-32b3faa681a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-EmieqWw7eCTvw-000&s=KOL2025&nf=P6022&i=206.91&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6404, 1, 1164, 2, 0, NULL, 0, '2025-01-06 20:11:39', '2025-01-07 09:16:00', '2025-01-07', 'P6019', '25-07853-01-06', 'si no hay nadie, dejar en el portal 15, 4 A, (mis padres)', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'jabier de barkaiztegui 17, 5a', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 17.50, 0, '2025-01-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-SKWSsb/gjqXrl-042', '539b3dd9-5fe1-477c-b209-7a34c9d5f9f3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-SKWSsb%2FgjqXrl-042&s=KOL2025&nf=P6019&i=17.50&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6405, 1, 389, 2, 0, NULL, 0, '2025-01-06 21:36:01', '2025-01-07 12:23:10', '2025-01-07', 'P6020', '25-07856-01-06', '', 0.00, 61.32, 12.88, 0.00, 0, 0.00, 0.00, 'Lugar de Muiños 6', 'Padrón', 'A Coruña', '15980', 'España', 74.20, 0, '2025-01-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070125-X+CaqNhpgzS0h-203', '8727c77e-22cf-4306-8d3c-84ed245eede1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-X%2BCaqNhpgzS0h-203&s=KOL2025&nf=P6020&i=74.20&cr=222', '[BLOB]', 0, 'PRANHY071000000D', '2025-01-07 12:23:15', '[BLOB]', 2, '', '2025-01-07', 'S0133', 20, 10, 15, 100, 0, '', 1, 1);
