select b.TagId from Posts a left join PostTags b on a....

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

--select b.*,a.Tags from Posts a
--left join PostTags b on a.id = b.postid
--where creationdate between '2017-01-01' AND '2017-12-31'
--and a.id = '41412928'

--tagid 6398


select b.TagId from Posts a
left join PostTags b on a.id = b.postid
where creationdate between '2017-01-01' AND '2017-12-31'
--and Tags like '%css3%'
and PostId in ('41449680','41438403')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results