SFMC related questions with answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

SELECT P.ID as [Post Link],
       P.Title,
       P.Body,
       P.Tags,
       P.AnswerCount,
       P.CommentCount,
       P.CreationDate,
       P.Score,
       P.ViewCount,
       P.OwnerUserId,
       P.LastEditDate,      
       P.LastActivityDate
       
FROM Posts as P
WHERE P.AnswerCount > 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