where
(
_t9011.tf_departmentId like '001030%'
or _t9011.tf_departmentId like '001020%'
)
and _t6010.tf_customerId in (
'1','2','3','4','5'
)
and (
_t7016.tf_tradeId like '10%'
or _t7016.tf_tradeId like '1106%'
or _t7016.tf_tradeId like '1105%'
or _t7016.tf_tradeId like '1104%'
or _t7016.tf_tradeId like '1103%'
or _t7016.tf_tradeId like '1102%'
or _t7016.tf_tradeId like '12%'
)
and _t7010.tf_district in (
'华北地区','华东地区','华南地区'
)