CREATE VIEW irclog_channels AS SELECT DISTINCT(channel) FROM irclog;