Query sequell: how to sort by turns?

[Turukano]

This is a question concerning listgame commands as shown in the listgame manual.

Imagine I'd like to know the fastest (turncount) wins and the players, e.g.
!lg * win urune=15 Mi-- turn<35000 s=turn, name
will search for all mino wins with 15 runes in < 35 k turns:

6 games for * (win urune=15 Mi-- turn<35000): 30129 (PurpleRed), 27655 (keymashgrqeeg), 27486 (PurpleRed), 28057 (eld), 31834 (DenpaOtoko), 31770 (4tharraofdagon)

The point is, I'd like to have a sorted list by min turncount like
27486 (PurpleRed), 27655 (keymashgrqeeg) etc.

Afaik the query I made sorts by occurence of turns which is 1 for each: 1x 30129, 1x 27655 etc. How to sort by turncount? The problem could be the following:

You may use only one max= or min= operation per query, and you may not combine it with o=, or s=

*******

And another question by the way: does sequell use SQL?

[gammafunk]

Imagine I'd like to know the fastest (turncount) wins and the players, e.g.
!lg * win urune=15 Mi-- turn<35000 s=turn, name
will search for all mino wins with 15 runes in < 35 k turns:

6 games for * (win urune=15 Mi-- turn<35000): 30129 (PurpleRed), 27655 (keymashgrqeeg), 27486 (PurpleRed), 28057 (eld), 31834 (DenpaOtoko), 31770 (4tharraofdagon)

The point is, I'd like to have a sorted list by min turncount like
27486 (PurpleRed), 27655 (keymashgrqeeg) etc.

Simply add an `o' term to your query, in this case you'd want to sort by turns ascending:

  Code:

<gammafunk> !lg * win urune=15 Mi-- turn<35000 s=turn,name o=-turn
<Sequell> 6 games for * (win urune=15 Mi-- turn<35000): 27486 (PurpleRed), 27655 (keymashgrqeeg), 28057 (eld), 30129 (PurpleRed), 31770 (4tharraofdagon), 31834 (DenpaOtoko)

Afaik the query I made sorts by occurence of turns which is 1 for each: 1x 30129, 1x 27655 etc. How to sort by turncount? The problem could be the following:

You may use only one max= or min= operation per query, and you may not combine it with o=, or s=

This is not a problem for your query, since you're not using max= or min=.

And another question by the way: does sequell use SQL?

Yes, it depends on PostgreSQL. See the Sequell README for details on its dependencies and installation.