select * from foo where ID between 50000 and 1000000