Difference between revisions of "Template:PlayerStreamTable"

From SMC Wiki
Jump to navigation Jump to search
Line 1: Line 1:
==Casts and Streams==
==Casts and Streams==
{{#get_web_data:url=https://docs.google.com/spreadsheets/d/1FhPcb2y6JyMvMyby9fOEeMGu_O_4zKMkPonH0nHzEV8/gviz/tq?gid=228066513&tqx=out:csv&headers=1&tq=SELECT%20*%20where%20G%20contains%20"{{!}}{{PAGENAME}}{{!}}"%20order%20by%20C
{{StreamTableFromQuery|SELECT%20*%20where%20G%20contains%20"{{!}}{{PAGENAME}}{{!}}"%20order%20by%20C|Casted Matches}}
|format=CSV with header
{{StreamTableFromQuery|SELECT%20*%20where%20F%20contains%20"{{!}}{{PAGENAME}}{{!}}"%20order%20by%20C|Streams as Caster}}
|delimiter=,
{{StreamTableFromQuery|SELECT%20*%20where%20E%3D"{{PAGENAME}}"%20order%20by%20C|Streams as Host}}
|data=season=Season,event=Event,title=Title,link=Link
}}
{| class="wikitable" style="display: inline-table;"
!colspan="3"|Casted Matches
|-
!Season || Tournament || Title
{{#for_external_table:<nowiki />
{{!}}-
{{!}} {{{season}}} {{!}}{{!}} [[{{{event}}}]] {{!}}{{!}} [{{{link}}} {{{title}}}]
}}
|}
{{#get_web_data:url=https://docs.google.com/spreadsheets/d/1FhPcb2y6JyMvMyby9fOEeMGu_O_4zKMkPonH0nHzEV8/gviz/tq?gid=228066513&tqx=out:csv&headers=1&tq=SELECT%20*%20where%20F%20contains%20"{{!}}{{PAGENAME}}{{!}}"%20order%20by%20C
|format=CSV with header
|delimiter=,
|data=season=Season,event=Event,title=Title,link=Link
}}
{| class="wikitable" style="display: inline-table;"
!colspan="3"|Streams as Caster
|-
!Season || Tournament || Title
{{#for_external_table:<nowiki />
{{!}}-
{{!}} {{{season}}} {{!}}{{!}} [[{{{event}}}]] {{!}}{{!}} [{{{link}}} {{{title}}}]
}}
|}
{{#get_web_data:url=https://docs.google.com/spreadsheets/d/1FhPcb2y6JyMvMyby9fOEeMGu_O_4zKMkPonH0nHzEV8/gviz/tq?gid=228066513&tqx=out:csv&headers=1&tq=SELECT%20*%20where%20E="{{PAGENAME}}"%20order%20by%20C
|format=CSV with header
|delimiter=,
|data=season=Season,event=Event,title=Title,link=Link
}}
{| class="wikitable" style="display: inline-table;"
!colspan="3"|Streams as Host
|-
!Season || Tournament || Title
{{#for_external_table:<nowiki />
{{!}}-
{{!}} {{{season}}} {{!}}{{!}} [[{{{event}}}]] {{!}}{{!}} [{{{link}}} {{{title}}}]
}}
|}

Revision as of 21:47, 7 February 2022

Casts and Streams

Casted Matches
Season Tournament Title
Streams as Caster
Season Tournament Title
Streams as Host
Season Tournament Title
Retrieved from "https://www.spypartysmc.com/index.php?title=Template:PlayerStreamTable&oldid=121"