View source for Create and Query Tables

<data table="E-Week 2019" fields="Event,Description,Location,Start,End,DoubleSub,RankTier,Scale,Points,ASA,BUSS,BREE,CEUS,CHESS,CMEUS,ECSESS,MAME,MEUS,OLD,ASA,BUSS,BREE,CEUS,,CHESS,CMEUS,ECSESS,,MAME,,MEUS,OLD,DamnThing,ASA,BUSS,BREE,CEUS,CHESS,CMEUS,ECSESS,MAME,MEUS,OLD">
Damn Thing Total,This is a sum total point value for damn thing checkins,,,,,,,,25,0,25,25,25,0,0,0,25,0,,,,,,,,,,,,,,,1,0,1,1,1,0,0,0,1,0
Bonus Points,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Big Boy's Spice City,"The big boy caravan is in town! Hurdle over the gom jabbar on your way to proving that you are the Kwisatz Haderach, destroying those less than capable spice boners with your angellic purity.","Dune Desert Planet
Arrakis, Canopus
H2X 3P8
",201812251015,201812260230,0,R,1,1000,1000,600,100,100,400,1000,800,69,400,800,1,3,9,"1,2",1,4,9,"1,4",2,"13,14",13,4,2,1,1,0,1,1,1,0,0,0,1,0
Captain's Challenge,"Grab all your cabin crew for this epic battle to prove which ~adventure ship~ ship has the best pilot line-up! You might have passed your pilot's exam BUT this challenge is only for the most elite, the most intelligent, analytical problem solvers! We had to vet the pilots somehow, eh?",Campus ,201901080100,201901080300,0,R,3,300,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Rookie Challenge (Physical),"Welcome to the Space Cadet Training Program. First things first, an Astronaut must be in good PHYSICAL shape...",McConnell Basement Elevators,,,1,R,3,300,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Sustainability Challenge ,"Don't forget to take care of your planet while you're away in space exploring!! We all need our planets in great shape to come back to them, after all, not like we want to live in Alderaan places.",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Beer Die,It's a bird! It's a plane! It's a rocket! It's a dice! Come down to the common room and let's see which department can win at Blues Pub's most iconic game.,Common Room,,,1,R,2,600,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
DUSTED/Time Trials,Oh no! Is that a wormhole that popped out of nowhere :o hold on tight because we're about to lose track of time and space. Who knows where this hole will take you :O we certainly don't.... ....wait... we're not alone out here?! 9 other ships have landed with you. It's time to bring forward 10 of your ship's best diplomats to get to know the other ships and what better way to do that than some friendly BOAT Races,???,201901081900,201901090300,0,R,1,1000,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Breakfast 1,"How do spaceships start their day off right? They fuel up! Come on down to the common room, eskethis bread!",Common Room,201901090800,201901090900,0,T,4,100,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Broomball,"""Il tire.... et le but!""! Teams will duke it out, on the rink, brooms in hand, to determine who goes to the final round. After all, what's a better way to stay in shape in zErO gRaViTy o.O",Lower Field ,201901090900,201901091200,0,R,2,600,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Fort Building,"The new planet does not offer much protection, with flat rugged terrain and wide clearings. Space rangers, you must build a fort to provide safety from the elements. In this event, teams will build forts out of snow on lower field. Note that you are not allowed to trample the forts of other teams or leave behind any garbage (pls be nice to the planet :3)",Lower Field ,201901091000,201901091200,0,T,2,500,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Innertube Water Polo,"Come float in a zero-gravity zone while playing some fun ball game, all while sitting comfortably in your personal spaceship. NOTE: Alcohol/being drunk at the McGill pool is 1000*∞% absolutely, even in another dimension or more, STRICTLY PROHIBITED. Participants found in possession of or under the influence of alcohol will be kicked out of the event, cause their team to receive a massive (4-digit kind of) point penalty, and run the risk of having their bracelet cut and E-Week ended. Captains MUST make this 500% clear to team members and enforce it as well as the coords. Secondary but equally as important NOTE: The McGill Pool has a dress code. Your underwear does NOT count as a swimsuit. Please don't wear lingerie as your swimsuit. the reason these are rules is because it's definitely happened before. You will be forced to leave the venue if you don't comply with the dresscode!",McGill Gym Pool,201901091200,201901091600,0,R,2,600,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Video Games ,"Did you ever hear the tragedy of Old Patrol the wise? I thought not. It's not a story the coords would tell you. It's an E-Week legend. Old Patrol was a team, so agressive and so strong it could use the Hype to influence the coords to create points… They had such a knowledge of the point system that they could even keep the teams they cared about from losing E-Week. The dark side of the points is a pathway to many abilities some consider to be unnatural. They became so powerful… the only thing they were afraid of was losing their damn thing, which eventually, of course, they did. Unfortunately, they taught their apprentice (mech) everything they knew, then their apprentice betrayed them at closing ceremonies. Ironic. They could save others from losing E-Week, but not themselves.",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Mario Kart Double Dash,,Common Room,201901091230,201901091500,1,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Super Smash,,Common Room,201901091230,201901091500,1,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Just Dance,,Common Room,201901091230,201901091500,1,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
FIFA,,Common Room,201901091230,201901091500,1,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Pub Crawl (Walking),"HOP IN YOUR FAVORITE SPACESHIP FOR A ~WILD~ RIDE! Gather your species and join us for a majestic ride to discover the fun hidden parts of Montreal. The journey includes visiting 9 different stops in the Downtown area and you will receive various hint(s) to encounter other friendly (?) species. The chosen ones will have to go zoom zoom as Running teams, and will have time deducted for their scunt submissions (MUCH ZOOM ZOOM). Food will be provided, but chances are that your tummy will still do the grumbles; something that you can fulfill by either EATING FOOD BEFORE (please), or getting some grub on your way to Pluto's Redemption!",Montreal,201901091700,201901092100,0,T,2,500,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Pub Crawl (Running),,Montreal,201901091700,201901092100,0,R,1,1000,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Flip Cup,"After a long day of drinking your way around the galaxy, it is time to regroup and face the other teams for an intense series of challenges to see which ship has the most skilled crew (of course it's yours).",Sky,201901092100,201901100300,1,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Tummies,,Sky,201901092100,201901100300,1,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Civil War,,Sky,201901092100,201901100300,1,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Stacks/Basketball,,Sky,201901092100,201901100300,0,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Creative Chug,,Sky,201901092100,201901100300,1,T,4,100,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Relay Races,,Sky,201901092100,201901100300,0,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Musical Beers (Rookie),,Sky,201901092100,201901100300,0,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Chug Ladder BEST,,Sky,201901092100,201901100300,1,T,4,100,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Chug Ladder WORST,,Sky,201901092100,201901100300,1,T,4,100,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Mountain Run,"Grab your crew and race through the cold dark void of space! Along the way, there will be some mandatory and fiery stops to test your crew's endurance ;)",Mount Royal,201901100800,201901100930,1,R,2,600,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Big Breakfast,"We've got a long day of Space exploration ahead, come grab some good grub to fuel up! The more of your team that comes out, the higher your tier!",Common Room,201901100930,201901101100,0,T,4,100,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Trivia,Are you smarter than a space ranger? Get a pencil & a piece of paper! Hungry for food or hungry for trivia? Why not both!,Common Room,201901101000,201901101100,0,R,3,300,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Aptitude Test,"Ever wondered if you've got what it takes to be an astronaut? With multiple rounds and ~requirements~ this test is a combination of multiple extensive evaluating systems, only to determine the best of the best. It will examine your knowledge of space physics, test your space logic, and then ask you how you'd react when faced with various space life or space death scenarios. Give it a go here, and see if you have the brrrrains to pass the test and make it as a top crew member, or if you should keep your feet firmly planted on Planet Earth ;)",Common Room ,201901101200,201901101330,1,T,2,500,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
WMC,"Paging all engineers! Each team must create a space helmet that supplies the wearer with special astronaut juice. The funkier the helmet, the more points will be given. Details can be found in the Appendix & the Design Package.",Games Room,201901101200,201901101330,0,R,1,1000,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Iron Chef,"Who said space food has to be gross and vacuumed? Tie up those aprons, put on that chef helmet and concoct some delicious spacey meals for your Fleet Commanders!",Common Room ,201901101400,201901101530,0,T,2,500,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Design Comp,The Space Rovers have landed on another planet! May each team battle it out for the glory with custom designed weapons! May the best bot win! Details can be found in the Appendix under Design Package.,Trottier Mezzanine,201901101330,201901101600,0,R,1,1000,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Rookie Challenge (Intellectual),"Round two ! This time, INTELLECTUAL capabilities will be tested. Are you up for the challenge ?",Infosys,201901101600,201901101900,1,R,3,300,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Beer Tasting,"Aristotle once asked, ""Does beer taste different in Space?""",Common Room,201901101600,201901101900,1,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
BOAT Races,"Remember the good old days... or back to the future days... umm... at the end of the.. or was it the beginning?... well, you get the point, it's a wormhole. Remember racing for the ""prestige"" not points, lol, WELL NOW depending on how well your team ""prestiged"" coming out of the wormhole, you will now face off again but this time the stakes are much higher! Who will make it to the Final Frontier? And who will be left behind... You will be put into a single-elimination style bracket with classic BOAT Race rules; majors, minors, two beers per person, up and down the table etc. The same two coord will be calling majors and minors to avoid any inconsistency in calls.",Cafe Campus,201901102000,201901110300,0,R,1,1000,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
3-MAN (Ranked),"Welcome space... Where everything comes in bulk and void, where past is the future, future the present and present is not so clear. Let's throw those giant galactic dice to play the most confusing game on the entirety of Milky Way.",Cafe Campus,201901110000,201901111330,0,R,4,150,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
3-MAN (Ranked),"Welcome space... Where everything comes in bulk and void, where past is the future, future the present and present is not so clear. Let's throw those giant galactic dice to play the most confusing game on the entirety of Milky Way.",Cafe Campus,201901110000,201901111330,0,T,3,250,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Lip Sync,"A giant mysterious head suddenly appeared on the skies, making golf easy, then hard again, changing climates with the splits of a second and the Earth's best effort was... to... get... Schwifty? Hopefully, you can show us what you got with a loud enough mic for around 3mins +/- 30 seconds!",Cafe Campus ,201901111330,201901111600,0,T,3,250,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Drunken Debates,What happens when astronauts have too much fermented space juice and start talking about rocket science? Drunken Debates! Silly people talking about topics so silly you will not be able to contain your laughter.,Cafe Campus,201901111330,201901111600,0,R,2,600,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Rap Battles,"RRRRRaaaarrrrrr ! That's how you say ""hi, I come in peace"" in alien language. That's also how you'll sound if you rap too fast without proper pronunciation",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Iron Bartender,Every party needs some good rocket fuel to achieve liftoff. Will you get us to space with the most premium fuel ever?,Chris Sarlos' Apartment ,201901111600,201901111700,0,T,3,250,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Rookie Challenge (Artistic),"Finally, the third installment of this training program, show us your ARTISTIC skills. As you know, a true astronaut needs to decorate their ship to avoid going insane..",Common Room,201901111600,201901112100,1,R,3,300,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
FOAT Races,,McConnell Basement,201901111600,201901112100,0,R,3,300,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Century Club,"You can't resist the gravity pulling you to this distant reach of the universe. Let yourself be drawn into the black hole where all the other ships will inevitably end up with you for the biggest party ever seen in the space-time continuum. Remember to bring proper gear as this is a guaranteed wet-n-wild adventure! NO COAT NO LINE!! Please remind all participants of Century Club tips: 
Bring a plastic bag or eight for your personal items (we will have some available)
Wear clothes (shoes included) that you don't mind getting SOAKED
Be careful with glasses, contact lenses (have spare contacts on you & eye drops if possible, eye beer != fun times)
Don't forget to EAT beforehand and HYDRATE at all times.
You've done this before, they might not have. Help them have a safe and successful century club!
",Entrepot Dominion,201901112100,201901120300,0,T,2,500,,,,,,,,,,,,,,,,,,,,,,,,0,x,x,x,x,x,x,x,x,x,x
Final Breakfast,"Well, that black hole travel knocked all of us off our feet didn't it... No need to worry cause we have a great recovery session planned out for y'all at the last breakfast of the week! Come hangout with us (and, who are we kidding, you just want food) while we send some challenges your way.",Common Room,201901120900,201901121000,0,T,4,100,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Mystery Challenge,"Captain, captain ! We have received an emergency transmission from a nearby ship. Skrshhhhhhh kssssshhhhh rxcrcxrxc beeeeeeeeep. Well, I guess we're going to have to check it out... MAKE SURE TO BRING AT LEAST 1-2 LAPTOPS PER TEAM.",Common Room,201901121000,201901121200,0,T,3,250,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Fear of Food,"Alien goop, yumyum! Participants will experience alien goop and degust other space foods. (This event is not vegetarian friendly)",Common Room,201901121000,201901121200,1,R,3,300,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Chariot Races,"Move aside, Fast and Furious! This year we're going to blast out of here faster than lightspeed. Stock up on fuel, get your final tech repairs done and get ready to launch your Damn Thing as fast as you can! May the warpspeed be with us all, let the fastest team win!",Campus,201901121200,201901121530,0,R,1,1000,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Therapy Dogs,"You just called your explorer rovers back and GUESS WHAT, they discovered an amazing beautiful habitat of SPACE PUPPERS. After being exposed to the endless cuteness radiated by these fluffy aliens and endless negotiations with Laurent, we have managed to arrange a diplomatic petting session for all of our discretion. Pls come with your best attitude as this is the MOST IMPORTANT EVENT OF ALL TIMES!",Common Room ,201901121200,201901121500,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Hot Chocolate,"Launch was one crazy of a ride, you've somehow made it but at the cost of your heating unit! As you keep cruising through the cold, dark space, you notice some white fluffy-looking chunks floating on Milky way along a line of HOT.... CHOCOLATE.... Come hangout and warm your crew with the best thing found on space.",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Ultimate Pres,"What a crazy week this has been! You've sweated blood and tears (hopefully not literally :/) and finally have come this far, competing to your upmost capabilities in space, shoulder to shoulder with your entire crew! Now, before the greatest week of all times comes to an end and we all unite as one giant crew, cause, well, #weareallbestfriendzzz, you must show us your final setting, on your, PHASERS! Here comes the ultimate ultimate event that can change everything with literally just by having the most fun! Show your Fleet Commanders your crew spirit!!",Montreal,201901121800,201901122100,0,T,1,750,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
Closing Ceremonies,"Welcome ladies and gentlemen to the night you've all been waiting for. We've searched the galaxy near and far for the one crew who has what it takes. Come one, come all to THE FINAL event. Only one team can win and make it to the FINAL FRONTIER, and for the others— it's time to hop on that bicycle to ride back home.",Queue Leu Leu,201901122100,201901122400,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,
</data>
Preyansh, this might be way more complicated than you had in mind, so forgive me. I think it could be more automated, but if you'd rather another way it's ALL YOURS! This was fun for me, so if you want another way that's all good.

