Template:Jam occurrence leaderboard/query: Difference between revisions
From VNDev Wiki
m wait huh? are you working now? Tag: Manual revert |
m fixed tie logic by adding new filter params |
||
| Line 13: | Line 13: | ||
<!-- The below section calculates the correct rank number by comparing to prior items --> | <!-- The below section calculates the correct rank number by comparing to prior items --> | ||
|userparam={{#ifexpr: {{{1}}} = 1 | 1 | | |userparam={{#ifexpr: {{{1}}} = 1 | 1 | | ||
{{#ifexpr: {{#ask: [[Jam occurrence:+]] |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-1}} }} | {{#ifexpr: {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-1}} }} | ||
= {{#ask: [[Jam occurrence:+]] |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-2}} }} | = {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-2}} }} | ||
| <!--At least two way tie; now test for three way tie--> | | <!--At least two way tie; now test for three way tie--> | ||
{{#ifexpr: {{#ask: [[Jam occurrence:+]] |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-1}} }} | {{#ifexpr: {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-1}} }} | ||
= {{#ask: [[Jam occurrence:+]] |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-3}} }} | = {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-3}} }} | ||
| {{#expr: {{{1}}}-2}} | | {{#expr: {{{1}}}-2}} | ||
| {{#expr: {{{1}}}-1}} | | {{#expr: {{{1}}}-1}} | ||
