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
(6573, 1, 166, 1, 0, NULL, 0, '2025-01-24 17:57:52', '2025-01-27 09:58:42', '2025-01-24', 'P6174', '', '<p>Enviar 10 de castaño pero cobrar solo 4, ya que debemos 6 del pedido anterior</p>', 0.00, 68.64, 14.41, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 83.05, 0, '2025-01-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240125-IULhFT+fWnPDy-207', 'dd1425b5-6570-4b94-8af8-64042b0d5742', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-IULhFT%2BfWnPDy-207&s=KOL2025&nf=P6174&i=83.05&cr=204', '[BLOB]', 0, 'PKANHY071000272J', '2025-01-27 09:58:47', '[BLOB]', 2, '', '2025-01-27', 'S0235', 20, 30, 35, 2200, 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
(6574, 1, 442, 2, 0, NULL, 0, '2025-01-24 17:05:42', '2025-01-27 09:56:42', '2025-01-27', 'P6175', '25-08023-01-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Travesía del Tornado 7, piso 4N', 'Tres Cantos', 'Madrid', '28760', 'España', 30.61, 0, '2025-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-dZuwsRUtF0V+n-071', '3274001f-069f-4789-ad88-862d11a9730d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-dZuwsRUtF0V%2Bn-071&s=KOL2025&nf=P6175&i=30.61&cr=098', '[BLOB]', 0, 'PKANHY071000271N', '2025-01-27 09:56:48', '[BLOB]', 2, '', '2025-01-27', 'S0235', 20, 5, 10, 200, 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
(6575, 1, 1640, 2, 0, NULL, 0, '2025-01-24 18:59:22', '2025-01-27 10:00:16', '2025-01-27', 'P6176', '25-08024-01-24', 'llamar antes de entregar al 634419053', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Cardenal Cisneros 23 bajo 2', 'Gandia', 'Valencia', '46701', 'España', 65.52, 0, '2025-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-EC3zeBRD1mf/X-154', '92430d1d-dd8c-4b5b-a3e7-3af4cd49c314', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-EC3zeBRD1mf%2FX-154&s=KOL2025&nf=P6176&i=65.52&cr=214', '[BLOB]', 0, 'PRANHY071000005Z', '2025-01-27 10:00:23', '[BLOB]', 2, '', '2025-01-27', 'S0133', 20, 5, 10, 500, 0, '', 1, 1);
