select *
 FROM mg_pedido_preventa t0, mg_cliente t1
  WHERE (t0.codigo_cliente = t1.codigo_cliente) AND (t0.codigo_empresa = t1.codigo_empresa)
  AND (t0.codigo_empresa = 'GAI') AND t0.codigo_vendedor LIKE '%' AND t0.codigo_cliente LIKE '%'
  AND UPPER(t0.nombre_cliente) LIKE '%' AND t0.estado_pedido LIKE '%' AND (t0.bodega_despacho IN ('E12', 'G5', 'PT'))
  AND (t0.fecha_programada_envio >= '2014-10-27')
   AND (t0.fecha_programada_envio <= '3000-01-01')