SELECT (SELECT DisplayName FROM Users WHERE OwnerUserId =...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

SELECT
  (SELECT DisplayName FROM Users WHERE OwnerUserId = Users.Id) Owner,
  D Fecha,
  (SELECT Name FROM PostTypes WHERE PostTypeId = PostTypes.Id) Tipo,
  Score Puntos,
  CONCAT(ParentTags, Tags) Etiquetas
FROM
(
  SELECT
    OwnerUserId,
    CONVERT (DATE, CreationDate) D,
    PostTypeId,
    Score,
    (SELECT Tags FROM Posts WHERE P.ParentId = Id) ParentTags,
    Tags
  FROM
    Posts P
  WHERE
    OwnerUserId IN (2742, 463, 19610, 7123)  AND
    PostTypeId IN (1, 2)
) X

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results