GraphDB question count

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

SELECT t.tagName, count(p.id)
FROM tags t
INNER JOIN postTags pt ON t.id = pt.tagid
INNER JOIN posts p ON p.id = pt.postid
WHERE t.tagname IN ('neo4j','titan','janusgraph','orientdb',
'datastax-enterprise-graph','azure-cosmosdb','arango','virtuoso',
'amazon-neptune','giraph','graphdb','hypergraphdb','AllegroGraph',
'stardog','dgraph','blazegraph','faunadb','velocitydb','sparksee',
'flockdb','infogrid','tinkergraph')
AND p.creationdate > '2017-01-01'
GROUP BY t.tagName
ORDER BY count(p.id) DESC;

Enter Parameters

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