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
(5813, 1, 75, 2, 0, NULL, 0, '2024-09-26 10:21:28', '2024-09-26 12:38:52', '2024-09-26', 'P5455', '24-07189-09-26', 'Lunes de 10:00 a 14 \r\nMartes a viernes de 10 00 a 19:00', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 241.40, 0, '2024-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260924-GqJBHkq814w6d-044', 'f493e9d8-98af-4e5b-8e3d-90c7367b3f40', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260924-GqJBHkq814w6d-044&s=KOL2024&nf=P5455&i=241.40&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5814, 1, 1425, 2, 0, NULL, 0, '2024-09-26 12:02:31', '2024-09-27 07:57:11', '2024-09-27', 'P5456', '24-07190-09-26', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida pedralbes 30 1 1 ', 'Barcelona', 'Barcelona', '08034', 'España', 17.50, 0, '2024-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270924-TKSftSrxf7hZP-117', '453e6e51-03d0-4ee0-aaa4-70d828945f79', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270924-TKSftSrxf7hZP-117&s=KOL2024&nf=P5456&i=17.50&cr=075', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5815, 1, 617, 2, 0, NULL, 0, '2024-09-26 21:51:28', '2024-09-27 08:00:26', '2024-09-27', 'P5457', '24-07193-09-26', 'Factura ', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Riestra, 14', 'Pontevedra', 'Pontevedra', '36001', 'España', 379.34, 0, '2024-09-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270924-A2HzExUdzu8OR-148', '3bac3696-e8b6-4751-9bfe-fe0501fbbc52', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270924-A2HzExUdzu8OR-148&s=KOL2024&nf=P5457&i=379.34&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5816, 1, 1148, 2, 0, NULL, 0, '2024-09-27 09:50:55', '2024-09-27 12:27:13', '2024-09-27', 'P5460', '24-07194-09-27', 'En el portal n° 6 hay portero 24x7', 0.00, 86.64, 18.19, 0.00, 0, 0.00, 0.00, 'Travesía Téllez 8, 1ºT', 'Madrid', 'Madrid', '28007', 'España', 104.83, 0, '2024-09-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270924-epMKVaP3gCoio-058', '00a71ba3-2266-406f-9f65-27cab6c74fec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270924-epMKVaP3gCoio-058&s=KOL2024&nf=P5460&i=104.83&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5817, 1, 443, 2, 0, NULL, 0, '2024-09-27 10:08:10', '2024-09-27 12:30:44', '2024-09-27', 'P5459', '24-07195-09-27', '', 0.00, 43.32, 10.62, 0.00, 0, 0.00, 8.76, 'Via Verdi, 14, puerta 2', 'Ciutadella de Menorc', 'Baleares (Illes)', '07760', 'España', 61.18, 0, '2024-09-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270924-X4BIq6S/VEILy-125', 'fd6832c9-3d9c-4f94-92ce-dd1af748512b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270924-X4BIq6S%2FVEILy-125&s=KOL2024&nf=P5459&i=61.18&cr=227', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5818, 1, 1426, 2, 0, NULL, 0, '2024-09-27 11:37:11', '2024-09-30 08:51:43', '2024-09-30', 'P5465', '24-07196-09-30', '', 0.00, 52.32, 10.99, 0.00, 0, 0.00, 0.00, 'Príncipe de Viana 4 3ro ext dcha', 'Bilbao', 'Bizkaia', '48007', 'España', 63.31, 0, '2024-09-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300924-TR5u0gyXcYyz8-019', 'cdfca060-3009-4e49-b762-0355af1fc6f3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300924-TR5u0gyXcYyz8-019&s=KOL2024&nf=P5465&i=63.31&cr=117', '[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
(5819, 1, 110, 2, 0, NULL, 0, '2024-09-27 16:29:33', '2024-09-30 08:58:16', '2024-09-30', 'P5461', '24-07197-09-27', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 206.91, 0, '2024-09-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-300924-Sy5SXMrzEwQsl-180', 'a329744e-29c2-414e-bc17-9650f586a773', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300924-Sy5SXMrzEwQsl-180&s=KOL2024&nf=P5461&i=206.91&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5820, 1, 1427, 2, 0, NULL, 0, '2024-09-28 20:24:38', '2024-09-30 08:59:57', '2024-09-30', 'P5462', '24-07199-09-28', 'Guadalsegur ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ victoria 1', 'Coín', 'Málaga', '29100', 'España', 30.61, 0, '2024-09-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300924-TsYtRCcir+BvG-109', 'd105032d-2363-4aff-8127-5cacff4737be', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300924-TsYtRCcir%2BBvG-109&s=KOL2024&nf=P5462&i=30.61&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5821, 1, 1428, 2, 0, NULL, 0, '2024-09-29 12:37:07', '2024-09-30 09:03:20', '2024-09-30', 'P5463', '24-07200-09-29', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle Casp, 78, 4° 3ª', 'Barcelona', 'Barcelona', '08010', 'España', 65.52, 0, '2024-09-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300924-VH8lYdiYM33Qs-090', '5c77ad5e-cfef-4f79-b452-9ad0142a16c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300924-VH8lYdiYM33Qs-090&s=KOL2024&nf=P5463&i=65.52&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5822, 1, 1429, 2, 0, NULL, 0, '2024-09-29 18:18:53', '2024-09-30 09:05:32', '2024-09-30', 'P5464', '24-07201-09-29', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Alpujarras 45 8b, 45 8b', 'Leganés', 'Madrid', '28915', 'España', 17.50, 0, '2024-09-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300924-ObCub016SbKr+-206', 'c6db4116-671e-4bba-83bb-6068c93e7ccb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300924-ObCub016SbKr%2B-206&s=KOL2024&nf=P5464&i=17.50&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5823, 1, 65, 2, 0, NULL, 0, '2024-09-30 08:56:44', '2024-10-01 09:12:57', '2024-09-30', 'P5466', '24-07202-09-30', '', 0.00, 570.00, 119.70, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 689.70, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300924-U4WFB95i/Cfal-175', '1ac8dfdb-d544-4f55-8e8d-402f52320be0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300924-U4WFB95i%2FCfal-175&s=KOL2024&nf=P5466&i=689.70&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5824, 1, 296, 2, 0, NULL, 0, '2024-09-30 09:30:49', '2024-09-30 11:39:56', '2024-09-30', 'P5467', '24-07203-09-30', 'De lunes a jueves de 9 a 19 hrs y viernes de 9 a 15 hrs ', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'Via Laietana 23, Entresuelo C', 'Barcelona', 'Barcelona', '08003', 'España', 54.60, 0, '2024-09-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300924-TDglEBpXUAk+l-089', '55750c05-be93-4859-acf3-e28c669704fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300924-TDglEBpXUAk%2Bl-089&s=KOL2024&nf=P5467&i=54.60&cr=227', '[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
(5825, 1, 264, 2, 0, NULL, 0, '2024-09-30 14:58:05', '2024-10-01 07:34:07', '2024-10-01', 'P5468', '24-07204-09-30', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Gran Via de les Corts Catalanes,  432', 'Barcelona', 'Barcelona', '08015', 'España', 17.50, 0, '2024-09-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-011024-Cu50l2QvjDIjp-171', '2b4fbbcf-15e8-4233-ac90-ba90c05a5561', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011024-Cu50l2QvjDIjp-171&s=KOL2024&nf=P5468&i=17.50&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5826, 1, 873, 1, 0, NULL, 0, '2024-10-01 08:35:20', '2024-10-01 08:55:30', '2024-10-01', 'P5469', '', '', 0.00, 63.34, 13.73, 0.00, 0, 0.00, 2.50, 'Hacienda de Pavones 15', 'Moralzarzal', 'Madrid', '28030', 'España', 79.14, 0, '2024-10-01 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-011024-f66lLtBHQIMKY-094', 'adead438-155e-494d-854c-5482c55ee20e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011024-f66lLtBHQIMKY-094&s=KOL2024&nf=P5469&i=79.14&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5827, 1, 67, 2, 0, NULL, 0, '2024-10-01 08:17:47', '2024-10-01 10:18:53', '2024-10-01', 'P5470', '24-07205-10-01', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-011024-QoGFYKemod7YY-242', '4ee44ea2-807d-489f-ada6-6a6155216297', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011024-QoGFYKemod7YY-242&s=KOL2024&nf=P5470&i=379.34&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5828, 1, 246, 2, 0, NULL, 0, '2024-10-01 08:55:46', '2024-10-01 11:00:15', '2024-10-01', 'P5471', '24-07211-10-01', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'iparraguirre 9 bis', 'Bilbao', 'Bizkaia', '48009', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-011024-LwzyFwK0A595Y-226', '485a2364-528f-4dd2-9bd9-dafd4b1a510e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011024-LwzyFwK0A595Y-226&s=KOL2024&nf=P5471&i=174.93&cr=074', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5829, 1, 1153, 2, 0, NULL, 0, '2024-10-01 15:07:15', '2024-10-02 09:01:42', '2024-10-02', 'P5472', '24-07213-10-01', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Aingeru kale 9 trasers', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 30.61, 0, '2024-10-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-021024-TCg2Fj/H+/DEH-170', '0439651a-2a22-4464-b89b-2a88d97ce0d6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021024-TCg2Fj%2FH%2B%2FDEH-170&s=KOL2024&nf=P5472&i=30.61&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5830, 1, 521, 2, 0, NULL, 0, '2024-10-01 19:43:43', '2024-10-02 09:03:42', '2024-10-02', 'P5473', '24-07214-10-01', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ Vidangoz 7 - 4° izd', 'Pamplona/Iruña', 'Navarra', '31014', 'España', 65.52, 0, '2024-10-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-021024-GcRM32VQYGFuE-130', 'b041af53-6f0b-4e0b-b750-2f4c20ea7f71', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021024-GcRM32VQYGFuE-130&s=KOL2024&nf=P5473&i=65.52&cr=097', '[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
(5831, 1, 220, 2, 0, NULL, 0, '2024-10-02 08:28:48', '2024-10-02 10:35:19', '2024-10-02', 'P5474', '24-07215-10-02', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 206.91, 0, '2024-10-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021024-f3AiWw9PofrIZ-075', '3112e475-474e-4c2f-9576-cc9455a44e09', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021024-f3AiWw9PofrIZ-075&s=KOL2024&nf=P5474&i=206.91&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5832, 1, 1430, 2, 0, NULL, 0, '2024-10-02 09:53:26', '2024-10-02 12:11:42', '2024-10-02', 'P5475', '24-07216-10-02', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'carrer Rei en Jaume 90, bajo', 'Vila-real', 'Castellón', '12540', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-021024-dZfHRjZqiY0pI-036', '3b41ce31-e293-43b8-bc6c-50d191dc5f8c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021024-dZfHRjZqiY0pI-036&s=KOL2024&nf=P5475&i=196.56&cr=009', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5833, 1, 687, 1, 0, NULL, 0, '2024-10-02 12:37:53', '2024-10-02 12:38:44', '2024-10-02', 'P5476', '', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 137.94, 0, '2024-10-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-021024-Zk4hBThQB6YsQ-089', '3a1bc543-34d2-4f84-90a8-cb20cac84d52', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021024-Zk4hBThQB6YsQ-089&s=KOL2024&nf=P5476&i=137.94&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5834, 1, 160, 2, 0, NULL, 0, '2024-10-02 10:59:16', '2024-10-02 13:02:01', '2024-10-02', 'P5477', '24-07217-10-02', '', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 133.00, 0, '2024-10-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021024-DkHaXztT4xAL1-231', '2f252f09-2ca5-4b57-bb69-6cb55764f52c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021024-DkHaXztT4xAL1-231&s=KOL2024&nf=P5477&i=133.00&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5835, 1, 68, 2, 0, NULL, 0, '2024-10-02 20:17:41', '2024-10-03 07:31:00', '2024-10-03', 'P5478', '24-07219-10-02', '', 0.00, 130.28, 27.79, 0.00, 0, 0.00, 2.50, 'Calle Olimpiadas 13 ', 'Ejido (El)', 'Almería', '04700', 'España', 160.14, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-031024-eVzVSFWmbaGTb-042', 'a83c0de7-9a84-4d23-abfa-3a51188359eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031024-eVzVSFWmbaGTb-042&s=KOL2024&nf=P5478&i=160.13&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5836, 1, 1212, 2, 0, NULL, 0, '2024-10-03 05:36:24', '2024-10-03 09:20:48', '2024-10-03', 'P5479', '24-07220-10-03', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Narkis Balentziaga 8 1A', 'Zestoa', 'Gipuzkoa', '20749', 'España', 28.39, 0, '2024-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031024-Lwft6UTQIHjJB-153', '81766f3a-b440-4254-aef8-76699cf4b2fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031024-Lwft6UTQIHjJB-153&s=KOL2024&nf=P5479&i=28.39&cr=153', '[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
(5837, 1, 1431, 2, 0, NULL, 0, '2024-10-03 06:55:14', '2024-10-03 09:22:06', '2024-10-03', 'P5480', '24-07221-10-03', '', 0.00, 32.49, 8.02, 0.00, 0, 0.00, 6.90, 'Calle legia 45 bajo izquierda', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 46.21, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-031024-Y1nej7z5r+jX5-235', '4f238406-15e2-4ae2-9df5-d91e4a9dbe15', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031024-Y1nej7z5r%2BjX5-235&s=KOL2024&nf=P5480&i=46.21&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5838, 1, 121, 2, 0, NULL, 0, '2024-10-03 08:37:46', '2024-10-03 10:45:49', '2024-10-03', 'P5481', '24-07222-10-03', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 310.37, 0, '2024-10-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-031024-b3xzjnjKwVDhb-101', '17514698-6990-4260-8f9d-eab3e3dba109', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031024-b3xzjnjKwVDhb-101&s=KOL2024&nf=P5481&i=310.37&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5839, 1, 1316, 2, 0, NULL, 0, '2024-10-03 08:42:35', '2024-10-03 10:51:48', '2024-10-03', 'P5482', '24-07224-10-03', 'lunes cerrado', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'AVENIDA DE SANTIAGO 18', 'Pino (O)', 'A Coruña', '15821', 'España', 275.88, 0, '2024-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031024-G2J8eLby591UX-067', '5fa9af80-b449-4dbf-824f-44a873080fff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031024-G2J8eLby591UX-067&s=KOL2024&nf=P5482&i=275.88&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5840, 1, 23, 2, 0, NULL, 0, '2024-10-03 08:57:24', '2024-10-03 10:59:34', '2024-10-03', 'P5483', '24-07225-10-03', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 172.43, 0, '2024-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031024-BpVmVofblKDJ0-124', '3fe59467-451f-445f-819e-adc6c9a5ff77', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031024-BpVmVofblKDJ0-124&s=KOL2024&nf=P5483&i=172.43&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5841, 1, 1387, 2, 0, NULL, 0, '2024-10-03 11:13:48', '2024-10-03 13:16:01', '2024-10-03', 'P5484', '24-07226-10-03', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle monasterio de sigena 2 esc2 4D', 'Huesca', 'Huesca', '22005', 'España', 68.97, 0, '2024-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031024-Fl5JR8y3rpZCT-162', 'd6bcd392-9f69-42b0-a07d-a12cb5519cbe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031024-Fl5JR8y3rpZCT-162&s=KOL2024&nf=P5484&i=68.97&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5842, 1, 1012, 2, 0, NULL, 0, '2024-10-03 12:05:23', '2024-10-04 09:50:50', '2024-10-04', 'P5485', '24-07227-10-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Josep de Peray, 17 bxs 1', 'Sant Cugat del Vallè', 'Barcelona', '08173', 'España', 17.50, 0, '2024-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041024-Fspxtx1KgtCMa-117', '64d00207-81fc-45b8-b2cf-7369f8181ba0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041024-Fspxtx1KgtCMa-117&s=KOL2024&nf=P5485&i=17.50&cr=070', '[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
(5843, 1, 221, 2, 0, NULL, 0, '2024-10-03 13:46:13', '2024-10-04 09:53:55', '2024-10-04', 'P5486', '24-07228-10-03', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 206.91, 0, '2024-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041024-LLcf5m6uvXP9w-221', '034095df-4e32-454a-9eb3-163ccaf77725', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041024-LLcf5m6uvXP9w-221&s=KOL2024&nf=P5486&i=206.91&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5844, 1, 1272, 2, 0, NULL, 0, '2024-10-03 20:05:18', '2024-10-04 09:57:15', '2024-10-04', 'P5487', '24-07229-10-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Karrika nagusia 15', 'Arantza', 'Navarra', '31790', 'España', 30.61, 0, '2024-10-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041024-a9kVoZbh2HuQY-049', 'be2fbcc3-6aeb-4d0d-ac20-e66877fd4756', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041024-a9kVoZbh2HuQY-049&s=KOL2024&nf=P5487&i=30.61&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5845, 1, 1432, 2, 0, NULL, 0, '2024-10-04 07:43:31', '2024-10-04 10:05:04', '2024-10-04', 'P5488', '24-07230-10-04', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Ave. Ciudad De Barcelona 108, 2 Escalera, 2 piso letra D', 'Madrid', 'Madrid', '28007', 'España', 30.61, 0, '2024-10-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041024-TMrKciZpGwUnK-199', '64dc7ed9-8bc0-4d25-8bbc-818b0bbc0a2c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041024-TMrKciZpGwUnK-199&s=KOL2024&nf=P5488&i=30.61&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5846, 1, 1433, 1, 0, NULL, 0, '2024-10-04 10:14:04', '2024-10-04 10:19:01', '2024-10-04', 'P5489', '2024-10-04', '', 0.00, 74.17, 15.58, 0.00, 0, 0.00, 0.00, 'Calle boters local 2 ', 'Vilafranca  del Pene', 'BARCELONA', '08720', 'España', 89.75, 0, '2024-10-04 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-041024-O0BJ4PUvxBB1Q-010', '9c8e7dc8-8f8e-4ec8-b69e-ad00cc1ab7c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041024-O0BJ4PUvxBB1Q-010&s=KOL2024&nf=P5489&i=89.75&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5847, 1, 80, 2, 0, NULL, 0, '2024-10-04 11:27:22', '2024-10-07 09:48:11', '2024-10-07', 'P5490', '24-07231-10-04', '', 0.00, 484.50, 101.75, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 586.25, 0, '2024-10-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-QGKwwTHnZxsIU-035', 'aef8d0eb-6b27-4c73-9d51-b758225b653b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-QGKwwTHnZxsIU-035&s=KOL2024&nf=P5490&i=586.25&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5848, 1, 1286, 2, 0, NULL, 0, '2024-10-04 11:36:51', '2024-10-07 09:51:06', '2024-10-07', 'P5491', '24-07232-10-04', 'peluqueria Salon Gorraiz\r\nhorario de martes a viernes 9,30-18,30\r\nsabado 9,00-14,00', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'zubiarte 15', 'Huarte/Uharte', 'Navarra', '31620', 'España', 241.40, 0, '2024-10-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-X+dM0trvokS/E-048', '7be2ccbe-feef-4f12-ad31-f3226ddc382b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-X%2BdM0trvokS%2FE-048&s=KOL2024&nf=P5491&i=241.40&cr=230', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(5849, 1, 1434, 2, 0, NULL, 0, '2024-10-04 12:43:27', '2024-10-07 09:52:55', '2024-10-07', 'P5492', '24-07234-10-04', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avda. Gotarra num. 4 Bajos 1A', 'Llagostera', 'Girona', '17240', 'España', 28.39, 0, '2024-10-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-071024-TvFZ4aByep/E3-047', 'aae9680c-6375-4ea2-8b92-074f1db91bcf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-TvFZ4aByep%2FE3-047&s=KOL2024&nf=P5492&i=28.39&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5850, 1, 1435, 2, 0, NULL, 0, '2024-10-04 14:19:42', '2024-10-07 09:55:25', '2024-10-07', 'P5493', '24-07235-10-04', '', 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, '2024-10-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-WnF/r586inqmT-153', '87fb2113-56e3-42c9-a8e0-46851f20c5aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-WnF%2Fr586inqmT-153&s=KOL2024&nf=P5493&i=17.50&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5851, 1, 285, 2, 0, NULL, 0, '2024-10-04 19:49:19', '2024-10-07 09:57:39', '2024-10-07', 'P5494', '24-07236-10-04', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Pasaje Doctor Puigvert, 8, 3C', 'Santa Coloma de Cerv', 'Barcelona', '08690', 'España', 30.61, 0, '2024-10-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-TMaVby+ulMnBD-255', '90b8fb3d-9484-4866-aa13-995c5bec105c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-TMaVby%2BulMnBD-255&s=KOL2024&nf=P5494&i=30.61&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5852, 1, 1436, 2, 0, NULL, 0, '2024-10-05 07:36:56', '2024-10-07 09:59:20', '2024-10-07', 'P5495', '24-07237-10-05', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Bilbao', 'Bilbao', 'Bizkaia', '48009', 'España', 30.61, 0, '2024-10-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-071024-eLBBUckcK3lrP-192', '94951d68-263e-429e-887b-0fc652ce34e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-eLBBUckcK3lrP-192&s=KOL2024&nf=P5495&i=30.61&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5853, 1, 1313, 2, 0, NULL, 0, '2024-10-06 09:02:11', '2024-10-07 10:03:14', '2024-10-07', 'P5496', '24-07238-10-06', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Pol. Ind. El Sequero Avda. Cameros, 57', 'Agoncillo', 'La Rioja', '26150', 'España', 56.82, 0, '2024-10-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-Ll2K4d1I8eX5u-223', '4c43862d-7e36-45b7-80bb-82df252e6339', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-Ll2K4d1I8eX5u-223&s=KOL2024&nf=P5496&i=56.82&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5854, 1, 1437, 2, 0, NULL, 0, '2024-10-06 09:39:44', '2024-10-07 10:05:53', '2024-10-07', 'P5501', '24-07239-10-06', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Tienda Bodegas Muga - Avda. Vizcaya - Acceso  por la rotonda', 'Haro', 'La Rioja', '26200', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-071024-MuIgv/8M9LD13-113', '22967415-fc05-4bff-9330-5cc5ae2fd655', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-MuIgv%2F8M9LD13-113&s=KOL2024&nf=P5501&i=33.11&cr=101', '[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
(5855, 1, 596, 2, 0, NULL, 0, '2024-10-06 11:42:10', '2024-10-07 10:18:29', '2024-10-07', 'P5497', '24-07240-10-06', 'Centro Salud Intxaurrondo', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'paseo Zarategi 92', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 65.52, 0, '2024-10-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-dKmsierVqL4xq-110', '4ba09801-4fab-4d40-839e-ea1433dc6963', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-dKmsierVqL4xq-110&s=KOL2024&nf=P5497&i=65.52&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5856, 1, 1411, 2, 0, NULL, 0, '2024-10-06 13:39:04', '2024-10-07 10:20:44', '2024-10-07', 'P5498', '24-07241-10-06', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Calle travesía la encina 1 entreplanta ', 'Ponferrada', 'León', '24401', 'España', 71.98, 0, '2024-10-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-eLDjmcIqqVZK3-247', '5dff6b4a-1728-4909-a79a-685707f5c9ab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-eLDjmcIqqVZK3-247&s=KOL2024&nf=P5498&i=71.98&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5857, 1, 1438, 2, 0, NULL, 0, '2024-10-06 21:30:06', '2024-10-07 10:22:43', '2024-10-07', 'P5499', '24-07244-10-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'PLAZA ZELAETA-BERRI 5 - 1ºA', 'Beasain', 'Gipuzkoa', '20200', 'España', 17.50, 0, '2024-10-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-071024-WeQsjDJdngdPm-098', '81df6c47-e9d5-4f61-8b24-7ffab151ce1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-WeQsjDJdngdPm-098&s=KOL2024&nf=P5499&i=17.50&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5858, 1, 1264, 2, 0, NULL, 0, '2024-10-07 05:45:52', '2024-10-07 10:27:09', '2024-10-07', 'P5500', '24-07246-10-07', 'Si no estamos en casa dejar a algún vecino, gracias', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Santiago Rusiñol 14-16,3°1a', 'Esplugues de Llobreg', 'Barcelona', '08950', 'España', 52.39, 0, '2024-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-IMTh9sMmbnQmH-031', '1a185567-6d06-4631-867b-77a127451449', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-IMTh9sMmbnQmH-031&s=KOL2024&nf=P5500&i=52.39&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5859, 1, 754, 2, 0, NULL, 0, '2024-10-07 08:12:09', '2024-10-07 10:31:51', '2024-10-07', 'P5502', '24-07247-10-07', '6+1 REGALO PREBASE DORADA\r\nDE FORMA PUNTUAL ENVIAR A CALLE MALLORCA Nº 5 LOCAL\r\n43870 AMPOSTA ', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep trradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-ODqmNhS7cqMAp-208', 'b6b2c8e0-2bb5-4a86-bd39-7b192f538174', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-ODqmNhS7cqMAp-208&s=KOL2024&nf=P5502&i=61.64&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5860, 1, 166, 1, 0, NULL, 0, '2024-10-07 10:37:03', '2024-10-07 10:37:03', '2024-10-07', 'P5503', '2024-10-07', '', 0.00, 188.76, 39.64, 0.00, 1, 9.82, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 238.22, 0, '2024-10-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-071024-DU57jna8UV42s-224', '85a32380-5a2b-49d3-b068-20bf509ab5bb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-DU57jna8UV42s-224&s=KOL2024&nf=P5503&i=238.22&cr=146', '[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
(5861, 1, 152, 1, 0, NULL, 0, '2024-10-07 11:48:34', '2024-10-07 11:48:34', '2024-10-07', 'P5504', '2024-10-07', '', 0.00, 145.86, 30.63, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 176.49, 0, '2024-10-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-071024-Qk3bPQu7h8FDo-155', '195bde42-5fe6-4430-afce-aed614caf861', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-Qk3bPQu7h8FDo-155&s=KOL2024&nf=P5504&i=176.49&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5862, 1, 152, 1, 0, NULL, 0, '2024-10-07 12:11:02', '2024-10-07 12:11:02', '2024-10-07', 'P5505', '2024-10-07', '', 0.00, 51.48, 10.81, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 62.29, 0, '2024-10-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-071024-NbLOIqrJMEFes-209', '5c25b198-c492-41b4-8946-176447ba850b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-NbLOIqrJMEFes-209&s=KOL2024&nf=P5505&i=62.29&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5863, 1, 97, 2, 0, NULL, 0, '2024-10-07 13:10:30', '2024-10-07 21:33:47', '2024-10-07', 'P5506', '24-07248-10-07', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle Bidasoa 8, Bajo Bera', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 68.97, 0, '2024-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-ZMN0VenUU7Ddq-200', '75a96d0b-bc63-41e7-a1dd-0eaa71328a1a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-ZMN0VenUU7Ddq-200&s=KOL2024&nf=P5506&i=68.97&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5864, 1, 215, 2, 0, NULL, 0, '2024-10-07 13:11:53', '2024-10-07 21:37:11', '2024-10-07', 'P5512', '24-07249-10-07', '', 0.00, 199.50, 42.33, 0.00, 0, 0.00, 2.50, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 243.90, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-071024-Jzlrds9DNoqPA-096', '23dcbf7c-f4ba-4480-a901-518ec58645c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-Jzlrds9DNoqPA-096&s=KOL2024&nf=P5512&i=243.90&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5865, 1, 976, 2, 0, NULL, 0, '2024-10-07 13:16:52', '2024-10-07 21:41:01', '2024-10-07', 'P5507', '24-07250-10-07', 'Peluquería Néstor Savi', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Bolivia n1 bajo puerta 3', 'Coruña (A)', 'A Coruña', '15004', 'España', 172.43, 0, '2024-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-J+UkZCrEBzU9o-013', 'e8137276-2226-4766-bc62-4d8f304a288f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-J%2BUkZCrEBzU9o-013&s=KOL2024&nf=P5507&i=172.43&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5866, 1, 1439, 2, 0, NULL, 0, '2024-10-07 14:51:36', '2024-10-07 21:43:00', '2024-10-07', 'P5508', '24-07251-10-07', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'calle Eladio Rodríguez Gonzalez 7, 2 piso ', 'Coruña (A)', 'A Coruña', '15005', 'España', 17.50, 0, '2024-10-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-071024-dVYZmSE521y52-173', '1a2fa555-c4d7-4ad7-885a-3eb994eac73d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-dVYZmSE521y52-173&s=KOL2024&nf=P5508&i=17.50&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
