Questions for elm vs react typescript stack

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

DECLARE @tag0 nvarchar(25) = ##tag0:string?elm##
DECLARE @tag1 nvarchar(25) = ##tag1:string?typescript##
DECLARE @tag2 nvarchar(25) = ##tag2:string?reactjs##
DECLARE @tag3 nvarchar(25) = ##tag3:string?redux##
DECLARE @tag4 nvarchar(25) = ##tag4:string?react-router##
DECLARE @tag5 nvarchar(25) = ##tag5:string?parceljs##
DECLARE @tag6 nvarchar(25) = ##tag6:string?webpack##
DECLARE @tag7 nvarchar(25) = ##tag7:string?vuejs##
DECLARE @tag8 nvarchar(25) = ##tag8:string?angularjs##


SELECT *
  FROM (SELECT COUNT(distinct p.Id) AS elm
          FROM Posts p               
               LEFT JOIN PostTags pt
               ON pt.PostId = p.Id
               
               LEFT JOIN Tags t
               ON pt.TagId = t.Id
         WHERE t.TagName = @tag0
            OR t.TagName = 'elm-architecture'
            OR t.TagName = 'elm-port'
       ) AS elm,
       (SELECT COUNT(distinct p.Id) AS typescript
          FROM Posts p               
               LEFT JOIN PostTags pt
               ON pt.PostId = p.Id
               
               LEFT JOIN Tags t
               ON pt.TagId = t.Id
         WHERE t.TagName = @tag1
       ) AS typescript,
       (SELECT COUNT(distinct p.Id) AS react
          FROM Posts p               
               LEFT JOIN PostTags pt
               ON pt.PostId = p.Id
               
               LEFT JOIN Tags t
               ON pt.TagId = t.Id
         WHERE t.TagName = @tag2
       ) AS react,
       (SELECT COUNT(distinct p.Id) AS redux
          FROM Posts p               
               LEFT JOIN PostTags pt
               ON pt.PostId = p.Id
               
               LEFT JOIN Tags t
               ON pt.TagId = t.Id
         WHERE t.TagName = @tag3
       ) AS redux,
       (SELECT COUNT(distinct p.Id) AS reactrouter
          FROM Posts p               
               LEFT JOIN PostTags pt
               ON pt.PostId = p.Id
               
               LEFT JOIN Tags t
               ON pt.TagId = t.Id
         WHERE t.TagName = @tag4
       ) AS reactrouter,
       (SELECT COUNT(distinct p.Id) AS parceljs
          FROM Posts p               
               LEFT JOIN PostTags pt
               ON pt.PostId = p.Id
               
               LEFT JOIN Tags t
               ON pt.TagId = t.Id
         WHERE t.TagName = @tag5
       ) AS parceljs,
       (SELECT COUNT(distinct p.Id) AS webpack
          FROM Posts p               
               LEFT JOIN PostTags pt
               ON pt.PostId = p.Id
               
               LEFT JOIN Tags t
               ON pt.TagId = t.Id
         WHERE t.TagName = @tag6
       ) AS webpack,
       (SELECT COUNT(distinct p.Id) AS vuejs
          FROM Posts p               
               LEFT JOIN PostTags pt
               ON pt.PostId = p.Id
               
               LEFT JOIN Tags t
               ON pt.TagId = t.Id
         WHERE t.TagName = @tag7
       ) AS vuejs,
       (SELECT COUNT(distinct p.Id) AS angularjs
          FROM Posts p               
               LEFT JOIN PostTags pt
               ON pt.PostId = p.Id
               
               LEFT JOIN Tags t
               ON pt.TagId = t.Id
         WHERE t.TagName = @tag8
       ) AS angularjs

Enter Parameters

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