User:Osarius/Sandbox/Data - Revision history

Osarius at 15:28, 20 February 2024

2024-02-20T15:28:59Z

← Older revision		Revision as of 15:28, 20 February 2024
Line 1:		Line 1:
	Ignore this. I'm working on something really cool		Ignore this. I'm working on something really cool
	<!--		<!--
	{{#~~get_web_data~~:		{{#get_db_data:db=tip_restricted
	~~url~~=~~https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXCO_-hGyv8/1/public/full?alt~~=~~json&key~~=~~AIzaSyA4ge7-C3XQBOiBANAIIwyBz5bqciQZZro~~		\| from=matches=m,teams=th,teams=ta
	~~\|format~~=~~JSON~~		\| join on=th.teamId=m.homeTeam,ta.teamId=m.awayTeam
	\|~~data~~=~~matchId~~=~~Idx~~,~~matchDate~~=~~Date,matchResult~~=~~Result,mOpp~~=~~Opponent,score~~=~~scoreString,comp~~=~~competitionString,venue~~=~~Venue,location=LocationString~~		\| where=th.teamName='{{{team_name}}}' OR ta.teamName='{{{team_name}}}'
	\|~~json offset~~=0		\| limit=20
			\| order by=matchId DESC
			\| data=th.teamName=homeTeam,ta.teamName=awayTeam
	}}		}}
	-->		-->

Osarius at 17:00, 22 November 2023

2023-11-22T17:00:31Z

← Older revision		Revision as of 17:00, 22 November 2023
Line 1:		Line 1:
	<~~nowiki>~~{{#get_web_data:		Ignore this. I'm working on something really cool
			<!--
			{{#get_web_data:
	url=https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXCO_-hGyv8/1/public/full?alt=json&key=AIzaSyA4ge7-C3XQBOiBANAIIwyBz5bqciQZZro		url=https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXCO_-hGyv8/1/public/full?alt=json&key=AIzaSyA4ge7-C3XQBOiBANAIIwyBz5bqciQZZro
	\|format=JSON		\|format=JSON
	\|data=matchId=Idx,matchDate=Date,matchResult=Result,mOpp=Opponent,score=scoreString,comp=competitionString,venue=Venue,location=LocationString		\|data=matchId=Idx,matchDate=Date,matchResult=Result,mOpp=Opponent,score=scoreString,comp=competitionString,venue=Venue,location=LocationString
	\|json offset=0		\|json offset=0
	}}~~</nowiki~~>		}}
			-->

Osarius at 16:57, 22 November 2023

2023-11-22T16:57:52Z

← Older revision		Revision as of 16:57, 22 November 2023
Line 5:		Line 5:
	\|json offset=0		\|json offset=0
	}}</nowiki>		}}</nowiki>

	~~{{#get_web_data:~~
	~~url=https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXCO_-hGyv8/1/public/full?alt=json&key=AIzaSyA4ge7-C3XQBOiBANAIIwyBz5bqciQZZro~~
	~~\|format=JSON~~
	~~\|data=matchId=Idx,matchDate=Date,matchResult=Result,mOpp=Opponent,score=scoreString,comp=competitionString,venue=Venue,location=LocationString~~
	~~\|json offset=0~~
	}}

Osarius: Created page with "{{#get_web_data: url=https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXCO_-hGyv8/1/public/full?alt=json&key=AIzaSyA4ge7-C3XQBOiBANAIIwyBz5bqciQZZro |format=JSON |data=matchId=Idx,matchDate=Date,matchResult=Result,mOpp=Opponent,score=scoreString,comp=competitionString,venue=Venue,location=LocationString |json offset=0 }} {{#get_web_data: url=https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXC..."

2023-11-22T16:57:27Z

Created page with "<nowiki>{{#get_web_data: url=https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXCO_-hGyv8/1/public/full?alt=json&key=AIzaSyA4ge7-C3XQBOiBANAIIwyBz5bqciQZZro |format=JSON |data=matchId=Idx,matchDate=Date,matchResult=Result,mOpp=Opponent,score=scoreString,comp=competitionString,venue=Venue,location=LocationString |json offset=0 }}</nowiki> {{#get_web_data: url=https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXC..."

New page

<nowiki>{{#get_web_data:
url=https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXCO_-hGyv8/1/public/full?alt=json&key=AIzaSyA4ge7-C3XQBOiBANAIIwyBz5bqciQZZro
|format=JSON
|data=matchId=Idx,matchDate=Date,matchResult=Result,mOpp=Opponent,score=scoreString,comp=competitionString,venue=Venue,location=LocationString
|json offset=0
}}</nowiki>

{{#get_web_data:
url=https://spreadsheets.google.com/feeds/cells/176JkAZ_dLX2vKzh00TKPSQmm_rM3YTvnQXCO_-hGyv8/1/public/full?alt=json&key=AIzaSyA4ge7-C3XQBOiBANAIIwyBz5bqciQZZro
|format=JSON
|data=matchId=Idx,matchDate=Date,matchResult=Result,mOpp=Opponent,score=scoreString,comp=competitionString,venue=Venue,location=LocationString
|json offset=0
}}