select
        id,
        name,
        weight,
        sum_count as total
from (
    select
        goods_id,
        sum(count) as sum_count
    from 
            trans
    group by
            goods_id
)a
left join 
        goods
on 
        a.goods_id = goods.id
where 
        sum_count > 20
and 
        weight < 50
order by
        id asc