So in short here's what's going on. If the coords have a table that has the data laid out as below, where '''Start''' and '''End''' are the YmdHi (concatenated timestamp sans seconds), we can insert that as comma separated syntax (see [[#The Data|the data]]) and then have it output in a table or other sort of fashion. This allows us to have all the event information accessible and reformattable from one location, as opposed to having to update say three locations at once. 
==The Input==
<pre>
<data table="E-Week 2019" fields="Start,End,Event,Location,Points,Rank/Tier,DoubleSub,Description,ASA,BUSS,BREE,CEUS,CHESS,CMEUS,ECSESS,MAME,MEUS,OLD">

201811271700,101811271830,Captain's Challenge,[[Blues Pub]],0,N/A,No,The captain's go on a hunt for clues!,10,20,30,40,50,60,70,80,90,100
201811271930,201811280230,Bus Trip to Nowhere,Nowhere,400,Ranked,No,TripleBogieNoDescription,1,2,3,4,5,6,7,8,9,10
201811280900,201811281000,Breakfast,Common Room,150,Tiered,No,This is where you eat food， points for participation,100,200,300,400,500,600,700,800,900,10000
201811281030,201811281430,Sports,Lower West Field,500,Ranked,Yes,You play the sports here,1000,2000,3000,4000,5000,6000,7000,8000,9000,10000

</data>
</pre>
==The Data==
I've not yet gone over with you what these alternative databases are.... In short, it's like mySQL but accessible to queries inside of the wiki. So when we input the information below, it creates and inserts information into a table called '''[[Table:E-Week 2019]]''' into the different fields we specify. Below is a full table of what is contained in that table, and will auto update as the information above is altered. It does not store anything, so if the above text is removed the table would have no information.
<repeat table="E-Week 2019"></repeat>

==Output Examples==
Now that it's all neat and tidy in one place, you can query it! So you can say things like
 Start>201811280000 
 Day = Tuesday
 Points = 500
Or a combination therein. Better yet, you can format the '''Start''' and '''End''' using <code><nowiki>{{#time:FORMAT|STRING}}</nowiki></code> parser functions to change the string into 6:00PM, Tuesday, or other date/time formats.
As far as I can tell, there's not an easy way to give viewers access to that kind of querying, but that's OK. 

After all this you can create a <code><nowiki><repeat table="E-Week 2019"></nowiki></code> Repeat Table. The repeat tag will apply the syntax to every line that matches the query. For example, you can create a table or bullet separated or button separated or any kind of format that pulls the row's data, over and over.
===Table===
;Criteria 
:Start Time < 201811271900 ''<small>({{#time:Y-m-d H:i|201811271900}})</small>''
<repeat table="E-Week 2019">
<header>
{| class="wikitable"
! Event !! Location !!Time End
|-
</header>
{{#ifexpr:{{{Start}}}<201811271900
|{{Test3|1={{{Event}}}|2={{{Location}}}|3={{#time:H:iA|{{{End}}} }} }}
}}
<footer>
|}
</footer>
</repeat>
===Bulleted===
;Criteria 
:Start Time > 201811271900 ''<small>({{#time:Y-m-d H:i|201811271900}})</small>''

----
<repeat table="E-Week 2019">{{#ifexpr:{{{Start}}}>201811271900
|{{Test4|1={{{Event}}}|2={{{Location}}}}}
}}</repeat>