0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

Select TOP 10 TempPost.Id, TempPost.Body, TempPost.CommentCount
From Posts TempPost Left Join Comments TempCom
On TempPost.Id = TempCom.PostId
Where TempCom.Id is NULL
and
TempPost.Id in
(Select NewTempUser.Id
From Users NewTempUser Left Join Posts NewTempPost
On NewTempUser.Id = NewTempPost.OwnerUserId
where NewTempPost.ID Is NULL Or NewTempPost.PostTypeId = 1
Group By NewTempUser.Id
Having Count(NewTempPost.ID) = 0)

fork query

edited nov 28 20

created nov 28 20 anonymous