[flukus]

Won't this be flat out wrong when something you're joining to has a condition in the where clause? Something like this:

  select * from Car
  inner join Color on Car.ColorId = Color.Id
  where Color.Name = 'Red'

You can't get the correct paginated list of car id's without doing the join in the first query. Even more wrong if you're ordering off the joined table.