Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT distinct
- hd.horario_locgps_codigo
- ,lgd.locgps_longitud
- ,lgd.locgps_latitud
- ,hp.horario_sentido
- ,hp.horario_media_vuelta
- ,hp.horario_id
- ,lgd.locgps_nombre
- ,hd.horario_hora_salida
- FROM horario_final hd
- LEFT JOIN localidad_gps lgd ON lgd.locgps_codigo = hd.horario_locgps_codigo AND lgd.locgps_codigo > ''
- LEFT JOIN horario_cabecera on horc_id=hd.horario_id
- LEFT JOIN localidad ld on ld.localidad_id = hd.horario_origen
- LEFT JOIN vehiculoestado on ves_id_horario = horc_id
- and ves_horario_fecha = date(now())
- Left join horario_final hp on hp.horario_id = horc_id and hp.horario_locgps_codigo > ''
- LEFT JOIN localidad_gps lgp ON lgp.locgps_codigo = hp.horario_locgps_codigo AND lgp.locgps_codigo > ''
- where lgd.locgps_latitud is not null
- and lgd.locgps_longitud is not null
- and coalesce(upper(ld.localidad_desc_publica),'si') <> 'NO'
- and coalesce(upper(hd.horario_leyenda),'si') <> 'NO'
- and ves_serie is not null
- and hp.horario_hora_salida >= time(now())
- and (hp.horario_id =1503)order by hd.horario_locgps_codigo
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement