select
a.att1 as att1
,i.att2 as att2
,i.att3 as att3
,f.att4 as att4
,e.att5 as att5
,e.att6 as att6
,b.att7 as att7
,c.att8 as att8
,c.att9 as att9
,i.att10 as att10
from
tb1 as a
inner join a.key1 as b
inner join b.key2 as c
inner join c.key3 as d
inner join d.key4 as e
inner join b.key5 as f
inner join f.key6 as g
inner join f.key7 as h
inner join g.key8 as i
where a.cri = '1'
and g.cri = 'false'
.....