SELECT TOP 10000 CONCAT('https://salesforce.stackexchange...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker

Q&A for serious players and enthusiasts of poker

SELECT TOP 10000
CONCAT('https://salesforce.stackexchange.com/questions/',Posts.Id,'/') as url
,Posts.Title AS Title
,Posts.Tags AS Tags
,Posts.CreationDate AS CreationDate
,Posts.Score AS score
,Posts.ViewCount AS ViewCount
,(Posts.ViewCount/DATEDIFF(MM, Posts.CreationDate, GETDATE())) AS ViewsPerMonth
,Posts.AnswerCount AS AnswerCount
,Posts.FavoriteCount AS FavoriteCount
,Posts.Body AS Body
,CASE WHEN Posts.AcceptedAnswerId IS NOT NULL THEN 1 ELSE 0 END AS Answered
,PostAnswer.Score AS AnswerScore
,PostAnswer.Body AS AnswerBody
FROM Posts
LEFT JOIN Posts AS PostAnswer ON Posts.AcceptedAnswerId = PostAnswer.Id
LEFT JOIN (
  SELECT
  Id
  ,Score
  FROM Posts
  WHERE PostTypeId = 2
) V6mths ON V6mths.Id = Posts.AcceptedAnswerId

WHERE (Posts.Tags LIKE '%marketing-cloud%' OR Posts.Tags LIKE '%ampscript%' OR Posts.Tags LIKE '%ssjs%' OR Posts.Tags LIKE '%journeybuilder%')
AND Posts.ClosedDate IS NULL
AND Posts.Score >= 0
AND Posts.PostTypeId = 1
ORDER BY Posts.ViewCount DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results