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
(6149, 1, 1539, 2, 0, NULL, 0, '2024-11-22 12:20:06', '2024-11-25 08:20:54', '2024-11-25', 'P5778', '24-07556-11-22', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida Valencia, 86, B', 'Altura', 'Castellón', '12410', 'España', 17.50, 0, '2024-11-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-251124-UcTGIiA8Y2dyE-020', 'fe14ad18-725e-4024-98fd-92bbf83e12a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-UcTGIiA8Y2dyE-020&s=KOL2024&nf=P5778&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),
(6150, 1, 522, 2, 0, NULL, 0, '2024-11-22 14:41:54', '2024-11-25 08:24:51', '2024-11-25', 'P5779', '24-07557-11-22', 'Realizo hoy el pedido para que salga el lunes y así tenerlo en L’essence el martes , gracias ', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 275.88, 0, '2024-11-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251124-NkDJrKdAA0tzg-080', '73297324-bcff-4861-954a-562c723edc08', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-NkDJrKdAA0tzg-080&s=KOL2024&nf=P5779&i=275.88&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6151, 1, 248, 2, 0, NULL, 0, '2024-11-22 15:39:06', '2024-11-25 08:27:29', '2024-11-25', 'P5786', '24-07558-11-22', '', 0.00, 65.12, 14.11, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 81.30, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-251124-CWH7Lrvu/922J-234', 'abc7d7b9-0b89-4271-bcb0-17cc8a8e1b0f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-CWH7Lrvu%2F922J-234&s=KOL2024&nf=P5786&i=81.30&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6152, 1, 1540, 2, 0, NULL, 0, '2024-11-23 12:07:18', '2024-11-25 08:28:25', '2024-11-25', 'P5780', '24-07559-11-23', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida algorta 106 3b', 'Getxo', 'Bizkaia', '48991', 'España', 17.50, 0, '2024-11-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251124-fmT6fM/+ZFCxK-190', '8cc57c52-01e3-4a42-aad3-97a01d2014ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-fmT6fM%2F%2BZFCxK-190&s=KOL2024&nf=P5780&i=17.50&cr=075', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6153, 1, 91, 2, 0, NULL, 0, '2024-11-23 17:02:35', '2024-11-25 08:29:24', '2024-11-25', 'P5781', '24-07560-11-23', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 206.91, 0, '2024-11-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-251124-Pee1bJZotpJU7-022', 'b00903c5-91c0-4421-95a5-ca9a669a49da', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-Pee1bJZotpJU7-022&s=KOL2024&nf=P5781&i=206.91&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6154, 1, 1162, 2, 0, NULL, 0, '2024-11-24 11:36:13', '2024-11-26 09:19:59', '2024-11-26', 'P5795', '24-07566-11-24', '', 0.00, 86.64, 18.19, 0.00, 0, 0.00, 0.00, 'Calle del Pilar 27', 'Casinos', 'Valencia', '46171', 'España', 104.83, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-261124-Y73jNInqdq0Qn-035', 'e4d5b8ce-0192-4246-8c53-6e351891cc2f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261124-Y73jNInqdq0Qn-035&s=KOL2024&nf=P5795&i=104.83&cr=132', '[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
(6155, 1, 1137, 2, 0, NULL, 0, '2024-11-24 16:12:12', '2024-11-25 08:31:57', '2024-11-25', 'P5782', '24-07567-11-24', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'PUJADA DE CAL REI 34', 'Porqueres', 'Girona', '17834', 'España', 56.82, 0, '2024-11-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251124-arjoQZCLF6B+R-193', 'd6cd3157-62ac-40f8-a139-7c0543d34f31', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-arjoQZCLF6B%2BR-193&s=KOL2024&nf=P5782&i=56.82&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6156, 1, 1541, 2, 0, NULL, 0, '2024-11-24 18:53:50', '2024-11-25 08:34:09', '2024-11-25', 'P5783', '24-07568-11-24', 'Entregar a Cristina Moll en la recepción del tanatorio', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Carrer el Pla 168', 'Sant Feliu de Llobre', 'Barcelona', '08980', 'España', 43.71, 0, '2024-11-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251124-B0Hu8mhwdGL18-073', '693caa9a-0886-40a9-bfcb-196d40716e97', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-B0Hu8mhwdGL18-073&s=KOL2024&nf=P5783&i=43.71&cr=123', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6157, 1, 270, 2, 0, NULL, 0, '2024-11-24 19:56:59', '2024-11-25 08:34:58', '2024-11-25', 'P5784', '24-07569-11-24', 'Horario comercial', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Juan Bautista Zabala 9 (Comercio Gaurko)', 'Getxo', 'Bizkaia', '48991', 'España', 41.50, 0, '2024-11-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251124-Tb9UdywnIBe/J-021', '03f85ade-1343-4a43-9c10-626b2c451409', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-Tb9UdywnIBe%2FJ-021&s=KOL2024&nf=P5784&i=41.50&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6158, 1, 1542, 2, 0, NULL, 0, '2024-11-24 19:59:11', '2024-11-25 08:35:37', '2024-11-25', 'P5785', '24-07570-11-24', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida Felipe V 19 2A', 'Petrer', 'Alicante', '03610', 'España', 17.50, 0, '2024-11-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251124-UG2+nniSExw7g-168', '5296530e-c57f-4aaa-bb3a-168e6f41a0ff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-UG2%2BnniSExw7g-168&s=KOL2024&nf=P5785&i=17.50&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6159, 1, 76, 1, 0, NULL, 0, '2024-11-25 08:45:15', '2024-11-25 10:30:41', '2024-11-25', 'P5788', '', '', 0.00, 463.32, 97.30, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 560.62, 0, '2024-11-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-251124-BsSRaSZQXa+If-114', 'a85bc859-c1fc-424f-83e0-fa5734c112ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-BsSRaSZQXa%2BIf-114&s=KOL2024&nf=P5788&i=560.62&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6160, 1, 53, 1, 0, NULL, 0, '2024-11-25 09:01:48', '2024-11-25 09:09:47', '2024-11-25', 'P5787', '', '', 0.00, 187.28, 39.76, 0.00, 0, 0.00, 2.50, 'Entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 229.11, 0, '2024-11-25 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-251124-NJr6i0FD7jLTu-182', 'd175e388-682c-4a2a-8955-0d03a7a2ff06', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-NJr6i0FD7jLTu-182&s=KOL2024&nf=P5787&i=229.11&cr=045', '[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
(6161, 1, 152, 1, 0, NULL, 0, '2024-11-25 11:25:33', '2024-11-25 11:26:35', '2024-11-25', 'P5789', '', '', 0.00, 98.67, 20.72, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 119.39, 0, '2024-11-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-251124-AozrAhvRVk486-232', 'e2ca2862-4d91-4287-90cc-0f87d3c6b129', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-AozrAhvRVk486-232&s=KOL2024&nf=P5789&i=119.39&cr=138', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6162, 1, 1543, 2, 0, NULL, 0, '2024-11-25 13:51:41', '2024-11-25 16:01:18', '2024-11-25', 'P5790', '24-07571-11-25', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Guipuzcoa,51 bajo peluqueria Lorea', 'Zarautz', 'Gipuzkoa', '20800', 'España', 17.50, 0, '2024-11-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251124-IkBuAPXnDvELf-188', '96c6f299-47b1-4b11-8f1e-f28d4da6d980', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251124-IkBuAPXnDvELf-188&s=KOL2024&nf=P5790&i=17.50&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6163, 1, 166, 1, 0, NULL, 0, '2024-11-25 16:11:27', '2024-11-26 08:59:15', '2024-11-26', 'P5791', '', '', 0.00, 186.73, 39.21, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 225.94, 0, '2024-11-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-261124-QiR95GsuNFo8n-102', '4e094535-8cf4-4596-9952-0dedd8200d6e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261124-QiR95GsuNFo8n-102&s=KOL2024&nf=P5791&i=225.94&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6164, 1, 4, 2, 0, NULL, 0, '2024-11-25 17:00:42', '2024-11-26 09:03:43', '2024-11-26', 'P5792', '24-07572-11-25', '', 0.00, 179.14, 37.62, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 216.76, 0, '2024-11-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261124-D6BsG8vx21SMm-052', 'f97d55c4-96f1-4335-94ad-8f7a0f4555d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261124-D6BsG8vx21SMm-052&s=KOL2024&nf=P5792&i=216.76&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6165, 1, 1026, 2, 0, NULL, 0, '2024-11-25 20:20:03', '2024-11-26 09:04:44', '2024-11-26', 'P5793', '24-07573-11-25', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'paseo maria agustin  15-17-19 6ºD', 'Zaragoza', 'Zaragoza', '50004', 'España', 43.71, 0, '2024-11-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261124-bflICUqJIlyvp-035', 'ca743eba-ae24-4863-8fbc-94fa1d24f20e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261124-bflICUqJIlyvp-035&s=KOL2024&nf=P5793&i=43.71&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6166, 1, 160, 2, 0, NULL, 0, '2024-11-26 08:06:00', '2024-11-26 09:07:19', '2024-11-26', 'P5794', '24-07574-11-26', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 68.97, 0, '2024-11-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261124-dIF0AS7JNaO7H-008', '880310d8-1421-4970-b677-051ce870a883', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261124-dIF0AS7JNaO7H-008&s=KOL2024&nf=P5794&i=68.97&cr=042', '[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
(6167, 1, 149, 2, 0, NULL, 0, '2024-11-26 09:00:30', '2024-11-26 10:04:20', '2024-11-26', 'P5796', '24-07575-11-26', '', 0.00, 52.92, 11.55, 0.00, 0, 0.00, 2.50, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 66.53, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-261124-DTXpCRSxK4xVW-051', '199dc773-4791-4e16-98ca-53e3bb5ef106', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261124-DTXpCRSxK4xVW-051&s=KOL2024&nf=P5796&i=66.53&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6168, 1, 676, 2, 0, NULL, 0, '2024-11-26 09:07:08', '2024-11-26 10:08:40', '2024-11-26', 'P5797', '24-07576-11-26', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'calle Monjardín 11 1ºA', 'Pamplona/Iruña', 'Navarra', '31006', 'España', 17.50, 0, '2024-11-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261124-XQwSXUWjJ89s9-183', '0fc2a441-8633-451e-9fcc-a8ef88af82b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261124-XQwSXUWjJ89s9-183&s=KOL2024&nf=P5797&i=17.50&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6169, 1, 190, 3, 0, NULL, 0, '2024-11-26 11:18:14', '2024-11-26 11:18:14', '2024-11-26', '', 'Consumo interno', '', 0.00, 570.00, 119.70, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 689.70, 0, '2024-11-26 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),
(6170, 1, 273, 2, 0, NULL, 0, '2024-11-26 11:44:39', '2024-11-26 12:48:05', '2024-11-26', 'P5798', '24-07577-11-26', 'Horario entrega: lunes a viernes de 8:30h a 16:00h', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avda. Eduard Maristany, 46-48', 'Sant Adrià de Besòs', 'Barcelona', '08930', 'España', 61.09, 0, '2024-11-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-261124-WyjtnfJp+H9pz-092', '1b85817d-052f-4b4c-abeb-ce0dbeed3cd4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261124-WyjtnfJp%2BH9pz-092&s=KOL2024&nf=P5798&i=61.09&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6171, 1, 1430, 1, 0, NULL, 0, '2024-11-26 13:44:12', '2024-11-26 13:44:23', '2024-11-26', 'P5799', '2024-11-26', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'Carrer Rei en Jaume 90, bajo', 'Vila-real', 'Castellón', '12540', 'España', 147.79, 0, '2024-11-26 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-261124-Jz1M2Lv2ooS9q-198', '531d9de5-073c-4060-a170-2ce4c65cb8d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261124-Jz1M2Lv2ooS9q-198&s=KOL2024&nf=P5799&i=147.79&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6172, 1, 1544, 2, 0, NULL, 0, '2024-11-26 17:39:59', '2024-11-27 09:32:48', '2024-11-27', 'P5800', '24-07578-11-26', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Espoz y mina n11 2b', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 17.50, 0, '2024-11-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271124-SZQKlOcP2l4Z+-089', 'ffa42b73-c9a5-4c91-a060-b935e313b23b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271124-SZQKlOcP2l4Z%2B-089&s=KOL2024&nf=P5800&i=17.50&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6173, 1, 293, 2, 0, NULL, 0, '2024-11-27 17:54:05', '2024-11-28 09:03:37', '2024-11-28', 'P5801', '24-07581-11-27', 'Llamen al Movil antes de llegar 606512178', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle Padre Francisco Palau Y Quer 3,6A', 'Madrid', 'Madrid', '28046', 'España', 43.71, 0, '2024-11-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281124-DZFj2GGV+i85v-195', '17c8d44b-016c-4e7f-8557-2a69a4be10ad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281124-DZFj2GGV%2Bi85v-195&s=KOL2024&nf=P5801&i=43.71&cr=008', '[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
(6174, 1, 1545, 2, 0, NULL, 0, '2024-11-28 07:31:44', '2024-11-28 09:29:18', '2024-11-28', 'P5802', '24-07582-11-28', 'EMPRESA LANIK', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'camino mundaiz 8 - 1º', 'Donostia-San Sebasti', 'Gipuzkoa', '20012', 'España', 17.50, 0, '2024-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281124-KXRjh69TRkXbK-178', '4d905955-f30a-4443-9cea-ce1eb1862145', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281124-KXRjh69TRkXbK-178&s=KOL2024&nf=P5802&i=17.50&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6175, 1, 337, 2, 0, NULL, 0, '2024-11-28 07:50:55', '2024-11-28 09:30:06', '2024-11-28', 'P5803', '24-07583-11-28', '', 0.00, 97.68, 20.51, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 118.19, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-281124-dlrR8pwY1+6Ni-133', '65cfbf2b-90ee-413e-8299-1d6c8244f762', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281124-dlrR8pwY1%2B6Ni-133&s=KOL2024&nf=P5803&i=118.19&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6176, 1, 65, 2, 0, NULL, 0, '2024-11-28 11:18:58', '2024-11-28 12:27:12', '2024-11-28', 'P5804', '24-07584-11-28', '', 0.00, 256.50, 53.86, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 310.36, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-281124-S82a3Hxnxb5do-101', '4906b4be-c31b-4f17-818f-63d5ab1317f3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281124-S82a3Hxnxb5do-101&s=KOL2024&nf=P5804&i=310.36&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6177, 1, 40, 2, 0, NULL, 0, '2024-11-28 12:18:29', '2024-11-28 13:20:39', '2024-11-28', 'P5805', '24-07588-11-28', '', 0.00, 44.78, 10.17, 0.00, 0, 0.00, 4.40, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 58.58, 0, '2024-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281124-XJEVugrjsVKBf-075', 'c7167569-f207-4662-872a-962daf96078a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281124-XJEVugrjsVKBf-075&s=KOL2024&nf=P5805&i=58.58&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6178, 1, 1263, 2, 0, NULL, 0, '2024-11-28 17:18:15', '2024-11-29 07:45:23', '2024-11-29', 'P5806', '24-07589-11-28', 'Pueden dejar el paquete en la entrada de la casa sin problema', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'sagardia 41', 'Urdiain', 'Navarra', '31810', 'España', 41.50, 0, '2024-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291124-enVgJKVH9RUtV-241', '1af5ae5f-a71d-4e95-af55-6bed695a5bf1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291124-enVgJKVH9RUtV-241&s=KOL2024&nf=P5806&i=41.50&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6179, 1, 1547, 2, 0, NULL, 0, '2024-11-28 18:31:12', '2024-11-29 07:46:35', '2024-11-29', 'P5807', '24-07590-11-28', '', 0.00, 10.83, 3.79, 0.00, 0, 0.00, 8.76, 'La laguna 96. Bajos.Carretera a Tazacorte', 'Llanos de Aridane (L', 'Santa Cruz de Teneri', '38760', 'España', 21.86, 0, '2024-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291124-aKzmQ3riQAAJl-233', '6f545029-f688-4746-80fe-3e51cce996e3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291124-aKzmQ3riQAAJl-233&s=KOL2024&nf=P5807&i=21.86&cr=190', '[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
(6180, 1, 1548, 2, 0, NULL, 0, '2024-11-28 22:49:57', '2024-11-29 07:47:21', '2024-11-29', 'P5808', '24-07591-11-28', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Jovellanos 10 Bajo', 'Gijón', 'Asturias', '33206', 'España', 28.39, 0, '2024-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291124-Zf99jwII9JtX7-063', '715a640b-fd0f-49eb-a31d-2d0b64e0d359', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291124-Zf99jwII9JtX7-063&s=KOL2024&nf=P5808&i=28.39&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6181, 1, 1549, 2, 0, NULL, 0, '2024-11-29 10:32:17', '2024-11-29 11:42:20', '2024-11-29', 'P5809', '24-07593-11-29', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/ Almirante Carranza  Edificio Bienvenido N°15  1C ', 'Nerja', 'Málaga', '29780', 'España', 43.71, 0, '2024-11-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291124-HCluhujNfNMKq-133', '3c19c864-d254-483d-9c41-51590f552a55', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291124-HCluhujNfNMKq-133&s=KOL2024&nf=P5809&i=43.71&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6182, 1, 1471, 2, 0, NULL, 0, '2024-11-29 16:33:41', '2024-12-02 08:12:56', '2024-12-02', 'P5810', '24-07594-11-29', 'lunes a viernes 09:30 a 18:00', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Mercedes Formica 10 local 5', 'Málaga', 'Málaga', '29140', 'España', 17.50, 0, '2024-11-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021224-FzFva+M/IKMfm-050', '5792b692-027a-4237-8bb4-a78864a099fb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-FzFva%2BM%2FIKMfm-050&s=KOL2024&nf=P5810&i=17.50&cr=184', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6183, 1, 1330, 2, 0, NULL, 0, '2024-11-29 19:40:13', '2024-12-02 08:13:46', '2024-12-02', 'P5811', '24-07597-11-29', 'Llamar antes de enviar', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'República Argentina 37 7b', 'Sevilla', 'Sevilla', '41011', 'España', 30.61, 0, '2024-11-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-021224-QJuAJzfosALOl-047', 'a8f3b411-099a-4e65-9ee6-56a8f15223d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-QJuAJzfosALOl-047&s=KOL2024&nf=P5811&i=30.61&cr=010', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6184, 1, 1550, 2, 0, NULL, 0, '2024-11-29 22:05:42', '2024-12-02 08:15:39', '2024-12-02', 'P5812', '24-07598-11-29', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer de les moreres, nº 12', 'Montornès del Vallès', 'Barcelona', '98170', 'España', 30.61, 0, '2024-11-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021224-QJUSIWF1XcBpt-117', 'af80ec4d-d0a5-40df-b6c7-6a577b547101', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-QJUSIWF1XcBpt-117&s=KOL2024&nf=P5812&i=30.61&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6185, 1, 248, 2, 0, NULL, 0, '2024-11-30 10:31:17', '2024-12-02 08:16:42', '2024-12-02', 'P5817', '24-07599-11-30', '', 0.00, 48.84, 10.69, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 61.60, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-021224-XC+yhNH2dKIA3-027', 'bdd89217-2183-47f9-a941-1dcb9687ede6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-XC%2ByhNH2dKIA3-027&s=KOL2024&nf=P5817&i=61.60&cr=026', '[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
(6186, 1, 510, 2, 0, NULL, 0, '2024-11-30 12:42:54', '2024-12-02 08:17:50', '2024-12-02', 'P5813', '24-07600-11-30', 'Si puede ser llamar antes para saber día y hora en que vais a pasar. Gracias', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Castillejos 343 6º 4ª', 'Barcelona', 'Barcelona', '08025', 'España', 71.98, 0, '2024-11-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021224-CbKlRxFUgLudb-003', '06838270-41d5-4aba-8d92-ad76f0d50923', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-CbKlRxFUgLudb-003&s=KOL2024&nf=P5813&i=71.98&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6187, 1, 1328, 2, 0, NULL, 0, '2024-11-30 18:56:15', '2024-12-02 08:18:32', '2024-12-02', 'P5814', '24-07601-11-30', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'CALLE ANTONIO BUERO VALLEJO 39', 'Alcalá de Henares', 'Madrid', '28806', 'España', 52.39, 0, '2024-11-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021224-DGGZVha0maOdy-072', 'd2261a97-483d-4640-b786-d157b16fa8c8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-DGGZVha0maOdy-072&s=KOL2024&nf=P5814&i=52.39&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6188, 1, 1503, 2, 0, NULL, 0, '2024-11-30 21:06:24', '2024-12-02 08:18:56', '2024-12-02', 'P5815', '24-07602-11-30', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/Alejandro de la Sota nº2 portal 4 Bajo B', 'Boadilla del Monte', 'Madrid', '28660', 'España', 28.39, 0, '2024-11-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021224-Wj9R/HXIZKd8g-233', 'dac834ca-5ff1-4796-b60b-c8b7c158c95e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-Wj9R%2FHXIZKd8g-233&s=KOL2024&nf=P5815&i=28.39&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6189, 1, 1373, 2, 0, NULL, 0, '2024-11-30 22:03:59', '2024-12-02 08:19:33', '2024-12-02', 'P5816', '24-07603-11-30', 'Llamar antes de entregar. ', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Almike bidea 5, 3izda', 'Bermeo', 'Bizkaia', '48370', 'España', 52.39, 0, '2024-11-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021224-KB2ka2OMlA0AJ-091', '3afcee2d-ebf6-47e9-8f85-5636c5a5dc3c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-KB2ka2OMlA0AJ-091&s=KOL2024&nf=P5816&i=52.39&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6190, 1, 152, 1, 0, NULL, 0, '2024-12-02 08:48:56', '2024-12-02 11:00:59', '2024-12-02', 'P5820', '', '', 0.00, 300.34, 63.07, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 363.41, 0, '2024-12-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-021224-EbDxHITnkW6wL-031', '45a1701c-0b1b-4ef4-82a4-9a220af4cadf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-EbDxHITnkW6wL-031&s=KOL2024&nf=P5820&i=363.41&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6191, 1, 166, 1, 0, NULL, 0, '2024-12-02 10:25:39', '2024-12-02 10:25:39', '2024-12-02', 'P5818', '', '', 0.00, 137.28, 28.83, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 166.11, 0, '2024-12-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-021224-EWBtY0Tydixg8-150', '914caf8b-2ac2-4974-ad45-61c6fe4f4f46', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-EWBtY0Tydixg8-150&s=KOL2024&nf=P5818&i=166.11&cr=159', '[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
(6192, 1, 1551, 2, 0, NULL, 0, '2024-12-02 09:48:23', '2024-12-02 10:56:13', '2024-12-02', 'P5819', '24-07605-12-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle azabache 26', 'Pozuelo de Alarcón', 'Madrid', '28224', 'España', 28.39, 0, '2024-12-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-021224-S0fv2SWatsTy8-093', 'd4a8d0fb-5210-46bf-bf8f-0df1ccd286e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-S0fv2SWatsTy8-093&s=KOL2024&nf=P5819&i=28.39&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6193, 1, 78, 2, 0, NULL, 0, '2024-12-02 11:29:24', '2024-12-02 12:34:29', '2024-12-02', 'P5821', '24-07606-12-02', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'AVD. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 482.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-021224-PKC3dcSbaFBvs-048', 'cae3f9ab-d3bb-4c45-af1f-43b410ed7057', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021224-PKC3dcSbaFBvs-048&s=KOL2024&nf=P5821&i=482.79&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6194, 1, 754, 2, 0, NULL, 0, '2024-12-02 17:27:27', '2024-12-03 08:32:10', '2024-12-03', 'P5822', '24-07607-12-02', '6+1 REGALO NEUTRAL\r\nGRACIAS', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-12-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031224-D/ZwL16T3aqJF-234', '30be706d-aa42-4238-b497-639d5d0346d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031224-D%2FZwL16T3aqJF-234&s=KOL2024&nf=P5822&i=61.64&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6195, 1, 1552, 2, 0, NULL, 0, '2024-12-02 20:59:02', '2024-12-03 08:32:45', '2024-12-03', 'P5823', '24-07608-12-02', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/San Lázaro, N 2 1drch', 'Madrid', 'Madrid', '28048', 'España', 43.71, 0, '2024-12-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031224-eGU75BMtKIj2m-160', '118bb46b-aaec-4de4-a732-adf1da257e88', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031224-eGU75BMtKIj2m-160&s=KOL2024&nf=P5823&i=43.71&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6196, 1, 25, 2, 0, NULL, 0, '2024-12-03 08:43:27', '2024-12-03 09:49:43', '2024-12-03', 'P5824', '24-07609-12-03', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'araba kalea 1 bajo 20240 ordizia ', 'Ordizia', 'Gipuzkoa', '20240', 'España', 68.97, 0, '2024-12-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031224-Ztq8vy6Q9qe+g-194', '9ab091c4-52ab-4667-a05d-72e6cf80e427', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031224-Ztq8vy6Q9qe%2Bg-194&s=KOL2024&nf=P5824&i=68.97&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6197, 1, 120, 2, 0, NULL, 0, '2024-12-03 08:49:49', '2024-12-03 09:53:30', '2024-12-03', 'P5825', '24-07610-12-03', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 68.97, 0, '2024-12-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031224-HNCp06Tipa0NS-028', 'd3db7877-89d9-4776-a0a9-fbcdbf17b9a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031224-HNCp06Tipa0NS-028&s=KOL2024&nf=P5825&i=68.97&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6198, 1, 204, 2, 0, NULL, 0, '2024-12-03 10:30:46', '2024-12-03 11:42:53', '2024-12-03', 'P5826', '24-07611-12-03', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'nou 23 local 1', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 103.46, 0, '2024-12-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031224-Jd2f1g+BY3SQL-145', '4f419028-7df4-4f82-ad9b-7c42ea2a179c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031224-Jd2f1g%2BBY3SQL-145&s=KOL2024&nf=P5826&i=103.46&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6199, 1, 1553, 2, 0, NULL, 0, '2024-12-03 10:51:50', '2024-12-03 12:13:59', '2024-12-03', 'P5827', '24-07612-12-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Levante, 8 Gea y Truyols', 'Murcia', 'Murcia', '30590', 'España', 17.50, 0, '2024-12-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031224-Wkh3jEkVrsUfP-075', 'd6fdb123-6dd1-4ab6-b14e-cb8561f455c9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031224-Wkh3jEkVrsUfP-075&s=KOL2024&nf=P5827&i=17.50&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6200, 1, 77, 1, 0, NULL, 0, '2024-12-03 11:57:17', '2024-12-03 11:58:06', '2024-12-03', 'P5828', '', '', 0.00, 519.09, 109.01, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 628.10, 0, '2024-12-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-031224-JcvqmGgJ+9csU-215', 'cec356ce-17de-4216-b582-63310f4e0a5c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031224-JcvqmGgJ%2B9csU-215&s=KOL2024&nf=P5828&i=628.10&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(6201, 1, 77, 1, 1, 'fallo en lotes', 6200, '2024-12-03 12:18:21', '2025-02-21 10:25:07', '2024-12-03', 'R94', 'P5828 RECT.', '', 0.00, 519.09, 109.01, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 628.10, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6202, 1, 1020, 1, 0, NULL, 0, '2024-12-03 12:26:40', '2024-12-03 12:26:40', '2024-12-03', 'P5829', '2024-12-03', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Pescadería 14', 'Donostia', 'Gipuzkoa', '20003', 'España', 103.46, 0, '2024-12-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-031224-YgVkQ/osdobOj-077', 'f71cfd48-1026-4f2d-b848-b63d316c9452', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031224-YgVkQ%2FosdobOj-077&s=KOL2024&nf=P5829&i=103.46&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6203, 1, 77, 1, 0, NULL, 0, '2024-12-03 12:29:59', '2024-12-03 12:29:59', '2024-12-03', 'P5830', '', '', 0.00, 519.09, 109.01, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 628.10, 0, '2024-12-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-031224-ER+akQ5Z0mlVE-191', '45152901-64e2-4420-a184-32ddfb16cb32', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031224-ER%2BakQ5Z0mlVE-191&s=KOL2024&nf=P5830&i=628.10&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(6204, 1, 98, 2, 0, NULL, 0, '2024-12-03 13:51:56', '2024-12-04 08:17:01', '2024-12-04', 'P5831', '24-07613-12-03', '', 0.00, 69.20, 14.53, 0.00, 0, 0.00, 0.00, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 83.73, 0, '2024-12-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041224-PTGR6RaF7w5Jw-197', '4bccd168-51d1-4758-bbb5-668b9ac6550c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041224-PTGR6RaF7w5Jw-197&s=KOL2024&nf=P5831&i=83.73&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
