Posts from MathOverflow an Mathematics with the same title and posted at the same time

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

---Posts from MathOverflow an Mathematics with the same title between two given dates
---Enter Date in the form: 2013-12-01
SELECT b.Title, a.CreationDate AS "MO Date",  b.CreationDate AS "MSE Date",
       ('http://mathoverflow.net/questions/' + CAST(a.Id AS varchar)) AS [MO Link], ('http://math.stackexchange.com/questions/' + CAST(b.Id AS varchar))
FROM [StackExchange.Mathoverflow]..[Posts] AS a JOIN [StackExchange.Math]..[Posts] AS b ON a.Title = b.Title
WHERE b.PostTypeId = 1
  AND b.CreationDate >= '##Date1##'
  AND b.CreationDate <= '##Date2##'
  and a.ClosedDate IS NULL
  and b.ClosedDate IS NULL
ORDER BY a.CreationDate;

Enter Parameters

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