select * from shop_goods a left join shop_goods_type b on (a.index_no=b.gs_id) left join shop_brand c on (a.brand_uid=c.br_id) left join shop_partner_policy d on (a.gcode=d.gcode) where a.shop_state = '0' and isopen IN('1','2') and (use_aff = '0') and find_in_set('mirage1', use_hide) = '0' and a.gcode IN('1200040','1200041','1200042','1200043','1200044','1200045','1200046','1200036','1200035','1200034','1200037','1200038','1200039','1200048','1200051','1200047') and d.bf_use = '1' group by a.index_no order by bf_12_sub1_1 asc, a.index_no desc limit 0, 18
1052 : Column 'bf_12_sub1_1' in order clause is ambiguous
error file : /m/shop/planlist.php