SELECT * FROM `pre_envios` where superado=0 and elim=0 and pais = 2 and fecha_venta > '2026-07-26 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)

-----------------------------------------------------------RTN Logistica 58

-----------------------------------------------------------AlphaGroup 61

-----------------------------------------------------------EnviosTeoRx 67

-----------------------------------------------------------TrepanChile 141

-----------------------------------------------------------Tu motorizado 183

-----------------------------------------------------------Stgo Courier 221

-----------------------------------------------------------Transporte ZM 305

-----------------------------------------------------------Linea Sport 342

-----------------------------------------------------------Amulen Spa 347

-----------------------------------------------------------Mautrack 348

-----------------------------------------------------------Brum Express 358

-----------------------------------------------------------Transalianza Spa 393

-----------------------------------------------------------Fastway Logistic 405