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
(3664, 1, 931, 2, 0, NULL, 0, '2023-08-21 14:25:19', '2023-08-21 16:59:00', '2023-08-21', 'P3441', '23-04884-08-21', 'Llamar antes por que es urbanización nueva y hay calles que no salen en gps', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/Marie Curie 16', 'Puebla de Montalbán ', 'Toledo', '45516', 'España', 28.39, 0, '2023-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210823-J75fTyhkJKQIF-139', 'da0eedb8-edc3-44f8-abf7-ee3735b19578', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210823-J75fTyhkJKQIF-139&s=KOL2023&nf=P3441&i=28.39&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3665, 1, 760, 2, 0, NULL, 0, '2023-08-21 15:14:06', '2023-08-21 17:33:07', '2023-08-21', 'P3442', '23-04885-08-21', 'Entregar por la tarde apertir de las 15 h', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Ortega y Gasset numero 3. Viana de Cega  .(Urbanizacion Coto del Cardiel', 'Valladolid', 'Valladolid', '47150', 'España', 17.50, 0, '2023-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210823-cILyv1QOR3RUr-049', 'b687e062-7bd4-497a-95ec-65e4e055a7b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210823-cILyv1QOR3RUr-049&s=KOL2023&nf=P3442&i=17.50&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3666, 1, 4, 2, 0, NULL, 0, '2023-08-21 15:42:15', '2023-08-21 17:45:12', '2023-08-21', 'P3443', '23-04886-08-21', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 310.37, 0, '2023-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210823-LZ4txmBn2DCCu-075', 'fdd3b46f-1e20-4fe9-b724-fd72de7fe769', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210823-LZ4txmBn2DCCu-075&s=KOL2023&nf=P3443&i=310.37&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3667, 1, 0, 1, 0, NULL, 0, '2023-08-22 09:59:50', '2023-08-22 09:59:50', '2023-08-22', '', 'PROMOCIÓN', '', 0.00, 10.83, 2.27, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 13.10, 0, '2023-08-22 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3668, 1, 445, 2, 0, NULL, 0, '2023-08-22 08:37:35', '2023-08-22 11:02:06', '2023-08-22', 'P3444', '23-04888-08-22', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'AMETZAGAÑA  66 BAJO, (ARTE MARMOL)', 'Donostia-San Sebasti', 'Gipuzkoa', '20012', 'España', 65.52, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220823-MxTxjIpJlWONt-149', '5346e703-9cc0-4ba8-81be-b47e957c4fa6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220823-MxTxjIpJlWONt-149&s=KOL2023&nf=P3444&i=65.52&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3669, 1, 932, 2, 0, NULL, 0, '2023-08-22 10:13:19', '2023-08-22 12:27:35', '2023-08-22', 'P3445', '23-04889-08-22', 'Llamar antes de entregar', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Calle acera del pilar edificio residencial casa fuerte local 2 peluquería ', 'Almuñécar', 'Granada', '18697', 'España', 196.56, 0, '2023-08-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220823-Kzrham1O5ZzNp-246', '6ac58f1a-8db3-4b31-8d0a-31a0b5910c04', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220823-Kzrham1O5ZzNp-246&s=KOL2023&nf=P3445&i=196.56&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3670, 1, 933, 2, 0, NULL, 0, '2023-08-22 15:51:11', '2023-08-23 09:24:33', '2023-08-22', 'P3446', '23-04890-08-22', 'Llamar al 667569120', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Mayor, 4A', 'Manises', 'Valencia', '46940', 'España', 17.50, 0, '2023-08-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220823-gxSlD2P+5yBn/-128', 'efe2773e-17ca-4a03-aeef-7a6687b6cad1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220823-gxSlD2P%2B5yBn%2F-128&s=KOL2023&nf=P3446&i=17.50&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3671, 1, 715, 2, 0, NULL, 0, '2023-08-22 22:04:48', '2023-08-23 09:28:30', '2023-08-22', 'P3447', '23-04894-08-22', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sanguino Michel 16, 4A', 'Cáceres', 'Cáceres', '10001', 'España', 28.39, 0, '2023-08-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220823-dBYiX59kqiLEM-185', '5449df6f-5f40-41c8-8c5a-d36e27d69a27', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220823-dBYiX59kqiLEM-185&s=KOL2023&nf=P3447&i=28.39&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3672, 1, 356, 2, 0, NULL, 0, '2023-08-23 10:27:16', '2023-08-23 12:32:09', '2023-08-23', 'P3448', '23-04895-08-23', 'El portal está en la parte de atrás del edificio.', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'c/ Mendarozabal, 5 - 2 izq.', 'Mendaro', 'Gipuzkoa', '20850', 'España', 52.39, 0, '2023-08-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230823-Iqg6WnqoZ6sbz-039', '395d8e43-f34d-4e44-8103-eec0d411d693', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230823-Iqg6WnqoZ6sbz-039&s=KOL2023&nf=P3448&i=52.39&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3673, 1, 110, 2, 0, NULL, 0, '2023-08-24 08:11:36', '2023-08-24 10:17:45', '2023-08-24', 'P3449', '23-04896-08-24', 'lunes cerrado', 0.00, 166.92, 35.05, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 201.97, 0, '2023-08-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240823-NCHwcnQWAz1cu-218', 'a6b9ac15-8e96-4e0b-b6ca-8bcbe3043bfa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240823-NCHwcnQWAz1cu-218&s=KOL2023&nf=P3449&i=201.97&cr=146', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3674, 1, 678, 2, 0, NULL, 0, '2023-08-24 08:35:25', '2023-08-30 10:59:19', '2023-08-24', 'P3450', '23-04897-08-24', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Carrer de les Corts  de  Càdis, 40 . 2 ,1', 'Castelldefels', 'Barcelona', '08860', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-240823-ibiCsDkzkrBen-127', '7a8788c6-9323-4fbb-9e3c-2e0fd2048df5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240823-ibiCsDkzkrBen-127&s=KOL2023&nf=P3450&i=33.11&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3675, 1, 934, 2, 0, NULL, 0, '2023-08-24 09:20:23', '2023-08-24 11:48:52', '2023-08-24', 'P3451', '23-04898-08-24', 'Horario comercial de 10 a 14. Llamar por teléfono en caso de no estar para dejar en local vecino.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carretera estación 2, local 10. Estudio de interiorismo manu zapata', 'Llerena', 'Badajoz', '06900', 'España', 17.50, 0, '2023-08-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240823-D6lF7zhEKHdTS-206', '735bb3d3-a438-4585-af22-c3db02473181', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240823-D6lF7zhEKHdTS-206&s=KOL2023&nf=P3451&i=17.50&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3676, 1, 935, 2, 0, NULL, 0, '2023-08-25 09:16:07', '2023-08-25 11:30:15', '2023-08-25', 'P3452', '23-04899-08-25', 'Es una ortopedia que se llama Muevete y Accede', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle amadeu torner, 51 local', 'Hospitalet de Llobre', 'Barcelona', '08902', 'España', 17.50, 0, '2023-08-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250823-E8E5xlgSehZgv-072', '32a371f7-100d-4247-8d9e-7a5cf9a5a453', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250823-E8E5xlgSehZgv-072&s=KOL2023&nf=P3452&i=17.50&cr=085', '[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
(3677, 1, 936, 2, 0, NULL, 0, '2023-08-25 11:27:47', '2023-08-28 09:08:33', '2023-08-25', 'P3453', '23-04900-08-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avda de miajadas nº32 (Inovo)', 'Trujillo', 'Cáceres', '10200', 'España', 30.61, 0, '2023-08-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250823-XBUTozRzv+Sf+-094', '3935cca5-d9ff-40d3-b711-427d9c060b0f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250823-XBUTozRzv%2BSf%2B-094&s=KOL2023&nf=P3453&i=30.61&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3678, 1, 677, 2, 0, NULL, 0, '2023-08-25 12:48:29', '2023-08-28 09:10:15', '2023-08-25', 'P3454', '23-04901-08-25', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'VOLVO ARREGUI (OSCAR ARAGUNDE)  PORTAL DE BETOÑO 13', 'Vitoria-Gasteiz', 'Álava', '01013', 'España', 65.52, 0, '2023-08-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250823-QdMwuMX9MNxkW-193', '56b36b0e-e121-4cc2-b727-97e86e9b2d88', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250823-QdMwuMX9MNxkW-193&s=KOL2023&nf=P3454&i=65.52&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3679, 1, 838, 2, 0, NULL, 0, '2023-08-26 12:05:53', '2023-08-28 09:11:58', '2023-08-26', 'P3455', '23-04902-08-26', 'En caso de ausencia entregar a conserje Gabriela', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'AVENIDA PAPA LUNA 28, 7E', 'Peñíscola', 'Castellón', '12598', 'España', 52.39, 0, '2023-08-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260823-HzQQzCu0/FGrf-067', '70a9eda0-779d-4d8f-9ba8-ac6e48f9f740', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260823-HzQQzCu0%2FFGrf-067&s=KOL2023&nf=P3455&i=52.39&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3680, 1, 937, 2, 0, NULL, 0, '2023-08-27 08:16:38', '2023-08-28 09:13:46', '2023-08-27', 'P3456', '23-04903-08-27', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'paseo del prior 73 3 B', 'Logroño', 'La Rioja', '26004', 'España', 30.61, 0, '2023-08-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270823-YJ7HVEZQ6eEWF-079', '5b14cf1e-e7a5-4972-af52-43d9f9575605', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270823-YJ7HVEZQ6eEWF-079&s=KOL2023&nf=P3456&i=30.61&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3681, 1, 613, 2, 0, NULL, 0, '2023-08-27 09:02:58', '2023-08-28 09:14:47', '2023-08-27', 'P3457', '23-04904-08-27', 'Si no hay nadie en el domicilio se puede dejar el paquete al conserje John Jairo 608 708 301', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Joaquín Zurita 11, 3-A', 'Boadilla del Monte', 'Madrid', '28660', 'España', 17.50, 0, '2023-08-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270823-f/eFJIDUwWPmj-086', '0a3978cc-ec99-4b6c-ae25-eb813669e901', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270823-f%2FeFJIDUwWPmj-086&s=KOL2023&nf=P3457&i=17.50&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3682, 1, 754, 2, 0, NULL, 0, '2023-08-27 15:30:53', '2023-08-28 09:18:24', '2023-08-27', 'P3458', '23-04905-08-27', 'DE FORMA PUNTUAL YA QUE ESTA SEMANA ESTAREMOS DE VACACIONES PORFAVOR ENVIEN EL PEDIDO A LA CALLE:\r\nMALLORCA Nº5 LOCAL \r\n43870 AMPOSTA\r\n( NO HACER CONTAR ESTA DIRECCIÓN EN LA FACTURA. ES ALGO PUNTUAL ) RESPONDAME POR MAIL PARA CONFIRMAR ENTREGA A ESTA DIRECCIÓN DE FORMA PUNTUAL EN ESTE PEDIDO.\r\nGRACIAS', 0.00, 65.12, 13.67, 0.00, 1, 3.39, 0.00, 'JOSEP TARRADELLAS 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 82.19, 0, '2023-08-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270823-EUoPUrDT2Dqwx-188', '488b1cfa-d858-44c4-8f6a-55e9ebd0659b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270823-EUoPUrDT2Dqwx-188&s=KOL2023&nf=P3458&i=82.19&cr=181', '[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
(3683, 1, 250, 2, 0, NULL, 0, '2023-08-27 17:01:18', '2023-08-28 09:35:38', '2023-08-27', 'P3459', '23-04906-08-27', '', 0.00, 21.66, 5.97, 0.00, 0, 0.00, 8.19, 'C/Estribor N 9 2B  PORTO CRISTO ', 'Manacor', 'Baleares (Illes)', '07680', 'España', 34.40, 0, '2023-08-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270823-HgX98MjO0LcT/-218', 'e9324d93-e87f-43e6-8627-52fabb0dd4cb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270823-HgX98MjO0LcT%2F-218&s=KOL2023&nf=P3459&i=34.40&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3684, 1, 23, 2, 0, NULL, 0, '2023-08-27 17:35:42', '2023-08-28 09:36:52', '2023-08-27', 'P3460', '23-04907-08-27', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 172.43, 0, '2023-08-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270823-BGcODzsNcsRq+-001', 'a3ae5494-b888-42f1-964a-54748988dba7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270823-BGcODzsNcsRq%2B-001&s=KOL2023&nf=P3460&i=172.43&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3685, 1, 938, 2, 0, NULL, 0, '2023-08-27 20:35:19', '2023-08-28 09:38:03', '2023-08-27', 'P3461', '23-04908-08-27', 'Es casa unifamiliar', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Comandante Fortea, 60', 'Madrid', 'Madrid', '28008', 'España', 52.39, 0, '2023-08-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270823-i7VPbqKvBkQDL-071', 'e83986e9-068d-4d1e-9bb6-cb6f140543de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270823-i7VPbqKvBkQDL-071&s=KOL2023&nf=P3461&i=52.39&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3686, 1, 676, 2, 0, NULL, 0, '2023-08-28 06:42:18', '2023-08-28 09:39:08', '2023-08-28', 'P3462', '23-04909-08-28', 'Piso 5, BEYOND ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo de Gracia 98, BEYOND Piso 5', 'Barcelona', 'Barcelona', '08008', 'España', 17.50, 0, '2023-08-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280823-UklLRP2TisCHJ-225', 'd6f65972-6757-476b-99ae-e4a950def34d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-UklLRP2TisCHJ-225&s=KOL2023&nf=P3462&i=17.50&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3687, 1, 391, 2, 0, NULL, 0, '2023-08-28 07:41:47', '2023-08-28 09:47:45', '2023-08-28', 'P3463', '23-04910-08-28', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle divina pastora 13 bajo', 'Ansoáin', 'Navarra', '31013', 'España', 68.97, 0, '2023-08-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280823-MKB4dtdpN6Zvs-033', '3b6852a1-4105-4a8d-ada3-e52c42d75a2f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-MKB4dtdpN6Zvs-033&s=KOL2023&nf=P3463&i=68.97&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3688, 1, 131, 2, 0, NULL, 0, '2023-08-28 08:40:52', '2023-08-28 11:07:23', '2023-08-28', '', '23-04911-08-28', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3689, 1, 131, 2, 0, NULL, 0, '2023-08-28 11:07:41', '2023-08-28 11:07:41', '2023-08-28', 'P3464', '23-04911-08-28', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280823-Ap3GT7zixtZKq-201', '57853b68-1a30-491e-825b-6e3ea055f833', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-Ap3GT7zixtZKq-201&s=KOL2023&nf=P3464&i=379.34&cr=249', '[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
(3690, 1, 385, 2, 0, NULL, 0, '2023-08-28 10:13:43', '2023-08-28 12:16:56', '2023-08-28', 'P3465', '23-04912-08-28', 'Empresa: Iparvending', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'PI Artunduaga. C/ Azganeta 14', 'Basauri', 'Bizkaia', '48970', 'España', 17.50, 0, '2023-08-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280823-QK5RIPLiMrKLJ-090', 'e371a14a-31af-4c28-a428-f46d2956fafa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-QK5RIPLiMrKLJ-090&s=KOL2023&nf=P3465&i=17.50&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3691, 1, 77, 1, 0, NULL, 0, '2023-08-28 12:15:36', '2023-08-28 12:15:36', '2023-08-28', 'P3466', '2023-08-28', '', 0.00, 557.70, 117.12, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 674.82, 0, '2023-08-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280823-BUvqFzbzDAwwj-133', 'b8a98b7f-5e43-4dcf-af70-a132c518e9d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-BUvqFzbzDAwwj-133&s=KOL2023&nf=P3466&i=674.82&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3692, 1, 340, 2, 0, NULL, 0, '2023-08-28 12:49:28', '2023-08-29 09:13:55', '2023-08-28', 'P3467', '23-04913-08-28', 'estamos cerrados hasta el 31 jueves que trabajamos ya en el horario habitual', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'juan carlos 1 17, 17', 'Sesma', 'Navarra', '31293', 'España', 68.97, 0, '2023-08-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280823-Z1sLo5kV+SJ7D-180', '8c11cd50-680c-4b78-bca6-8b52994c4967', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-Z1sLo5kV%2BSJ7D-180&s=KOL2023&nf=P3467&i=68.97&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3693, 1, 939, 2, 0, NULL, 0, '2023-08-28 15:11:17', '2023-08-29 09:16:22', '2023-08-28', 'P3468', '23-04914-08-28', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Kazkazuri plaza 2-3B', 'Oiartzun', 'Gipuzkoa', '20180', 'España', 17.50, 0, '2023-08-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280823-OTogzbkbF9DAQ-140', 'fb0d4a7a-5671-4bdf-ba23-6a2e7f0d1efc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-OTogzbkbF9DAQ-140&s=KOL2023&nf=P3468&i=17.50&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3694, 1, 940, 2, 0, NULL, 0, '2023-08-28 16:17:20', '2023-08-29 09:18:32', '2023-08-28', 'P3469', '23-04915-08-28', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Matilde Orbegozo 17. 3c', 'Bilbao', 'Bizkaia', '48003', 'España', 30.61, 0, '2023-08-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280823-c3btnljTmsgOW-210', '598f6322-deb7-46b4-b8b5-52ad5aaa32f8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-c3btnljTmsgOW-210&s=KOL2023&nf=P3469&i=30.61&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3695, 1, 218, 2, 0, NULL, 0, '2023-08-28 16:27:52', '2023-08-29 09:20:57', '2023-08-28', 'P3470', '23-04916-08-28', 'HORARIO: DE 10.00 A 17.00 ', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'C/ Josefa Amar y Borbon nº 11 ', 'Zaragoza', 'Zaragoza', '50001', 'España', 68.97, 0, '2023-08-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280823-J1VQCdx/6fCpo-222', '4fd324c0-bf53-4cd8-b956-c3b4376330fb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-J1VQCdx%2F6fCpo-222&s=KOL2023&nf=P3470&i=68.97&cr=236', '[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
(3696, 1, 108, 2, 0, NULL, 0, '2023-08-28 20:30:51', '2023-08-29 09:23:28', '2023-08-28', 'P3471', '23-04917-08-28', '', 0.00, 280.92, 58.99, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 339.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280823-kNqKH6oSvGHp/-003', '060cd472-984a-4283-99d4-c09e6841332a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280823-kNqKH6oSvGHp%2F-003&s=KOL2023&nf=P3471&i=339.91&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3697, 1, 190, 3, 0, NULL, 0, '2023-08-29 10:31:45', '2023-08-29 10:31:45', '2023-08-29', '', 'consumo peluquería', '', 0.00, 138.42, 29.07, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 167.49, 0, '2023-08-29 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3698, 1, 720, 2, 0, NULL, 0, '2023-08-29 10:37:39', '2023-08-29 12:41:59', '2023-08-29', 'P3472', '23-04918-08-29', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Sipiri 18, 2D', 'Sopelana', 'Bizkaia', '48600', 'España', 30.61, 0, '2023-08-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-290823-jxikKblE24Xp0-009', '4d75b04b-4bad-41df-96a4-c0a5b1f2a8de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290823-jxikKblE24Xp0-009&s=KOL2023&nf=P3472&i=30.61&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3699, 1, 941, 2, 0, NULL, 0, '2023-08-29 11:03:30', '2023-08-29 13:03:50', '2023-08-29', 'P3473', '23-04919-08-29', 'Si no estuviera dejar al conserje ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Limonita n.7, 3C, 7, 3C', 'Madrid', 'Madrid', '28021', 'España', 17.50, 0, '2023-08-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290823-m9CEhV9DegIEj-099', '8e05b6eb-2c2c-4580-b470-5c37af79b6ff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290823-m9CEhV9DegIEj-099&s=KOL2023&nf=P3473&i=17.50&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3700, 1, 652, 2, 0, NULL, 0, '2023-08-29 20:14:07', '2023-08-30 08:05:51', '2023-08-29', 'P3474', '23-04920-08-29', 'Clínica Bastida', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Avda Hispanidad 96', 'Vigo', 'Pontevedra', '36210', 'España', 43.71, 0, '2023-08-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290823-FtSxTL0PMHthD-088', '99384b6a-e17d-4ebf-976b-2cb93f6e4878', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290823-FtSxTL0PMHthD-088&s=KOL2023&nf=P3474&i=43.71&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3701, 1, 942, 2, 0, NULL, 0, '2023-08-30 10:18:31', '2023-08-30 12:19:31', '2023-08-30', 'P3475', '23-04921-08-30', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'C/Cardona n3 pº 2-1', 'Barcelona', 'Barcelona', '08001', 'España', 41.50, 0, '2023-08-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300823-YHiUS5qH3z0oO-075', 'c46312b0-7289-4668-8492-eca103761717', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300823-YHiUS5qH3z0oO-075&s=KOL2023&nf=P3475&i=41.50&cr=011', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3702, 1, 712, 1, 1, 'precio incorrecto', 3581, '2023-08-30 13:03:09', '2023-08-30 13:03:09', '2023-08-30', 'R52', 'P3476 RECT.', '', 0.00, 16.28, 4.18, 0.00, 0, 1.04, 4.40, '', '', '', '', '', 25.14, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-300823-W1Qwt7eY/TwUU-175', 'c55504a0-4444-4a86-806c-37812a9bebec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300823-W1Qwt7eY%2FTwUU-175&s=KOL2023&nf=R52&i=-25.14&cr=234', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 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
(3703, 1, 566, 2, 0, NULL, 0, '2023-08-30 14:22:18', '2023-08-31 09:41:25', '2023-08-30', 'P3479', '23-04922-08-30', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 379.34, 0, '2023-08-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300823-aaoBb3Ndc4EvY-188', 'ffbadb0d-73dc-4e0c-9a00-d189867ec9ff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300823-aaoBb3Ndc4EvY-188&s=KOL2023&nf=P3479&i=379.34&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3704, 1, 909, 2, 0, NULL, 0, '2023-08-30 17:07:03', '2023-08-31 09:44:19', '2023-08-30', 'P3477', '23-04923-08-30', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Taller Tricapa Pol. La Ravaleta 2.15', 'Roquetes', 'Tarragona', '43520', 'España', 17.50, 0, '2023-08-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300823-StU4j9iTw4Gsa-093', '0df694b7-e8e0-4f66-90e8-b86c64afd4fa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300823-StU4j9iTw4Gsa-093&s=KOL2023&nf=P3477&i=17.50&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3705, 1, 40, 2, 0, NULL, 0, '2023-08-30 18:27:15', '2023-08-31 09:51:03', '2023-08-30', 'P3478', '23-04924-08-30', 'el lunes por la mañana cerrado y el martes todo el dia ,', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 123.15, 0, '2023-08-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300823-fqqisVjfIkf6j-022', '45dbd984-d1d5-40ec-be2b-0560da0b6e5d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300823-fqqisVjfIkf6j-022&s=KOL2023&nf=P3478&i=123.15&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3706, 1, 222, 2, 0, NULL, 0, '2023-08-30 20:25:40', '2023-08-31 09:53:54', '2023-08-30', 'P3480', '23-04925-08-30', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Cartagena 296 ', 'Barcelona', 'Barcelona', '08025', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300823-aacoiGsT7ZV9I-078', 'b6907aa6-418d-4102-b584-423fe52b388f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300823-aacoiGsT7ZV9I-078&s=KOL2023&nf=P3480&i=241.40&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3707, 1, 220, 2, 0, NULL, 0, '2023-08-31 08:41:27', '2023-08-31 10:43:45', '2023-08-31', 'P3481', '23-04926-08-31', 'Lunes tarde cerrado', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 310.37, 0, '2023-08-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310823-M6zpZUN2szx8I-106', 'cc9f6959-528a-4895-9bf6-2faf8232a704', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310823-M6zpZUN2szx8I-106&s=KOL2023&nf=P3481&i=310.37&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3708, 1, 152, 1, 0, NULL, 0, '2023-08-31 11:55:47', '2023-08-31 12:03:11', '2023-08-31', 'P3482', '2023-08-31', '', 0.00, 609.18, 127.93, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 737.11, 0, '2023-08-31 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-310823-jEhgzltL0qGL1-219', 'bb01526c-d91a-4557-aa4c-a467b88e3ecc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310823-jEhgzltL0qGL1-219&s=KOL2023&nf=P3482&i=737.11&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(3709, 1, 776, 2, 0, NULL, 0, '2023-08-31 11:56:20', '2023-09-01 09:03:50', '2023-08-31', 'P3483', '23-04927-08-31', 'NO DEJAR A NINGÚN VECINO SI NO ESTAMOS EN CASA.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle María Domínguez 3, 6°B (Nuevo Artica)', 'Berrioplano', 'Navarra', '31013', 'España', 17.50, 0, '2023-08-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310823-R0wqjQyTj/3os-211', '2a31dea7-5555-4200-a7c3-f48d50680dcd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310823-R0wqjQyTj%2F3os-211&s=KOL2023&nf=P3483&i=17.50&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3710, 1, 796, 2, 0, NULL, 0, '2023-08-31 13:59:52', '2023-09-01 09:10:19', '2023-08-31', 'P3484', '23-04928-08-31', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ Santa Llúcia 8, bajos', 'Canet de Mar', 'Barcelona', '08360', 'España', 30.61, 0, '2023-08-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310823-SMPsj+LZr9ogb-047', 'de1653b8-ed59-4cba-9e23-9f478a3cda19', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310823-SMPsj%2BLZr9ogb-047&s=KOL2023&nf=P3484&i=30.61&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3711, 1, 477, 2, 0, NULL, 0, '2023-08-31 17:30:19', '2023-09-01 09:12:31', '2023-08-31', 'P3485', '23-04930-08-31', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Pedro Elejalde 12, 4. ezk', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 56.82, 0, '2023-08-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310823-CrX96Un2uT2Oc-196', 'a406e66e-1f16-44e3-812e-a840e7b26c3a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310823-CrX96Un2uT2Oc-196&s=KOL2023&nf=P3485&i=56.82&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3712, 1, 248, 2, 0, NULL, 0, '2023-09-01 07:31:09', '2023-09-01 09:43:02', '2023-09-01', 'P3486', '23-04931-09-01', 'Cerrado miércoles', 0.00, 97.68, 20.51, 0.00, 0, 0.00, 0.00, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 118.19, 0, '2023-09-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010923-Wcr+9x/9r1Otd-218', '7bee60ba-c69a-4c1a-85f6-799ab1ebaee9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010923-Wcr%2B9x%2F9r1Otd-218&s=KOL2023&nf=P3486&i=118.19&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3713, 1, 67, 2, 0, NULL, 0, '2023-09-01 07:53:54', '2023-09-01 10:20:08', '2023-09-01', 'P3488', '23-04932-09-01', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010923-lAozvQUJQyUMp-211', '7f148674-adff-4683-8a1a-f7221cfb8b21', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010923-lAozvQUJQyUMp-211&s=KOL2023&nf=P3488&i=241.40&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3714, 1, 519, 1, 0, NULL, 0, '2023-09-01 10:17:23', '2023-09-01 11:09:31', '2023-09-01', 'P3487', '2023-09-01', '', 0.00, 118.04, 24.79, 0.00, 0, 0.00, 0.00, 'CALLE DE SAN AGUSTÍN \'EL VIEJO\' 25', 'TALAVERA DE LA REINA', 'TOLEDO', '45600', 'España', 142.83, 0, '2023-09-01 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010923-Szr15lsItFasE-071', 'e6371325-dca1-4871-a38f-ec585ae274d7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010923-Szr15lsItFasE-071&s=KOL2023&nf=P3487&i=132.97&cr=154', '[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
(3715, 1, 519, 1, 1, 'Problemas al añadir nuevo artículo', 3714, '2023-09-01 11:10:30', '2023-09-01 11:10:30', '2023-09-01', 'R53', 'P3487 RECT.', '', 0.00, 118.04, 24.79, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 142.83, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-010923-CCIgS0RDDjU6r-079', 'df5c6109-7164-402e-acc8-e45b86179528', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010923-CCIgS0RDDjU6r-079&s=KOL2023&nf=R53&i=-142.83&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3716, 1, 519, 1, 0, NULL, 0, '2023-09-01 11:12:43', '2023-09-01 11:13:42', '2023-09-01', 'P3489', '2023-09-01', '', 0.00, 118.04, 24.79, 0.00, 0, 0.00, 0.00, 'CALLE DE SAN AGUSTÍN \'EL VIEJO\' 25', 'TALAVERA DE LA REINA', 'TOLEDO', '45600', 'España', 142.83, 0, '2023-09-01 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010923-B1b/MooEdnzwQ-077', 'ee6eeffb-4859-4f9d-9a3f-0b6bd22187ee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010923-B1b%2FMooEdnzwQ-077&s=KOL2023&nf=P3489&i=142.83&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3717, 1, 632, 2, 0, NULL, 0, '2023-09-01 11:06:55', '2023-09-01 13:09:53', '2023-09-01', 'P3490', '23-04933-09-01', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'Urbieta 57, bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 147.79, 0, '2023-09-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-010923-mgyrpTA7yLBCh-187', '499abcd2-5851-4952-ba47-9132b21c92de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010923-mgyrpTA7yLBCh-187&s=KOL2023&nf=P3490&i=147.79&cr=009', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3718, 1, 944, 2, 0, NULL, 0, '2023-09-01 11:47:22', '2023-09-01 13:48:32', '2023-09-01', 'P3491', '23-04934-09-01', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Entença 91 BOCUS CLÍNICA DENTAL', 'Barcelona', 'Barcelona', '08015', 'España', 17.50, 0, '2023-09-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-010923-AhI44uxlhDL/N-163', '9958630f-2352-4b07-b175-9b2a1c6dfa97', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010923-AhI44uxlhDL%2FN-163&s=KOL2023&nf=P3491&i=17.50&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3719, 1, 945, 2, 0, NULL, 0, '2023-09-01 13:41:31', '2023-09-04 09:10:26', '2023-09-01', 'P3492', '23-04935-09-01', 'Llamen al 607302517 antes de entregar', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida de Niza, núm 2, torre 2, 7 , B', 'Alicante/Alacant', 'Alicante', '03540', 'España', 17.50, 0, '2023-09-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010923-dUK/r6r43nCNd-027', '82b652fb-4fd0-47fa-9bb1-c6a4db78a36b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010923-dUK%2Fr6r43nCNd-027&s=KOL2023&nf=P3492&i=17.50&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3720, 1, 946, 2, 0, NULL, 0, '2023-09-02 00:22:56', '2023-09-04 09:13:59', '2023-09-02', 'P3493', '23-04942-09-02', '', 0.00, 30.66, 7.86, 0.00, 0, 0.00, 8.19, 'Carretera Las caletas 27', 'Fuencaliente de la P', 'Santa Cruz de Teneri', '38740', 'España', 45.29, 0, '2023-09-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020923-QyvEa+6T+o7O4-211', '030e1bf0-a90e-4616-ad8a-7c18ebeee962', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020923-QyvEa%2B6T%2Bo7O4-211&s=KOL2023&nf=P3493&i=45.29&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
