title: Order nodes by relationship count --> ThisShouldNotHappenError
body: <p>In a Neo4j database with a couple of nodes and relationships, I am trying to find out the most "popular" users (in this case: The nodes participating in most relationships):</p>
  
  <pre><code>START n=node:user('*:*')
  MATCH (n)-[r]-&gt;(x)
  RETURN n
  ORDER BY COUNT(r) DESC
  LIMIT 10
  </code></pre>
  
  <p>However, this query (Neo4j 1.9.2) results in the following error:</p>
  
  <blockquote>
    <p>ThisShouldNotHappenError</p>
    
    <p>Developer: Andres claims that: Aggregations should not be used like
    this.</p>
    
    <p>StackTrace:
    org.neo4j.cypher.internal.commands.expressions.AggregationExpression.apply(AggregationExpression.scala:31)
    org.neo4j.cypher.internal.commands.expressions.AggregationExpression.apply(AggregationExpression.scala:29)
    org.neo4j.cypher.internal.pipes.ExtractPipe$$anonfun$internalCreateResults$1$$anonfun$apply$1.apply(ExtractPipe.scala:47)
    org.neo4j.cypher.internal.pipes.ExtractPipe$$anonfun$internalCreateResults$1$$anonfun$apply$1.apply(ExtractPipe.scala:45)
    scala.collection.immutable.Map$Map1.foreach(Map.scala:109)
    org.neo4j.cypher.internal.pipes.ExtractPipe$$anonfun$internalCreateResults$1.apply(ExtractPipe.scala:45)
    org.neo4j.cypher.internal.pipes.ExtractPipe$$anonfun$internalCreateResults$1.apply(ExtractPipe.scala:44)
    scala.collection.Iterator$$anon$11.next(Iterator.scala:328)
    org.neo4j.cypher.internal.pipes.TopPipe.internalCreateResults(TopPipe.scala:45)
    org.neo4j.cypher.internal.pipes.PipeWithSource.createResults(Pipe.scala:69)
    org.neo4j.cypher.internal.pipes.PipeWithSource.createResults(Pipe.scala:66)
    org.neo4j.cypher.internal.executionplan.ExecutionPlanImpl.org$neo4j$cypher$internal$executionplan$ExecutionPlanImpl$$prepareStateAndResult(ExecutionPlanImpl.scala:164)
    org.neo4j.cypher.internal.executionplan.ExecutionPlanImpl$$anonfun$getLazyReadonlyQuery$1.apply(ExecutionPlanImpl.scala:139)
    org.neo4j.cypher.internal.executionplan.ExecutionPlanImpl$$anonfun$getLazyReadonlyQuery$1.apply(ExecutionPlanImpl.scala:138)
    org.neo4j.cypher.internal.executionplan.ExecutionPlanImpl.execute(ExecutionPlanImpl.scala:38)
    org.neo4j.cypher.ExecutionEngine.execute(ExecutionEngine.scala:72)
    org.neo4j.cypher.ExecutionEngine.execute(ExecutionEngine.scala:76)
    org.neo4j.cypher.javacompat.ExecutionEngine.execute(ExecutionEngine.java:79)
    org.neo4j.server.rest.web.CypherService.cypher(CypherService.java:94)
    java.lang.reflect.Method.invoke(Method.java:611)
    org.neo4j.server.rest.security.SecurityFilter.doFilter(SecurityFilter.java:112)</p>
  </blockquote>
  
  <p>Any ideas on how I can express this differntly?</p>