Stack Overflow answers with a specific tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Movies and TV Meta

Q&A about the site for movie and tv enthusiasts

SELECT
  PP.Id,
  PP.ParentId,
  PP.CreationDate,
  P.ViewCount,
  P.Title,
  PP.Body,
  P.Tags,
  PP.PostTypeId
FROM
  Posts as P
JOIN
  Posts PP ON PP.ParentId = P.Id
WHERE
  -- Set your specific tag here
  PP.PostTypeId = 2 AND P.tags LIKE '%<html>%'
ORDER BY
  P.ViewCount DESC;

Enter Parameters

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