select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_wfl'

封装：

外壳： -

描述：

select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_wfl'

封装：

外壳： -

描述：

select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_cgq_b_zycgq'

封装：-

外壳：-

描述： QCM SENSOR 9.176 MHZ THRU HOLE

select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_cgq_b_zycgq'

封装：-

外壳：-

描述： QCM SENSOR 9.176 MHZ SMD

select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_cgq_b_zycgq'

封装：-

外壳：-

描述： QCM SENSOR 30.834 MHZ THRU HOLE

select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_cgq_b_zycgq'

封装：-

外壳：-

描述： QCM SENSOR 30.834 MHZ SMD

select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_wfl'

封装：SMD

外壳： -

描述：