test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Hinduism Meta

Q&A about the site for followers of the Hindu religion and those interested in learning more about Hinduism

SELECT Posts.Id as [Post_Link_Id], 
Posts.Score as [Question_Score],
Posts.ViewCount,
Posts.Title As [Question_Title],
Posts.Body As [Question_Content],
Answers.Body AS [Best_Answer],
Posts.Tags AS [Tags],
Posts.CreationDate AS [Create_Date]



From Posts
left join Posts As Answers 
        ON Answers.parentid = Posts.id
        AND Answers.posttypeid = 2

WHERE Posts.PostTypeId = 1 AND 
YEAR(Posts.CreationDate) BETWEEN 2017 AND 2019 AND
Posts.AcceptedAnswerId = Answers.Id AND
Posts.Tags LIKE '%python%' AND
Posts.Title NOT LIKE '%why%' AND 
Posts.Title NOT LIKE '%Why%'

GROUP BY
Posts.Id, Posts.CreationDate, Posts.Score, Posts.ViewCount, Posts.Title, Posts.ViewCount, Answers.Body, Posts.Body, Posts.AcceptedAnswerId, Answers.Id, Posts.Tags

HAVING Answers.Body LIKE '%def %'

Enter Parameters

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