0

Please login or register to vote for this query.

(click on this box to dismiss)

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

With Question(id, user_id, title, body, tags, creation_date, closed_date)
as
(
  select Id, OwnerUserId , Title, Body, Tags, CreationDate, ClosedDate
  from Posts
  WHERE 
    PostTypeId = 1  and ClosedDate is null 
    and CreationDate >= '2019-10-25' and CreationDate <= '2019-11-01'
)

SELECT 
    p.Body,
    q.tags,
    p.Id as A_id,
    concat(q.title, '. ', q.body) as Questions,
    q.id as Q_id,
    q.creation_date as Q_CreateDate
FROM
    Posts AS p, Question as q
WHERE 
    PostTypeId = 2 and p.ParentId = q.id and p.OwnerUserId != q.user_id
order by q.creation_date, q.id

fork query

edited nov 17

created nov 17 jon.doe32564