gistfile1.sql

select c.channel
from channels c
where c.id in (select ct.channelid
			   from channel_tags ct 
			   join tags t on ct.tagid = t.id
			   where t.tag = 'tag 1')
  and c.id in (select ct.channelid
               from channel_tags ct 
               join tags t on ct.tagid = t.id
               where t.tag = 'tag 2')

select c.channel
  from channels c
  join channel_tags ct on c.id = ct.channelid
  join tags t on t.id = ct.tagid
 where t.tag in ('tag 1', 'tag 2')
group by c.channel, 
         ct.channelid
  having COUNT(ct.channelid) = 2