SELECT id, nick_name, shop_calculate_result.* FROM mydb.shop_calculate_result
join member on shop_calculate_result.member_idx = member.idx
 order by shop_calculate_result.create_dt desc;