select top 10 a,b,c, t2.* from t1 left join t2 on right(t1.fa,5)=t2.fb
where (1=1) and ( (f1>3) or (f2>2) and (f3>4) or f5>1 and (f6>3 or f7<3) orf9=8 )