select base.c1 baseid,
base.C700000001 baseschema,
dp2.turnSentCount,
from (select dp2.C700020001 baseid, count(*) turnSentCount
from T92 dp2
where dp2.C700020011 != '条件' having count(*) > 4
group by dp2.C700020001) dp2,
T581 base,
T92 dp
where dp2.baseid = base.c1
and dp.C700020001 = base.c1
and dp.C700020020 = '1'