로그인
고객센터
010-3494-6141
상담 : 오전9시~오후7시 (토요일,공휴일 휴무)
점심 : 오후12시~오후1시
정수기 고객감사 특별전

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('') 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