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 and posted at the same time
SELECT b.Title, a.CreationDate AS "MO Date",  b.CreationDate AS "MSE Date",
       ('http://mathoverflow.net/questions/' + CAST(a.Id AS varchar)), 
       ('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 ABS(DATEDIFF(hh,a.CreationDate,b.CreationDate)) <= 12 
  and a.ClosedDate IS NULL
  and b.ClosedDate IS NULL
ORDER BY a.CreationDate;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results