11

Please login or register to vote for this query.

(click on this box to dismiss)

Searches for open, non-CW posts older than 60 days with no accepted answer and no answer scoring 2 or more. (Now updated so merged questions do not appear.)

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT
    p.Id AS [Post Link], t.name as [Edit type]
FROM
    Posts p
INNER JOIN 
    PostHistory h ON h.PostId = p.Id
INNER JOIN 
    PostHistoryTypes t ON t.Id = h.PostHistoryTypeId 
WHERE 
    p.ParentID IS NULL AND t.Id = 18

view current version

edited mar 28 12

created dec 17 11 mattdm