Q&A for people who like playing board games, designing board games or modifying the rules of existing board games
select postID , case when comment like 'to http://serverfault.com/%' then 'severfault' when comment like 'to http://meta.stackoverflow.com/%' then 'meta.so' when comment like 'to http://superuser.com/%' then 'superuser' when comment like 'to http://dba.stackexchange.com%' then 'dba.se' when comment like 'to http://programmers.stackexchange.com%' then 'programmers.se' end target , year(creationdate), month(creationDate) from postHistory where posthistoryTypeid in (17, 35) order by creationdate desc