Definitions:
$1
the winner
$nn-th player (must be less or equal to player-count)
$1.playerthe winner's name
$n.playerthe n-th player's name
$1.elapsedthe winner's elapsed time
$1.gamesWonsnumber of games won by the winner
$player.#player's finishing position. e.g. $Kaos.#
player-countnumber of participants
game-counttotal number of games won by the participants
start-datethe tournament's start date and time (YYYY-MM-DD)
Conditional operators:
less-than, < less than
more-than, > greater than
equal-to, = equal to
and
or
not-less-than
not-more-than
not-equal-to
not
playschecks if a player has played in a tournament
winschecks if a player has won a tournament
Arithmetic operators:
+plus, add
-minus, subtract
*times, multiply
A condition is like
operand1 operand2 operator
Example: $1.elapsed 10:00 less-than
A condition can be combined with another one like this:
cond1 cond2 and
cond1 cond2 or
Examples:
  • player-count 10 more-than player-count 25 less-than and
    • the above in infix notation would be: if (player-count>10 and player-count<25)
  • Kaos plays vishna plays and
    • the above would find the tournaments in which players "Kaos" and "vishna" have played
  • Kaos wins WRAC plays and
    • the above would find the tournaments in which "Kaos" has won and "WRAC" played
  • WRAC wins start-date 2015-01-01 not-less-than and start-date 2020-01-01 less-than and
    • the above would find the tournaments won by "WRAC" between 2015-01-01 and 2020-01-01
  • $WRAC.# 3 not-more-than
    • the above would find the tournaments with podium finishes for "WRAC"
  • $1.gamesWons 0 more-than
    • the above would list all the tournaments played so far for the selected theme
  • Feel free to ask here if you cannot figure out how to build a query


    • The tournaments are included in result set if the condition(s) in the query string is/are met.

    The syntax is inspired by Forth programming language and Reverse Polish Notation in particular.