b.*,
s.log_text
FROM dashboard_mat b LEFT JOIN build_status_log s
- ON b.snapshot = s.snapshot AND s.log_stage = 'test-results.log'
+ ON b.sysname = s.sysname
+ AND b.snapshot = s.snapshot
+ AND s.log_stage = 'test-results.log'
ORDER BY b.branch = 'master' desc,
b.branch desc, $sort_clause
b.snapshot desc