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_txcgq_xj'

封装：模块

外壳：模块

描述： CAMERA IR 80X60 50 DEGREE 9HZ

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_txcgq_xj'

封装：模块

外壳：模块

描述： CAMERA IR 80X60 50 DEG W/SHUTTER

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_txcgq_xj'

封装：模块

外壳：模块

描述： CAMERA IR 80X60 25 DEGREE 9HZ