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
(6663, 1, 1658, 2, 0, NULL, 0, '2025-02-06 13:40:59', '2025-02-07 09:20:15', '2025-02-07', 'P6261', '25-08135-02-06', '', 0.00, 11.20, 3.12, 0.00, 0, 0.00, 4.40, 'c/Valerio Ortiz de Uriarte, 6  2D', 'Valle de Mena', 'Burgos', '09580', 'España', 17.95, 0, '2025-02-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070225-gOoIP2lxgl2y+-066', '3f07616c-0fd6-4c9b-a10c-ffc79b29161e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070225-gOoIP2lxgl2y%2B-066&s=KOL2025&nf=P6261&i=17.95&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6664, 1, 1587, 2, 0, NULL, 0, '2025-02-06 18:04:02', '2025-02-07 09:21:00', '2025-02-07', 'P6262', '25-08136-02-06', 'En caso de no estar en casa, por favor dejen el paquete en la puerta correspondiente. Gracias', 0.00, 41.00, 9.37, 0.00, 0, 0.00, 4.40, 'Rua Maria Casares 5 -5°A', 'Santiago de Composte', 'A Coruña', '15706', 'España', 54.01, 0, '2025-02-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070225-OtX97vJn9gFPf-223', '4956ebb6-063a-4d6f-982c-3e4f5e4ee918', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070225-OtX97vJn9gFPf-223&s=KOL2025&nf=P6262&i=54.01&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6665, 1, 1659, 2, 0, NULL, 0, '2025-02-06 19:38:06', '2025-02-07 09:21:28', '2025-02-07', 'P6263', '25-08138-02-06', '', 0.00, 33.60, 7.82, 0.00, 0, 0.00, 4.40, 'Cordovin 6 4D', 'Madrid', 'Madrid', '28032', 'España', 45.06, 0, '2025-02-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070225-HQ7HIGiaxc0KS-182', '474c7768-ca40-434f-afbe-5823d7f423cf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070225-HQ7HIGiaxc0KS-182&s=KOL2025&nf=P6263&i=45.06&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6666, 1, 1660, 1, 0, NULL, 0, '2025-02-07 10:02:18', '2025-02-07 10:02:52', '2025-02-07', 'P6264', '', '', 0.00, 162.45, 34.54, 0.00, 0, 0.00, 2.50, 'CALLE CARQUIZANO 3, BAJO', 'San Sebastián', 'Gipuzkoa', '20001', 'España', 199.06, 0, '2025-02-07 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-070225-CQ7XBRgNwkZq6-130', '36c99b69-b48b-4695-aa14-92eb01917984', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070225-CQ7XBRgNwkZq6-130&s=KOL2025&nf=P6264&i=199.06&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6667, 1, 1661, 2, 0, NULL, 0, '2025-02-07 09:15:41', '2025-02-07 09:15:41', '2025-02-07', '', '25-08139-02-07', NULL, 0.00, 168.00, 35.28, 0.00, 0, 0.00, 0.00, 'CALLE CARQUIZANO 3, BAJO', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 203.28, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6668, 1, 106, 1, 0, NULL, 0, '2025-02-07 10:41:07', '2025-02-07 10:41:24', '2025-02-07', 'P6265', '', '', 0.00, 134.72, 28.29, 0.00, 0, 0.00, 0.00, 'Hipódromo 10 bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'ESPAÑA', 163.01, 0, '2025-02-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070225-NkGstdOhEnfcm-234', '53db8909-7d21-4dd1-84ec-80e6feea8bd4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070225-NkGstdOhEnfcm-234&s=KOL2025&nf=P6265&i=163.01&cr=023', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6669, 1, 1524, 2, 0, NULL, 0, '2025-02-07 17:16:52', '2025-02-10 09:16:52', '2025-02-10', 'P6266', '25-08141-02-07', '', 0.00, 11.20, 3.12, 0.00, 0, 0.00, 4.40, 'Camino de la Marquesa 13 urb la santa', 'Espartinas', 'Sevilla', '41807', 'España', 17.95, 0, '2025-02-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100225-FRzR9PHpUhJEu-195', 'a22c0e91-935e-4fcf-af23-2884a81e581e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-FRzR9PHpUhJEu-195&s=KOL2025&nf=P6266&i=17.95&cr=153', '[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
(6670, 1, 1662, 2, 0, NULL, 0, '2025-02-08 07:16:49', '2025-02-10 09:19:37', '2025-02-10', 'P6267', '25-08142-02-08', '', 0.00, 20.50, 5.07, 0.00, 0, 0.00, 4.40, 'Cercas bajas 2 4dr', 'Vitoria-Gasteiz', 'Álava', '01001', 'España', 29.21, 0, '2025-02-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100225-ORugEP46iIcD4-208', '2079a09f-c916-4e95-8a1d-399fb239138c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-ORugEP46iIcD4-208&s=KOL2025&nf=P6267&i=29.21&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6671, 1, 1663, 2, 0, NULL, 0, '2025-02-08 11:47:41', '2025-02-10 09:21:55', '2025-02-10', 'P6268', '25-08143-02-08', '', 0.00, 56.00, 11.76, 0.00, 0, 0.00, 0.00, 'PLAZA ZELAETA-BERRI 5, 1ºA', 'Beasain', 'Gipuzkoa', '20200', 'España', 67.76, 0, '2025-02-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100225-Qc3dNQl/Zwn6D-053', '42f5e35d-3a32-4b1a-8211-754764722edf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-Qc3dNQl%2FZwn6D-053&s=KOL2025&nf=P6268&i=67.76&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6672, 1, 1664, 2, 0, NULL, 0, '2025-02-09 07:13:58', '2025-02-10 09:25:07', '2025-02-10', 'P6269', '25-08144-02-09', '', 0.00, 11.20, 3.87, 0.00, 0, 0.00, 8.76, 'Isidoro macabich 63 torre 3 , 4A', 'Eivissa', 'Baleares (Illes)', '07800', 'España', 22.31, 0, '2025-02-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100225-bJueJGkBPTuTq-193', '1a554acc-c51c-4dbc-961c-b007f163c871', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-bJueJGkBPTuTq-193&s=KOL2025&nf=P6269&i=22.31&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6673, 1, 425, 2, 0, NULL, 0, '2025-02-09 18:31:30', '2025-02-10 09:26:27', '2025-02-10', 'P6270', '25-08146-02-09', '', 0.00, 83.90, 17.62, 0.00, 0, 0.00, 0.00, 'Camino Labiano, 45B. Bajo derecha.', 'Aranguren', 'Navarra', '31192', 'España', 101.52, 0, '2025-02-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100225-NJsoemF8/s/NN-109', 'c4b74eca-a189-4ab7-9956-00f731f8e50e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-NJsoemF8%2Fs%2FNN-109&s=KOL2025&nf=P6270&i=101.52&cr=084', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6674, 1, 1204, 2, 0, NULL, 0, '2025-02-09 18:34:08', '2025-02-10 09:29:05', '2025-02-10', 'P6271', '25-08147-02-09', '', 0.00, 56.00, 11.76, 0.00, 0, 0.00, 0.00, 'Eustasio Amilibia 5  local 4 (clínica podológica)', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 67.76, 0, '2025-02-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100225-COV8BAo/vC7Ik-226', '5b7b470b-4c1e-48aa-b0ce-10e3e76fdc65', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-COV8BAo%2FvC7Ik-226&s=KOL2025&nf=P6271&i=67.76&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6675, 1, 91, 2, 0, NULL, 0, '2025-02-09 19:55:14', '2025-02-10 09:31:51', '2025-02-10', 'P6275', '25-08152-02-09', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 106.98, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100225-UQtY8AAhtWxRe-232', 'c1ec3b7c-2b7d-4504-8601-5ec46849f7c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-UQtY8AAhtWxRe-232&s=KOL2025&nf=P6275&i=106.98&cr=183', '[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
(6676, 1, 284, 2, 0, NULL, 0, '2025-02-09 20:11:18', '2025-02-10 09:35:11', '2025-02-10', 'P6272', '25-08153-02-09', '', 0.00, 33.60, 7.82, 0.00, 0, 0.00, 4.40, 'AV MIL.LENARI Nº29 3º1ª', 'Viladecans', 'Barcelona', '08840', 'España', 45.06, 0, '2025-02-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100225-E5/O15Zhj1AXH-086', '8ee815d9-34a8-45a6-82d4-ab2f7fd5106c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-E5%2FO15Zhj1AXH-086&s=KOL2025&nf=P6272&i=45.06&cr=182', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6677, 1, 1247, 2, 0, NULL, 0, '2025-02-09 22:39:14', '2025-02-10 09:36:43', '2025-02-10', 'P6273', '25-08154-02-09', 'Si no estamos se puede entregar al conserje en la garita de la entrada.', 0.00, 44.80, 10.17, 0.00, 0, 0.00, 4.40, 'c/ Infanta Cristina 20', 'Valdemorillo', 'Madrid', '28210', 'España', 58.61, 0, '2025-02-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100225-KuKgyUfp1GoIP-143', 'd4754745-7eb9-4ee7-a8f3-c8ca682e4fa1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-KuKgyUfp1GoIP-143&s=KOL2025&nf=P6273&i=58.61&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6678, 1, 891, 2, 0, NULL, 0, '2025-02-10 06:02:12', '2025-02-10 09:49:23', '2025-02-10', 'P6274', '25-08157-02-10', '', 0.00, 41.00, 9.37, 0.00, 0, 0.00, 4.40, 'Plaza de los Atano', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 54.01, 0, '2025-02-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100225-GROy80IKjlIUa-209', '6f079ff8-2d6a-455e-9044-827b166a5bad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-GROy80IKjlIUa-209&s=KOL2025&nf=P6274&i=54.01&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6679, 1, 687, 1, 0, NULL, 0, '2025-02-10 09:53:23', '2025-02-10 09:53:56', '2025-02-10', 'P6276', '', '', 0.00, 117.88, 24.75, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 142.63, 0, '2025-02-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100225-VhgBxIWagyf7l-076', 'b31c0c1a-27d6-40a1-a548-e61b510a6b13', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-VhgBxIWagyf7l-076&s=KOL2025&nf=P6276&i=142.63&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6680, 1, 166, 1, 0, NULL, 0, '2025-02-10 09:57:24', '2025-02-10 09:58:15', '2025-02-10', 'P6277', '', '', 0.00, 150.96, 31.70, 0.00, 1, 7.85, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 190.51, 0, '2025-02-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100225-a5rw1OicGY4nm-253', 'f55a7449-fae4-449b-91ab-18370ded530a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-a5rw1OicGY4nm-253&s=KOL2025&nf=P6277&i=190.51&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6681, 1, 65, 2, 0, NULL, 0, '2025-02-10 09:47:23', '2025-02-10 10:58:05', '2025-02-10', 'P6278', '25-08158-02-10', '', 0.00, 589.40, 123.77, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 713.17, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100225-HGCC6XVi14bHO-183', '3783deea-0fec-4bec-98e0-2816d3b083f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-HGCC6XVi14bHO-183&s=KOL2025&nf=P6278&i=713.17&cr=122', '[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
(6682, 1, 139, 2, 0, NULL, 0, '2025-02-10 11:02:07', '2025-02-10 12:20:28', '2025-02-10', 'P6279', '25-08159-02-10', 'NECESITO FACTURA \r\nNUDE COLOR S.L.\r\nC/CARLOS MARTINEZ ABRBEITO 6 BAJO IZQ \r\n15009 A CORUÑA B70583638', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'Rúa Carlos Martínez Barbeito Moras, 6 BAJO IZQ', 'Coruña (A)', 'A Coruña', '15009', 'España', 213.95, 0, '2025-02-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100225-Wdexo6KSPZBsz-157', '08a8f73d-3efd-4d5d-b558-9a4aac42e608', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100225-Wdexo6KSPZBsz-157&s=KOL2025&nf=P6279&i=213.95&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6683, 1, 1313, 2, 0, NULL, 0, '2025-02-10 15:21:08', '2025-02-11 08:40:22', '2025-02-11', 'P6280', '25-08160-02-10', '', 0.00, 33.60, 7.82, 0.00, 0, 0.00, 4.40, 'Labelgrafic SA. Pol. Ind. El Sequero Avda. Cameros, 57', 'Agoncillo', 'La Rioja', '26160', 'España', 45.06, 0, '2025-02-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110225-PWVuyZCAo/l+N-174', '793a0cf6-1e49-4b06-88b7-4cf7403e7749', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110225-PWVuyZCAo%2Fl%2BN-174&s=KOL2025&nf=P6280&i=45.06&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6684, 1, 253, 2, 0, NULL, 0, '2025-02-10 15:50:12', '2025-02-11 08:41:18', '2025-02-11', 'P6281', '25-08161-02-10', 'llamar para instrucciones de entrega, casa aislada', 0.00, 11.20, 3.12, 0.00, 0, 0.00, 4.40, 'Camino del Molino sn', 'Villamayor de Gálleg', 'Zaragoza', '50162', 'España', 17.95, 0, '2025-02-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-110225-Q11033vRnW7sh-023', '29ec7149-88b9-4b86-9373-6269e482dad9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110225-Q11033vRnW7sh-023&s=KOL2025&nf=P6281&i=17.95&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6685, 1, 1665, 2, 0, NULL, 0, '2025-02-10 20:56:26', '2025-02-11 08:41:59', '2025-02-11', 'P6282', '25-08162-02-10', '', 0.00, 11.20, 3.12, 0.00, 0, 0.00, 4.40, 'Tejar 5', 'Serranillos del Vall', 'Madrid', '28979', 'España', 17.95, 0, '2025-02-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110225-Jro6aGK2mM8Q6-189', 'c7423985-8f55-45d1-83ed-b0acfd3105c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110225-Jro6aGK2mM8Q6-189&s=KOL2025&nf=P6282&i=17.95&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6686, 1, 1666, 2, 0, NULL, 0, '2025-02-11 08:09:33', '2025-02-11 09:28:26', '2025-02-11', 'P6283', '25-08163-02-11', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Bº UGANE 35', 'Fruiz', 'Bizkaia', '48116', 'España', 31.50, 0, '2025-02-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110225-W0Lv4VK5/sKl4-115', 'abc80670-699b-4ba2-b48a-b283956a7eca', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110225-W0Lv4VK5%2FsKl4-115&s=KOL2025&nf=P6283&i=31.50&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6687, 1, 1011, 2, 0, NULL, 0, '2025-02-11 11:32:19', '2025-02-11 12:49:41', '2025-02-11', 'P6284', '25-08164-02-11', 'Salón de peluquería Arte&Cabello', 0.00, 147.35, 30.94, 0.00, 0, 0.00, 0.00, 'Avenida Goleta 23-25', 'Alicante/Alacant', 'Alicante', '03550', 'España', 178.29, 0, '2025-02-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110225-NMcOOQ1Wf9p9W-199', '329612f7-b064-45ad-9424-08d9542abb91', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110225-NMcOOQ1Wf9p9W-199&s=KOL2025&nf=P6284&i=178.29&cr=191', '[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
(6688, 1, 556, 2, 0, NULL, 0, '2025-02-11 14:47:05', '2025-02-11 17:29:45', '2025-02-11', 'P6287', '25-08165-02-11', '', 0.00, 33.68, 8.14, 0.00, 0, 0.00, 6.17, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 46.92, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-110225-SStfP9wArPQPO-149', 'c6790d09-19c0-49df-b45e-83de359ea882', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110225-SStfP9wArPQPO-149&s=KOL2025&nf=P6287&i=46.92&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6689, 1, 28, 2, 0, NULL, 0, '2025-02-11 15:19:20', '2025-02-11 17:31:01', '2025-02-11', 'P6285', '25-08166-02-11', '', 0.00, 206.29, 44.02, 0.00, 0, 0.00, 4.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 253.82, 0, '2025-02-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-110225-W0W48uasLsOLR-197', '64fd3c22-4011-4230-9d90-7942868e8405', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110225-W0W48uasLsOLR-197&s=KOL2025&nf=P6285&i=253.82&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6690, 1, 1667, 2, 0, NULL, 0, '2025-02-11 15:36:50', '2025-02-11 17:31:26', '2025-02-11', 'P6286', '25-08167-02-11', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Calle San Pedro de Mezonzo, Nº 3, 3º F', 'Santiago de Composte', 'A Coruña', '15701', 'España', 31.27, 0, '2025-02-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110225-L1R7azFFQPxH5-194', '2425cd05-225b-42d0-b72e-6d98d27ca1c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110225-L1R7azFFQPxH5-194&s=KOL2025&nf=P6286&i=31.27&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6691, 1, 337, 2, 0, NULL, 0, '2025-02-11 17:19:19', '2025-02-12 08:42:34', '2025-02-12', 'P6293', '25-08169-02-11', '', 0.00, 58.94, 12.38, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaragoza', 'Zaragoza', '50014', 'España', 71.32, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120225-NCIsq2rvGOq5c-043', '271a6ae6-93d9-4091-b8b7-4a9657b5b3b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-NCIsq2rvGOq5c-043&s=KOL2025&nf=P6293&i=71.31&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6692, 1, 144, 2, 0, NULL, 0, '2025-02-11 17:39:53', '2025-02-12 08:53:22', '2025-02-12', '', '25-08170-02-11', '', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 213.95, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0),
(6693, 1, 75, 2, 0, NULL, 0, '2025-02-11 18:13:46', '2025-02-12 08:57:36', '2025-02-12', 'P6294', '25-08171-02-11', 'Horario martes a viernes de 10 00 a 19 00 ', 0.00, 147.35, 30.94, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 178.29, 0, '2025-02-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120225-aK4SzvaNfIQsN-012', '746c159f-3dcc-474f-beaa-3cb724540aff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-aK4SzvaNfIQsN-012&s=KOL2025&nf=P6294&i=178.29&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6694, 1, 144, 2, 0, NULL, 0, '2025-02-11 18:31:02', '2025-02-12 08:58:11', '2025-02-12', 'P6288', '25-08172-02-11', 'Si es posible lo necesito mañana miércoles por la tarde\r\nMuchas gracias ', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 213.95, 0, '2025-02-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120225-FZAoxFlAfjgcQ-034', '6f1ce3ab-acc6-41c1-ae80-d63ca11528f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-FZAoxFlAfjgcQ-034&s=KOL2025&nf=P6288&i=213.95&cr=096', '[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
(6695, 1, 1668, 2, 0, NULL, 0, '2025-02-11 20:08:07', '2025-02-12 08:59:16', '2025-02-12', 'P6289', '25-08173-02-11', 'Si no estoy en casa, llamar al telefono 610733563 para buscar opciones.', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'C/Filadores, 13 2-1', 'Salt', 'Girona', '17190', 'España', 28.98, 0, '2025-02-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120225-X5hQzjyArqQlo-114', 'abc4663e-9898-4f57-bf4d-50b97b1fa327', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-X5hQzjyArqQlo-114&s=KOL2025&nf=P6289&i=28.98&cr=255', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6696, 1, 1669, 2, 0, NULL, 0, '2025-02-11 20:41:53', '2025-02-12 08:59:44', '2025-02-12', 'P6290', '25-08175-02-11', 'Es el bajo vivienda, en el portal el timbre que no pone piso. Telefono de contacto 661340017', 0.00, 56.00, 11.76, 0.00, 0, 0.00, 0.00, 'Calle Herrador 1, bajo', 'Coruña (A)', 'A Coruña', '15004', 'España', 67.76, 0, '2025-02-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120225-QLT9cBJHIJfOs-051', 'b617b74c-87f6-438b-b560-e187f4caa52e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-QLT9cBJHIJfOs-051&s=KOL2025&nf=P6290&i=67.76&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6697, 1, 1670, 2, 0, NULL, 0, '2025-02-11 22:56:05', '2025-02-12 09:01:16', '2025-02-12', 'P6291', '25-08176-02-11', '', 0.00, 42.90, 9.65, 0.00, 0, 0.00, 3.67, 'Aiherra kalea 3-2 dch', 'Antzuola', 'Gipuzkoa', '20577', 'España', 55.58, 0, '2025-02-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120225-X6Zs2NFvX+lMR-168', 'ec540743-1a8a-4a2f-a919-fc483d1d8bce', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-X6Zs2NFvX%2BlMR-168&s=KOL2025&nf=P6291&i=55.58&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0),
(6698, 1, 1671, 2, 0, NULL, 0, '2025-02-12 07:33:21', '2025-02-12 09:07:19', '2025-02-12', 'P6292', '25-08177-02-12', 'Si no estuviese en mi domicilio avisar vecino a 1A 1B 1 C 1D', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Planeta Tierra 44 qB', 'Parla', 'Madrid', '28983', 'España', 31.27, 0, '2025-02-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120225-YvjwGhBbU2/jn-036', 'f4df8edc-868f-4225-99da-16107bb6228c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-YvjwGhBbU2%2Fjn-036&s=KOL2025&nf=P6292&i=31.27&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6699, 1, 1670, 2, 1, 'faltan lotes por incluir', 6697, '2025-02-12 09:01:59', '2025-02-12 09:01:59', '2025-02-12', 'R101', 'P6291 RECT.', '', 0.00, 42.90, 9.65, 0.00, 0, 0.00, 3.67, '', '', '', '', '', 55.58, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-120225-douYws3H4njb+-222', 'd99edbfa-352a-4d66-824b-f9891b86b7b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-douYws3H4njb%2B-222&s=KOL2025&nf=R101&i=-55.58&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(6700, 1, 1670, 1, 0, NULL, 0, '2025-02-12 09:04:02', '2025-02-12 09:06:56', '2025-02-12', 'P6295', '', '', 0.00, 42.91, 9.65, 0.00, 0, 0.00, 3.66, 'Aiherra kalea 3-2 dch', 'Antzuola', 'Gipuzkoa', '20577', 'España', 55.58, 0, '2025-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120225-UhmGjGjhhLSnX-069', 'f9a4a026-b667-40b3-b8a1-15cbc9d71604', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-UhmGjGjhhLSnX-069&s=KOL2025&nf=P6295&i=55.58&cr=127', '[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
(6701, 1, 1311, 1, 0, NULL, 0, '2025-02-12 09:12:13', '2025-02-12 09:12:13', '2025-02-12', 'P6296', '', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'Emilio Arrieta 25', 'Pamplona', 'Navarra', '31002', 'España', 106.98, 0, '2025-02-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120225-gmmDDKadj9kbV-244', 'f3218d3c-7b25-46a3-b939-2c2e6296ea4f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-gmmDDKadj9kbV-244&s=KOL2025&nf=P6296&i=106.98&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6702, 1, 77, 1, 0, NULL, 0, '2025-02-12 09:18:40', '2025-02-12 09:18:40', '2025-02-12', 'P6297', '', '', 0.00, 888.00, 186.48, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1074.48, 0, '2025-02-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120225-e/GXGPlA0X3Cy-218', '916fc127-d6fb-473e-b9cd-89753e9e2448', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-e%2FGXGPlA0X3Cy-218&s=KOL2025&nf=P6297&i=1074.48&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6703, 1, 976, 2, 0, NULL, 0, '2025-02-12 10:41:37', '2025-02-12 11:43:15', '2025-02-12', 'P6298', '25-08185-02-12', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'Calle Bolivia n1 bajo puerta 3', 'Coruña (A)', 'A Coruña', '15004', 'España', 106.98, 0, '2025-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120225-dVhxGnpXhGXIm-196', 'a9adfd6c-a9fc-4e46-b3f3-a77495d2d17c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-dVhxGnpXhGXIm-196&s=KOL2025&nf=P6298&i=106.98&cr=054', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6704, 1, 862, 2, 0, NULL, 0, '2025-02-12 11:26:30', '2025-02-12 12:50:54', '2025-02-12', 'P6300', '25-08186-02-12', '', 0.00, 11.20, 3.51, 0.00, 0, 0.00, 6.67, 'Finca san Anton, s/n', 'Mirabel', 'Cáceres', '10540', 'España', 20.22, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-120225-N/o67suOt/I1G-116', 'eb848e22-5965-436c-922b-4e9463418bf9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-N%2Fo67suOt%2FI1G-116&s=KOL2025&nf=P6300&i=20.22&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6705, 1, 4, 2, 0, NULL, 0, '2025-02-12 11:29:52', '2025-02-12 12:51:34', '2025-02-12', 'P6299', '25-08187-02-12', '', 0.00, 117.88, 25.45, 0.00, 0, 0.00, 4.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 146.66, 0, '2025-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120225-CuOzw7tnA7SaD-215', '3dd4b31b-72ec-4035-ad4e-9ef10209fe12', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-CuOzw7tnA7SaD-215&s=KOL2025&nf=P6299&i=146.66&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6706, 1, 34, 1, 0, NULL, 0, '2025-02-12 13:14:55', '2025-02-12 13:15:25', '2025-02-12', 'P6301', '', '', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'Calle iparraguirre 34 plaza trasera  ', 'Leioa', 'Bizkaia', '48940', 'España', 213.95, 0, '2025-02-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120225-P2pEhnISZK/Nx-062', '5a0f7dd0-81a7-49d3-a42a-161af02fe1cd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120225-P2pEhnISZK%2FNx-062&s=KOL2025&nf=P6301&i=213.95&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6707, 1, 913, 2, 0, NULL, 0, '2025-02-12 14:36:46', '2025-02-12 14:36:46', '2025-02-12', '', '25-08188-02-12', NULL, 0.00, 168.00, 35.28, 0.00, 0, 0.00, 0.00, 'Av. Extremadura 34 2D', 'Hoyos', 'Cáceres', '10850', 'España', 203.28, 0, '0000-00-00 00:00:00', '', '', 1, 3, 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
(6708, 1, 913, 2, 0, NULL, 0, '2025-02-12 14:44:46', '2025-02-13 09:00:01', '2025-02-13', 'P6302', '25-08189-02-12', '', 0.00, 33.68, 7.80, 0.00, 0, 0.00, 4.17, 'Av. Extremadura 34 2D', 'Hoyos', 'Cáceres', '10850', 'España', 44.92, 0, '2025-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130225-bCJjkKkTxgB1Z-021', 'e9aa6fb5-c988-4701-b202-b6e003d045a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-bCJjkKkTxgB1Z-021&s=KOL2025&nf=P6302&i=44.92&cr=205', '[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
(6709, 1, 1672, 2, 0, NULL, 0, '2025-02-12 17:33:08', '2025-02-13 14:03:03', '2025-02-13', 'P6303', '25-08190-02-12', 'Llamar al móvil para quedar hora de entrega', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'C/ General Vara de Rey 6-7ºA', 'Logroño', 'La Rioja', '26002', 'España', 17.72, 0, '2025-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130225-cY+soEKZ5dchf-011', '6f2221c0-1127-419d-a78a-01f848a6e49d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-cY%2BsoEKZ5dchf-011&s=KOL2025&nf=P6303&i=17.72&cr=011', '[BLOB]', 0, 'PRANHY071000006S', '2025-02-13 14:03:09', '[BLOB]', 2, '', '2025-02-13', 'S0133', 15, 20, 10, 100, 0, '', 1, 1);
