Anonymous

SELECT inet_aton(VastRuns.ip) AS bin_ip, VastRuns.ip,fulltcpnmapports.portid,GROUP_CONCAT(nessusnbe.category,nessusnbe.report   ORDER BY nessusnbe.portid + 0 ASC SEPARATOR "[|]") as concat_nessus from (VastRuns left join fulltcpnmapports ON (VastRuns.ip = fulltcpnmapports.ip ))  left join nessusnbe ON (VastRuns.ip = nessusnbe.ip and fulltcpnmapports.portid = nessusnbe.portid) where concat_nessus is not null group by fulltcpnmapports.portid order by bin_ip ;