0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Muslims, experts in Islam, and those interested in learning more about Islam

SELECT 
	q.Id AS QID,
	qh.PostHistoryTypeId,
	qh.Text AS QInitialTitle
FROM
	Posts q
	LEFT JOIN
	Posts a
	ON (q.Id = a.ParentId)
	LEFT JOIN
	PostHistory qh
	ON (q.Id = qh.PostId)
WHERE
	q.PostTypeId = 1 AND
	q.ClosedDate IS NULL AND
    (a.Id IS NULL OR q.OwnerUserId <> a.OwnerUserId) AND
	q.CreationDate >= '2017-10-02 00:00:00.0' AND
	qh.PostHistoryTypeId = 3
ORDER BY
	q.Id

fork query

created oct 21 17 anonymous