*mysq

Чуваки, как сделать это лучшь и пизже?

SELECT distinct basename as bn,
(
select sum(all_traffic) from traffic WHERE src_ip in
(
select ip from resolves where basename = bn
)

) as t_sum
FROM resolves group by bn order by t_sum desc;

#ogstzo

3 comments