- select timezone('GMT'::text, now())::timestamp(0) without time zone - b.snapshot AS when_ago, b.*
- from dashboard_mat b
- order by branch = 'master' desc,
- branch desc, $sort_clause
- snapshot desc
+ SELECT timezone('GMT'::text, now())::timestamp(0) without time zone - b.snapshot AS when_ago,
+ 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'
+ ORDER BY b.branch = 'master' desc,
+ b.branch desc, $sort_clause
+ b.snapshot desc