Unnamed

SELECT fulltcpnmapports.ip, COUNT(*) as cnt, GROUP_CONCAT(fulltcpnmapports.portid ORDER BY fulltcpnmapports.portid SEPARATOR ', ') as tcpport_list FROM fulltcpnmapports GROUP BY fulltcpnmap.ip ORDER BY fulltcpnmapports.ip;