SELECT * FROM `pre_envios` where superado=0 and elim=0 and pais = 1 and fecha_venta > '2026-07-25 00:00:00' and status not in ('cancelled','canceled') and sync != -1 and fulfillment = 1 and (synclightdata=0 OR didEmpresa = 231) and didEmpresa NOT IN (334)

-----------------------------------------------------------Megapack 2

-----------------------------------------------------------Procourrier 4

-----------------------------------------------------------Planet 12

-----------------------------------------------------------Express Flex 17

-----------------------------------------------------------Rabion Flex 20

-----------------------------------------------------------Thesend 24

-----------------------------------------------------------RM Logistics 34

-----------------------------------------------------------GT Pack 41

-----------------------------------------------------------Sobre alas 42

-----------------------------------------------------------GoFlexpress 47

-----------------------------------------------------------Mamut Logistica 49

-----------------------------------------------------------Jn Logistica 51

-----------------------------------------------------------Papexpress 54

-----------------------------------------------------------Zuiden 55

-----------------------------------------------------------Wyn Flex 72

-----------------------------------------------------------TransporteMG 76

-----------------------------------------------------------EntregoYa 79

-----------------------------------------------------------deliverybox 82

-----------------------------------------------------------Nexoflex 87

-----------------------------------------------------------aglogisticaexpress 94

-----------------------------------------------------------EnBox 97

-----------------------------------------------------------Inmediato Logistica 102

-----------------------------------------------------------LM Servicio Logistico 103

-----------------------------------------------------------Startshipping 104

-----------------------------------------------------------Lambda Logistica 105

-----------------------------------------------------------LogisticaS3 108

-----------------------------------------------------------SINLOG 109

-----------------------------------------------------------Dac Logistica 110

-----------------------------------------------------------FastCorreo 111

-----------------------------------------------------------LOGISTICA ENTREGAS 115

-----------------------------------------------------------Bairesmensajeria 117

-----------------------------------------------------------Logisticafbflex 124

-----------------------------------------------------------Flexit 125

-----------------------------------------------------------LF 130

-----------------------------------------------------------Milla Sur 131

-----------------------------------------------------------IntiExpress 132

-----------------------------------------------------------Quickpack 135

-----------------------------------------------------------E-Envios 136

-----------------------------------------------------------JMK Logistica 137

-----------------------------------------------------------Cyro Flex 144

-----------------------------------------------------------Soluciones logisticas sur 146

-----------------------------------------------------------LogisticaValentino 157

-----------------------------------------------------------SeanUnidos 159

-----------------------------------------------------------FlexAenvios 162

-----------------------------------------------------------CreadoLogistica 164

-----------------------------------------------------------LIONNES 165

-----------------------------------------------------------jlslogistica 167

-----------------------------------------------------------Ultrajet 173

-----------------------------------------------------------PrimeLogistik 175

-----------------------------------------------------------Yending 176

-----------------------------------------------------------Confiable 177

-----------------------------------------------------------Rueddo 178

-----------------------------------------------------------Servibox 186

-----------------------------------------------------------Soluciones flex 188

-----------------------------------------------------------MailingExpress 191

-----------------------------------------------------------LOGISTICA GLOBAL 192

-----------------------------------------------------------FingerInc 194

-----------------------------------------------------------Brat Logística 195

-----------------------------------------------------------Envios QP 198

-----------------------------------------------------------Riders 201

-----------------------------------------------------------Fletestore 202

-----------------------------------------------------------AmbaLogistica 203

-----------------------------------------------------------Dar Logistica 204

-----------------------------------------------------------Simplex 205

-----------------------------------------------------------CG Envios 206

-----------------------------------------------------------E3logistica 207

-----------------------------------------------------------Zeta Llegue 211

-----------------------------------------------------------BH Flex 214

-----------------------------------------------------------Motos Duo 215

-----------------------------------------------------------Ya! Envios 217

-----------------------------------------------------------Full Pack 224

-----------------------------------------------------------Hogareño 230

-----------------------------------------------------------Logistica CEV 231

-----------------------------------------------------------Logistica VIP EXPRESS 234

-----------------------------------------------------------EnviosFlex 237

-----------------------------------------------------------Ozshipping 238

-----------------------------------------------------------RDZ 241

-----------------------------------------------------------JJ Logistica 243

-----------------------------------------------------------Logistica Shipment 247

-----------------------------------------------------------Seven Express 249

-----------------------------------------------------------Neez 251

-----------------------------------------------------------MercadoPacks 253

-----------------------------------------------------------Henu 254

-----------------------------------------------------------Logística fox 256

-----------------------------------------------------------Transtech 257

-----------------------------------------------------------Ecoflex 260

-----------------------------------------------------------LOGÍSTICA PREMIER 265

-----------------------------------------------------------Logistica Entregas del Sur 266

-----------------------------------------------------------ADN-DGROUP 267

-----------------------------------------------------------MULTI CANNING 268

-----------------------------------------------------------DemoRutma 270

-----------------------------------------------------------EnviosYa 271

-----------------------------------------------------------LOGTAC 272

-----------------------------------------------------------GURA! 273

-----------------------------------------------------------Diaz Home 274

