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;