0

Please login or register to vote for this query.

(click on this box to dismiss)

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, t1.posttypeid
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

fork query

edited feb 25 anonymous

created feb 22 kiii183