Select Q.ID as Q_Id, A.Id as A_Id, Q.Title as Title, Q.Bo...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

Select Q.ID as Q_Id, A.Id as A_Id, 
Q.Title as Title, 
Q.Body as Question, A.Body as Answer, Q.Tags as Tags,
Q.OwnerUserId as Q_UserId, QU.DisplayName as Q_Name,
A.OwnerUserId as A_UserId, AU.DisplayName as A_Name,
Q.Score as Q_Score, A.Score as A_Score, 
Q.FavoriteCount as Q_FavoriteCount, A.FavoriteCount as A_FavoriteCount,
Q.AnswerCount as Q_AnsCnt, 
Q.CreationDate as Q_CreateDate, A.CreationDate as A_CreateDate, 
Q.ClosedDate as Q_ClosedDate,
Q.LastActivityDate as Q_LastActivityDate, 
A.LastActivityDate as A_LastActivityDate
From Posts A
Left Join 
Posts Q On A.Id = Q.AcceptedAnswerId
Left Join
Users QU on Q.OwnerUserId = QU.Id
Left Join
Users AU on A.OwnerUserId = AU.Id
Where (Q.Tags is not null
and 
Q.CreationDate >= '2019-07-01')

Enter Parameters

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