SELECT inet_aton(VastRuns.ip) AS bin_ip, VastRuns.ip,fulltcpnmapports.portid,fulltcpnmapports.service,ftpbanner.banner,smtpbanner.banner,sshbanner.banner,httpbanner.banner,httpsbanner.banner,imapbanner.banner  from (((((((VastRuns left join fulltcpnmapports ON (VastRuns.ip = fulltcpnmapports.ip ))  left join ftpbanner ON (VastRuns.ip = ftpbanner.ip and fulltcpnmapports.portid = ftpbanner.portid)) left join smtpbanner ON (VastRuns.ip = smtpbanner.ip and fulltcpnmapports.portid = smtpbanner.portid)) left join sshbanner ON (VastRuns.ip = sshbanner.ip and fulltcpnmapports.portid = sshbanner.portid)) left join httpbanner ON (VastRuns.ip = httpbanner.ip and fulltcpnmapports.portid = httpbanner.portid)) left join httpsbanner ON (VastRuns.ip = httpsbanner.ip and fulltcpnmapports.portid = httpsbanner.portid)) left join imapbanner ON (VastRuns.ip = imapbanner.ip and fulltcpnmapports.portid = imapbanner.portid)) group by VastRuns.ip order by bin_ip,fulltcpnmapports.portid +0 asc