|
|
1. rida: |
1. rida: |
|
| |
| ====Välkturniirid====
| |
| {{#get_db_data: | | {{#get_db_data: |
| db=ID | | db=ID |
| |from=tournament_2y_view | | |from=tournament_2y_view |
| |where=Tournament_Tc=0.1 AND Tournament_Ttype=100
| | |data=Turniir=Tournament_Name |
| |order by=Tournament_Date desc
| |
| |data=Turniir=Tournament_Name,Algus=Tournament_Start_Date,Lopp=Tournament_End_Date,Ajakontroll=Tournament_Tc | |
| | |
| }} | | }} |
| {| class="wikitable"
| | {{{Turniir}}} |
| ! Nimi
| |
| ! Turniiri algus
| |
| ! Turniiri lõpp
| |
| {{#for_external_table:<nowiki/>
| |
| {{!}}-
| |
| {{!}} {{{Turniir}}}
| |
| {{!}} {{{Algus}}}
| |
| {{!}} {{{Lopp}}} }}
| |
| |}
| |
| {{#clear_external_data:}}
| |
| | |
| ====Kiirturniirid====
| |
| {{#get_db_data:
| |
| db=ID
| |
| |from=tournament_2y_view
| |
| |where=Tournament_Tc=0.3 AND Tournament_Ttype=100
| |
| |order by=Tournament_Date desc
| |
| |data=Turniir=Tournament_Name,Algus=Tournament_Start_Date,Lopp=Tournament_End_Date,Ajakontroll=Tournament_Tc
| |
| | |
| }}
| |
| {| class="wikitable"
| |
| ! Nimi
| |
| ! Turniiri algus
| |
| ! Turniiri lõpp
| |
| {{#for_external_table:<nowiki/>
| |
| {{!}}-
| |
| {{!}} {{{Turniir}}}
| |
| {{!}} {{{Algus}}}
| |
| {{!}} {{{Lopp}}} }}
| |
| |}
| |
| {{#clear_external_data:}}
| |
| ====Poolpikad turniirid====
| |
| {{#get_db_data:
| |
| db=ID
| |
| |from=tournament_2y_view
| |
| |where=Tournament_Tc=0.5 AND Tournament_Ttype=100
| |
| |order by=Tournament_Date desc
| |
| |data=Turniir=Tournament_Name,Algus=Tournament_Start_Date,Lopp=Tournament_End_Date,Ajakontroll=Tournament_Tc
| |
| }}
| |
| {| class="wikitable"
| |
| ! Nimi
| |
| ! Turniiri algus
| |
| ! Turniiri lõpp
| |
| {{#for_external_table:<nowiki/>
| |
| {{!}}-
| |
| {{!}} {{{Turniir}}}
| |
| {{!}} {{{Algus}}}
| |
| {{!}} {{{Lopp}}} }}
| |
| |}
| |
| {{#clear_external_data:}}
| |
| ====Täispikad turniirid====
| |
| {{#get_db_data:
| |
| db=ID
| |
| |from=tournament_2y_view
| |
| |where=Tournament_Tc=1 AND Tournament_Ttype=100
| |
| |order by=Tournament_Date desc
| |
| |data=Turniir=Tournament_Name,Algus=Tournament_Start_Date,Lopp=Tournament_End_Date,Ajakontroll=Tournament_Tc
| |
| }}
| |
| {| class="wikitable"
| |
| ! Nimi
| |
| ! Turniiri algus
| |
| ! Turniiri lõpp
| |
| {{#for_external_table:<nowiki/>
| |
| {{!}}-
| |
| {{!}} {{{Turniir}}}
| |
| {{!}} {{{Algus}}}
| |
| {{!}} {{{Lopp}}} }}
| |
| |}
| |
| {{#clear_external_data:}} | | {{#clear_external_data:}} |