Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
Select t.TagName, count(p.id) from Posts p, Tags t, PostTags pt WHERE p.Id=pt.PostId AND pt.TagId=t.Id AND t.TagName IN ('angular', 'angularjs', 'aurelia', 'backbone.js', 'd3.js', 'dojo', 'ember.js', 'enyo', 'extjs', 'gwt', 'jquery', 'keystone', 'knockout.js', 'mercury', 'meteor', 'mobx', 'mootools', 'polymer', 'prototype', 'qooxdoo', 'reactjs', 'riot', 'socket.io', 'spine', 'sproutcore', 'svelte', 'vue.js', 'lodash') GROUP BY (t.TagName);