SELECT
min(dtime),max(dtime),count(*),destination,ipaddress,position[0] AS latitude ,position[1] AS longitude,country,city
FROM
traffic INNER JOIN nodePos ON traffic.destination = nodePos.nodeid
WHERE
MASKLEN(ipaddress) != '16'
GROUP BY
destination,ipaddress,country,city,position[0],position[1]
ORDER BY
ipaddress;
SELECT min(dtime),max(dtime),count(*),destination,min(doffset),max(doffset),ipaddress,position[0] AS latitude ,position[1] AS longitude,country,city
FROM
traffic INNER JOIN nodePos ON traffic.destination = nodePos.nodeid
WHERE
dport=80
GROUP BY
destination,ipaddress,country,city,position[0],position[1]
ORDER BY
ipaddress;
