Post mentions 'data.table'

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

-- R questions with no answers and no comments

select TOP 30
  p.Id as [Post Link],
  p.score,
  p.creationdate
FROM 
  Posts p
   -- INNER JOIN PostTags pt ON p.Id = pt.PostId
    --INNER JOIN Tags t ON pt.TagId = t.Id
WHERE 
  p.PostTypeId = 1 
  AND (p.score >= 2
       OR p.FavoriteCount >= 2)
  AND p.closeddate is null 
  AND ISNULL(p.AnswerCount,0) = 0 
  AND ISNULL(p.CommentCount,0) = 0 
  --t.TagName = 'r'
  and p.deletiondate is null
  --and creationdate > getdate()-183
  and p.Body like '%data.table%' 
ORDER BY
  p.creationdate desc
  --p.score desc

Enter Parameters

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