select fields, sum(otherFields)
from table1
where table1.field1 in (Select table2.field1
                        from table2
                        where table1.id=table2.id
                        order by table2.date desc limit 100)
group by fields

select fields, sum(otherFields)
    from table1
    where exists (Select table2.field1
                   from table 2
                   where table1.id=table2.id
                     and table1.field=table2.fields
                   order by table2.date desc limit 100)
    group by fields