0

Please login or register to vote for this query.

(click on this box to dismiss)

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

select top 50000 p1.id as p1_Id, p1.PostTypeId as p1_PostTypeId,
p1.AcceptedAnswerId as p1_AcceptedAnswerId, p1.CreationDate as p1_CreationDate,
p1.DeletionDate as p1_DeletionDate, p1.Score as p1_Score, p1.ViewCount as p1_ViewCount,
p1.Body as p1_Body, p1.OwnerUserId as p1_OwnerUserId, p1.OwnerDisplayName as p1_OwnerDisplayName,
p1.LastEditorUserId as p1_LastEditorUserId, p1.LastEditorDisplayName as p1_LastEditorDisplayName,
p1.LastEditDate as p1_LastEditDate, p1.LastActivityDate as p1_LastActivityDate,
p1.Title as p1_Title, p1.Tags as p1_Tags, p1.AnswerCount as p1_AnswerCount,
p1.CommentCount as p1_CommentCount, p1.FavoriteCount as p1_FavoriteCount,
p1.ClosedDate as p1_ClosedDate, p1.CommunityOwnedDate as p1_CommunityOwnedDate,
p2.id as p2_Id, p2.PostTypeId as p2_PostTypeId,
p2.AcceptedAnswerId as p2_AcceptedAnswerId, p2.ParentId as p2_ParentId,
p2.CreationDate as p2_CreationDate,
p2.DeletionDate as p2_DeletionDate, p2.Score as p2_Score, p2.ViewCount as p2_ViewCount,
p2.Body as p2_Body, p2.OwnerUserId as p2_OwnerUserId, p2.OwnerDisplayName as p2_OwnerDisplayName,
p2.LastEditorUserId as p2_LastEditorUserId, p2.LastEditorDisplayName as p2_LastEditorDisplayName,
p2.LastEditDate as p2_LastEditDate, p2.LastActivityDate as p2_LastActivityDate,
p2.Title as p2_Title, p2.Tags as p2_Tags, p2.AnswerCount as p2_AnswerCount,
p2.CommentCount as p2_CommentCount, p2.FavoriteCount as p2_FavoriteCount,
p2.ClosedDate as p2_ClosedDate, p2.CommunityOwnedDate as p2_CommunityOwnedDate,
u1.id as u1_Id, u1.Reputation as u1_Reputation,
u2.id as u2_Id, u2.Reputation as u2_Reputation, u2.CreationDate as u2_CreationDate,
u2.Views as u2_Views, u2.UpVotes as u2_UpVotes, u2.DownVotes as u2_DownVotes
from ((posts as p1 left join posts as p2 on p1.id=p2.parentid) left join
users as u1 on p1.OwnerUserId = u1.id) left join users as u2 on
p2.OwnerUserId = u2.id
where p1.PostTypeID = 1 and p1.CreationDate > '2018-02-06' and
p1.CreationDate < '2018-05-06'
order by p1.CreationDate desc

fork query

created jul 15 18 anonymous