Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `route_id`, `latitude`, `longitude`, `time` FROM `updates` `u`
- JOIN `routes` `r` ON `u`.`route_id` = `r`.`id`
- WHERE `u`.`bus_id`=%s AND
- `u`.`time` BETWEEN
- TIMESTAMP(%s, midpoint_time(`r`.`end_time`, `r`.`start_time`)) AND
- TIMESTAMP(DATE_ADD(%s, INTERVAL 1 DAY), midpoint_time(`r`.`end_time`, `r`.`start_time`))
- AND MOD(`u`.`id`, 3)=0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement