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
(5096, 1, 1281, 2, 0, NULL, 0, '2024-05-22 15:58:50', '2024-05-23 09:36:15', '2024-05-23', 'P4763', '24-06405-05-22', 'A partir de las 15:00 horas  hasta las 18:00', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Joaquín Turina 21, 3B', 'Logroño', 'La Rioja', '26007', 'España', 17.50, 0, '2024-05-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230524-KK3cBRTZzpFS0-237', '7567dcdc-60f6-4b11-af79-6b8234838240', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230524-KK3cBRTZzpFS0-237&s=KOL2024&nf=P4763&i=17.50&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5097, 1, 152, 1, 0, NULL, 0, '2024-05-23 09:42:17', '2024-05-23 09:48:02', '2024-05-23', 'P4765', '', '', 0.00, 90.09, 18.92, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 109.01, 0, '2024-05-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230524-aiHPIWWuAq0Bm-230', '2d93d5b0-2700-48e2-a30f-a20726250558', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230524-aiHPIWWuAq0Bm-230&s=KOL2024&nf=P4765&i=109.01&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5098, 1, 78, 2, 0, NULL, 0, '2024-05-23 14:51:19', '2024-05-24 09:33:02', '2024-05-24', 'P4767', '24-06408-05-23', '', 0.00, 570.00, 119.70, 0.00, 0, 0.00, 0.00, 'AV. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 689.70, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240524-bW8ui3EI0dq1/-155', '6a89ccd2-d108-469b-80fb-906862b8397c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240524-bW8ui3EI0dq1%2F-155&s=KOL2024&nf=P4767&i=689.70&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5099, 1, 967, 2, 0, NULL, 0, '2024-05-23 17:57:18', '2024-05-24 09:35:22', '2024-05-24', 'P4766', '24-06409-05-23', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Crta/ asua erletxes 15 ', 'Erandio', 'Bizkaia', '48950', 'España', 41.50, 0, '2024-05-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240524-QgWPcabMw4wpN-076', '77e79546-7da1-47ec-b192-3f1541190caa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240524-QgWPcabMw4wpN-076&s=KOL2024&nf=P4766&i=41.50&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5100, 1, 1282, 2, 0, NULL, 0, '2024-05-24 10:55:52', '2024-05-24 13:36:23', '2024-05-24', 'P4768', '24-06410-05-24', '', 0.00, 63.15, 13.26, 0.00, 0, 0.00, 0.00, 'somocuevas 5, numero 39, LIENCRES', 'Piélagos', 'Cantabria', '39120', 'España', 76.41, 0, '2024-05-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240524-Wwz8bu35IGS/h-212', '548d8302-e745-4f74-9314-25e5f5e4fcdf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240524-Wwz8bu35IGS%2Fh-212&s=KOL2024&nf=P4768&i=76.41&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5101, 1, 40, 2, 0, NULL, 0, '2024-05-25 07:50:05', '2024-05-27 09:23:11', '2024-05-27', 'P4769', '24-06411-05-25', 'lunes por la mañana cerrado y martes todo el dia', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 68.97, 0, '2024-05-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270524-a7Vhz6CatLsDu-014', 'ee25ce2f-b69e-46fb-8ba9-8ae8b84c122a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270524-a7Vhz6CatLsDu-014&s=KOL2024&nf=P4769&i=68.97&cr=216', '[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
(5102, 1, 454, 2, 0, NULL, 0, '2024-05-26 13:20:57', '2024-05-27 09:24:37', '2024-05-27', 'P4770', '24-06412-05-26', '', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'C/Pablo Iglesias nº 39, 7º-A', 'Zaragoza', 'Zaragoza', '50018', 'España', 95.98, 0, '2024-05-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270524-NsiIW7ZtBsA9c-127', '1bc544f9-f502-49c5-8271-e58b25c22fc1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270524-NsiIW7ZtBsA9c-127&s=KOL2024&nf=P4770&i=95.98&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5103, 1, 1283, 2, 0, NULL, 0, '2024-05-26 16:19:59', '2024-05-27 09:26:14', '2024-05-27', 'P4771', '24-06413-05-26', 'Descon Quimica', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Calle Arana 27 1 ', 'Vitoria-Gasteiz', 'Álava', '01002', 'España', 41.50, 0, '2024-05-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270524-WUdrJN5eU2Ft4-197', '24e41bad-b852-4780-8a03-96eae1938ba3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270524-WUdrJN5eU2Ft4-197&s=KOL2024&nf=P4771&i=41.50&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5104, 1, 121, 2, 0, NULL, 0, '2024-05-26 20:17:27', '2024-05-27 09:29:51', '2024-05-27', 'P4772', '24-06414-05-26', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 275.88, 0, '2024-05-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270524-j0AkWqaX3O0q5-140', 'c38ffe7a-d01c-4069-94b8-fc23aebfc4a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270524-j0AkWqaX3O0q5-140&s=KOL2024&nf=P4772&i=275.88&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5105, 1, 1050, 2, 0, NULL, 0, '2024-05-27 07:59:51', '2024-05-27 10:22:00', '2024-05-27', 'P4774', '24-06415-05-27', '', 0.00, 52.92, 11.55, 0.00, 1, 2.86, 2.50, 'Carlos castaño,3', 'Madrid', 'Madrid', '28016', 'España', 69.39, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-270524-fWf7p3kltAzWv-164', 'bc2d2c10-2868-4610-88b2-f39f43f17a7a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270524-fWf7p3kltAzWv-164&s=KOL2024&nf=P4774&i=69.39&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5106, 1, 273, 2, 0, NULL, 0, '2024-05-27 08:06:33', '2024-05-27 10:25:37', '2024-05-27', 'P4773', '24-06416-05-27', 'Horario entrega: lunes a viernes, de 8:30h a 16:30h', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avda. Eduard Maristany, 46-48. ENDESA', 'Sant Adrià de Besòs', 'Barcelona', '08930', 'España', 61.09, 0, '2024-05-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270524-lpHUt0ieSHWG1-241', '42d1d0fe-49db-426b-b869-41469d9c755c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270524-lpHUt0ieSHWG1-241&s=KOL2024&nf=P4773&i=61.09&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5107, 1, 205, 1, 0, NULL, 0, '2024-05-27 11:10:54', '2024-05-29 11:14:47', '2024-05-27', 'P4775', '', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'Sarrikobaso 20 b', 'Getxo', 'Bizkaia', '48991', 'España', 172.42, 0, '2024-05-27 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-270524-IP4aaV52eNg6R-157', '910e1018-7460-44dd-95fe-e68da521323a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270524-IP4aaV52eNg6R-157&s=KOL2024&nf=P4775&i=172.42&cr=212', '[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
(5108, 1, 248, 2, 0, NULL, 0, '2024-05-27 09:26:25', '2024-05-27 11:30:29', '2024-05-27', 'P4776', '24-06417-05-27', '', 0.00, 105.82, 22.66, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 130.54, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-270524-mvgUD0W5IOOaP-169', 'bdb81cd3-af7e-4b7b-b56d-d4e7675cbc0c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270524-mvgUD0W5IOOaP-169&s=KOL2024&nf=P4776&i=130.54&cr=247', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5109, 1, 1284, 2, 0, NULL, 0, '2024-05-27 10:01:40', '2024-05-28 09:26:30', '2024-05-28', 'P4777', '24-06420-05-27', 'si no estamos dejaremos la puerta abierta (sin cerrar con llave) con un cartel y pueden dejarlo ahí, gracias', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Veronica 24', 'Sant Cugat del Vallè', 'Barcelona', '08196', 'España', 17.50, 0, '2024-05-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280524-eoQjpBIy33tEY-145', 'e3ea0f36-9bed-46ba-8681-639fdd4f5c46', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-eoQjpBIy33tEY-145&s=KOL2024&nf=P4777&i=17.50&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5110, 1, 635, 2, 0, NULL, 0, '2024-05-27 15:58:38', '2024-05-28 09:29:46', '2024-05-28', 'P4778', '24-06421-05-27', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 172.43, 0, '2024-05-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280524-hdx+fPAuvQYu7-199', '52ee02ab-80d5-46f6-8df4-9f752195392e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-hdx%2BfPAuvQYu7-199&s=KOL2024&nf=P4778&i=172.43&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5111, 1, 53, 2, 0, NULL, 0, '2024-05-28 07:58:10', '2024-05-28 10:37:18', '2024-05-28', 'P4781', '24-06423-05-28', '', 0.00, 158.78, 33.78, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 194.62, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-280524-XDzgSD+YY+cko-129', '7bd320ff-8efb-4227-b539-50964c0d9c0c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-XDzgSD%2BYY%2Bcko-129&s=KOL2024&nf=P4781&i=194.62&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5112, 1, 4, 2, 0, NULL, 0, '2024-05-28 08:19:16', '2024-05-28 10:39:53', '2024-05-28', 'P4779', '24-06424-05-28', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 344.85, 0, '2024-05-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280524-apwS7L7/5PPy9-171', '0b32347b-54b4-4ea8-8339-5810cfac003d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-apwS7L7%2F5PPy9-171&s=KOL2024&nf=P4779&i=344.85&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5113, 1, 687, 1, 0, NULL, 0, '2024-05-28 10:36:24', '2024-05-28 10:36:24', '2024-05-28', 'P4780', '', '', 0.00, 81.42, 17.10, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 98.52, 0, '2024-05-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280524-fR1rQZOthPX8m-123', 'ee6d83d1-2a6e-49b6-ab94-dda299651e1b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-fR1rQZOthPX8m-123&s=KOL2024&nf=P4780&i=98.52&cr=040', '[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
(5114, 1, 215, 1, 0, NULL, 0, '2024-05-28 11:07:11', '2024-05-28 11:07:38', '2024-05-28', 'P4782', '', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 172.42, 0, '2024-05-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280524-aQnJAMv1P/lXc-235', 'd4571cc0-f74b-458a-aa3a-ffd9de3f6681', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-aQnJAMv1P%2FlXc-235&s=KOL2024&nf=P4782&i=172.42&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5115, 1, 566, 2, 0, NULL, 0, '2024-05-28 09:10:50', '2024-05-28 11:21:28', '2024-05-28', 'P4783', '24-06425-05-28', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280524-AzhienLqcngJL-160', '4c64506b-34eb-4d95-8e30-38d2cf9de12f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-AzhienLqcngJL-160&s=KOL2024&nf=P4783&i=103.46&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5116, 1, 87, 2, 0, NULL, 0, '2024-05-28 09:21:43', '2024-05-28 11:22:55', '2024-05-28', 'P4784', '24-06426-05-28', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'José María Salaberria 3, 7D', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 68.97, 0, '2024-05-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280524-mI7KgPp8P62Ok-122', '4f13ef65-e998-44da-8a1b-2b679d04fa93', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-mI7KgPp8P62Ok-122&s=KOL2024&nf=P4784&i=68.97&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5117, 1, 632, 2, 0, NULL, 0, '2024-05-28 10:33:51', '2024-05-28 13:06:15', '2024-05-28', 'P4785', '24-06427-05-28', '', 0.00, 150.64, 31.63, 0.00, 0, 0.00, 0.00, 'Urbieta 57, bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 182.27, 0, '2024-05-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280524-KkelvgUJmF2Z/-222', '588320a5-4432-435a-8698-a550b0207293', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-KkelvgUJmF2Z%2F-222&s=KOL2024&nf=P4785&i=182.27&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5118, 1, 693, 2, 0, NULL, 0, '2024-05-28 10:46:17', '2024-05-28 13:08:58', '2024-05-28', 'P4786', '24-06428-05-28', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Gran Vía 45, 3ª planta (SRB)', 'Bilbao', 'Bizkaia', '48011', 'España', 17.50, 0, '2024-05-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280524-AhTv+dz7sZ4GR-013', '5fba83db-6381-4178-90f4-282d0a9b6da1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280524-AhTv%2Bdz7sZ4GR-013&s=KOL2024&nf=P4786&i=17.50&cr=089', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5119, 1, 57, 2, 0, NULL, 0, '2024-05-28 13:04:35', '2024-05-29 09:08:01', '2024-05-29', 'P4787', '24-06429-05-28', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 344.85, 0, '2024-05-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290524-ennxq6FmSn61s-130', '7373afb8-e500-4a50-89c5-a441a6b90611', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-ennxq6FmSn61s-130&s=KOL2024&nf=P4787&i=344.85&cr=002', '[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
(5120, 1, 1174, 2, 0, NULL, 0, '2024-05-28 13:33:23', '2024-05-29 09:10:06', '2024-05-29', 'P4788', '24-06430-05-28', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'C/Bizkaia N10 2D', 'Zarautz', 'Gipuzkoa', '20800', 'España', 41.50, 0, '2024-05-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290524-EGpak2J/jo2Lp-164', 'cea67d0a-56e9-4fb7-9d20-0312067e90b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-EGpak2J%2Fjo2Lp-164&s=KOL2024&nf=P4788&i=41.50&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5121, 1, 11, 2, 0, NULL, 0, '2024-05-28 17:08:08', '2024-05-29 09:12:43', '2024-05-29', 'P4791', '24-06431-05-28', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'calle Colomeres 36 local 2', 'Gavà', 'Barcelona', '08840', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290524-a6FrJFmrNa+pp-138', 'c3328a5f-5dd5-4f7a-9537-5b6f89fe5b61', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-a6FrJFmrNa%2Bpp-138&s=KOL2024&nf=P4791&i=137.94&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5122, 1, 779, 2, 0, NULL, 0, '2024-05-28 20:34:25', '2024-05-29 09:14:10', '2024-05-29', 'P4789', '24-06432-05-28', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'plaza arsenio fernandez 23', 'Villaquejida', 'León', '24235', 'España', 52.39, 0, '2024-05-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290524-oCsEuLBXqA3zr-226', 'da24d1f0-13ad-4e82-8c83-392ffa848ea6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-oCsEuLBXqA3zr-226&s=KOL2024&nf=P4789&i=52.39&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5123, 1, 120, 2, 0, NULL, 0, '2024-05-29 07:04:26', '2024-05-29 09:16:07', '2024-05-29', 'P4790', '24-06433-05-29', '', 0.00, 232.06, 48.73, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 280.79, 0, '2024-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290524-i1l+2puyaIXkl-101', 'bf7018e1-53ee-4950-9aa0-8bf4729e5f00', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-i1l%2B2puyaIXkl-101&s=KOL2024&nf=P4790&i=280.79&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5124, 1, 152, 1, 0, NULL, 0, '2024-05-29 09:20:45', '2024-05-29 09:21:36', '2024-05-29', 'P4792', '', '', 0.00, 141.57, 29.73, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 171.30, 0, '2024-05-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290524-SJTquXUkXuc6W-084', '576399eb-c811-4ba4-aefc-5d2049f48fae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-SJTquXUkXuc6W-084&s=KOL2024&nf=P4792&i=171.30&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5125, 1, 1285, 2, 0, NULL, 0, '2024-05-29 08:28:26', '2024-05-29 10:57:04', '2024-05-29', 'P4793', '24-06434-05-29', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle aoiz 4,6 izda', 'Pamplona/Iruña', 'Navarra', '31004', 'España', 28.39, 0, '2024-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290524-OlrvKrEqL1438-023', 'e2903854-b036-48b6-96cf-f53620c8d72d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-OlrvKrEqL1438-023&s=KOL2024&nf=P4793&i=28.39&cr=135', '[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
(5126, 1, 821, 2, 0, NULL, 0, '2024-05-29 08:47:10', '2024-05-29 10:59:06', '2024-05-29', 'P4794', '24-06435-05-29', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'gurutzeaga 9 bajo, 72438407e', 'Zestoa', 'Gipuzkoa', '20740', 'España', 68.97, 0, '2024-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290524-oLpmxgA1xvVp+-092', '9ac59f3b-1da9-4390-8924-c9c187dad886', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-oLpmxgA1xvVp%2B-092&s=KOL2024&nf=P4794&i=68.97&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5127, 1, 38, 1, 0, NULL, 0, '2024-05-29 11:08:10', '2024-05-29 11:08:10', '2024-05-29', 'P4795', '', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'SARRICOBASO Nº 20 B,  BAJO', ' GETXO', 'BIZKAIA', '48991', '', 68.97, 0, '2024-05-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290524-SjmrumVZ2vZzA-076', 'd05d5c69-0c78-48a7-b444-2e84c41ac24d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-SjmrumVZ2vZzA-076&s=KOL2024&nf=P4795&i=68.97&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5128, 1, 38, 1, 1, 'error en productos', 5127, '2024-05-29 11:09:02', '2024-05-29 11:09:02', '2024-05-29', 'R80', 'P4795 RECT.', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 68.97, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-290524-hHLpDyCxXZ7iz-067', '7a031b11-574d-45c5-8083-32ac86433815', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-hHLpDyCxXZ7iz-067&s=KOL2024&nf=R80&i=-68.97&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(5129, 1, 38, 1, 0, NULL, 0, '2024-05-29 11:15:43', '2024-05-29 11:15:43', '2024-05-29', 'P4796', '', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'SARRICOBASO Nº 20 B,  BAJO', ' GETXO', 'BIZKAIA', '48991', '', 34.48, 0, '2024-05-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290524-QcZOijydNJm9h-054', '96e83f1b-2b25-46b2-8ef9-fb79ffe65c2a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-QcZOijydNJm9h-054&s=KOL2024&nf=P4796&i=34.47&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5130, 1, 65, 2, 0, NULL, 0, '2024-05-29 09:36:41', '2024-07-17 13:18:49', '2024-05-29', 'P4797', '24-06440-05-29', '', 0.00, 541.50, 113.71, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 655.21, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290524-XOdy47gO7q5Sa-074', '0e54c212-049b-4a5f-abdc-78ad1d6a315b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-XOdy47gO7q5Sa-074&s=KOL2024&nf=P4797&i=655.22&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5131, 1, 110, 2, 0, NULL, 0, '2024-05-29 10:25:08', '2024-05-29 12:40:51', '2024-05-29', 'P4798', '24-06441-05-29', 'lunes cerrado', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 172.43, 0, '2024-05-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-290524-JQXYwPwthtL6S-246', 'a5a168b5-fa12-4fc8-8262-6246388865fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290524-JQXYwPwthtL6S-246&s=KOL2024&nf=P4798&i=172.43&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(5132, 1, 1137, 2, 0, NULL, 0, '2024-05-29 12:01:33', '2024-05-30 09:27:02', '2024-05-30', 'P4805', '24-06443-05-29', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'PUJADA DE CAL REI 34', 'Porqueres', 'Girona', '17834', 'España', 78.63, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300524-UrMWH6vd74gjQ-176', '09cbbc91-b697-4340-af10-5365043ebd3d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-UrMWH6vd74gjQ-176&s=KOL2024&nf=P4805&i=78.63&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5133, 1, 55, 2, 0, NULL, 0, '2024-05-29 14:24:23', '2024-05-30 09:32:29', '2024-05-30', 'P4799', '24-06444-05-29', '', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'San Pedro De Mezonzo 17 bajo derch', 'Santiago de Composte', 'A Coruña', '15701', 'España', 78.82, 0, '2024-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300524-TEVX8mBBLLYl6-234', 'e81f3041-ad31-41d1-be8f-4139b9a53c58', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-TEVX8mBBLLYl6-234&s=KOL2024&nf=P4799&i=78.81&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5134, 1, 144, 2, 0, NULL, 0, '2024-05-29 15:06:51', '2024-05-30 09:34:19', '2024-05-30', 'P4800', '24-06445-05-29', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 68.97, 0, '2024-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300524-NQhRa2AnxETwh-042', '3be86f4a-cd2b-46ed-a929-7cb25066edcf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-NQhRa2AnxETwh-042&s=KOL2024&nf=P4800&i=68.97&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5135, 1, 530, 2, 0, NULL, 0, '2024-05-29 16:30:22', '2024-05-30 09:35:37', '2024-05-30', 'P4801', '24-06446-05-29', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Ronda 2, escalera izquierda, tercero derecha', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 28.39, 0, '2024-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300524-g22Wzhc7EIjmx-163', '3535b924-97ac-488f-8400-782d37da9785', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-g22Wzhc7EIjmx-163&s=KOL2024&nf=P4801&i=28.39&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5136, 1, 498, 2, 0, NULL, 0, '2024-05-29 22:37:40', '2024-05-30 09:37:46', '2024-05-30', 'P4802', '24-06449-05-29', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Calle Manel Farres 107 1-1', 'Sant Cugat del Vallè', 'Barcelona', '08173', 'España', 71.98, 0, '2024-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300524-AaBs5TGcA1+jA-085', '57c8748d-0661-4049-aa56-c4f66e199cba', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-AaBs5TGcA1%2BjA-085&s=KOL2024&nf=P4802&i=71.98&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5137, 1, 1090, 2, 0, NULL, 0, '2024-05-30 05:51:39', '2024-05-30 09:39:11', '2024-05-30', 'P4803', '24-06450-05-30', '', 0.00, 61.32, 12.88, 0.00, 0, 0.00, 0.00, 'C/Aiotzategi n15 ático b', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 74.20, 0, '2024-05-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300524-K3odbn5jPQc27-130', 'f3f08a18-47b3-4e8b-b05e-a458dde6dcc1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-K3odbn5jPQc27-130&s=KOL2024&nf=P4803&i=74.20&cr=182', '[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
(5138, 1, 1110, 2, 0, NULL, 0, '2024-05-30 07:23:33', '2024-05-30 09:42:14', '2024-05-30', 'P4804', '24-06451-05-30', '', 0.00, 16.28, 4.18, 0.00, 0, 0.00, 4.40, 'C/unió N015', 'Lleida', 'Lleida', '25002', 'España', 24.10, 0, '2024-05-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300524-GQ4rr/GEv54A5-216', '5b1c4302-73d6-42b4-8120-31f75b1fe7eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-GQ4rr%2FGEv54A5-216&s=KOL2024&nf=P4804&i=24.10&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5139, 1, 155, 2, 0, NULL, 0, '2024-05-30 08:59:57', '2024-05-30 11:01:13', '2024-05-30', 'P4806', '24-06452-05-30', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 206.91, 0, '2024-05-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300524-TtuFXOVTVAILt-024', 'b0a91728-b1cb-4105-ba89-7ade0e65b64b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-TtuFXOVTVAILt-024&s=KOL2024&nf=P4806&i=206.91&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5140, 1, 242, 1, 0, NULL, 0, '2024-05-30 11:36:36', '2024-05-30 11:36:36', '2024-05-30', 'P4807', '', '', 0.00, 195.36, 41.03, 0.00, 1, 10.16, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 246.55, 0, '2024-05-30 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300524-Mzuhdr9cKUKKf-060', '24033691-bf51-4902-a369-9299cfd4b8cc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-Mzuhdr9cKUKKf-060&s=KOL2024&nf=P4807&i=246.55&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5141, 1, 1286, 2, 0, NULL, 0, '2024-05-30 11:08:24', '2024-05-30 13:13:37', '2024-05-30', 'P4808', '24-06453-05-30', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'zubiarte 15', 'Huarte/Uharte', 'Navarra', '31620', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300524-Y2RBhhm0Z3RJB-185', '0f50cb93-5717-4c9c-9086-946c4c45b0ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300524-Y2RBhhm0Z3RJB-185&s=KOL2024&nf=P4808&i=196.56&cr=154', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5142, 1, 686, 2, 0, NULL, 0, '2024-05-30 11:59:28', '2024-05-31 08:47:59', '2024-05-31', 'P4809', '24-06455-05-30', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'CALLE DEL PARQUE 3 . UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 241.40, 0, '2024-05-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310524-FmoAzxbikgGUQ-209', 'c14e59f0-3bbc-4cfe-88b9-71898cb5214f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310524-FmoAzxbikgGUQ-209&s=KOL2024&nf=P4809&i=241.40&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5143, 1, 1287, 2, 0, NULL, 0, '2024-05-30 16:03:42', '2024-05-31 08:50:18', '2024-05-31', 'P4810', '24-06458-05-30', 'Si no estoy en domicilio dejar en portería ', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle Silicio 32, escalera derecha 1D ', 'Torrejón de Ardoz', 'Madrid', '28850', 'España', 56.82, 0, '2024-05-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310524-TzhBFkAB19KI5-034', '76385485-7fe4-44a1-b988-4b6d774ae53a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310524-TzhBFkAB19KI5-034&s=KOL2024&nf=P4810&i=56.82&cr=064', '[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
(5144, 1, 204, 2, 0, NULL, 0, '2024-05-30 16:50:08', '2024-05-31 08:51:53', '2024-05-31', 'P4811', '24-06459-05-30', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'nou 23 local 1', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 68.97, 0, '2024-05-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310524-UhpL9U2KxCp0Z-103', '1b761041-c425-4feb-868f-2b667b6bce8f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310524-UhpL9U2KxCp0Z-103&s=KOL2024&nf=P4811&i=68.97&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5145, 1, 754, 2, 0, NULL, 0, '2024-05-31 07:40:26', '2024-05-31 09:49:31', '2024-05-31', 'P4812', '24-06461-05-31', '6+1 de regalo RUBIO 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, '2024-05-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310524-CvlpQg4yFT96C-097', '37c55130-58d3-40f9-abd2-c4d18786f6e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310524-CvlpQg4yFT96C-097&s=KOL2024&nf=P4812&i=61.64&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5146, 1, 1208, 2, 0, NULL, 0, '2024-05-31 20:14:41', '2024-06-03 08:28:58', '2024-06-03', 'P4813', '24-06465-05-31', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Calle Mallorca número 2 / 6 C', 'Madrid', 'Madrid', '28012', 'España', 41.50, 0, '2024-05-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030624-WLNuRUx/Uj+a1-049', '89132de8-ba86-4204-93f5-7b43d9f14b29', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-WLNuRUx%2FUj%2Ba1-049&s=KOL2024&nf=P4813&i=41.50&cr=023', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5147, 1, 1288, 2, 0, NULL, 0, '2024-06-01 08:10:35', '2024-06-03 08:33:18', '2024-06-03', 'P4814', '24-06466-06-01', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Caño n°9', 'Blascosancho', 'Ávila', '05290', 'España', 30.61, 0, '2024-06-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030624-Q076RC9Bbsrzp-095', 'dca3eac1-2c39-442b-ae27-aefaff531563', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-Q076RC9Bbsrzp-095&s=KOL2024&nf=P4814&i=30.61&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5148, 1, 1289, 2, 0, NULL, 0, '2024-06-01 10:35:33', '2024-06-03 08:34:02', '2024-06-03', 'P4815', '24-06467-06-01', '', 0.00, 86.64, 18.20, 0.00, 0, 0.00, 0.00, 'Calle de Moreno Nieto ,, 13', 'Garlitos', 'Badajoz', '06656', 'España', 104.83, 0, '2024-06-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030624-AlyZHuHQnJkrf-063', '8cf38bab-9f84-4d12-8c62-01f10d04a816', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-AlyZHuHQnJkrf-063&s=KOL2024&nf=P4815&i=104.83&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5149, 1, 1039, 2, 0, NULL, 0, '2024-06-01 21:12:43', '2024-06-03 08:36:35', '2024-06-03', 'P4816', '24-06468-06-01', 'Localidad: Ondategui', 0.00, 97.47, 20.47, 0.00, 0, 0.00, 0.00, 'Elizalde 19', 'Zigoitia', 'Álava', '01138', 'España', 117.94, 0, '2024-06-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030624-FCZjyd9hOPcxZ-126', '1d9d86c4-7633-467f-a6cb-6defe14ff22e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-FCZjyd9hOPcxZ-126&s=KOL2024&nf=P4816&i=117.94&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
