select t1.id, t1.acceptedanswerid, t1.creationdate, t1.sc...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Windows Phone Meta

Q&A about the site for enthusiasts and power users of Windows Phone OS

select t1.id, t1.acceptedanswerid, t1.creationdate, t1.score, t1.viewcount,
t1.title, t1.body, t1.tags, t1.commentcount, t1.answercount, 
t3.tagname, t5.relatedpostid
from posts t1 inner join posttags t2 on
t1.id = t2.postid 
inner join tags t3 on t2.tagid = t3.id 
inner join postlinks t5 on t1.id = t5.postid
where
t1.viewcount > 500
and t1.posttypeid = 1
and (t3.tagname = 'java' or t3.tagname = 'python' or t3.tagname = 'javascript')
and t1.CreationDate < '2020-12-01'
and t1.CreationDate > '2020-01-01'
and t1.score >= 0
and t5.linktypeid = 1
order by t1.id

Enter Parameters

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