successful (not between different kinds of failure).
JSG5QEZJTJJJ3VZS2CVQGRTD3QD63U4E6I7WSTWXN3K56QVLE27QC
SZYY2EQQK2JUAHMDPBASGWC2RON2GA5G6FHBLO4GAAX2XTM6QLSQC
J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC
x.id > c.id and r.buildstatus != r2.buildstatus)
x.id > c.id and ((r.buildstatus = 0 and r2.buildstatus != 0) or (r.buildstatus != 0 and r2.buildstatus = 0)))
x.id > c.id and
((r.buildstatus = 0 and r2.buildstatus != 0) or
(r.buildstatus != 0 and r2.buildstatus = 0)))