Generic query about a bunch of posts based on postID

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select --top 100
p.id as [Post Link]
, owneruserid as [User Link]
, creationdate
, tags
from posts p
where p.id in (
1072540,
10810,
109553,
1512218,
169222,
171519,
172486,
173329,
18773,
189555,
211169,
216110,
22135,
240283,
277044,
295628,
31326,
338385,
3437,
34632744,
34979509,
35183488,
36167750,
36877,
454355,
459248,
4753643,
521101,
5408971,
6463152,
73781,
7551,
950928)



--inner join posttags pt on p.id = pt.postid
--inner join tags t on t.id = pt.tagid
--where t.tagname = 'c++'
--and p.answercount =0

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results