Definitions: | ||

$1 | the winner | |

$n | n-th player (must be less or equal to player-count) | |

$1.player | the winner's name | |

$n.player | the n-th player's name | |

$1.elapsed | the winner's elapsed time | |

$1.gamesWons | number of games won by the winner | |

$player.# | player's finishing position. e.g. $Kaos.# | |

player-count | number of participants | |

game-count | total number of games won by the participants | |

start-date | the 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 | ||

plays | checks if a player has played in a tournament | |

wins | checks if a player has won a tournament | |

Arithmetic operators: | ||

+ | plus, add | |

- | minus, subtract | |

* | times, multiply |

A condition is like | ||

operand_{1} operand_{2} operator | ||

Example: $1.elapsed 10:00 less-than | ||

A condition can be combined with another one like this: | ||

cond_{1} cond_{2} and | ||

cond_{1} cond_{2} or |

Examples: | |

the above in infix notation would be: if (player-count>10 and player-count<25) | |

the above would find the tournaments in which players "Kaos" and "vishna" have played | |

the above would find the tournaments in which "Kaos" has won and "WRAC" played | |

the above would find the tournaments won by "WRAC" between 2015-01-01 and 2020-01-01 | |

the above would find the tournaments with podium finishes for "WRAC" | |

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.