WITH cte1 AS ( SELECT pt.PostId FROM PostTags pt JOIN Tag...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Japanese Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

WITH cte1 AS (
              SELECT pt.PostId 
              FROM PostTags pt 
                JOIN Tags t1 ON pt.TagId = t1.Id 
              WHERE t1.TagName like '%html%'
              ), 
      cte2 AS (
              SELECT pt.PostId 
              FROM PostTags pt 
                JOIN Tags t1 ON pt.TagId = t1.Id 
              WHERE t1.TagName like '%css%'
              )
SELECT p.Id as p0_id, pt1.PostId, pt2.PostId
FROM Posts p 
    INNER JOIN cte1 pt1 ON pt1.PostId = p.Id
    INNER JOIN cte2 pt2 ON pt2.PostId = p.Id
ORDER BY p.Id

Enter Parameters

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