-----------------------------------------------------------Demo Lightdata 275

-----------------------------------------------------------Procourrier 276

-----------------------------------------------------------Logistica KCHI 278

-----------------------------------------------------------Logistica JYL 280

-----------------------------------------------------------Logistica Express 282

-----------------------------------------------------------Logistica Urbik 286

-----------------------------------------------------------New Garden 287

-----------------------------------------------------------King Flex 288

-----------------------------------------------------------Grupo Elite 293

-----------------------------------------------------------Logistica CT 294

-----------------------------------------------------------Colucci 297

-----------------------------------------------------------Logística Nasere 302

-----------------------------------------------------------MT Logistica 306

-----------------------------------------------------------App Express 309

-----------------------------------------------------------YIP 310

-----------------------------------------------------------Via Urbana 312

-----------------------------------------------------------CargoXpres 313

-----------------------------------------------------------Rueddo Rosario 314

-----------------------------------------------------------Dahe Logistica 316

-----------------------------------------------------------New Track Co 317

-----------------------------------------------------------Mi Pack 319

-----------------------------------------------------------Logística Integración 321

-----------------------------------------------------------Flex Solutions 322

-----------------------------------------------------------Flexi Pack 323

-----------------------------------------------------------EBP 326

-----------------------------------------------------------AurexBox 327

-----------------------------------------------------------Rueddo MDQ 329

-----------------------------------------------------------BRU-RAM 331

-----------------------------------------------------------Fune Flex 333

-----------------------------------------------------------JM 334

-----------------------------------------------------------Servicios Flex 335

-----------------------------------------------------------Snow Flex 336

-----------------------------------------------------------La eficaz 337

-----------------------------------------------------------Envios Dex 338

-----------------------------------------------------------Reparto Leo 340

-----------------------------------------------------------Logistica ABBA 341

-----------------------------------------------------------Logistica Tiosohogar 343

-----------------------------------------------------------Abastanza 344

-----------------------------------------------------------EnviosJas 349

-----------------------------------------------------------Tornus 350

-----------------------------------------------------------Logistica TMD 351

-----------------------------------------------------------Grupo Reba 352

-----------------------------------------------------------Logistica Flex 354

-----------------------------------------------------------Logistica led 355

-----------------------------------------------------------CGZ Logística 357

-----------------------------------------------------------Flux Logisitica 360

-----------------------------------------------------------Punto Carga 361

-----------------------------------------------------------CORREO POSTINO 362

-----------------------------------------------------------Ventajas Logistica y Distribución 363

-----------------------------------------------------------GM Logistica 364

-----------------------------------------------------------Rueddo Santa Fe 365

-----------------------------------------------------------Entregado 367

-----------------------------------------------------------Romano Logistica 368

-----------------------------------------------------------Place it 369

-----------------------------------------------------------Envios Lego 370

-----------------------------------------------------------Speed Solutions 371

-----------------------------------------------------------Flex Suipacha 372

-----------------------------------------------------------JYJ 373

-----------------------------------------------------------UJ Logistica 375

-----------------------------------------------------------FlexGo 376

-----------------------------------------------------------GoSpin 377

-----------------------------------------------------------HDM Express 378

-----------------------------------------------------------ENVI.AR LOGISTICA Y DISTRIBUCIÓN 379

-----------------------------------------------------------Mendoza Express 380

-----------------------------------------------------------Red Logistica 381

-----------------------------------------------------------Servicios Integrales 382

-----------------------------------------------------------GEA logística 383

-----------------------------------------------------------Transfer Mailing 384

-----------------------------------------------------------Motomensajeria Roman y Alf 385

-----------------------------------------------------------Blitzz Express S.R.L. 386

-----------------------------------------------------------BoxoFlex 387

-----------------------------------------------------------Uruz Logistica 388

-----------------------------------------------------------Rapiflex Logistica 389

-----------------------------------------------------------Motomensajeria Urbana 390

-----------------------------------------------------------SP Flex 392

-----------------------------------------------------------Transporte Capece 394

-----------------------------------------------------------Logistica Constitución 395

-----------------------------------------------------------Eagle 396

-----------------------------------------------------------Nethub 397

-----------------------------------------------------------Unifast 398

-----------------------------------------------------------Red Urbana 399

-----------------------------------------------------------Bicimensajeros 400

-----------------------------------------------------------Carrizo-Banchiero 401

-----------------------------------------------------------Correo eflet 402

-----------------------------------------------------------MBL Logistica 403

-----------------------------------------------------------Logistica La Galera 404

-----------------------------------------------------------NinjaDrop 406

-----------------------------------------------------------logistica luz de angel 407

-----------------------------------------------------------demo l3 408

-----------------------------------------------------------demo premium l3 409

-----------------------------------------------------------Logistica Maipah y Zeta 410

-----------------------------------------------------------Elyon Pack 411

-----------------------------------------------------------Punto Atlas 412

-----------------------------------------------------------Novex 413

-----------------------------------------------------------Logistica Irala 414

-----------------------------------------------------------Logistica El Suizo 415

-----------------------------------------------------------Melipacks 416

-----------------------------------------------------------PICKIT 417