select distinct id, (select min(time) table1 b where status=10 and b.id=a.id) as MINTIME
,(select max(time) table1 c where status=11 and c.id=a.id) as MAXTIME from table1 a
,(select max(time) table1 c where status=11 and c.id=a.id) as MAXTIME from table1 a
,(select max(time) from table1 c where status=11 and c.id=a.id) as MAXTIME from table1 a