select * from shop_goods a, shop_category b where a.ca_id = b.catecode and a.shop_state = '0' and a.isopen IN('1','2') and (a.use_aff = '0') and b.cateuse = '0' and find_in_set('admin', a.use_hide) = '0' and find_in_set('admin', b.catehide) = '0' and a.brand_uid = '126' order by index_no desc, a.index_no desc limit 0, 40

1052 : Column 'index_no' in order clause is ambiguous

error file : /shop/brandlist.php