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
(6261, 1, 870, 2, 0, NULL, 0, '2024-12-12 12:59:45', '2024-12-13 09:58:13', '2024-12-13', 'P5885', '24-07679-12-12', 'Si no estamos, puede entregarlo en portería ', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'Calle Fuente Carrantona 38c 4 izquierda ', 'Madrid', 'Madrid', '28030', 'España', 113.30, 0, '2024-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131224-NImgXayAcxszP-056', '8775223f-6c7a-4946-97e6-a01b824021b5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-NImgXayAcxszP-056&s=KOL2024&nf=P5885&i=113.30&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6262, 1, 65, 2, 0, NULL, 0, '2024-12-12 13:22:18', '2024-12-13 10:02:54', '2024-12-13', 'P5892', '24-07680-12-12', '', 0.00, 370.50, 77.80, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 448.30, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-131224-B7HaqcTDVv3sS-197', '6b32a96c-f73e-4473-ba7c-6e357ff7d902', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-B7HaqcTDVv3sS-197&s=KOL2024&nf=P5892&i=448.30&cr=160', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6263, 1, 1572, 2, 0, NULL, 0, '2024-12-12 13:52:29', '2024-12-13 10:07:07', '2024-12-13', 'P5886', '24-07681-12-12', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Bartolomé de Urdinso n°9 3°izd', 'Irun', 'Gipuzkoa', '20301 ', 'España', 30.61, 0, '2024-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131224-ZDt6iSbDX6Zpo-169', '0b59947e-659b-4f66-90db-efe1b6bdac73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-ZDt6iSbDX6Zpo-169&s=KOL2024&nf=P5886&i=30.61&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6264, 1, 28, 2, 0, NULL, 0, '2024-12-12 15:56:44', '2024-12-13 10:09:56', '2024-12-13', 'P5887', '24-07682-12-12', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 137.94, 0, '2024-12-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-131224-UczkSiYqugpSS-219', '03db7797-d8da-4371-9bfb-55c73d80eea8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-UczkSiYqugpSS-219&s=KOL2024&nf=P5887&i=137.94&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6265, 1, 1495, 2, 0, NULL, 0, '2024-12-12 17:19:13', '2024-12-13 10:11:24', '2024-12-13', 'P5888', '24-07684-12-12', 'Es un atienda nombre ALEGRIA', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Manuel de sandobal 10', 'Córdoba', 'Córdoba', '14008', 'España', 30.61, 0, '2024-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131224-Ti3lq2MAYDddy-183', 'c1c96e8d-a883-444a-bc08-6814193744d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-Ti3lq2MAYDddy-183&s=KOL2024&nf=P5888&i=30.61&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6266, 1, 672, 2, 0, NULL, 0, '2024-12-13 07:25:10', '2024-12-13 10:24:46', '2024-12-13', 'P5889', '24-07685-12-13', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'MEXICO KALEA 10, 7 B', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 61.09, 0, '2024-12-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131224-anj2qBwdMwq/s-028', '6a26f332-1937-4af6-9b9a-cefe45f31e56', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-anj2qBwdMwq%2Fs-028&s=KOL2024&nf=P5889&i=61.09&cr=088', '[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
(6267, 1, 1571, 2, 0, NULL, 0, '2024-12-13 08:21:04', '2024-12-13 10:26:49', '2024-12-13', 'P5890', '24-07686-12-13', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/DIEGO SALVA LEZÁUN, Nº1-6ºB', 'Pamplona/Iruña', 'Navarra', '31016', 'España', 17.50, 0, '2024-12-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131224-JVzmthZ+RrB/t-115', '9bc053df-13ad-4ac8-b8b3-fb969f1fc827', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-JVzmthZ%2BRrB%2Ft-115&s=KOL2024&nf=P5890&i=17.50&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6268, 1, 40, 2, 0, NULL, 0, '2024-12-13 08:36:55', '2024-12-13 10:32:40', '2024-12-13', 'P5891', '24-07687-12-13', 'martes cerrado y lunes t dejar en la panaderia   OGI KOSKORRA', 0.00, 28.50, 6.75, 0.00, 0, 0.00, 4.40, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 38.89, 0, '2024-12-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131224-RzT+Fds/FpchF-183', 'e571b87c-94fc-4e7e-acf1-02702d9c0724', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-RzT%2BFds%2FFpchF-183&s=KOL2024&nf=P5891&i=38.89&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6269, 1, 1461, 2, 0, NULL, 0, '2024-12-13 09:52:40', '2024-12-13 11:06:19', '2024-12-13', 'P5893', '24-07695-12-13', '', 0.00, 52.32, 10.99, 0.00, 0, 0.00, 0.00, 'C/Nueva n°6, ARTIKA', 'Berrioplano', 'Navarra', '31013', 'España', 63.31, 0, '2024-12-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131224-dWHu7rqljhbhJ-056', '15e39a6b-a476-4bac-bdb2-05acd396b729', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-dWHu7rqljhbhJ-056&s=KOL2024&nf=P5893&i=63.31&cr=043', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6270, 1, 522, 1, 0, NULL, 0, '2024-12-13 11:15:43', '2024-12-13 11:16:24', '2024-12-13', 'P5894', '', '', 0.00, 207.64, 43.60, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 251.24, 0, '2024-12-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-131224-gfuCpmgPqtOCK-138', '1d25fede-28d4-42b6-a2a3-60543124031c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-gfuCpmgPqtOCK-138&s=KOL2024&nf=P5894&i=251.24&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6271, 1, 87, 2, 0, NULL, 0, '2024-12-13 10:40:27', '2024-12-13 11:48:05', '2024-12-13', 'P5895', '24-07697-12-13', '', 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-12-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131224-clwwhKWkpZY6y-068', 'ce8b22a3-5902-4777-a42e-366f30673691', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131224-clwwhKWkpZY6y-068&s=KOL2024&nf=P5895&i=68.97&cr=138', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6272, 1, 215, 2, 0, NULL, 0, '2024-12-14 07:30:18', '2024-12-16 09:23:56', '2024-12-16', 'P5896', '24-07699-12-14', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 241.40, 0, '2024-12-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161224-bZPdG/e+kMZaV-113', 'b046ec6b-b960-4050-b3e5-aa64e2c9cda4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-bZPdG%2Fe%2BkMZaV-113&s=KOL2024&nf=P5896&i=241.40&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6273, 1, 215, 2, 0, NULL, 0, '2024-12-14 07:30:36', '2024-12-14 07:30:36', '2024-12-14', '', '24-07700-12-14', NULL, 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', '', '', 1, 4, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0);
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
(6274, 1, 378, 2, 0, NULL, 0, '2024-12-14 08:36:58', '2024-12-16 09:25:29', '2024-12-16', 'P5897', '24-07701-12-14', 'Entregar entre las 9,00-13,00 por la mañana o las 16,30-19,30 por la tarde', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Elizgibela 1 -Bajo', 'Burlada/Burlata', 'Navarra', '31600', 'España', 30.61, 0, '2024-12-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161224-Ual1n7TejZ0fl-187', 'cc3c4f82-de13-4db2-a6ec-7afa9132e73f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-Ual1n7TejZ0fl-187&s=KOL2024&nf=P5897&i=30.61&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6275, 1, 1130, 2, 0, NULL, 0, '2024-12-14 10:46:51', '2024-12-16 09:27:16', '2024-12-16', 'P5898', '24-07702-12-14', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle de Ulises, 4', 'Mairena del Aljarafe', 'Sevilla', '41927', 'España', 56.82, 0, '2024-12-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-161224-XWtEbhxSpTF4v-248', '55c24074-248e-4ad6-8011-88345c6ba097', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-XWtEbhxSpTF4v-248&s=KOL2024&nf=P5898&i=56.82&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6276, 1, 91, 2, 0, NULL, 0, '2024-12-14 16:24:38', '2024-12-16 09:28:14', '2024-12-16', 'P5899', '24-07706-12-14', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 103.46, 0, '2024-12-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161224-JkypCGtDL/hjc-025', '2057b852-16c4-4091-a16d-4293fb24b92d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-JkypCGtDL%2Fhjc-025&s=KOL2024&nf=P5899&i=103.46&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6277, 1, 1283, 2, 0, NULL, 0, '2024-12-15 16:38:40', '2024-12-16 09:29:42', '2024-12-16', 'P5900', '24-07707-12-15', 'Entrega por tarde', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Calle Jacinto Quincoces 2 C', 'Vitoria-Gasteiz', 'Álava', '01007', 'España', 52.39, 0, '2024-12-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161224-U4shG5Mzo/g8u-109', '39a2221a-9b53-47d7-9a3b-72ae74e60da3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-U4shG5Mzo%2Fg8u-109&s=KOL2024&nf=P5900&i=52.39&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6278, 1, 834, 2, 0, NULL, 0, '2024-12-15 17:08:36', '2024-12-16 09:30:34', '2024-12-16', 'P5901', '24-07708-12-15', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Camí del pinar s/n', 'Gavà', 'Barcelona', '08850', 'España', 52.39, 0, '2024-12-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161224-fs4lCgb7ZMFTj-107', 'e8b90b5e-7ce8-47b3-a80b-46ba3eee0dde', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-fs4lCgb7ZMFTj-107&s=KOL2024&nf=P5901&i=52.39&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6279, 1, 113, 1, 0, NULL, 0, '2024-12-16 10:05:01', '2024-12-16 10:05:11', '2024-12-16', 'P5902', '', '', 0.00, 199.50, 42.33, 0.00, 0, 0.00, 2.50, 'AVENIDA DE LOS LABRADORES 5 LOCAL3', 'Tres Cantos', 'Madrid', '28760', 'España', 243.90, 0, '2024-12-16 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-161224-CL2wzHvRCMPX8-238', 'b959c12c-b384-4c40-b297-5a8717ca9957', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-CL2wzHvRCMPX8-238&s=KOL2024&nf=P5902&i=243.90&cr=083', '[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
(6280, 1, 1423, 1, 0, NULL, 0, '2024-12-16 10:26:13', '2024-12-16 13:10:01', '2024-12-16', 'P5903', '', '', 0.00, 63.34, 13.30, 0.00, 0, 0.00, 0.00, 'General eguia frente al 31', 'Bilbao', 'Bizkaia', '48013', 'España', 76.64, 0, '2024-12-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-161224-enS2L7+VLOdrT-008', 'f70fef0d-084f-4605-be35-bf773b56e990', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-enS2L7%2BVLOdrT-008&s=KOL2024&nf=P5903&i=76.64&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6281, 1, 30, 1, 0, NULL, 0, '2024-12-16 10:42:08', '2024-12-16 13:11:45', '2024-12-16', 'P5904', '', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle González tablas, 3 bajo', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 68.97, 0, '2024-12-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-161224-AEoiX2YfWlm1w-182', '276d0f5a-7332-40c5-a9a0-74b99fee5f43', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-AEoiX2YfWlm1w-182&s=KOL2024&nf=P5904&i=68.97&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6282, 1, 67, 1, 0, NULL, 0, '2024-12-16 11:00:45', '2024-12-16 13:13:33', '2024-12-16', 'P5905', '', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 137.94, 0, '2024-12-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-161224-FDbICe7/Pq+oO-189', '836d94bf-bc6c-4cd3-968a-569c75802e6b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-FDbICe7%2FPq%2BoO-189&s=KOL2024&nf=P5905&i=137.94&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6283, 1, 77, 1, 0, NULL, 0, '2024-12-16 12:40:05', '2024-12-16 12:41:58', '2024-12-16', 'P5906', '', '', 0.00, 343.20, 72.07, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 415.27, 0, '2024-12-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-161224-Z/i6qA8vzbUId-132', '7807711e-25c3-4351-b027-498f9c34098b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-Z%2Fi6qA8vzbUId-132&s=KOL2024&nf=P5906&i=415.27&cr=082', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6284, 1, 1134, 1, 0, NULL, 0, '2024-12-16 12:50:47', '2024-12-16 12:50:47', '2024-12-16', 'P5907', '', '', 0.00, 81.42, 17.10, 0.00, 0, 0.00, 0.00, 'Aoiz 14, bajo.   ', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 98.52, 0, '2024-12-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-161224-aoL6owqa22GwO-133', 'd7b881cd-bc90-4ca4-bf24-972845f7ca4d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-aoL6owqa22GwO-133&s=KOL2024&nf=P5907&i=98.52&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6285, 1, 190, 3, 0, NULL, 0, '2024-12-16 13:15:50', '2024-12-20 09:34:40', '2024-12-16', '', 'Consumo interno', '', 0.00, 2429.92, 510.28, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2940.20, 0, '2024-12-16 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),
(6286, 1, 75, 2, 0, NULL, 0, '2024-12-16 12:26:13', '2024-12-16 13:27:50', '2024-12-16', 'P5908', '24-07710-12-16', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 68.97, 0, '2024-12-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161224-Qa1n4UlfK0eua-175', '2fa83748-3da6-4184-9424-1c7fcf1eae79', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-Qa1n4UlfK0eua-175&s=KOL2024&nf=P5908&i=68.97&cr=051', '[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
(6287, 1, 635, 2, 0, NULL, 0, '2024-12-16 12:40:16', '2024-12-16 17:43:37', '2024-12-16', 'P5909', '24-07711-12-16', 'SI ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703 (estoy al lado: Hermanos Noáin 9, 7ºB). GRACIAS.', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 137.94, 0, '2024-12-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161224-B5JpaDnT8uFhc-126', '406fc59e-3f99-4bea-8d97-27732c61c5ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-B5JpaDnT8uFhc-126&s=KOL2024&nf=P5909&i=137.94&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6288, 1, 1039, 2, 0, NULL, 0, '2024-12-16 15:10:30', '2024-12-16 17:44:47', '2024-12-16', 'P5910', '24-07713-12-16', 'Población: Ondategui', 0.00, 86.64, 18.19, 0.00, 0, 0.00, 0.00, 'Elizalde 19', 'Zigoitia', 'Álava', '01138', 'España', 104.83, 0, '2024-12-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161224-Whk1k/F/Br5P8-197', '2c1d6cce-fb88-4636-ad60-a77163e0ca0c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-Whk1k%2FF%2FBr5P8-197&s=KOL2024&nf=P5910&i=104.83&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6289, 1, 248, 2, 0, NULL, 0, '2024-12-16 16:06:20', '2024-12-16 17:50:43', '2024-12-16', 'P5912', '24-07714-12-16', '', 0.00, 48.84, 10.69, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 61.60, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-161224-EQFfnuRcFOlmV-048', '988e4d3d-df0c-43c8-8183-e3cf9894a050', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-EQFfnuRcFOlmV-048&s=KOL2024&nf=P5912&i=61.60&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6290, 1, 1573, 2, 0, NULL, 0, '2024-12-16 16:24:46', '2024-12-16 17:51:19', '2024-12-16', 'P5911', '24-07715-12-16', '', 0.00, 21.66, 6.07, 0.00, 0, 0.00, 8.76, 'Carrer de les Mates 197/4, URB Cala Blanca', 'Ciutadella de Menorc', 'Baleares (Illes)', '07769', 'España', 34.97, 0, '2024-12-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161224-F5q4RpNGj9Kku-038', '3b8fafbe-936a-4b55-bd90-c204b344ebd2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161224-F5q4RpNGj9Kku-038&s=KOL2024&nf=P5911&i=34.97&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6291, 1, 1011, 2, 0, NULL, 0, '2024-12-16 17:22:16', '2024-12-17 09:04:34', '2024-12-17', 'P5916', '24-07716-12-16', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'AVDA,CONDOMINA,70 ESC 9 6Q BLOQUE 4', 'Alicante/Alacant', 'Alicante', '03540', 'España', 137.94, 0, '2024-12-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171224-UmufGLTiztJqG-180', '842d57bc-6212-4c7a-b57a-5e41ae790122', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-UmufGLTiztJqG-180&s=KOL2024&nf=P5916&i=137.94&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6292, 1, 4, 2, 0, NULL, 0, '2024-12-16 17:29:43', '2024-12-17 09:05:57', '2024-12-17', 'P5913', '24-07717-12-16', '', 0.00, 240.20, 50.44, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 290.64, 0, '2024-12-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171224-AOE4dzLaqjlkW-031', 'bf46b177-9022-4c36-892d-9128f26a58c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-AOE4dzLaqjlkW-031&s=KOL2024&nf=P5913&i=290.64&cr=144', '[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
(6293, 1, 1551, 2, 0, NULL, 0, '2024-12-16 18:19:43', '2024-12-17 09:08:52', '2024-12-17', 'P5914', '24-07718-12-16', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle azabache 26 ', 'Pozuelo de Alarcón', 'Madrid', '28224', 'España', 28.39, 0, '2024-12-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-171224-Ik4LZyOMEz8H2-065', 'df3d4f0d-c8d6-4b0a-83e6-78c9b514ce57', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-Ik4LZyOMEz8H2-065&s=KOL2024&nf=P5914&i=28.39&cr=229', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6294, 1, 337, 2, 0, NULL, 0, '2024-12-16 19:14:08', '2024-12-17 09:10:36', '2024-12-17', 'P5917', '24-07719-12-16', '', 0.00, 158.76, 33.34, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaragoza', 'Zaragoza', '50014', 'España', 192.10, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-171224-a68cfqoiBBSoi-006', '6c6de319-ac16-43a2-8c77-1d2a14cb0477', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-a68cfqoiBBSoi-006&s=KOL2024&nf=P5917&i=192.10&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6295, 1, 262, 2, 0, NULL, 0, '2024-12-16 23:29:22', '2024-12-17 09:12:22', '2024-12-17', 'P5915', '24-07720-12-16', '', 0.00, 179.12, 37.61, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 216.74, 0, '2024-12-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171224-QEUmyOAGY8tbt-098', '4d349725-7b5a-4125-8b51-c2639dace9c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-QEUmyOAGY8tbt-098&s=KOL2024&nf=P5915&i=216.74&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6296, 1, 1033, 2, 0, NULL, 0, '2024-12-17 08:18:54', '2024-12-17 09:23:15', '2024-12-17', 'P5918', '24-07721-12-17', '', 0.00, 40.70, 9.31, 0.00, 0, 0.00, 4.40, 'Lersundi 18 bajo peluqueria Ilea', 'Deba', 'Gipuzkoa', '20820', 'España', 53.65, 0, '2024-12-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171224-Umr4y2ti8ZXE5-004', 'c98357e0-54ed-4378-82d0-a229e0cdd9fa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-Umr4y2ti8ZXE5-004&s=KOL2024&nf=P5918&i=53.65&cr=112', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6297, 1, 98, 2, 0, NULL, 0, '2024-12-17 08:42:36', '2024-12-17 10:07:32', '2024-12-17', 'P5919', '24-07722-12-17', '', 0.00, 105.84, 22.22, 0.00, 0, 0.00, 0.00, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 128.07, 0, '2024-12-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171224-CMgkVjPAy2Jd4-108', 'ded8c296-4ad9-4c00-9808-d1af6c42350e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-CMgkVjPAy2Jd4-108&s=KOL2024&nf=P5919&i=128.07&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6298, 1, 152, 1, 0, NULL, 0, '2024-12-17 09:59:49', '2024-12-17 10:02:18', '2024-12-17', 'P5920', '', '', 0.00, 137.28, 28.83, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 166.11, 0, '2024-12-17 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-171224-APCwLujTYmt7A-102', '1245bf74-f685-49c3-99b4-d4591794b632', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-APCwLujTYmt7A-102&s=KOL2024&nf=P5920&i=166.11&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
(6299, 1, 34, 2, 0, NULL, 0, '2024-12-17 09:32:14', '2024-12-17 11:01:30', '2024-12-17', 'P5921', '24-07723-12-17', 'Entregar de martes a viernes hasta la 12', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'peluqueria Marzo21 calle iparraguirre34 plaza trasera   Leioa Bizkaia', 'Leioa', 'Bizkaia', '48940', 'España', 379.34, 0, '2024-12-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-171224-Ly/gj8wNhVLaD-034', '90724671-fd48-4b50-84a8-0053ca51e0ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-Ly%2Fgj8wNhVLaD-034&s=KOL2024&nf=P5921&i=379.34&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6300, 1, 1254, 2, 0, NULL, 0, '2024-12-17 11:04:55', '2024-12-17 12:19:42', '2024-12-17', 'P5922', '24-07730-12-17', '', 0.00, 72.15, 15.59, 0.00, 0, 0.00, 2.50, 'C/Pedregales 6. (POL. IND,. SAN ISIDRO)', 'Don Benito', 'Badajoz', '06400', 'España', 89.80, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-171224-PLwUkDBFU8sRt-232', 'c5c7efbd-2c32-4c70-8e61-3c71d15fe7c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-PLwUkDBFU8sRt-232&s=KOL2024&nf=P5922&i=89.80&cr=227', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6301, 1, 40, 1, 0, NULL, 0, '2024-12-17 12:50:34', '2024-12-17 12:50:34', '2024-12-17', 'P5923', '', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Plaza valencia 7 intxaurrondo ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 71.47, 0, '2024-12-17 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-171224-TQUsZeex2sJpc-081', 'ef89a362-88e0-40ce-82fb-0cf68cebd597', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-TQUsZeex2sJpc-081&s=KOL2024&nf=P5923&i=71.47&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6302, 1, 821, 2, 0, NULL, 0, '2024-12-17 11:50:49', '2024-12-17 12:53:26', '2024-12-17', 'P5924', '24-07731-12-17', '', 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-12-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171224-WuXnuWD/QEHfy-135', '8d6159fa-b585-456c-8266-697826489d20', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171224-WuXnuWD%2FQEHfy-135&s=KOL2024&nf=P5924&i=68.97&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6303, 1, 144, 2, 0, NULL, 0, '2024-12-17 16:56:33', '2024-12-18 08:35:56', '2024-12-18', 'P5925', '24-07735-12-17', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 103.46, 0, '2024-12-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181224-gXQ02OhZSdL7a-135', 'fff10ca9-869d-4f69-9c9e-be3d97488f2d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181224-gXQ02OhZSdL7a-135&s=KOL2024&nf=P5925&i=103.46&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6304, 1, 236, 2, 0, NULL, 0, '2024-12-17 17:25:24', '2024-12-18 08:36:40', '2024-12-18', 'P5926', '24-07736-12-17', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'AVDA. DE LA POLICÍA NACIONAL, EDF. DONI IVES, 24', 'Antequera', 'Málaga', '29200', 'España', 103.46, 0, '2024-12-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181224-GFzWWLAY7y4R3-028', 'fef8165e-bdab-4a69-9beb-595e264b1a5a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181224-GFzWWLAY7y4R3-028&s=KOL2024&nf=P5926&i=103.46&cr=074', '[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
(6305, 1, 110, 2, 0, NULL, 0, '2024-12-17 17:54:03', '2024-12-18 08:38:43', '2024-12-18', 'P5927', '24-07738-12-17', '', 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-12-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181224-NgcsZGHuz/ElW-127', '932c438c-b97f-4782-b101-489d090ac786', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181224-NgcsZGHuz%2FElW-127&s=KOL2024&nf=P5927&i=206.91&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6306, 1, 1450, 2, 0, NULL, 0, '2024-12-17 19:43:53', '2024-12-18 08:39:13', '2024-12-18', 'P5928', '24-07739-12-17', 'Entregar a partir de las 3 de la tarde', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Francisco Javier Landaburu 78 5º C', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 71.98, 0, '2024-12-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181224-fggwl+0AFIR/t-086', 'e82e6b8c-ee4d-4bd3-8b23-ed82eed8c3fa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181224-fggwl%2B0AFIR%2Ft-086&s=KOL2024&nf=P5928&i=71.98&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6307, 1, 121, 2, 0, NULL, 0, '2024-12-17 23:33:08', '2024-12-18 08:40:08', '2024-12-18', 'P5929', '24-07740-12-17', '', 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-12-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181224-N5AWm6eWV9TRD-227', 'dca2c6bd-7c7f-4a2f-bb28-ed2d9d6e60a1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181224-N5AWm6eWV9TRD-227&s=KOL2024&nf=P5929&i=275.88&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6308, 1, 882, 2, 0, NULL, 0, '2024-12-18 06:54:34', '2024-12-18 08:40:51', '2024-12-18', 'P5930', '24-07741-12-18', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Clavileño 27', 'Madrid', 'Madrid', '28002', 'España', 17.50, 0, '2024-12-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181224-ZTpq/+cpgKwK+-037', 'e4bc7485-4ff1-4658-82ff-4eae59bb963f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181224-ZTpq%2F%2BcpgKwK%2B-037&s=KOL2024&nf=P5930&i=17.50&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6309, 1, 391, 2, 0, NULL, 0, '2024-12-18 08:24:43', '2024-12-18 09:29:51', '2024-12-18', 'P5931', '24-07742-12-18', 'Cerrado lunes y jueves por tarde ', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Paseo Santxiki num14', 'Pamplona/Iruña', 'Navarra', '31192', 'España', 68.97, 0, '2024-12-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181224-Zq7kQe+uF5zb/-113', '208910ba-dc53-4459-bb36-1874775206cb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181224-Zq7kQe%2BuF5zb%2F-113&s=KOL2024&nf=P5931&i=68.97&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6310, 1, 57, 2, 0, NULL, 0, '2024-12-18 09:07:17', '2024-12-18 10:11:03', '2024-12-18', 'P5932', '24-07743-12-18', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 310.37, 0, '2024-12-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181224-ee0EV3E9vuVBp-093', '64804b01-4c8c-42c0-83b1-ee9e7751d09d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181224-ee0EV3E9vuVBp-093&s=KOL2024&nf=P5932&i=310.37&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6311, 1, 76, 1, 0, NULL, 0, '2024-12-18 10:15:19', '2024-12-18 12:20:39', '2024-12-18', '', '', '', 0.00, 3003.00, 630.63, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 3633.63, 0, '2024-12-18 00:00:00', '', '', 1, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0);
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
(6312, 1, 259, 2, 0, NULL, 0, '2024-12-18 12:38:18', '2024-12-18 13:39:13', '2024-12-18', 'P5933', '24-07747-12-18', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'GIPUZKOA KALEA 53 bajo', 'Zarautz', 'Gipuzkoa', '20800', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-181224-doS36SDs+XsHg-007', 'fb2ebeda-4fe7-4df8-ae36-d2a53e395771', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181224-doS36SDs%2BXsHg-007&s=KOL2024&nf=P5933&i=172.43&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6313, 1, 1234, 2, 0, NULL, 0, '2024-12-18 13:20:54', '2024-12-19 20:20:07', '2024-12-19', 'P5934', '24-07748-12-18', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle Liceaga, 2, 1º D', 'Hernani', 'Gipuzkoa', '20120', 'España', 43.71, 0, '2024-12-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191224-BGGKJ3zsfbxjK-145', '2ac86d51-0ebd-4daa-a257-670db55ef76c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-BGGKJ3zsfbxjK-145&s=KOL2024&nf=P5934&i=43.71&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 2, '', '2024-12-19', 'S0133', 10, 20, 15, 300, 0, '', 1, 1),
(6314, 1, 1574, 2, 0, NULL, 0, '2024-12-18 17:29:52', '2024-12-19 10:29:51', '2024-12-19', 'P5935', '24-07749-12-18', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Lepanto 13', 'Numancia de la Sagra', 'Toledo', '45230', 'España', 17.50, 0, '2024-12-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191224-FGnO7YbJkdRJn-144', 'dd355126-0021-4a13-8813-4d01c074c8c3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-FGnO7YbJkdRJn-144&s=KOL2024&nf=P5935&i=17.50&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '2024-12-20', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6315, 1, 1387, 2, 0, NULL, 0, '2024-12-18 19:29:51', '2024-12-19 08:48:45', '2024-12-19', 'P5936', '24-07755-12-18', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle monasterio de sigena 2 esc2 4D', 'Huesca', 'Huesca', '22005', 'España', 172.43, 0, '2024-12-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191224-HPZT/W6c8pmCp-182', '5ffac271-cf90-492b-a9b3-d81505ab4f4b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-HPZT%2FW6c8pmCp-182&s=KOL2024&nf=P5936&i=172.43&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6316, 1, 687, 1, 0, NULL, 0, '2024-12-19 08:53:45', '2024-12-19 08:55:42', '2024-12-19', 'P5937', '', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 172.42, 0, '2024-12-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-191224-TcgzhvJSi4+8s-068', '651a4ce0-da4d-40f0-bb18-e45ff9e1b6d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-TcgzhvJSi4%2B8s-068&s=KOL2024&nf=P5937&i=172.42&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6317, 1, 1011, 1, 0, NULL, 0, '2024-12-19 09:16:20', '2024-12-19 09:17:23', '2024-12-19', 'P5938', '', '', 0.00, 32.56, 6.84, 0.00, 0, 0.00, 0.00, 'Avenida Goleta 23-25, Local 7', 'ALICANTE', 'ALICANTE', '03540', '', 39.40, 0, '2024-12-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-191224-JkzzI5sOza3Bh-173', '43618494-81d3-4431-b7c9-211e1fe4a7eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-JkzzI5sOza3Bh-173&s=KOL2024&nf=P5938&i=39.40&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0);
