상품후기 쓰고 사은품 받자
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('1100091','1100074','1100076','1100071','1100070','1100065','1100067','1100004','1100008','1100012','1100038','1100026') and d.bf_use = '1' group by a.index_no order by bf_12_sub1_1 desc, a.index_no desc limit 0, 18
1052 : Column 'bf_12_sub1_1' in order clause is ambiguous
error file : /m/shop/planlist.php