0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

-- Enter Query Title
-- Enter Query Description

SELECT
  q.Id,
  q.Title,
  q.CreationDate
FROM
  Posts AS q
WHERE
  EXISTS (
    SELECT
      a.Id, 
      a.CreationDate,
      a.PostTypeId
    FROM
      Posts AS a
    WHERE
      a.OwnerUserId = 121096
      AND a.PostTypeId = 2
      AND a.Score >= 5
      AND a.ParentId = q.Id
    )
;

fork query

created jun 21 10 beggs