Q&A for experienced flyers, pilots, and builders of drones and model aircraft
select top 100 posts.id [Post Link]
inner join posttags pt on pt.postid = posts.id
inner join tags t on t.id = pt.tagid
where posttypeid = 1 -- Q
and answercount = 0
and closeddate is null
and commentcount = 0
and tagname = 'java'
and cast(creationdate as date) = '2021-01-15'
order by creationdate desc