Untitled

SELECT DISTINCT name, hn.room, hn.detail
FROM hostsummary AS hn
        INNER JOIN host AS h
                USING (hostid)
        INNER JOIN host2jack AS h2j
                USING (hostid)
        INNER JOIN jack AS jl
                USING (jackid)
WHERE (jl.room IN ('60-07', '60-10', '60-11', '60-17', '60-18') OR jl.room LIKE '88-%')
        AND name NOT IN ('LAPTOP GIG', 'LAPTOP 100')
        AND hn.room IS NOT NULL
ORDER BY hn.room ASC;