Selecting a value from a row where another column is max
In your case you can simply exchange the column names, but remember that text sorts differently then integer 1.10 comes before 1.2, so if you get such numbers you have to check and change your approach. see https://lists.mysql.com/mysql/183349
SELECT bug.`id`,
       Max(report.`date`),
       Count(report.`id`),
       Max(version.`name`),
       bug.`id`
FROM   `bug`
       LEFT OUTER JOIN `stacktrace`
                    ON ( stacktrace.`bug_id` = bug.`id` )
       CROSS JOIN `version`
                  LEFT OUTER JOIN `report`
                               ON ( report.`stacktrace_id` = stacktrace.`id` )
WHERE  stacktrace.`version_id` = version.`id`
GROUP  BY bug.`id`
ORDER  BY Max(report.`date`) DESC;