英雄推荐

with A as (SELECT * FROM `heidao-market.mafia1_dmd.exchange_info` WHERE DATE(timestamp) > "2010-09-21"  and item like '%21056810%')
select charge_id ,MAX(timestamp )as ma from A group by charge_id 

SELECT * FROM `heidao-market.mafia1_dmd.item_info` WHERE DATE(timestamp) >"2010-09-21" and para1 like '%10026%' and type=31