SELECT q.Id, a.PostTypeId,a.Id, q.Title, q.Body,q.tags, q...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Japanese Language

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

SELECT q.Id, a.PostTypeId,a.Id, q.Title, q.Body,q.tags, q.AnswerCount, a.Body, a.AcceptedAnswerId, a.CreationDate
, case when a.posttypeid = 1 then 'Q' else 'A' end [Q/A]
from posts a
inner join posts q 
        on q.id = coalesce(a.parentid, a.id) -- only questions have tags
where q.tags like '%<##tag?python##>%'
and year(q.CreationDate) > 2018
and a.posttypeid in (1,2)
Order by q.Id

Enter Parameters

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