0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students and teachers of all martial arts

declare @base_url varchar(100) = 'https://stackoverflow.com/questions/';

select posts.Title as 'Post Title',
      @base_url + convert(varchar(20), posts.Id) as 'URL',
      types.Name      
from Posts as posts
  inner join Votes as votes on votes.PostId = posts.Id
  inner join VoteTypes as types on types.Id = votes.VoteTypeId
where types.Name = 'Offensive'

view current version

edited apr 23 18

created apr 23 18 anonymous