SELECT MAX(testresults.build) as b, bitmaps.id, bitmaps.state FROM testresults, bitmaps WHERE testresults.bitmap = bitmaps.id AND testresults.test = 1 GROUP BY bitmaps.id ORDER BY b DESC;