can you write the raw SQL for what you want to do? sounds like you need to do a sub-query with it's own grouping so that you can get the max start value, and then join those results into your outer query where you can group by something different.
if you can write the SQL then we'll be certain we are on the same page and it will be easier for us to help you translate to web2py. :) thanks, cfh
