select id as id

0

Please login or register to vote for this query.

(click on this box to dismiss)

History

Q&A for historians and history buffs

select 
id as id,
CreationDate as create_at,
Body as content,
title as title,
AnswerCount as answers,
OwnerUserId as uid,
'1161785736040450'as tid,
tags
from posts as p
where (p.posttypeid=1) and (p.ClosedDate is null)  AND Tags in( '<##Tag##>','<##Tag2##>','<##Tag3##>')
 and  OwnerUserId is not null
and AnswerCount > 1
 and CreationDate > '2017-12-31'
 and CreationDate < '2019-12-31'

Enter Parameters

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