Q&A since 2020 with User Rep

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

select  
FORMAT(p1.CreationDate, 'yyyy-MM-dd hh:mm:ss') AS Q_CreateDate,
FORMAT(p2.CreationDate, 'yyyy-MM-dd hh:mm:ss') AS A_CreateDate,
p1.Id as Q_Id,
p2.Id as A_Id,
p1.Title as Question, 
p1.Body as Description, 
p1.AcceptedAnswerID,
p2.Body as Answer, 
p2.ParentId, 
p1.Score AS Q_Score, 
p2.Score AS A_Score, 
u.Reputation as A_User_Reputation,
u.id as U_Id_A,
FORMAT(p1.LastActivityDate, 'yyyy-MM-dd hh:mm:ss') AS Q_LActivityDate,
FORMAT(p2.LastActivityDate, 'yyyy-MM-dd hh:mm:ss') AS A_LActivityDate,
FORMAT(p1.ClosedDate, 'yyyy-MM-dd hh:mm:ss') AS Q_ClosedDate,
FORMAT(p2.ClosedDate, 'yyyy-MM-dd hh:mm:ss') AS A_ClosedDate,
p1.AnswerCount, 
p1.CommentCount as Q_CommentCount, 
p2.CommentCount as A_CommentCount, 
p1.Tags FROM Posts p1 INNER JOIN Posts p2 ON p1.Id = p2.ParentId
INNER JOIN Users as u on p2.OwnerUserId = u.id
where (p1.CreationDate like '%2020%' OR  p1.CreationDate like '%2021%') AND (p1.PostTypeId = 1 AND p2.PostTypeId = 2)
order by p1.Id, A_CreateDate

Enter Parameters

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