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
(3096, 1, 754, 2, 1, NULL, 3018, '2023-04-25 11:00:41', '2023-04-25 11:00:41', '2023-04-25', 'R36', 'P2841 RECT.', '', 0.00, 147.45, 30.96, 0.00, 0, 7.67, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 186.08, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-250423-nrO86eP0xY+XK-097', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-nrO86eP0xY%2BXK-097&s=KOL2023&nf=R36&i=-186.08&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3097, 1, 166, 2, 0, NULL, 0, '2023-04-25 09:24:50', '2023-04-25 11:28:16', '2023-04-25', 'P2918', '23-04178-04-25', '', 0.00, 115.10, 24.17, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 139.27, 0, '2023-04-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250423-lg0a3Khy+x0i1-160', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-lg0a3Khy%2Bx0i1-160&s=KOL2023&nf=P2918&i=139.27&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3098, 1, 136, 2, 0, NULL, 0, '2023-04-25 10:00:54', '2023-04-25 12:13:32', '2023-04-25', 'P2919', '23-04179-04-25', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'C/AVIADOR ZORITA, 13 - LOCAL PELUQUERIA', 'Madrid', 'Madrid', '28020', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-250423-bp6YbvnQVf5zB-139', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-bp6YbvnQVf5zB-139&s=KOL2023&nf=P2919&i=209.41&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3099, 1, 67, 1, 0, NULL, 0, '2023-04-25 12:57:53', '2023-04-25 12:57:53', '2023-04-25', 'P2920', '', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 344.85, 0, '2023-04-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250423-MRqrphIHjy18U-057', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-MRqrphIHjy18U-057&s=KOL2023&nf=P2920&i=344.85&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3100, 1, 259, 2, 0, NULL, 0, '2023-04-25 11:48:42', '2023-04-26 09:22:51', '2023-04-25', 'P2921', '23-04180-04-25', 'ENTREGAR DE 9:00 A 13:00', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'GIPUZKOA KALEA 53 BAJO', 'Zarautz', 'Gipuzkoa', '20800', 'España', 241.40, 0, '2023-04-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250423-fhGHVU3Qly6SA-101', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-fhGHVU3Qly6SA-101&s=KOL2023&nf=P2921&i=241.40&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3101, 1, 28, 2, 0, NULL, 0, '2023-04-25 11:52:55', '2023-04-26 09:33:38', '2023-04-25', 'P2922', '23-04181-04-25', '', 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, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250423-McGH/Sw9MnBgL-026', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-McGH%2FSw9MnBgL-026&s=KOL2023&nf=P2922&i=137.94&cr=156', '[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
(3102, 1, 28, 2, 0, NULL, 0, '2023-04-25 11:53:01', '2023-06-14 13:43:13', '2023-04-25', 'P2923', '23-04182-04-25', '', 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, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250423-ZiAah4cP+SojU-095', 'c587bb4c-2402-498e-8b87-1f14c8d63cdf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-ZiAah4cP%2BSojU-095&s=KOL2023&nf=P2923&i=137.94&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3103, 1, 28, 2, 0, NULL, 0, '2023-04-25 11:53:03', '2023-06-14 13:44:52', '2023-04-25', 'P2924', '23-04183-04-25', '', 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, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250423-L+mNXs7euymhM-184', 'ce6b96ab-ff4b-4f89-bd2b-42d384cb9c01', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-L%2BmNXs7euymhM-184&s=KOL2023&nf=P2924&i=137.94&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3104, 1, 28, 2, 0, NULL, 0, '2023-04-25 11:53:05', '2023-06-14 13:46:02', '2023-04-25', 'P2925', '23-04184-04-25', '', 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, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250423-IvUkrURB+cA0j-213', '0f2f3a17-016b-4ab8-b473-9526f9d009d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-IvUkrURB%2BcA0j-213&s=KOL2023&nf=P2925&i=137.94&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3105, 1, 57, 2, 0, NULL, 0, '2023-04-25 15:11:01', '2023-04-26 09:37:56', '2023-04-25', 'P2926', '23-04185-04-25', '', 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, '2023-04-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250423-fd4Xwb/xShw4s-220', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-fd4Xwb%2FxShw4s-220&s=KOL2023&nf=P2926&i=344.85&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3106, 1, 778, 2, 0, NULL, 0, '2023-04-25 15:24:00', '2023-04-26 09:42:19', '2023-04-25', 'P2927', '23-04186-04-25', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Elatzeta 42 2D', 'Irun', 'Gipuzkoa', '20303', 'España', 16.29, 0, '2023-04-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250423-SsZBgF1xTRPYy-141', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-SsZBgF1xTRPYy-141&s=KOL2023&nf=P2927&i=16.29&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3107, 1, 779, 2, 0, NULL, 0, '2023-04-25 20:44:42', '2023-04-26 09:45:53', '2023-04-25', 'P2928', '23-04187-04-25', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'plaza arsenio fernandez 23', 'Villaquejida', 'León', '24235', 'España', 26.40, 0, '2023-04-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250423-NfaTGkYwBEmj+-017', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250423-NfaTGkYwBEmj%2B-017&s=KOL2023&nf=P2928&i=26.40&cr=081', '[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
(3108, 1, 780, 2, 0, NULL, 0, '2023-04-26 07:51:57', '2023-04-26 12:17:28', '2023-04-26', 'P2929', '23-04188-04-26', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Santsaerreka.24', 'Asparrena', 'Álava', '01250', 'España', 26.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260423-fouw8Mh4Lt8Ru-117', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260423-fouw8Mh4Lt8Ru-117&s=KOL2023&nf=P2929&i=26.40&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3109, 1, 113, 1, 0, NULL, 0, '2023-04-26 10:20:33', '2023-04-26 10:52:06', '2023-04-26', 'P2930', '2023-04-26', '', 0.00, 143.60, 30.16, 0.00, 0, 0.00, 0.00, 'AVENIDA DE LOS LABRADORES 5 LOCAL3', 'Tres Cantos', 'Madrid', '28760', 'España', 173.76, 0, '2023-04-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260423-DFrP8SKulQyrT-233', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260423-DFrP8SKulQyrT-233&s=KOL2023&nf=P2930&i=173.76&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3110, 1, 110, 2, 0, NULL, 0, '2023-04-26 09:07:28', '2023-04-26 11:20:58', '2023-04-26', 'P2931', '23-04189-04-26', '', 0.00, 178.40, 37.46, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 215.86, 0, '2023-04-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260423-k1S2fzLn86ARv-170', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260423-k1S2fzLn86ARv-170&s=KOL2023&nf=P2931&i=215.86&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3111, 1, 781, 2, 0, NULL, 0, '2023-04-26 09:45:35', '2023-04-26 11:48:16', '2023-04-26', 'P2932', '23-04190-04-26', 'Timbre desde calle 604 ????️ ', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Enriqueta Elizacin 2 escalera 6-2B', 'Alicante/Alacant', 'Alicante', '03007', 'España', 16.29, 0, '2023-04-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260423-nSXg2mZu18mpK-179', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260423-nSXg2mZu18mpK-179&s=KOL2023&nf=P2932&i=16.29&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3112, 1, 782, 2, 0, NULL, 0, '2023-04-26 16:53:20', '2023-04-27 09:15:50', '2023-04-26', 'P2933', '23-04191-04-26', 'Llamar antes al 610959888 o 656660602', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Rda. Intermedia 4 puerta 26', 'Antequera', 'Málaga', '29200', 'España', 26.40, 0, '2023-04-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260423-TdBPlOfUCK0W8-055', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260423-TdBPlOfUCK0W8-055&s=KOL2023&nf=P2933&i=26.40&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3113, 1, 573, 2, 0, NULL, 0, '2023-04-26 19:57:41', '2023-04-27 09:41:11', '2023-04-26', 'P2934', '23-04192-04-26', '', 0.00, 36.36, 8.83, 0.00, 0, 0.00, 6.90, 'Paseo Margallo 22', 'Sitges', 'Barcelona', '08879', 'España', 50.90, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-260423-j8mVKBDKnsLBr-030', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260423-j8mVKBDKnsLBr-030&s=KOL2023&nf=P2934&i=50.90&cr=166', '[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
(3114, 1, 783, 2, 0, NULL, 0, '2023-04-26 20:05:28', '2023-04-27 09:46:23', '2023-04-26', 'P2935', '23-04193-04-26', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'Alvaro Cunqueiro, nº 15, 7º A ', 'Vigo', 'Pontevedra', '36211', 'España', 55.89, 0, '2023-04-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260423-ZcruLunNkJGHB-179', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260423-ZcruLunNkJGHB-179&s=KOL2023&nf=P2935&i=55.89&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3115, 1, 687, 1, 0, NULL, 0, '2023-04-27 09:26:16', '2023-04-27 09:30:30', '2023-04-27', 'P2936', '2023-04-27', '', 0.00, 64.40, 13.52, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 77.92, 0, '2023-04-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270423-UHzgihuoui0vZ-144', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270423-UHzgihuoui0vZ-144&s=KOL2023&nf=P2936&i=77.92&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3116, 1, 784, 2, 0, NULL, 0, '2023-04-27 09:42:14', '2023-04-27 11:49:43', '2023-04-27', 'P2937', '23-04195-04-27', '', 0.00, 147.45, 30.96, 0.00, 1, 7.67, 0.00, 'C/San Francisco 30 bis, bajo. Gros', 'Donostia-San Sebasti', 'Gipuzkoa', '20002', 'España', 186.08, 0, '2023-04-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270423-icy4OXZCOQV88-109', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270423-icy4OXZCOQV88-109&s=KOL2023&nf=P2937&i=186.08&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3117, 1, 602, 2, 0, NULL, 0, '2023-04-27 11:34:47', '2023-04-28 09:14:27', '2023-04-27', 'P2938', '23-04196-04-27', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Plaza Porticada 2 5B', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 28.19, 0, '2023-04-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270423-UQ0FtQoTbvfmR-054', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270423-UQ0FtQoTbvfmR-054&s=KOL2023&nf=P2938&i=28.19&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3118, 1, 785, 2, 0, NULL, 0, '2023-04-27 12:21:21', '2023-04-28 12:39:22', '2023-04-27', 'P2939', '23-04201-04-27', '', 0.00, 9.83, 6.54, 0.00, 0, 0.00, 25.77, 'Rua Silva Carvalho 234, 1', 'Lisboa', 'Lisboa', '1250-259', 'Portugal', 37.66, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-270423-RZYSPqHA9ZGaX-118', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270423-RZYSPqHA9ZGaX-118&s=KOL2023&nf=P2939&i=37.65&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3119, 1, 617, 2, 0, NULL, 0, '2023-04-27 17:26:00', '2023-04-28 09:17:20', '2023-04-27', 'P2940', '23-04202-04-27', 'PELUQUERIA ANA BARROS ', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'MARQUES DE RIESTRA 14 BAJO ', 'Pontevedra', 'Pontevedra', '36002', 'España', 517.28, 0, '2023-04-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270423-M3VHEVu+PW3u+-197', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270423-M3VHEVu%2BPW3u%2B-197&s=KOL2023&nf=P2940&i=517.28&cr=060', '[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
(3120, 1, 786, 2, 0, NULL, 0, '2023-04-27 19:38:27', '2023-04-28 09:36:07', '2023-04-27', 'P2941', '23-04203-04-27', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Cañamero 89A', 'Don Benito', 'Badajoz', '06400', 'España', 16.29, 0, '2023-04-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270423-dSDekQ1J0pphp-056', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270423-dSDekQ1J0pphp-056&s=KOL2023&nf=P2941&i=16.29&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3121, 1, 787, 2, 0, NULL, 0, '2023-04-28 06:37:56', '2023-04-28 09:39:34', '2023-04-28', 'P2942', '23-04204-04-28', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'can xum 33', 'Canyelles', 'Barcelona', '08811', 'España', 28.19, 0, '2023-04-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280423-m0iSshmtTGk6T-241', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280423-m0iSshmtTGk6T-241&s=KOL2023&nf=P2942&i=28.19&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3122, 1, 652, 2, 0, NULL, 0, '2023-04-28 08:52:07', '2023-04-28 10:54:12', '2023-04-28', 'P2943', '23-04205-04-28', 'Clínica dental Bastida', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Avda Hispanidad 96', 'Vigo', 'Pontevedra', '36203', 'España', 40.08, 0, '2023-04-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280423-JR3IhYZirchdD-129', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280423-JR3IhYZirchdD-129&s=KOL2023&nf=P2943&i=40.08&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3123, 1, 788, 2, 0, NULL, 0, '2023-04-28 10:09:06', '2023-04-28 12:34:20', '2023-04-28', 'P2944', '23-04206-04-28', '', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'CALLE BEGONIA 66', 'Alcobendas', 'Madrid', '28109', 'España', 40.08, 0, '2023-04-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280423-aKU++wpYByzvZ-061', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280423-aKU%2B%2BwpYByzvZ-061&s=KOL2023&nf=P2944&i=40.08&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3124, 1, 713, 2, 0, NULL, 0, '2023-04-28 11:45:32', '2023-05-02 09:11:57', '2023-04-28', 'P2945', '23-04232-04-28', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'c/ Escorxador nº8, 1-2', 'Torredembarra', 'Tarragona', '43830', 'España', 28.19, 0, '2023-04-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280423-MMj6/za6v14RA-062', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280423-MMj6%2Fza6v14RA-062&s=KOL2023&nf=P2945&i=28.19&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3125, 1, 789, 2, 0, NULL, 0, '2023-04-28 12:33:37', '2023-05-02 09:16:20', '2023-04-28', 'P2946', '23-04233-04-28', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'José María Jimeno Jurío 17Bis', 'Ansoáin', 'Navarra', '31013', 'España', 28.19, 0, '2023-04-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280423-GNTAuLC/JR/h9-041', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280423-GNTAuLC%2FJR%2Fh9-041&s=KOL2023&nf=P2946&i=28.19&cr=246', '[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
(3126, 1, 262, 2, 0, NULL, 0, '2023-04-29 06:24:53', '2023-05-02 09:20:00', '2023-04-29', 'P2947', '23-04234-04-29', 'Entrega de martes a sábado: de 9h a 13H y de 16H a 19H', 0.00, 129.90, 27.28, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 157.18, 0, '2023-04-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290423-o9bi5H3A73Jti-163', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290423-o9bi5H3A73Jti-163&s=KOL2023&nf=P2947&i=157.18&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3127, 1, 376, 2, 0, NULL, 0, '2023-04-30 14:46:04', '2023-05-02 09:25:04', '2023-04-30', 'P2948', '23-04236-04-30', '', 0.00, 58.98, 12.39, 0.00, 0, 0.00, 0.00, 'Gremi d\'Hortolans n°11, planta 2, oficina 7', 'Palma de Mallorca', 'Baleares (Illes)', '07009', 'España', 71.37, 0, '2023-04-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300423-ICU1s0q75+Ck+-093', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300423-ICU1s0q75%2BCk%2B-093&s=KOL2023&nf=P2948&i=71.37&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3128, 1, 538, 2, 0, NULL, 0, '2023-05-01 06:17:19', '2023-05-02 09:29:31', '2023-05-01', 'P2949', '23-04237-05-01', '', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'C/Raval n24', 'Olesa de Bonesvalls', 'Barcelona', '08795', 'España', 40.08, 0, '2023-05-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010523-IoHRnCOIlkmIM-247', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010523-IoHRnCOIlkmIM-247&s=KOL2023&nf=P2949&i=40.08&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3129, 1, 4, 2, 0, NULL, 0, '2023-05-02 08:49:27', '2023-05-02 11:11:46', '2023-05-02', 'P2950', '23-04238-05-02', '', 0.00, 278.70, 58.53, 0.00, 0, 0.00, 0.00, 'Plazuela de San Martín de Abendaño 4, bajo', 'VITORIA -GAZTEIZ', 'ALAVA', '01009', 'ESPAÑA', 337.23, 0, '2023-05-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020523-jddxIZszH8HaU-069', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020523-jddxIZszH8HaU-069&s=KOL2023&nf=P2950&i=337.23&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3130, 1, 10, 2, 0, NULL, 0, '2023-05-02 15:05:36', '2023-05-02 17:28:18', '2023-05-02', 'P2951', '23-04239-05-02', '', 0.00, 214.30, 45.00, 0.00, 0, 0.00, 0.00, 'Agirre auzunea 1 behea', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 259.30, 0, '2023-05-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020523-KxyiiumBe8AjY-183', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020523-KxyiiumBe8AjY-183&s=KOL2023&nf=P2951&i=259.30&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3131, 1, 791, 2, 0, NULL, 0, '2023-05-02 19:55:08', '2023-05-04 12:39:26', '2023-05-02', 'P2952', '23-04240-05-02', '', 0.00, 36.36, 8.40, 0.00, 0, 0.00, 4.40, 'Joaquín Bustamante 5, 3D', 'Santander', 'Cantabria', '39011', 'España', 48.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020523-By6zWmvkJgSRU-217', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020523-By6zWmvkJgSRU-217&s=KOL2023&nf=P2952&i=48.40&cr=022', '[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
(3132, 1, 792, 2, 0, NULL, 0, '2023-05-02 20:24:18', '2023-05-03 09:03:48', '2023-05-02', 'P2953', '23-04241-05-02', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Jordi pujol 9 ', 'Benavent de Segrià', 'Lleida', '25132 ', 'España', 16.29, 0, '2023-05-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020523-od335bhyLkFsB-147', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020523-od335bhyLkFsB-147&s=KOL2023&nf=P2953&i=16.29&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3133, 1, 455, 2, 0, NULL, 0, '2023-05-03 06:56:23', '2023-05-03 09:06:11', '2023-05-03', 'P2954', '23-04243-05-03', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Barrio Frain 22 ', 'Lesaka', 'Navarra', '31770', 'España', 28.19, 0, '2023-05-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030523-N02yMMCXbx+U+-086', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030523-N02yMMCXbx%2BU%2B-086&s=KOL2023&nf=P2954&i=28.19&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3134, 1, 639, 2, 0, NULL, 0, '2023-05-03 07:55:33', '2023-05-03 10:58:02', '2023-05-03', 'P2955', '23-04244-05-03', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Plaza Pontevedra, 8- 6 D', 'Fuenlabrada', 'Madrid', '28942', 'España', 16.29, 0, '2023-05-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030523-fU5lkRD/pspGC-089', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030523-fU5lkRD%2FpspGC-089&s=KOL2023&nf=P2955&i=16.29&cr=190', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3135, 1, 462, 2, 0, NULL, 0, '2023-05-03 12:15:11', '2023-05-04 09:36:24', '2023-05-03', 'P2956', '23-04245-05-03', '', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Santa María 12', 'Font-rubí', 'Barcelona', '08736', 'España', 40.08, 0, '2023-05-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030523-ZJriqnSQkYA+N-007', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030523-ZJriqnSQkYA%2BN-007&s=KOL2023&nf=P2956&i=40.08&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3136, 1, 793, 2, 0, NULL, 0, '2023-05-03 12:28:59', '2023-05-04 09:39:11', '2023-05-03', 'P2957', '23-04246-05-03', 'Entrada por Martin Luther King, 33. ', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'C/Igualdad, 54', 'Alcorcón', 'Madrid', '28922', 'España', 55.89, 0, '2023-05-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030523-N8BM6NKnZ2AQq-079', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030523-N8BM6NKnZ2AQq-079&s=KOL2023&nf=P2957&i=55.89&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3137, 1, 68, 2, 0, NULL, 0, '2023-05-03 14:07:50', '2023-05-04 09:43:04', '2023-05-03', 'P2958', '23-04248-05-03', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'murgis 45', 'Ejido (El)', 'Almería', '04700', 'España', 137.94, 0, '2023-05-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030523-G+1z3EqUWqvpj-155', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030523-G%2B1z3EqUWqvpj-155&s=KOL2023&nf=P2958&i=137.94&cr=025', '[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
(3138, 1, 351, 2, 0, NULL, 0, '2023-05-03 15:02:38', '2023-05-04 09:45:32', '2023-05-03', 'P2959', '23-04250-05-03', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Apartado de correos 45', 'Hoyos', 'Cáceres', '10850', 'España', 16.29, 0, '2023-05-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030523-OA2P7ZsmL1ekh-150', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030523-OA2P7ZsmL1ekh-150&s=KOL2023&nf=P2959&i=16.29&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3139, 1, 40, 1, 0, NULL, 0, '2023-05-04 10:19:15', '2023-05-04 10:19:15', '2023-05-04', 'P2960', '2023-05-04', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 103.46, 0, '2023-05-04 00:00:00', '', '', 3, 6, 1, 'TBAI-B20930640-040523-cQGA7Hm6QaXhP-117', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040523-cQGA7Hm6QaXhP-117&s=KOL2023&nf=P2960&i=103.46&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3140, 1, 65, 2, 0, NULL, 0, '2023-05-04 09:05:07', '2024-07-17 13:06:50', '2023-05-04', 'P2961', '23-04251-05-04', '', 0.00, 798.00, 167.58, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 965.58, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040523-N2LpGs0Dxk1Gt-096', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040523-N2LpGs0Dxk1Gt-096&s=KOL2023&nf=P2961&i=965.58&cr=138', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3141, 1, 794, 2, 0, NULL, 0, '2023-05-04 09:37:18', '2023-05-04 12:00:38', '2023-05-04', 'P2962', '23-04252-05-04', '', 0.00, 129.90, 27.28, 0.00, 0, 0.00, 0.00, 'Idoia 4 bajo', 'Zizur Mayor/Zizur Na', 'Navarra', '31180', 'España', 157.18, 0, '2023-05-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040523-aOTISbsmTASRK-056', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040523-aOTISbsmTASRK-056&s=KOL2023&nf=P2962&i=157.18&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3142, 1, 794, 1, 0, NULL, 0, '2023-05-04 12:02:23', '2023-05-04 12:02:23', '2023-05-04', 'P2963', '2023-05-04', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Idoia 4 bajo', 'Zizur Mayor/Zizur Na', 'Navarra', '31180', 'España', 34.48, 0, '2023-05-04 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040523-EI8iwp/cqjkxo-072', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040523-EI8iwp%2Fcqjkxo-072&s=KOL2023&nf=P2963&i=34.47&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3143, 1, 242, 1, 0, NULL, 0, '2023-05-04 12:06:24', '2023-05-04 12:06:33', '2023-05-04', 'P2964', '2023-05-04', '', 0.00, 177.60, 37.30, 0.00, 1, 9.24, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 224.14, 0, '2023-05-04 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040523-mKSi6MsZc+Tq6-008', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040523-mKSi6MsZc%2BTq6-008&s=KOL2023&nf=P2964&i=224.14&cr=211', '[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
(3144, 1, 494, 2, 0, NULL, 0, '2023-05-04 15:11:00', '2023-05-04 17:12:14', '2023-05-04', 'P2965', '23-04107-04-13', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Segura,14', 'Monzón', 'Huesca', '22400', 'España', 28.19, 0, '0000-00-00 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040523-nE9vdlq50e+3O-186', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040523-nE9vdlq50e%2B3O-186&s=KOL2023&nf=P2965&i=28.19&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3145, 1, 494, 2, 0, NULL, 0, '2023-05-04 15:14:11', '2023-05-05 11:00:41', '2023-05-04', 'P2966', '23-04107-04-13', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Segura,14', 'Monzón', 'Huesca', '22400', 'España', 28.19, 0, '0000-00-00 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040523-CVjofStA4W+43-068', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040523-CVjofStA4W%2B43-068&s=KOL2023&nf=P2966&i=28.19&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3146, 1, 120, 2, 0, NULL, 0, '2023-05-04 16:00:46', '2023-05-05 08:58:13', '2023-05-04', 'P2967', '23-04254-05-04', '', 0.00, 115.10, 24.17, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 139.27, 0, '2023-05-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040523-gIaBRQwqe9XMW-016', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040523-gIaBRQwqe9XMW-016&s=KOL2023&nf=P2967&i=139.27&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3147, 1, 149, 1, 0, NULL, 0, '2023-05-05 08:50:23', '2023-05-05 08:53:20', '2023-05-05', 'P2968', '2023-05-05', '', 0.00, 71.80, 15.51, 0.00, 0, 0.00, 2.50, 'Urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 89.38, 0, '2023-05-05 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-050523-izZz0Q+Z2grd0-091', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050523-izZz0Q%2BZ2grd0-091&s=KOL2023&nf=P2968&i=89.38&cr=010', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3148, 1, 190, 3, 0, NULL, 0, '2023-05-05 09:05:21', '2023-05-05 09:06:29', '2023-05-05', '', 'consumo peluquería', '', 0.00, 100.30, 21.06, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 121.36, 0, '2023-05-05 00:00:00', '', '', 1, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3149, 1, 204, 2, 0, NULL, 0, '2023-05-05 07:58:36', '2023-05-05 10:37:14', '2023-05-05', 'P2969', '23-04255-05-05', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'nou 23 local 1', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 137.94, 0, '2023-05-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050523-ZLX6meE1epnr4-223', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050523-ZLX6meE1epnr4-223&s=KOL2023&nf=P2969&i=137.94&cr=208', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3150, 1, 494, 2, 1, 'Corrección.', 3145, '2023-05-05 11:04:24', '2023-06-08 09:17:38', '2023-05-05', 'R37', 'P2966 RECT.', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Segura,14', 'Monzón', 'Huesca', '22400', 'España', 28.19, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-050523-ltfyd7aDyuWsO-003', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050523-ltfyd7aDyuWsO-003&s=KOL2023&nf=R37&i=-28.19&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 1);
