query and conversion completed

better query for summary page
This makes the same mistake as your original query - this inner select just returns random build ids.

You want retrieve tree,host,compiler in the inner select too and then JOIN on those fields.