SFMC related questions with answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

SELECT P.ID as [Post Link],
       P.PostTypeId,
       P.Title,
       P.Body,
       P.Tags,
       P.AnswerCount,
       P.CommentCount,
       C.Text,
       C.Score,
       C.Id,
       P.CreationDate,
       P.Score,
       P.ViewCount,
       P.OwnerUserId,
       P.LastEditDate,      
       P.LastActivityDate
       
FROM Posts as P
  INNER JOIN Comments as C
     ON P.Id = C.PostId

WHERE  P.PostTypeId = 1
    AND (P.Tags LIKE '%##tag1##%'
      OR P.Tags LIKE '%##tag2##%'     
      OR P.Tags LIKE '%##tag3##%'
      OR P.Tags LIKE '%##tag4##%'
      OR P.Tags LIKE '%##tag5##%'
      OR P.Tags LIKE '##tag6##')
ORDER BY P.CreationDate DESC

Enter Parameters

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