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
(2949, 1, 629, 2, 0, NULL, 0, '2023-03-25 06:58:07', '2023-03-27 09:33:13', '2023-03-25', 'P2777', '23-03987-03-25', '', 0.00, 9.83, 2.06, 0.00, 0, 0.00, 4.40, 'Calle tierruca, 6,B°A', 'Madrid', 'Madrid', '28018', 'España', 16.29, 0, '2023-03-25 00:00:00', '', '', 3, 5, 1, '', '', '', '', 0, '3230006101305785', '0000-00-00 00:00:00', 'SlZCRVJpMHhMalFLSmVMano5TUtOQ0F3SUc5aWFnbzhQQzlVZVhCbEwxaFBZbXBsWTNRdlUzVmlkSGx3WlM5SmJXRm5aUzlYYVdSMGFDQXhPRGN2U0dWcFoyaDBJRFk1TDB4bGJtZDBhQ0F6TURVeUwwTnZiRzl5VTNCaFkyVXZSR1YyYVdObFVrZENMMDFoYzJzZ1d6QWdNQ0F3SURBZ01DQXdYUzlFWldOdlpHVlFZWEp0Y3p3OEwwSnBkSE5RWlhKRGIyMXdiMjVsYm5RZ09DOVFjbVZrYVdOMGIzSWdNVFV2UTI5c2RXMXVjeUF4T0RjdlEyOXNiM0p6SURNK1BpOUNhWFJ6VUdWeVEyOXRjRzl1Wlc1MElEZ3ZSbWxzZEdWeUwwWnNZWFJsUkdWamIyUmxQajV6ZEhKbFlXMEtlTnJ0WFFXVDZ6Z016akVNSERNek16TXpQbVptWEdabVptWm1acVpqL0UrblR0OStrNjFkYlJwbjIyNHYzL2pCeGs2YXJyL0lraXdwbWduMERjN2xsM1I0MnRxNkpuc0habnNINXpRYi96ZkVwOVpxejE5UWI5L3ZUYW1zN2Rkc0JEeHFHZ1lWdVNJMkJ3dHRCQ3FXVnY2MmxpNW9iMzRWUFRpeXFOa0lQT2luK2NqWlhGSlFqTFRPM3VtRXRMb2o1L0o0M2p6d2R1alE2SkptSTVDUW1kZUNDWDcxOHlqVHNxcW92TXNkYno3YmxxRFpDRlF4YytoMGpxYUc1TXdHS1c4Y2xMSVJHS2h0SEhKUlFUUmwxRFVQUzAwcXpVWmc0UGlGZkpmWlBYdzJkM3J1TjJWNTB5aVJOellDQTZUMmVtUU5QZlplR0JuU1hYMHoybm9nb2VWeWJ2L3dncmFSY0RpSFhwRGNjMGxGdDJiRFFrQjd0ZHdORTVmaTZpb2tnMHZiQUpCY1hQZFdIVjRvR3haaTI4RTAwN3g1NjZ2b2tmRmxUWWIyN2ttWHdWajFyTUw0MUU5cm5BVm5jdXViUjV6dWdNVDBlaHkvbk1TUGpZMVFodytleWpiSG0zZStpZEZrR0J4ZDNGQ2RCcGM5ZGo1ZjJrOXNwaVd5dExKSHMrRmxZQUtTc3hyZDhTWk90azdOTC8xbHJWMEdoTWRYT3E5NU1xaFFzK0gvSUJjd2VNQVRvbmRnenNYUmJMRlhTUUcwZnBWVzk5VTFqd3g0cUpzUGp5MDF0bzV5VHM2Zi91N3BuKzBkV3BBdXBrM3Q0d1hsM1FaMXU5bUYzN3Y3WmpMeTI3cjdaK2ovQnI3VVhHWDlZSGxOUDY3dnB4NWtOS2t0b3gvUTJqbWhxV0ZtL3BMQ0c1VlFwWGtDVENjTU9uM2JkVFJUT2w2djdCZVdkV0s4Ty9yaTR2SDBYT21RVjl3aGZ1Z1ArOXg2clVvcWU2VGl2TFJLdnM2ZXVGQWdIVi90YjdvL2Vlb2twT0cvakJySWJJYmRia0t1OEdvWnc1aXhTZWphY3NhQUxtQU03ODZBQVdIRS9jR0w2ZzkvaUdQR1gvcm1YbXZyQzV0OFFkZ0l1UDdsSVBRR1JaVnFDb2hMcVRITlBOeERVOXZZMnVDaE9xeXQwbFBPaFJWVFYyUkMxUXlNUHVHYXhSWGROS2FsWTl5bHY3NWxCRE10OWIrVHRCWWVDZm5OZ0pFbGxkMDZMOE92em9NcHBHaXVSWHBPMDluUVl0eWx0MXRxZHBNSHp5NmcvMVpvQ25qd25UQnpGd21PS3J1ME1tSlNkUWlMclhEMmtnb2lFSUx6S3ZGTERBYmMrRW9RYzB1OGxzYjN3cHVnTWZBRlk3QmhsR3lFTkZ2MnA3b01PSGc2QjcwLzdrdnhnZHFMRTlrQlgrNU0waDhERzh4ZGRuSDVrc0ZZWHRQSG5LNjNTWjFIS3R3RU9wWlY5VG9IakU2c0lMclNmeG5Ecnl5azFlckhWQWkvSTB2RXpJYy94cXN3SmpLKzBxTzVoeDVqampGUS9LZG1mNVVPZ0FEanA1KzVwYjZoZWVlUmo3ZkVMeXo5dVQ1anN2SmJMTmRkRUV1VmxORndGTEZVQnN6cG1PUWFoaGJFTTNTRlJKZXBCaXg3QWxLVG5XZWw1Ylo0alRIR3c2dlRWKy9xclc5aURETG0wMjBKN3JiejN2NDZocFFxMVlkVkhhRXg1Ynh4SWQ1OVVHUXB3M1hGZ09XT25pa1RWbEpKdGZ1dzl1ZDh4aGk0UVBtcmlXTjRaOGVQMEExOEdGRncrRXdPVDVyRmxiK1kzbzkwZG1ELzBMeXBJTUMvWUhxWTJJZEt6R2p3aVl5QnVzM2poMzJwQmhteisxaW1WRzBpNmZMNkYxRzRxNjkzSmZtTU1VQkJhU2UvUE8wOGtvRmVoMlRTZ1N3UmRPMDVsdWsxNVJkbm5RMHA4aVpqcXVzdlNVVGFhUFBJTDBxZVJqN0NuN1FSZzVFbnZtY01KaDZOY3VHTXJUNnFOdzhQRU1TTTViYlNudU5aRmpJR3RoSWNlanhtVmtNNDBuTGt2b3lrMVVoWkdtbHdqaWFtZi9HZXJmVGlKeEVrVWZocGs2OCtQOGFqQ3prR0VqWE5MSXpzVmUwOWtWVlZQNEFmNmFGY2ZUcGJ4Y0c3ajJZNmV5ZG5mbEZralBFQi9IakZxNUV2VVpBeFhtekh6K2Z6U201RWZLVkFjUG1rMGtLTHJycW1ZYzBVeUZoZGMzc1g4a20zcFErbHYwazEvbTVQc3ZQNEZTL0luV094eVRYU1pYVGZDUWdZeXhqVDBES0s1ZHV4cHVoQTdOeHlJSldPaTl1MzRrNUkzK0E4anRQL2NaeVN4WndlWitmRnNWMkt3VDd6eHp6elViZ0dLS3crc3d0LzBCRjQzM0ZjalRUeVJnR0J4bDFabURsempGRUprMlhrdDlnY3ZUcWNEaTVpQmxmWEQvaUFNY3p2OUwzdll0RTdNZjJ6R1RLcEliZW9UWHFyVVluVm1odVF6UytPenk3QVVtVWxZd0NxZVhEYmE4RVNBM2hmcXVNUkFuVDdLdUllT3gyaDR3WnQrRnRlRFlJMWFnYWsvdUJhbDBGV3l6Wjk3bnc5V0I4eWNpRzhoQ0Y0VisrTTZBaUdOODhFbVZUUUMxbHREQ01USzNPTGZ4Z2M3TVA3N0J0YVVMcTR1blVEMVE4TTVTVXpyK1M2NjJyVGJSbzB0NDh6cDlqd1J5U2sxNHQ2ay9INW8zaGVqSUZnNUU4ZkdGa1VmSnFiaWpGMi9SZ1ZyWUlDU2pDR3RrOE5udTR1WWVXdXQwSURtVEUyWTdBdmcrbFhaTXlXUTVrQnpoaWJNWTVZYU1pWWFsVVpjL3NiSWY3T0dCdUphL1NZT1U4Wjg5YlgwUjdyTWNNTG0xaVBzZEV6SUxHVmtFMnk0YlpTaDIwcmJSN0FJVzF3MXE5NjhXSzNMdGIxWkZBQjQ0L3A2SmxHRjBXdHJ2WEhWS05yY3ZvWFh6TEdocnIzbHNtTzRYMitqTlZOcExUZTU4dXI0WHl6WVNGakRwL040elBXMElSQ2FPcjdTcjhMKzBwK3pCaWJNV2hpRkhGWDc3Uzd3YWREaXRpOWEremp3TVU4WTJqdnVubllIR09RazBCV21MdW0yYkNXTWJlL0h1eHVQckRYU3ZGL2lESG1aUkt6UXpreXZyTEc3RktPandGanpHUVgyNHhST2RlUmZXa0s3ZDFUZktsRWRTWEc5NHl4R1FOZm5HS1JqdHlpZGo1emVNdUJOSGVSVnQyNjFlckFxV3l2TVdieHAzK3A4YjNVbUNPdEhSUE94YTZqZThyNHAxQmxCbmZyWTFQYnFQT0N0VTNENjFiam9tZlNPYmlGOW5SbFFIUVZiU0RTTUVvYm9zZ3N5eDdUNktRYWx4WEsrTHNxS0p6YjVWd3hzcFhwZlYrM1d0RldwZGNZZ3c5bDBsbW8yS3hzdkZ6UnppM3VjUGNwVDM0UzdiaXN2cXpwV2xEQ3FIakJBeWZsejgrTnJ3WUpnNUdjSUdpSFFxTndSRlhHaUZGaEVEYVVYY2ZuTFh1Y3J4U2xrSzlrS1dNUTA3OFhnZDhBSktYc1B2SC9kNzZOM1g0NFEzLy9JVEhsN2hqRGZOUG5QNDdBY2Nydi9IcDNNbjc4Zkh1aWNZVTFOYnNSb3lqNGxSbnBpT1owL2c4Sk9GVEV4dE9XV2RER1Y5Yk1LK21nYWp3VTlVaWhyOFpqSEtuNmdYNk13TGxTSVN0RmlURzFqWU9hWVZDQ0R3SVpjZkNENytONFpXdnJnYlNGNWI5YzhqK2VvMWxIcEppTU1ZZk81RVRLZ2dEM25jaGVGVkh0VXE4NmhlcmhZRVI4RlZLc3hlelNrYkZsRGNDTUNJR3RrREYrbDNjdGFraUk0emNoWU5UOU1kSzROZlM2U1BMbXRqRitwQWdJQ2ZIZ2xTOWViR2daWWM0S2x2MzJ5Rk1BVWFjZmZQY2J3ZHA2QU52OE1WT2Z2cGlSV2R4eE9GMmEzb0hnVnA4d1puaHNHWS9qK05UUHp2OGZPNWRuSW5vWFBnTGpaOUdlLytveThaZllTM29KVTh1SUI3WUwvWVV4RUtRR0U5NnVmU2xvbmJoL3dDeGo4TEI2V0NnSkt5UENwNFA1MzdCbkJRT2d4OGl3N1ZBNmMwMktPSGJwRFZsTmROOStLSDFoK1UrTmdXelhEL0J5amFvNU13WHhCREFybXZmOU1hOTlIb1diSWN2T0hHUHFXMFp4RHlKalZKN3pvZEZGZDZjOC8wbUUxS0U2cUF1UUJjbFFjdEMvOE0ydXBIWHA0bHBQQlBBUlk0aXk2b21NcERSc0VHTndRUlRQTXJKcEEwM0lwVkZKRjgxUGtKN2JMTjRmVTFNSlg4Q0hqRUZpTTlyNXNHSnpqQ2tzNzBMYW9xZU1NVmZSZ3FwWjZ6MFhWRjdaWFJXTDJOUTYzKzdJOGlZMFg4OTNWaXdTNlZ2RzRHNnBJU0xSeE95U2Q4QlRQUVp2bmZGT09lUEt1Z0huTUVmaW1EZUJQRjdLVmZibzNSYTBBU2xTeXJlTWdkOVMrTlVyNTkvempFRnhUUlJuVkVBbzFxbDFBUHM4eFByWDFNS2JhYnloOXBvbUFtbmwrZ2I0aURHWU1GSWU4Y1hkMVhuazM1NkNTeUhza0djTVlNbkRzK3RvaGtlTU9VOVpyWllBdXBLNTl1NjNzVlFZa3E5RGdUYVBXQnpEVUkrUEdSNWZrWlRTM0pHNHR1UldMcDhnUWM1NGw5cHNhMlF0WUl3eEVhdHZWUGhpZTZLTFY0YUtjVjczMHNYVXJFWVhpVWg3a1BPTGY3aFk5V0E1UHZlakxmRzBWNkMzMVRHNU1IaVZRRFdDVEhNbEtiTlJjNCtZcEdwRytiZVdNWHdycXhrUWQ3dU1yeTg0K01hWFVkTHJreHhsR0tOZTU4SEFNRzRrQ2lqNTRCMXVGQjVGNlNOR0poNFRJNFJUK1pJeGVDNXBOV0ZpNXJGWWlEVGFjVGlEY1h3Ylp3emN1L2UrR1NJcDh5RTRiV05UQk4xUjlzWVhFdmJrUmhkR3dndXNCckhhNnNtTEJTVEVyTXlnUTdXZnpRczdXQmk2bnVYMlM1RVFtWUZWMW1iTXBvZUYzaEc4QUVKb01FWnN4bXh5Wk9RMnEwc1gwdkR6VVowMWdGOXpMVExHRmpBR055T2Q4YTBIVCtXNFl3bXlEbUJzYjI3WWpFSGsyTVlWeHdOWGJNWUVtczVyYlF2OExESzdmb3g2by9xejFVUStHd0VQY3BtVFI4dWpWdDA0N0ZSbEJrY1dOQnViR2Y4QmJTL21FQXBsYm1SemRISmxZVzBLWlc1a2IySnFDalVnTUNCdlltb0tQRHd2VEdWdVozUm9JRGM0TVM5R2FXeDBaWEl2Um14aGRHVkVaV052WkdVK1BuTjBjbVZoYlFwNG5JMVdTMjdiTUJEZDZ4U3pUQUZINXZBclowZmJ0T3RFdG1SSkNiSnZQbWhRSjBoYXROc2VxZXZlb3VnNWVvZVNrdWd2TFFlR0FkSXo3NzM1YWVUWGFGaEZCR2hDb2JxemgzTVU2RStFdUpPcG9tWDBXbjhwWEZyRDFKNUlmWHFLU0l6d28vN05jV0E4RUxDS0tHTXg5ZGN2VWVsLzRDSW16azc4MGR0UTFBR3MxaGZlMkpaQnBSMzZWY1FwMzlhcXIxNXBSN2l4TXVmWXFQbExwNW9MbHUvazFWdzNlU0ZEbjFkNzNNNkxpMDFlMW53Nkw2L1dKTUszODFvcjdRZzNqQTBQWmNKeFVBcVN4bFFCUlhpN3QvYldPbEF4VjBmTlRBeGl4WTZqRzI2Q25keEh6Sjc3d0x4MEE0aEE3QWZCWnF6cytLMmkvZ1JCUWZVUW5UR1VqQkZDOEVQMTVHWnh5MXRpYkJrVjlRQlpBL0lpbXhaNnJtRnNZR3JLYXZaM0FWZFptaFhtS2p2a3NJcXlWYVF0d2FnUHN6UzluZzhOTEg0RGc2RytEQU1GN2lwVEc2VUFLUFVDU2pQVVZsb3ZEb0VvZWN3RDZDcWRMQzVBSmtJa3dsYnJFTmpXWDBxUFErNkFOdjAzVzJRdXBWUzIwR2ZtTnI4QVJsM05KQkprUktoRU9EYmlIRjB2Z3JUNzRaam43LzllYkl1K3Zidzl2d1RUWit1NklXa2dOeHB1Yk9sc3ZVb29qRTZETUJ4NFdOS1VXNmVwZ1dwbWl1SjZwSHNnZThOZk9vVEVaT0JEcEhJcjg4Um5UaE9DU1VlbWxzS09vSStaYmhldmhaL1A5YmlZamJzNWhGbzNvT1k0YTBCZ3lsei9DVWZPcFpkdGhscFhWZDFxYTFDRVFnL2VWVHBrWXBjbUc1WVhvVGxScnFIZTJUZTBNR1krek5JeU1Nc3R3bTZZN1VldnJZM2ROWXk1K3BDZWZTSDg3SnFrd2FCZUFmdkt3K3UwQ3FtMjdpZGtFZTd1QVR0a21kMERiclhzeTA3TTZHT2dIZDc5aEN4VmZjTDZsRkRXK2V6VWhVTys5eWpQOGd6eXJLaE1SMzhJNjlUUDlWU1BzM2RVZTE4OE4yVVdVbTNkVDhpU25udnRYejEralUrbWpXcnpQRFlMNEZpdXVObFpnM1lXSjZFUUpZdHRFdys4YzZxVU9zb3QySzczS0J2SFVJOWNzQXBKblBCRDBONitKRmp2a3VBU3JrVTNzeFpld3ZlNVhsSytYOExkZjFIMkRDUldDYmZCT0hKL3R1OFFqcTVYbjFiUXYzMUFHTDlBN1F2bkNRTkdZdW44cVpCMmJTSEsydTN6NnJIMSt3OTlad2dyQ21WdVpITjBjbVZoYlFwbGJtUnZZbW9LTnlBd0lHOWlhZ284UEM5VWVYQmxMMUJoWjJVdlRXVmthV0ZDYjNoYk1DQXdJRFF5TkNBeU9ESmRMMUpsYzI5MWNtTmxjenc4TDBadmJuUThQQzlHTVNBeUlEQWdVaTlHTWlBeklEQWdVajQrTDFoUFltcGxZM1E4UEM5WVpqRWdNU0F3SUZJdmFXMW5NU0EwSURBZ1VqNCtQajR2UTI5dWRHVnVkSE1nTlNBd0lGSXZVR0Z5Wlc1MElEWWdNQ0JTUGo0S1pXNWtiMkpxQ2pnZ01DQnZZbW9LUER3dlZIbHdaUzlHYjI1MFJHVnpZM0pwY0hSdmNpOUJjMk5sYm5RZ056STRMME5oY0VobGFXZG9kQ0EyT1RrdlJHVnpZMlZ1ZENBdE1qRXdMMFp2Ym5SQ1FtOTRXeTAyTmpRZ0xUTXlOQ0F5TURBd0lERXdNRFZkTDBadmJuUk9ZVzFsTDBGeWFXRnNUVlF2U1hSaGJHbGpRVzVuYkdVZ01DOVRkR1Z0VmlBNE1DOUdiR0ZuY3lBek1qNCtDbVZ1Wkc5aWFnb3lJREFnYjJKcUNqdzhMMVI1Y0dVdlJtOXVkQzlUZFdKMGVYQmxMMVJ5ZFdWVWVYQmxMMEpoYzJWR2IyNTBMMEZ5YVdGc1RWUXZSVzVqYjJScGJtY3ZWMmx1UVc1emFVVnVZMjlrYVc1bkwwWnBjbk4wUTJoaGNpQXpNaTlNWVhOMFEyaGhjaUF5TXpjdlYybGtkR2h6V3pJM055QXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTWpjM0lEQWdNamMzSURJM055QTFOVFlnTlRVMklEVTFOaUExTlRZZ05UVTJJRFUxTmlBMU5UWWdOVFUySURVMU5pQTFOVFlnTWpjM0lEQWdNQ0F3SURBZ01DQXdJRFkyTmlBMk5qWWdOekl5SURjeU1pQTJOallnTmpFd0lEYzNOeUEzTWpJZ01qYzNJREFnTmpZMklEVTFOaUE0TXpNZ056SXlJRGMzTnlBMk5qWWdOemMzSURjeU1pQTJOallnTmpFd0lEY3lNaUF3SURBZ05qWTJJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBMU5UWWdOVFUySURBZ05UVTJJREFnTUNBd0lEQWdNQ0F3SURVMU5pQTFOVFlnTUNBd0lETXpNeUExTURBZ01qYzNJREFnTlRBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEVTFOaUF3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdOekl5SURBZ056YzNJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01qYzNYUzlHYjI1MFJHVnpZM0pwY0hSdmNpQTRJREFnVWo0K0NtVnVaRzlpYWdvNUlEQWdiMkpxQ2p3OEwxUjVjR1V2Um05dWRFUmxjMk55YVhCMGIzSXZRWE5qWlc1MElEWXhNaTlEWVhCSVpXbG5hSFFnTmprNUwwUmxjMk5sYm5RZ0xURTRPQzlHYjI1MFFrSnZlRnN0TWpFZ0xUWTNPU0EyTXpjZ01UQXlNRjB2Um05dWRFNWhiV1V2UTI5MWNtbGxjazVsZDFCVFRWUXZTWFJoYkdsalFXNW5iR1VnTUM5VGRHVnRWaUE0TUM5R2JHRm5jeUF6TXo0K0NtVnVaRzlpYWdveklEQWdiMkpxQ2p3OEwxUjVjR1V2Um05dWRDOVRkV0owZVhCbEwxUnlkV1ZVZVhCbEwwSmhjMlZHYjI1MEwwTnZkWEpwWlhKT1pYZFFVMDFVTDBWdVkyOWthVzVuTDFkcGJrRnVjMmxGYm1OdlpHbHVaeTlHYVhKemRFTm9ZWElnTXpJdlRHRnpkRU5vWVhJZ01UZzJMMWRwWkhSb2MxczJNREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEWXdNQ0EyTURBZ01DQTJNREFnTmpBd0lEWXdNQ0EyTURBZ05qQXdJRFl3TUNBMk1EQWdOakF3SURZd01DQTJNREFnTUNBMk1EQWdNQ0F3SURBZ01DQXdJREFnTmpBd0lEWXdNQ0EyTURBZ05qQXdJRFl3TUNBd0lEQWdNQ0EyTURBZ05qQXdJREFnTmpBd0lEWXdNQ0EyTURBZ05qQXdJREFnTUNBMk1EQWdOakF3SURZd01DQTJNREFnTmpBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdNQ0F3SURBZ01DQXdJREFnTUNBMk1EQWdNQ0F3SURBZ01DQXdJREFnTUNBd0lEQWdOakF3WFM5R2IyNTBSR1Z6WTNKcGNIUnZjaUE1SURBZ1VqNCtDbVZ1Wkc5aWFnb3hJREFnYjJKcUNqdzhMMVI1Y0dVdldFOWlhbVZqZEM5VGRXSjBlWEJsTDBadmNtMHZVbVZ6YjNWeVkyVnpQRHcrUGk5Q1FtOTRXekFnTUNBek1ESXVOaUE1TlYwdlJtOXliVlI1Y0dVZ01TOU5ZWFJ5YVhnZ1d6RWdNQ0F3SURFZ01DQXdYUzlNWlc1bmRHZ2dNak0wTDBacGJIUmxjaTlHYkdGMFpVUmxZMjlrWlQ0K2MzUnlaV0Z0Q25pY2pWTkxzc013Q052bkZEa0JBL0lIZktEM3V1LzlGNldlekNSbzFja2lRVEVnQ2F5bjV2TitIZDlYazM2dWNiNy9qaUdXc1lsZnNha2dnUzk4QVpIL25obndmZUlHR3FSVndQUHpDWFRJcUlETHJEVG01bkVEMDZqTGpCSjZsd3FFN1pLM2txVWtiVFZpWWFyRTNIUVFkVE1RRVRQbkxJQ3ptc3FxTnFZcDFVZExWNko2M3hkcHNORW9qaTFxWnVhRnpCQTY0OGFkUExieTUxQzk1cVJablpDeGMrNU9TRzlvRXd4VUY2aVdBNTNxSXRjbmF0MDJ0NEpIbGQ2MnlnY3llTG9ZZFpiSWhhbHV3bm02OE1Gc1Fta25FSFZ1U0IrbzdscDhBUlNibmY0WS94OGZERjYwV0FwbGJtUnpkSEpsWVcwS1pXNWtiMkpxQ2pZZ01DQnZZbW9LUER3dlZIbHdaUzlRWVdkbGN5OURiM1Z1ZENBeEwwdHBaSE5iTnlBd0lGSmRQajRLWlc1a2IySnFDakV3SURBZ2IySnFDanc4TDFSNWNHVXZRMkYwWVd4dlp5OVFZV2RsY3lBMklEQWdVajQrQ21WdVpHOWlhZ294TVNBd0lHOWlhZ284UEM5UWNtOWtkV05sY2locFZHVjRkSzRnTlM0MUxqRXpMaklncVRJd01EQXRNakF5TUNCcFZHVjRkQ0JIY205MWNDQk9WaUJjS0VGSFVFd3RkbVZ5YzJsdmJsd3BLUzlEY21WaGRHbHZia1JoZEdVb1JEb3lNREl6TURNeU56QTVNek15TVNzd01pY3dNQ2NwTDAxdlpFUmhkR1VvUkRveU1ESXpNRE15TnpBNU16TXlNU3N3TWljd01DY3BQajRLWlc1a2IySnFDbmh5WldZS01DQXhNZ293TURBd01EQXdNREF3SURZMU5UTTFJR1lnQ2pBd01EQXdNRFU0TVRBZ01EQXdNREFnYmlBS01EQXdNREF3TkRRMk9TQXdNREF3TUNCdUlBb3dNREF3TURBMU1qZzFJREF3TURBd0lHNGdDakF3TURBd01EQXdNVFVnTURBd01EQWdiaUFLTURBd01EQXdNek14TUNBd01EQXdNQ0J1SUFvd01EQXdNREEyTWpBeUlEQXdNREF3SUc0Z0NqQXdNREF3TURReE5UZ2dNREF3TURBZ2JpQUtNREF3TURBd05ETXhNaUF3TURBd01DQnVJQW93TURBd01EQTFNVEl6SURBd01EQXdJRzRnQ2pBd01EQXdNRFl5TlRNZ01EQXdNREFnYmlBS01EQXdNREF3TmpJNU9TQXdNREF3TUNCdUlBcDBjbUZwYkdWeUNqdzhMMU5wZW1VZ01USXZVbTl2ZENBeE1DQXdJRkl2U1c1bWJ5QXhNU0F3SUZJdlNVUWdXenhqTTJZd09XVTRaakZpTmpCall6VmxOMlEwTnpRMU1qSmpaR05rTnpWbE1ENDhZek5tTURsbE9HWXhZall3WTJNMVpUZGtORGMwTlRJeVkyUmpaRGMxWlRBK1hUNCtDaVZwVkdWNGRDMDFMalV1TVRNdU1ncHpkR0Z5ZEhoeVpXWUtOalEyTUFvbEpVVlBSZ289', 1, '', '2023-03-27', '63', 0, 0, 0, 0, 0, '', 1, 1),
(2950, 1, 736, 2, 0, NULL, 0, '2023-03-25 08:54:53', '2023-03-27 09:35:44', '2023-03-25', 'P2778', '23-03988-03-25', '', 0.00, 9.83, 2.06, 0.00, 0, 0.00, 4.40, 'Rua As Teixugueiras 7, portal 4, 7ºO ', 'Vigo', 'Pontevedra', '36212', 'España', 16.29, 0, '2023-03-25 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2951, 1, 535, 2, 0, NULL, 0, '2023-03-25 12:10:16', '2023-03-27 09:38:36', '2023-03-25', 'P2779', '23-03989-03-25', '', 0.00, 9.83, 2.06, 0.00, 0, 0.00, 6.90, 'Fraiz-Villestro, 6', 'Santiago de Composte', 'A Coruña', '15896', 'España', 18.79, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2952, 1, 581, 2, 0, NULL, 0, '2023-03-25 15:54:14', '2023-03-27 09:39:45', '2023-03-25', 'P2780', '23-03990-03-25', 'Llamar antes de entregar: 615575628', 0.00, 18.18, 3.82, 0.00, 0, 0.00, 4.40, 'P. Arcillero 3, 6 D', 'Santander', 'Cantabria', '39001', 'España', 26.40, 0, '2023-03-25 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2953, 1, 737, 2, 0, NULL, 0, '2023-03-25 17:40:49', '2023-03-27 09:42:56', '2023-03-25', 'P2781', '23-03991-03-25', 'Entregar en el buzón city box', 0.00, 19.66, 4.13, 0.00, 0, 0.00, 4.40, 'Avenida de los Planetas 26 1°2', 'Parla', 'Madrid', '28983', 'España', 28.19, 0, '2023-03-25 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2954, 1, 300, 2, 0, NULL, 0, '2023-03-25 18:55:17', '2023-03-27 09:44:04', '2023-03-25', 'P2782', '23-03992-03-25', '', 0.00, 54.54, 11.45, 0.00, 0, 0.00, 0.00, 'Moisés de León 50 6ºB', 'León', 'León', '24006', 'España', 65.99, 0, '2023-03-25 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2955, 1, 324, 2, 0, NULL, 0, '2023-03-26 15:03:45', '2023-03-27 09:46:22', '2023-03-26', 'P2783', '23-03993-03-26', '', 0.00, 36.36, 7.64, 0.00, 0, 0.00, 4.40, 'C/Martinez Izquierdo 84, 2º dc', 'Madrid', 'Madrid', '28028', 'España', 48.40, 0, '2023-03-26 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2956, 1, 262, 2, 0, NULL, 0, '2023-03-26 16:48:14', '2023-03-27 09:47:21', '2023-03-26', 'P2784', '23-03994-03-26', 'Horario: martes a viernes de 9h a 13h y de 16h a 19h', 0.00, 101.40, 21.29, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 122.69, 0, '2023-03-26 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2957, 1, 98, 2, 0, NULL, 0, '2023-03-26 20:57:24', '2023-03-27 09:50:21', '2023-03-26', 'P2785', '23-03995-03-26', '', 0.00, 64.40, 13.52, 0.00, 0, 0.00, 2.50, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 80.42, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2958, 1, 40, 1, 0, NULL, 0, '2023-03-27 09:07:25', '2023-03-27 09:07:25', '2023-03-27', 'P2786', '2023-03-27', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 68.97, 0, '2023-03-27 00:00:00', '', '', 3, 3, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2959, 1, 738, 2, 0, NULL, 0, '2023-03-27 07:57:33', '2023-03-27 10:38:56', '2023-03-27', 'P2787', '23-03996-03-27', '', 0.00, 9.83, 2.06, 0.00, 0, 0.00, 4.40, 'ZELAI ONDO 23 5ºB', 'Zarautz', 'Gipuzkoa', '20800', 'España', 16.29, 0, '2023-03-27 00:00:00', '', '', 3, 5, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2960, 1, 277, 2, 0, NULL, 0, '2023-03-27 08:43:22', '2023-03-27 10:45:43', '2023-03-27', 'P2788', '23-03997-03-27', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 413.82, 0, '2023-03-27 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2961, 1, 739, 2, 0, NULL, 0, '2023-03-27 09:55:48', '2023-03-27 11:57:23', '2023-03-27', 'P2789', '23-03999-03-27', '', 0.00, 19.66, 4.13, 0.00, 0, 0.00, 6.90, 'Eguzkialde auzoa Gorritxiki etxea 8b', 'Berastegi', 'Gipuzkoa', '20492', 'España', 30.69, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2962, 1, 78, 2, 0, NULL, 0, '2023-03-27 10:51:07', '2023-03-27 12:53:14', '2023-03-27', 'P2790', '23-04000-03-27', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'AVND. DE SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2963, 1, 40, 2, 0, NULL, 0, '2023-03-27 11:04:32', '2023-03-27 11:04:32', '2023-03-27', 'P2791', '23-04001-03-27', 'pedido enviado hoy a la panaderia ogi koskorra y recogido ,gracias', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 68.97, 0, '2023-03-27 11:04:32', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(2964, 1, 40, 1, 1, NULL, 2958, '2023-03-27 13:13:33', '2023-03-27 13:13:33', '2023-03-27', 'R33', 'P2786 RECT.', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 1),
(2965, 1, 164, 2, 0, NULL, 0, '2023-03-27 19:42:37', '2023-03-28 09:10:34', '2023-03-27', 'P2792', '23-04003-03-27', '', 0.00, 292.40, 61.40, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 353.80, 0, '2023-03-27 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2966, 1, 571, 2, 0, NULL, 0, '2023-03-28 05:41:39', '2023-03-28 09:14:45', '2023-03-28', 'P2793', '23-04004-03-28', '', 0.00, 18.18, 3.82, 0.00, 0, 0.00, 4.40, 'AMAROZ 30, 1B', 'Tolosa', 'Gipuzkoa', '20400', 'España', 26.40, 0, '2023-03-28 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2967, 1, 0, 4, 0, NULL, 0, '2023-03-28 11:47:39', '2023-03-28 11:48:42', '2023-03-28', '', 'promoción', '', 0.00, 9.83, 2.06, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 11.89, 0, '2023-03-28 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),
(2968, 1, 740, 2, 0, NULL, 0, '2023-03-28 10:51:37', '2023-03-28 17:07:56', '2023-03-28', 'P2794', '23-04005-03-28', 'Por las tardes  o a partir de las 2;30', 0.00, 19.66, 4.12, 0.00, 0, 0.00, 4.40, 'Río Duero 52 urb el soto', 'Aldeamayor de San Ma', 'Valladolid', '47162', 'España', 28.19, 0, '2023-03-28 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2969, 1, 36, 2, 0, NULL, 0, '2023-03-28 11:12:52', '2023-03-28 17:08:43', '2023-03-28', 'P2795', '23-04006-03-28', 'Lunes cerrado, entregas de martes a viernes', 0.00, 114.00, 23.95, 0.00, 0, 0.00, 0.00, 'Artekale 12 bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 137.94, 0, '2023-03-28 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2970, 1, 741, 2, 0, NULL, 0, '2023-03-28 12:09:26', '2023-03-28 17:09:34', '2023-03-28', 'P2796', '23-04007-03-28', '', 0.00, 36.36, 7.64, 0.00, 0, 0.00, 4.40, 'C/ Jerusalen, 13 3 B', 'Cáceres', 'Cáceres', '10005', 'España', 48.40, 0, '2023-03-28 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2971, 1, 28, 2, 0, NULL, 0, '2023-03-28 12:44:45', '2023-03-29 09:18:27', '2023-03-28', 'P2797', '23-04008-03-28', '', 0.00, 228.00, 47.90, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2972, 1, 28, 2, 0, NULL, 0, '2023-03-28 12:44:51', '2023-03-28 12:44:51', '2023-03-28', 'P2798', '23-04009-03-28', NULL, 0.00, 228.00, 47.90, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(2973, 1, 675, 2, 0, NULL, 0, '2023-03-28 22:54:30', '2023-03-29 09:19:40', '2023-03-28', 'P2799', '23-04010-03-28', '', 0.00, 47.67, 10.01, 0.00, 0, 0.00, 0.00, 'Assutzenes 10', 'Viladecans', 'Barcelona', '08840', 'España', 57.68, 0, '2023-03-28 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2974, 1, 215, 2, 0, NULL, 0, '2023-03-29 01:17:40', '2023-03-29 09:20:46', '2023-03-29', 'P2800', '23-04013-03-29', '', 0.00, 285.00, 59.90, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 344.85, 0, '2023-03-29 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2975, 1, 563, 2, 0, NULL, 0, '2023-03-29 05:06:37', '2023-03-29 09:21:34', '2023-03-29', 'P2801', '23-04014-03-29', 'Astelehen-Ostegun: 8-18:00\r\nOstirala: 8-14:30', 0.00, 28.01, 5.88, 0.00, 0, 0.00, 4.40, 'Elkarmedia - Aingeru Kalea 9 - atzekaldea', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 38.29, 0, '2023-03-29 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2976, 1, 28, 2, 1, NULL, 2972, '2023-03-29 09:19:12', '2023-03-29 09:19:12', '2023-03-29', 'R34', 'P2798 RECT.', '', 0.00, 228.00, 47.90, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(2977, 1, 110, 2, 0, NULL, 0, '2023-03-29 08:50:29', '2023-03-29 11:35:54', '2023-03-29', 'P2802', '23-04015-03-29', 'lunes cerrado', 0.00, 228.00, 47.90, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 275.88, 0, '2023-03-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-290323-HSxU17gMDKgZK-255', '', 'https://tbai.prep.gipuzkoa.eus/qr/?id=TBAI-B20930640-290323-HSxU17gMDKgZK-255&s=2023&nf=P2802&i=275.88&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2978, 1, 474, 2, 0, NULL, 0, '2023-03-29 13:47:39', '2023-03-30 09:07:08', '2023-03-29', 'P2803', '23-04017-03-29', 'Llamar antes de la entrega \r\n638130106', 0.00, 22.20, 4.65, 0.00, 0, 0.00, 4.40, 'C Ntra Sra de los clarines , 56', 'Beas', 'Huelva', '21630', 'España', 31.26, 0, '2023-03-29 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2979, 1, 218, 2, 0, NULL, 0, '2023-03-29 18:24:37', '2023-03-30 09:23:48', '2023-03-29', 'P2804', '23-04018-03-29', 'DE 10.00 A 17.00 HORAS', 0.00, 157.30, 33.05, 0.00, 0, 0.00, 0.00, 'C/ Josefa Amar y Borbon nº 11 ', 'Zaragoza', 'Zaragoza', '50001', 'España', 190.33, 0, '2023-03-29 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2980, 1, 678, 2, 0, NULL, 0, '2023-03-29 18:58:45', '2023-03-30 09:26:50', '2023-03-29', 'P2805', '23-04020-03-29', '', 0.00, 19.66, 4.13, 0.00, 0, 0.00, 6.90, 'Calle Cortés de Cádiz #40 2-1', 'Castelldefels', 'Barcelona', '08860', 'España', 30.69, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2981, 1, 76, 1, 0, NULL, 0, '2023-03-30 10:55:16', '2023-03-30 10:55:16', '2023-03-30', 'P2806', '2023-03-30', '', 0.00, 280.80, 58.97, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 339.77, 0, '2023-03-30 00:00:00', '', '', 3, 3, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2982, 1, 264, 2, 0, NULL, 0, '2023-03-30 09:36:39', '2023-03-30 11:42:46', '2023-03-30', 'P2807', '23-04022-03-30', '', 0.00, 18.18, 3.82, 0.00, 0, 0.00, 4.40, 'Gran via de les corts catalanes 432 ent 2', 'Barcelona', 'Barcelona', '08015', 'España', 26.40, 0, '2023-03-30 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2983, 1, 556, 2, 0, NULL, 0, '2023-03-30 10:02:52', '2023-03-30 12:30:43', '2023-03-30', 'P2808', '23-04023-03-30', '', 0.00, 57.00, 11.98, 0.00, 0, 0.00, 2.50, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2984, 1, 742, 2, 0, NULL, 0, '2023-03-30 13:09:17', '2023-03-31 08:59:34', '2023-03-30', 'P2809', '23-04024-03-30', '', 0.00, 19.66, 4.13, 0.00, 0, 0.00, 4.40, 'Calle San Blas 1 4C', 'Donostia-San Sebasti', 'Gipuzkoa', '20013', 'España', 28.19, 0, '2023-03-30 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2985, 1, 743, 2, 0, NULL, 0, '2023-03-30 14:48:51', '2023-03-31 09:01:37', '2023-03-30', 'P2810', '23-04025-03-30', '', 0.00, 19.66, 4.13, 0.00, 0, 0.00, 4.40, 'URB. FINCAFLORES, 14-Carrer les Flors', 'Alfàs del Pi (l\')', 'Alicante', '03580', 'España', 28.19, 0, '2023-03-30 00:00:00', '', '', 3, 5, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2986, 1, 444, 2, 0, NULL, 0, '2023-03-30 17:56:18', '2023-03-30 17:56:18', '2023-03-30', 'P2811', '23-04026-03-30', NULL, 0.00, 9.83, 2.06, 0.00, 0, 0.00, 4.40, 'Antziola 9,3ºdcha', 'Hernani', 'Gipuzkoa', '20120', 'España', 16.29, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(2987, 1, 444, 2, 0, NULL, 0, '2023-03-30 17:58:56', '2023-03-31 09:02:11', '2023-03-30', 'P2812', '23-04027-03-30', '', 0.00, 9.83, 2.06, 0.00, 0, 0.00, 4.40, 'Antziola 9,3ºdcha', 'Hernani', 'Gipuzkoa', '20120', 'España', 16.29, 0, '2023-03-30 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2988, 1, 126, 2, 0, NULL, 0, '2023-03-30 18:38:24', '2023-03-31 09:02:53', '2023-03-30', 'P2813', '23-04029-03-30', 'Entrega en horario de 10 a 13:30', 0.00, 114.00, 23.96, 0.00, 0, 0.00, 0.00, 'C/ Santa Lucía Nº 8 ocal', 'Valladolid', 'Valladolid', '47005', 'España', 137.94, 0, '2023-03-30 00:00:00', '', '', 3, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2989, 1, 77, 1, 0, NULL, 0, '2023-03-31 09:32:15', '2023-03-31 09:32:15', '2023-03-31', 'P2814', '2023-03-31', '', 0.00, 546.00, 114.66, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 660.66, 0, '2023-03-31 00:00:00', '', '', 3, 3, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2990, 1, 444, 2, 1, NULL, 2986, '2023-03-31 09:40:13', '2023-03-31 09:40:13', '2023-03-31', 'R35', 'P2811 RECT.', '', 0.00, 9.83, 2.06, 0.00, 0, 0.00, 4.40, 'Antziola 9,3ºdcha', 'Hernani', 'Gipuzkoa', '20120', 'España', 16.29, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(2991, 1, 595, 2, 0, NULL, 0, '2023-03-31 10:46:01', '2023-04-03 12:37:42', '2023-04-03', 'P2815', '23-04030-03-31', '', 0.00, 57.00, 11.98, 0.00, 0, 0.00, 0.00, 'Zurbanbarri 16 Loja( Peluqueria)', 'Bilbao', 'Bizkaia', '48007', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030423-YYxeU4UjbWNHw-127', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030423-YYxeU4UjbWNHw-127&s=2023&nf=P2815&i=68.97&cr=091', '[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
(2992, 1, 744, 2, 0, NULL, 0, '2023-03-31 12:57:31', '2023-04-03 15:43:47', '2023-03-31', 'P2816', '23-04031-03-31', '', 0.00, 19.66, 4.12, 0.00, 0, 0.00, 10.69, 'Bisbe Azara, 2', 'Eivissa', 'Baleares (Illes)', '07800', 'España', 34.48, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-310323-BLavx9/Aboam5-143', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310323-BLavx9%2FAboam5-143&s=2023&nf=P2816&i=34.47&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2993, 1, 379, 2, 0, NULL, 0, '2023-03-31 13:55:46', '2023-04-04 12:43:55', '2023-03-31', 'P2817', '23-04032-03-31', 'Les ruego por favor que me llamen al móvil para decirme la hora de entrega, para que esté alguien en casa y recoger el paquete .\r\nGracias. Saludos cordiales.\r\nMaría', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Alameda de Mazarredo nº 81, 5º izda., izda.', 'Bilbao', 'Bizkaia', '48009', 'España', 28.19, 0, '2023-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310323-LvyqNrdqyl9iw-143', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310323-LvyqNrdqyl9iw-143&s=2023&nf=P2817&i=28.19&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2994, 1, 745, 2, 0, NULL, 0, '2023-03-31 17:14:50', '2023-04-04 12:56:03', '2023-03-31', 'P2818', '23-04033-03-31', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Paseo de Miramón, 172 (ETB)', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 28.19, 0, '2023-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310323-LrHtidh61LQW/-078', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310323-LrHtidh61LQW%2F-078&s=2023&nf=P2818&i=28.19&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2995, 1, 522, 2, 0, NULL, 0, '2023-04-01 17:45:45', '2023-04-04 13:04:37', '2023-04-01', 'P2819', '23-04034-04-01', 'Esta semana abrimos Lunes/Martes/miércoles ', 0.00, 377.90, 79.36, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 457.26, 0, '2023-04-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010423-kIMN3oGSo54Jj-162', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010423-kIMN3oGSo54Jj-162&s=2023&nf=P2819&i=457.26&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2996, 1, 662, 2, 0, NULL, 0, '2023-04-02 06:48:38', '2023-04-04 13:17:13', '2023-04-02', 'P2820', '23-04035-04-02', '', 0.00, 39.32, 9.02, 0.00, 0, 0.00, 4.40, 'passatge mercè rodoreda 13, local 8', 'Castelldefels', 'Barcelona', '08860', 'España', 51.98, 0, '2023-04-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020423-Yk1A/05rmfOal-251', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020423-Yk1A%2F05rmfOal-251&s=2023&nf=P2820&i=51.98&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2997, 1, 746, 2, 0, NULL, 0, '2023-04-03 02:26:52', '2023-04-04 13:19:39', '2023-04-03', 'P2821', '23-04036-04-03', 'Preciso que el repartidor me llame antes de la entrega. Un saludo.\r\nGracias ', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Calle Arroyo 28', 'Ahigal', 'Cáceres', '10650', 'España', 59.47, 0, '2023-04-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030423-d4XC4wquWpg61-010', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030423-d4XC4wquWpg61-010&s=2023&nf=P2821&i=59.47&cr=151', '[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
(2998, 1, 747, 2, 0, NULL, 0, '2023-04-03 07:18:18', '2023-04-04 13:23:05', '2023-04-03', 'P2822', '23-04037-04-03', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Carre Consell de Cent, 238, 1°- 1ª', 'Barcelona', 'Barcelona', '08011', 'España', 59.47, 0, '2023-04-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030423-fxViQ+pryaQW8-213', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030423-fxViQ%2BpryaQW8-213&s=2023&nf=P2822&i=59.47&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(2999, 1, 748, 2, 0, NULL, 0, '2023-04-03 18:47:47', '2023-04-04 13:31:24', '2023-04-03', 'P2823', '23-04038-04-03', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Manzanedo 55 1C ', 'Don Benito', 'Badajoz', '06400', 'España', 28.19, 0, '2023-04-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030423-QH7h6ouuEAyRy-140', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030423-QH7h6ouuEAyRy-140&s=2023&nf=P2823&i=28.19&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3000, 1, 190, 3, 0, NULL, 0, '2023-04-04 09:47:04', '2023-04-04 09:47:04', '2023-04-04', '', 'consumo peluquería', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 68.97, 0, '2023-04-04 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),
(3001, 1, 397, 2, 0, NULL, 0, '2023-04-04 11:57:07', '2023-06-27 12:24:24', '2023-04-04', 'P2824', '23-04039-04-04', '', 0.00, 9.83, 2.82, 0.00, 0, 0.00, 4.40, 'Alberga ...69..1 izda', 'Errenteria', 'Gipuzkoa', '20100', 'España', 16.29, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040423-CRVvdfRGCrcai-033', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040423-CRVvdfRGCrcai-033&s=2023&nf=P2824&i=16.29&cr=210', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3002, 1, 749, 2, 0, NULL, 0, '2023-04-04 12:26:21', '2023-04-05 10:48:55', '2023-04-04', 'P2825', '23-04041-04-04', 'HORARIO PORTERIA: 9:00 A 14:00 Y DE 17:00 A 20:00', 0.00, 9.83, 2.82, 0.00, 0, 0.00, 4.40, 'CALLE LUIS PEIDRO 4 A 4 C', 'Madrid', 'Madrid', '28007', 'España', 16.29, 0, '2023-04-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040423-e1iqVehxOFt8K-101', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040423-e1iqVehxOFt8K-101&s=KOL2023&nf=P2825&i=16.29&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3003, 1, 453, 2, 0, NULL, 0, '2023-04-04 12:26:48', '2023-04-05 10:22:57', '2023-04-04', 'P2826', '23-04040-04-04', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Plaza Fray Luis Colomer Numero 10 puerta 13', 'Valencia', 'Valencia', '46021', 'España', 28.19, 0, '2023-04-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040423-kSavKW+MHmony-165', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040423-kSavKW%2BMHmony-165&s=KOL2023&nf=P2826&i=28.19&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3004, 1, 677, 2, 0, NULL, 0, '2023-04-04 13:12:53', '2023-04-05 10:56:07', '2023-04-04', 'P2827', '23-04042-04-04', '', 0.00, 9.83, 2.82, 0.00, 0, 0.00, 4.40, 'VOLVO ARREGUI (OSCAR ARAGUNDE)  PORTAL DE BETOÑO 13', 'Vitoria-Gasteiz', 'Álava', '01013', 'España', 16.29, 0, '2023-04-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040423-ZOQR59rXTAKwd-188', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040423-ZOQR59rXTAKwd-188&s=KOL2023&nf=P2827&i=16.29&cr=198', '[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
(3005, 1, 337, 2, 0, NULL, 0, '2023-04-04 17:07:25', '2023-04-05 10:56:53', '2023-04-04', 'P2828', '23-04043-04-04', '', 0.00, 51.80, 10.88, 0.00, 0, 0.00, 0.00, ' A VECINAL (Coopolis S.C.)  C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 62.68, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040423-Rw/kQtQrgdt98-073', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040423-Rw%2FkQtQrgdt98-073&s=KOL2023&nf=P2828&i=62.68&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3006, 1, 750, 2, 0, NULL, 0, '2023-04-05 06:38:58', '2023-04-05 10:57:38', '2023-04-05', 'P2829', '23-04045-04-05', 'Casa', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Calle Nardo 12 ', 'Torrelodones', 'Madrid', '28250', 'España', 28.19, 0, '2023-04-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050423-a64Ib2Y/rkM7B-221', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050423-a64Ib2Y%2FrkM7B-221&s=KOL2023&nf=P2829&i=28.19&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3007, 1, 106, 1, 0, NULL, 0, '2023-04-05 13:13:52', '2023-04-05 13:15:38', '2023-04-05', 'P2830', '2023-04-05', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, '', '', '', '0', '', 140.44, 0, '2023-04-05 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-050423-Yvp7n0CbXO9Q9-008', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050423-Yvp7n0CbXO9Q9-008&s=KOL2023&nf=P2830&i=140.44&cr=225', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3008, 1, 751, 2, 0, NULL, 0, '2023-04-06 13:58:14', '2023-04-11 08:56:52', '2023-04-06', 'P2831', '23-04048-04-06', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'Joaquin Gamon Kalea 2 autoescuela Teknika', 'Irun', 'Gipuzkoa', '20302', 'España', 55.89, 0, '2023-04-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060423-TgoA74LxuQ72e-064', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060423-TgoA74LxuQ72e-064&s=KOL2023&nf=P2831&i=55.89&cr=197', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3009, 1, 752, 2, 0, NULL, 0, '2023-04-07 16:53:56', '2023-04-11 09:07:46', '2023-04-07', 'P2832', '23-04049-04-07', 'Concesionario IMP SPORT BILBAO ', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Poligono Iru bide 2-3. Pabellón 5, Concesionario imp sport bilbao', 'Galdakao', 'Bizkaia', '48960', 'España', 28.19, 0, '2023-04-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070423-gvuDAIK6diUq2-091', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070423-gvuDAIK6diUq2-091&s=KOL2023&nf=P2832&i=28.19&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3010, 1, 372, 2, 0, NULL, 0, '2023-04-07 21:42:17', '2023-04-11 09:29:32', '2023-04-07', 'P2833', '23-04050-04-07', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Carrer Arenal n 7', 'Castelló d\'Empúries', 'Girona', '17487', 'España', 16.29, 0, '2023-04-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070423-awC6I91yeWzE/-096', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070423-awC6I91yeWzE%2F-096&s=KOL2023&nf=P2833&i=16.29&cr=202', '[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
(3011, 1, 439, 2, 0, NULL, 0, '2023-04-08 13:39:24', '2023-04-11 09:32:40', '2023-04-08', 'P2834', '23-04051-04-08', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'kukutza nº4', 'Laudio/Llodio', 'Álava', '01400', 'España', 28.19, 0, '2023-04-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080423-gMplNn/sijobD-241', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080423-gMplNn%2FsijobD-241&s=KOL2023&nf=P2834&i=28.19&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3012, 1, 611, 2, 0, NULL, 0, '2023-04-09 08:21:59', '2023-04-11 09:42:09', '2023-04-09', 'P2835', '23-04064-04-09', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Avenida de la libertad 12 6A', 'Alcorcón', 'Madrid', '28924', 'España', 16.29, 0, '2023-04-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090423-JlE8k7LnLTzMw-170', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090423-JlE8k7LnLTzMw-170&s=KOL2023&nf=P2835&i=16.29&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3013, 1, 314, 2, 0, NULL, 0, '2023-04-09 22:26:36', '2023-04-11 09:47:58', '2023-04-09', 'P2836', '23-04065-04-09', 'LLAMAR PREVIAMENTE PARA CONCERTAR ENTREGA ', 0.00, 56.02, 11.76, 0.00, 0, 0.00, 0.00, 'CALLE MATEO MIGUEL AYLLÓN 2, 3C', 'Cuenca', 'Cuenca', '16002', 'España', 67.78, 0, '2023-04-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090423-cbpf6Jk9yrQMB-085', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090423-cbpf6Jk9yrQMB-085&s=KOL2023&nf=P2836&i=67.78&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3014, 1, 325, 2, 0, NULL, 0, '2023-04-10 12:42:27', '2023-04-11 09:53:25', '2023-04-10', 'P2837', '23-04068-04-10', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'San pelaio bide nagusia 52 bajo ', 'Bakio', 'Bizkaia', '48130', 'España', 28.19, 0, '2023-04-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100423-FcU1UL+W70TZA-214', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100423-FcU1UL%2BW70TZA-214&s=KOL2023&nf=P2837&i=28.19&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3015, 1, 753, 2, 0, NULL, 0, '2023-04-10 16:39:47', '2023-04-11 09:58:07', '2023-04-10', 'P2838', '23-04070-04-10', 'llamar antes de entregar', 0.00, 39.32, 9.02, 0.00, 0, 0.00, 4.40, 'ELORTZA AUZOA 17 bajo', 'Urduliz', 'Bizkaia', '48610', 'España', 51.98, 0, '2023-04-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100423-JjnwsQvxai6Oz-134', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100423-JjnwsQvxai6Oz-134&s=KOL2023&nf=P2838&i=51.98&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3016, 1, 162, 2, 0, NULL, 0, '2023-04-10 18:21:48', '2023-04-11 10:03:08', '2023-04-10', 'P2839', '23-04071-04-10', 'Entregar por la mañana', 0.00, 116.20, 24.40, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 140.60, 0, '2023-04-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100423-QpzPaAohIdHAp-121', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100423-QpzPaAohIdHAp-121&s=KOL2023&nf=P2839&i=140.60&cr=123', '[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
(3017, 1, 127, 2, 0, NULL, 0, '2023-04-11 07:32:16', '2023-04-11 10:07:17', '2023-04-11', 'P2840', '23-04072-04-11', '', 0.00, 121.40, 25.49, 0.00, 0, 0.00, 0.00, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 146.89, 0, '2023-04-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110423-NYIRcW7ooYCop-092', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-NYIRcW7ooYCop-092&s=KOL2023&nf=P2840&i=146.88&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3018, 1, 754, 2, 0, NULL, 0, '2023-04-11 07:48:33', '2023-04-25 11:16:00', '2023-04-11', 'P2841', '23-04073-04-11', '', 0.00, 147.45, 30.96, 0.00, 1, 7.67, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 186.08, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, 'TBAI-B20930640-110423-AM6YK+4tBRYWR-024', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-AM6YK%2B4tBRYWR-024&s=KOL2023&nf=P2841&i=186.08&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3019, 1, 220, 2, 0, NULL, 0, '2023-04-11 08:01:07', '2023-04-11 10:10:34', '2023-04-11', 'P2842', '23-04074-04-11', 'Lunes tarde cerrado', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 206.91, 0, '2023-04-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110423-N8gKAiueAPeM9-081', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-N8gKAiueAPeM9-081&s=KOL2023&nf=P2842&i=206.91&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3020, 1, 190, 3, 0, NULL, 0, '2023-04-11 11:05:52', '2023-04-11 11:05:52', '2023-04-11', '', 'consumo peluquería', '', 0.00, 157.30, 33.03, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 190.33, 0, '2023-04-11 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),
(3021, 1, 53, 2, 0, NULL, 0, '2023-04-11 09:10:44', '2023-04-11 11:37:30', '2023-04-11', 'P2843', '23-04075-04-11', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-110423-jp4ulKtjSrOlZ-190', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-jp4ulKtjSrOlZ-190&s=KOL2023&nf=P2843&i=174.93&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3022, 1, 290, 2, 0, NULL, 0, '2023-04-11 09:18:48', '2023-04-11 11:40:42', '2023-04-11', 'P2844', '23-04076-04-11', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Rúa N2,16, 1º', 'Moraña', 'Pontevedra', '36660', 'España', 28.19, 0, '2023-04-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110423-oD65esrqe30xH-070', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-oD65esrqe30xH-070&s=KOL2023&nf=P2844&i=28.19&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3023, 1, 754, 2, 0, NULL, 0, '2023-04-11 10:36:08', '2023-04-18 11:29:55', '2023-04-11', 'P2845', '23-04077-04-11', 'llamar si no estoy para dejar en otro sitio', 0.00, 96.20, 20.20, 0.00, 1, 5.00, 0.00, 'Josep Tarradellas 166 2º1', 'Amposta', 'Tarragona', '43870', 'España', 121.40, 0, '2023-04-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-110423-B3K5unIZ8ngl1-230', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-B3K5unIZ8ngl1-230&s=KOL2023&nf=P2845&i=121.40&cr=079', '[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
(3024, 1, 23, 2, 0, NULL, 0, '2023-04-11 11:10:21', '2023-04-12 09:19:51', '2023-04-11', 'P2846', '23-04078-04-11', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 241.40, 0, '2023-04-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110423-lwI6mavtch7Pl-153', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-lwI6mavtch7Pl-153&s=KOL2023&nf=P2846&i=241.40&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3025, 1, 131, 2, 0, NULL, 0, '2023-04-11 13:10:46', '2023-04-12 09:25:34', '2023-04-11', 'P2847', '23-04079-04-11', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'C / general eguia frente al 31, Peluqueria bilbo', 'Bilbao', 'Bizkaia', '48013', 'España', 310.37, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110423-ogqEqf/f1CaMu-182', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-ogqEqf%2Ff1CaMu-182&s=KOL2023&nf=P2847&i=310.37&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3026, 1, 755, 2, 0, NULL, 0, '2023-04-11 21:11:40', '2023-04-12 09:29:44', '2023-04-11', 'P2848', '23-04084-04-11', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Estrada pola Vía, 21', 'Nigrán', 'Pontevedra', '36350', 'España', 16.29, 0, '2023-04-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110423-OenAFJ2ciEzta-170', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-OenAFJ2ciEzta-170&s=KOL2023&nf=P2848&i=16.29&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3027, 1, 756, 2, 0, NULL, 0, '2023-04-11 22:16:32', '2023-04-12 09:37:52', '2023-04-11', 'P2849', '23-04087-04-11', '', 0.00, 49.15, 13.06, 0.00, 0, 0.00, 15.77, '15 Rue Pontcottier \"Le Quadrille\"', 'Bourgoin - Jallieu', 'Isère', '38300', 'Francia', 75.24, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110423-ZWa3NDOVan9ef-021', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110423-ZWa3NDOVan9ef-021&s=KOL2023&nf=P2849&i=75.23&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3028, 1, 757, 2, 0, NULL, 0, '2023-04-12 07:55:36', '2023-04-12 10:13:40', '2023-04-12', 'P2850', '23-04088-04-12', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Estrada Soutomaior 22, 3ºD', 'Soutomaior', 'Pontevedra', '36690', 'España', 26.40, 0, '2023-04-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120423-L55C0/1j7MAex-230', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120423-L55C0%2F1j7MAex-230&s=KOL2023&nf=P2850&i=26.40&cr=212', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3029, 1, 144, 2, 0, NULL, 0, '2023-04-12 08:09:16', '2023-04-12 10:23:24', '2023-04-12', 'P2851', '23-04089-04-12', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 137.94, 0, '2023-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120423-m6MYPtn5K2490-246', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120423-m6MYPtn5K2490-246&s=KOL2023&nf=P2851&i=137.94&cr=089', '[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
(3030, 1, 160, 2, 0, NULL, 0, '2023-04-12 10:04:57', '2023-04-12 12:29:06', '2023-04-12', 'P2852', '23-04090-04-12', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 137.94, 0, '2023-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120423-V2uJtzJgIp68W-135', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120423-V2uJtzJgIp68W-135&s=KOL2023&nf=P2852&i=137.94&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3031, 1, 50, 2, 0, NULL, 0, '2023-04-12 11:20:00', '2023-04-12 13:21:41', '2023-04-12', 'P2853', '23-04091-04-12', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'CALLE ELTZETA 3, BAJO', 'LESAKA', 'NAVARRA', '31770', 'ESPAÑA', 137.94, 0, '2023-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120423-NfxJe5dge/Wjk-169', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120423-NfxJe5dge%2FWjk-169&s=KOL2023&nf=P2853&i=137.94&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3032, 1, 758, 2, 0, NULL, 0, '2023-04-12 17:44:00', '2023-04-13 09:21:33', '2023-04-12', 'P2854', '23-04092-04-12', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'Avda Pintor Fernando Soria 14 Bloque 1 Esc 3,3°A dcha', 'Alicante/Alacant', 'Alicante', '03540', 'España', 55.89, 0, '2023-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120423-XJN3N2U+PZYNS-044', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120423-XJN3N2U%2BPZYNS-044&s=KOL2023&nf=P2854&i=55.89&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3033, 1, 659, 2, 0, NULL, 0, '2023-04-12 21:12:57', '2023-04-13 09:24:00', '2023-04-12', 'P2855', '23-04102-04-12', '', 0.00, 28.01, 6.65, 0.00, 0, 0.00, 4.40, 'C/San Lázaro, 11', 'Medina del Campo', 'Valladolid', '47400', 'España', 38.29, 0, '2023-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120423-DYk6Ra8p08rVp-234', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120423-DYk6Ra8p08rVp-234&s=KOL2023&nf=P2855&i=38.29&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3034, 1, 754, 2, 0, NULL, 0, '2023-04-13 09:05:25', '2023-04-18 10:39:57', '2023-04-13', 'P2856', '23-04103-04-13', '', 0.00, 51.80, 10.88, 0.00, 1, 2.69, 0.00, 'Josep Tarradellas 166 2º 1º', 'Amposta', 'Tarragona', '43870', 'España', 65.37, 0, '2023-04-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130423-bHWwhD1sZcPxw-045', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130423-bHWwhD1sZcPxw-045&s=KOL2023&nf=P2856&i=65.37&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3035, 1, 65, 2, 0, NULL, 0, '2023-04-13 10:51:58', '2024-07-17 13:06:31', '2023-04-13', 'P2857', '23-04104-04-13', '', 0.00, 627.00, 131.67, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 758.67, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130423-IPv26b3hCUGo9-035', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130423-IPv26b3hCUGo9-035&s=KOL2023&nf=P2857&i=758.67&cr=082', '[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
(3036, 1, 79, 2, 0, NULL, 0, '2023-04-13 11:15:30', '2023-04-13 13:16:06', '2023-04-13', 'P2858', '23-04105-04-13', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'Calle María Paya 8', 'Biar', 'Alicante', '03410', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130423-T5Hbylc+y0DE8-158', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130423-T5Hbylc%2By0DE8-158&s=KOL2023&nf=P2858&i=174.93&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3037, 1, 262, 2, 0, NULL, 0, '2023-04-13 16:28:29', '2023-04-14 09:15:14', '2023-04-13', 'P2859', '23-04106-04-13', 'Horario: martes a viernes de 9h a 13h y de 16h a 19h', 0.00, 115.10, 24.17, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 139.27, 0, '2023-04-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130423-TDy4roXcExifP-058', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130423-TDy4roXcExifP-058&s=KOL2023&nf=P2859&i=139.27&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3038, 1, 375, 2, 0, NULL, 0, '2023-04-14 17:13:22', '2023-04-17 09:02:39', '2023-04-14', 'P2860', '23-04108-04-14', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Mayor 12', 'Asteasu', 'Gipuzkoa', '20159', 'España', 26.40, 0, '2023-04-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140423-EkZJAy00dD2hw-203', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140423-EkZJAy00dD2hw-203&s=KOL2023&nf=P2860&i=26.40&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3039, 1, 4, 2, 0, NULL, 0, '2023-04-14 18:05:14', '2023-04-20 08:50:51', '2023-04-14', 'P2861', '23-04110-04-14', '', 0.00, 329.40, 69.17, 0.00, 0, 0.00, 0.00, 'Plazuela de San Martín 4, bajo', 'VITORIA -GAZTEIZ', 'ALAVA', '01009', 'ESPAÑA', 398.57, 0, '2023-04-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140423-ebPEvYyBWJrrH-156', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140423-ebPEvYyBWJrrH-156&s=KOL2023&nf=P2861&i=398.57&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3040, 1, 759, 2, 0, NULL, 0, '2023-04-14 19:38:03', '2023-04-17 09:11:54', '2023-04-14', 'P2862', '23-04111-04-14', 'Edificio Caixabank. Hay que subir las escaleras para entregar el paquete. Gracias.  ', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Calle del Pintor Sorolla, 8', 'Valencia', 'Valencia', '46002', 'España', 59.47, 0, '2023-04-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140423-VLJ8losbwDmkY-069', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140423-VLJ8losbwDmkY-069&s=KOL2023&nf=P2862&i=59.47&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3041, 1, 760, 2, 0, NULL, 0, '2023-04-15 08:18:00', '2023-04-17 09:12:59', '2023-04-15', 'P2863', '23-04112-04-15', 'Entregar por las mañanas', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Centro Salud La Marina,C/ Castilla s.n', 'Santander', 'Cantabria', '39009', 'España', 16.29, 0, '2023-04-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150423-QE+BE+3I2ItUU-229', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150423-QE%2BBE%2B3I2ItUU-229&s=KOL2023&nf=P2863&i=16.29&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
