SO Tag Extraction

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

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

SELECT DISTINCT-- TOP 100
  -- Title and body
  CONCAT('<div style="border: double; padding: 1em; margin-bottom: 1em; background: #eee;"><b>Question ID:</b> ', p.Id,'<br><b>Post #:</b> ', ROW_NUMBER()  OVER ( ORDER BY p.Id ) ,'<br><b>Question:</b> <i>', p.Title ,'</i><br><b>Score:</b> ', p.Score, '<br><b>Tags:</b><code>', p.Tags, '</code><br><b>View Count:</b> ', p.ViewCount, '<br><hr><div style="padding: 1em; width: 80%; margin: 0 auto; font-size: 80%;">', p.Body,'</div></div>')
FROM Posts p
-- join up to tags
INNER JOIN PostTags pt ON p.Id = pt.PostId
INNER JOIN Tags t ON t.Id = pt.TagId
-- We want questions (not answers) only
WHERE p.Title IS NOT NULL 
AND p.PostTypeId = 1
-- Only positive scores
AND p.Score > 0
AND t.TagName IN (
  -- GOOGLE SERVICES
  'google-cloud-ml',
  'google-cloud-ml-engine',
  'google-cloud-automl',
  'google-vision',
  'google-speech-api',
  'google-cloud-speech',
  'google-natural-language',
  'google-cloud-automl-nl',
  'google-cloud-nl',
  'google-translation-api',
  'dialogflow',
  -- AMAZON SERVICES
  'amazon-sagemaker',
  'aws-sagemaker',
  'sagemaker',
  'amazon-machine-learning',
  'amazon-rekognition',
  'aws-transcribe',
  'amazon-lex',
  'aws-lex',
  -- MICROSOFT SERVICES
  'azure-machine-learning',
  'azure-cognitive-services',
  'microsoft-cognitive',
  'project-oxford',
  -- IBM SERVICES
  'watson-ml',
  'watson-studio',
  'watson-conversation',
  'watson-assistant',
  'watson-dialog',
  'ibm-watson-cognitive',
  'ibm-watson',
  'watson'
)

Enter Parameters

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