Desktop Technologies 2019

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

SELECT COUNT(0) AS Question, SUM(q.FavoriteCount) AS 'Watchers', t.TagName FROM Posts q
INNER JOIN PostTags pt ON q.Id = pt.PostId
INNER JOIN Tags t ON t.Id = pt.TagId
WHERE q.PostTypeId IN (1, 2)
AND q.CreationDate >= '2019-1-1'
AND q.CreationDate < '2020-1-1'
AND t.TagName In ('uwp', 'wpf', 'winforms', 'electron', 'swing', 'javafx', 'qt', 'mfc')
GROUP BY t.TagName;

Enter Parameters

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