dssdfgdsfg

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