0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT
  Posts.OwnerUserId,
  Posts.OwnerDisplayName,
  Posts.Id,
  Posts.PostTypeId,
  Posts.Title,
  Posts.CreationDate,
  Users.Id,
  Users.DisplayName
FROM
  Posts
JOIN
  Users ON Posts.OwnerUserId = Users.Id
WHERE
  Posts.Title IS NOT NULL
  AND (Users.Id = 13623640 OR Users.Id = 12732673)
ORDER BY
  Users.DisplayName ASC,
  Posts.CreationDate DESC;
--offset 0 rows
--fetch next 100 rows only;

fork query

edited feb 28

created feb 28 anonymous