Create and Query Tables

From EUSwiki
Jump to: navigation, search

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) 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

<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>

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.

Event Read Description Location Start End DoubleSub RankTier Scale Points ASAscore BUSSscore BREEscore CEUSscore CHESSscore CMEUSscore ECSESSscore MAMEscore MEUSscore OLDscore ASAplace BUSSplace BREEplace CEUSeach CEUSplace CHESSplace CMEUSplace ECSESSeach ECSESSplace MAMEeach MAMEplace MEUSplace OLDplace DamnThing ASAdt BUSSdt BREEdt CEUSdt CHESSdt CMEUSdt ECSESSdt MAMEdt MEUSdt OLDdt
Damn Thing Total 0 This is a sum total point value for damn thing checkins       0 NA     50 75 25 175 50 25 50 150 75 25                             2 3 1 7 2 1 2 6 3 1
Bonus Points 0         0 NA     113 133 81 108 43 60 216 808.5 575 208                                                
Captain's Challenge 1 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 201901081100 201901081530 0 R 3 300 21 90 75 120 240 45 180 300 60 30 10 5 6   4 2 8   3   1 7 9 0 x x x x x x x x x x
Sustainability Challenge 1 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.   201901081500 201901081730 0 R 2 600 480 360 360 600 480 360 360 480 600 480 2 3 3   1 2 3   3   2 1 2 0   x x x x x x x x x
Beer Die 1 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 201901081600 201901081800 1 R 2 600 360 90 90 150 480 600 240 150 180 90 3 8 8   6 2 1   4   6 5 8 0 x x x x x x x x x x
Rookie Challenge (Physical) 1 Welcome to the Space Cadet Training Program. First things first， an Astronaut must be in good PHYSICAL shape... McConnell Basement Elevators 201901081630 201901081730 1 R 3 300 120 90 300 90 75 75 120 120 90 75 4 5 1   5 6 6 2>>6 4 3>>5 4 5 6 1 1 1 0 2 1 1 1 1 1 1
DUSTED/Time Trials 1 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 ??? 201901081830 201901090300 0 R 1 1000 800 1000 800 1000 800 600 1000 1000 1000 1000 2 1 2   1 2 3   1   1 1 1 0 x x x x x x x x x x
Breakfast 1 1 How do spaceships start their day off right? They fuel up! Come on down to the Common Room， eskethis bread! Common Room 201901090830 201901090930 0 T 4 100                                               1 1 1 0 1 1 0 1 1 1 0
Broomball 1 """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 360 60 90 480 150 42 180 600 120 240 3 9 8   2 6 10   5   1 7 4 0 x x x x x x x x x x
Fort Building 1 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 201901091100 0 T 2 500 500 300 500 300 500 300 300 500 300   1 2 1   2 1 2   2   1 2   1 0 1 1 4 0 0 0 2 1 0
Hot Chocolate 1 After the smoke has cleared from the battles of broomball， treat yourself to some space(?) hot chocolate Common Room 201901091030 201901091130 0 NA                                                   0                    
Innertube Water Polo 1 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 201901091530 0 R 2 600 60 120 180 240 480 42 150 360 90 600 9 7 5   4 2 10   6   3 8 1 0 x x x x x x x x x x
Video Games 1 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. Common Room 201901091200 201901091500 0 NA                                                   0 x x x x x x x x x x
Mario Kart Double Dash 0   Common Room 201901091200 201901091500 1 R 4 150 22.5 15 45 150 37.5 120 60 30 30 90 8 9 5   1 6 2   4   7 7 3 0 x x x x x x x x x x
Super Smash 0   Common Room 201901091200 201901091500 1 R 4 150   120 22.5 45 60 37.5 90 30 150 15   2 8   5 4 6   3   7 1 9 0 x x x x x x x x x x
Just Dance 0   Common Room 201901091200 201901091500 1 R 4 150   90 30   150 37.5 22.5 60 45 120   3 7     1 6   8   4 5 2 0 x x x x x x x x x x
FIFA 0   Common Room 201901091200 201901091500 1 R 4 150   37.5 90 120 15 37.5 60 150 45 22.5   6 3   2 9 6   4   1 5 8 0 x x x x x x x x x x
Pub Crawl (Walking) 1 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 201901091600 201901092000 0 T 2 500 500 500 150 300 300 300 150 500 300 500 1 1 3   2 2 2   3   1 2 1 0 x x x x x x x x x x
Pub Crawl (Running) 0   Montreal 201901091600 201901092000 0 R 1 1000 400 200 150 800 300 70 250 600 1000 100 4 7 8   2 5 10   6   3 1 9 0 x x x x x x x x x x
Beer Olympics 1 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 201901100200 1 NA                                                   1               2    
Flip Cup 0   Sky 201901092100 201901100200 1 R 4 150 15 30 37.5 22.5 120 45 90 150 10.5 60 9 7 6   8 2 5   3   1 10 4 0 x x x x x x x x x x
Tummies 0   Sky 201901092100 201901100200 1 R 4 150 90 22.5 37.5 45 30 10.5 60 120 15 150 3 8 6   5 7 10   4   2 9 1 0 x x x x x x x x x x
Civil War 0   Sky 201901092100 201901100200 1 R 4 150 22.5 37.5 30 60 150 45 90 15 60 15 8 6 7   4 1 5   3   9 4 9 0 x x x x x x x x x x
Stacks/Basketball 0   Sky 201901092100 201901100200 0 R 4 150 90 120 120 150 60 120 60 37.5 45 30 3 2 2   1 4 2   4   6 5 7 0 x x x x x x x x x x
Creative Chug 0   Sky 201901092100 201901100200 1 T 4 100 60 30 30 60 30 100 100 100 60 100 2 3 3   2 3 1   1   1 2 1 0 x x x x x x x x x x
Relay Races 0   Sky 201901092100 201901100200 0 R 4 150 120 15 10.5 37.5 90 30 45 150 60 22.5 2 9 10   6 3 7   5   1 4 8 0 x x x x x x x x x x
Musical Beers (Rookie) 0   Sky 201901092100 201901100200 0 R 4 150 22.5 15 30 60 90 10.5 45 120 37.5 150 8 9 7   4 3 10   5   2 6 1 0 x x x x x x x x x x
Chug Ladder BEST 0   Sky 201901092100 201901100200 1 T 4 100                                               0 x x x x x x x x x x
Chug Ladder WORST 0   Sky 201901092100 201901100200 1 T 4 100                                               0 x x x x x x x x x x
Mountain Run 1 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 120 360 600 240 90 42 150 180 480 60 7 3 1   4 8 10   6   5 2 9 0 x x x x x x x x x x
Big Breakfast 1 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 201901101030 0 T 4 100 60 100 30 30 100 100 30 60 60 100 2 1 3   3 1 1   3   2 2 1 1                    
Trivia 1 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 201901100930 201901101030 0 R 3 300 45 240 90 60 75 30 120 180 300 30 8 2 5   7 6 9   4   3 1 9 0 x x x x x x x x x x
Aptitude Test 1 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 300 300 500 500 300 500 500 500 500 500 2 2 1   1 2 1   1   1 1 1 0 x x x x x x x x x x
WMC 1 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. Common Room 201901101200 201901101330 0 R 1 1000 300 250   800 1000   400 200 600 150 5 6     2 1     4   7 3 8 0 x x x x x x x x x x
Design Comp 1 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 201901101630 0 R 1 1000 250 400 600 300 1000 150 200 800 100 70 6 4 3   5 1 8   7   2 9 10 1                    
Iron Chef 1 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 500 500 150 300 500 300 300 300 500 500 1 1 3   2 1 2   2   2 1 1 0 x x x x x x x x x x
Rookie Challenge (Artistic) 1 Round two ! This time， INTELLECTUAL capabilities will be tested. Are you up for the challenge ? Committee Room 201901101600 201901101700 1 R 3 300 45 120 300 180 45 120 60 240 120 45 8 4 1   3 8 4   7   2 4 8 0 x x x x x x x x x x
Beer Tasting 1 "Aristotle once asked， ""Does beer taste different in Space?""" Julia's House 201901101700 201901101800 1 R 4 150 10.5 120 15 37.5 60 90 30 45 150 22.5 10 2 9   6 4 3   7   5 1 8 0 x x x x x x x x x x
BOAT Races 1 "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 201901110200 0 R 1 1000 250 100 200 800 300 150 400 1000 600 70 6 9 7   2 5 8   4   1 3 10 1                    
Sports Semis & Finals 1 FINISH THEM. Lower Field 201901110900 201901111100 0 NA                                                   0                    
Hot Chocolate 1 Have some more of that hot chocolate， from space. Common Room 201901110930 201901111100 0 NA                                                   0                    
3-Man (Ranked) 1 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 201901111100 201901111300 0 R 4 150 37.5 60 22.5 150 15 120 45 90 30 10.5 6 4 8   1 9 2   5   3 7 10 0 x x x x x x x x x x
3-Man (Tiered) 0 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 201901111100 201901111300 0 T 3 250 150 250 250 150 75 150 150 250 250 250 2 1 1   2 3 2   2   1 1 1 0 x x x x x x x x x x
Lip Sync 1 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 201901111430 0 T 3 250 250 75 75 250 150 150 150 150 250 250 1 3 3   1 2 2   2   2 1 1 1                    
Drunken Debates 1 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 201901111430 201901111600 0 R 2 600 120 150 90 60 240 360 180 480 600 42 7 6 8   9 4 3   5   2 1 10 1                    
Rookie Challenge (Intellectual) 1 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 120 240 75 75 45   120 180 300   4 2 6   6 8     4   3 1   0 x x x x x x x x x x
Beer Die 1 Final round of the notorious game of Beer Die Common Room 201901111600 201901112100 0 NA                                                   0                    
Iron Bartender 1 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 201901111700 201901111800 0 T 3 250   150   250 150 150 250 250 250 150   2     1 2 2   1   1 1 2 0 x x x x x x x x x x
FOAT Races 1 Eat it， but fast Common Room 201901111800 201901112000 0 R 3 300 45 120 75 60 300 21 30 180 240 90 8 4 6   7 1 10   9   3 2 5 0 x x x x x x x x x x
Century Club 1 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 500 500 300 500 300 300 500 500 500 500 1 1 2   1 2 2   1   1 1 1 0 x x x x x x x x x x
Final Breakfast 1 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 60 100 60 100 100 60 60 100 100 100 2 1 2   1 1 2   2   1 1 1 1               x x  
Mystery Challenge 1 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 201901121100 0 T 3 250 150 150 250 250 250   150 250 250   2 2 1   1 1     2   1 1   1                    
Fear of Food 1 Alien goop， yumyum! Participants will experience alien goop and degust other space foods. (This event is not vegetarian friendly) Common Room 201901121100 201901121200 1 R 3 300 45 240 60 120 30   90 75 300 180 8 2 7   4 9     5   6 1 3 1                    
Chariot Races 1 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 70 150 400 1000 250 200 100 300 800 600 10 8 4   1 6 7   9   5 2 3 1                    
Therapy Dogs 1 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 0 R 1 1000 1000 1000 800 1000 800 600 1000 1000 1000 1000 1 1 2   1 2 3   1   1 1 1 0 x x x x x x x x x x
Hot Chocolate 1 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. Common Room 201901121500 201901121630 0 NA                                                   0 x x x x x x x x x x
Ultimate Pres 1 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 201901121730 201901122100 0 T 1 750                                               1                    
Closing Ceremonies 1 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 201901130200 0 0                                                   1                    

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 {{#time:FORMAT|STRING}} 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 <repeat table="E-Week 2019"> 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 (2018-11-27 19:00)
Event Location Time End
Captain's Challenge Campus 15:30PM
Sustainability Challenge 17:30PM
Beer Die Common Room 18:00PM
Rookie Challenge (Physical) McConnell Basement Elevators 17:30PM
DUSTED/Time Trials ??? 03:00AM
Breakfast 1 Common Room 09:30AM
Broomball Lower Field 12:00PM
Fort Building Lower Field 11:00AM
Hot Chocolate Common Room 11:30AM
Innertube Water Polo McGill Gym Pool 15:30PM
Video Games Common Room 15:00PM
Mario Kart Double Dash Common Room 15:00PM
Super Smash Common Room 15:00PM
Just Dance Common Room 15:00PM
FIFA Common Room 15:00PM
Pub Crawl (Walking) Montreal 20:00PM
Pub Crawl (Running) Montreal 20:00PM
Beer Olympics Sky 02:00AM
Flip Cup Sky 02:00AM
Tummies Sky 02:00AM
Civil War Sky 02:00AM
Stacks/Basketball Sky 02:00AM
Creative Chug Sky 02:00AM
Relay Races Sky 02:00AM
Musical Beers (Rookie) Sky 02:00AM
Chug Ladder BEST Sky 02:00AM
Chug Ladder WORST Sky 02:00AM
Mountain Run Mount Royal 09:30AM
Big Breakfast Common Room 10:30AM
Trivia Common Room 10:30AM
Aptitude Test Common Room 13:30PM
WMC Common Room 13:30PM
Design Comp Trottier Mezzanine 16:30PM
Iron Chef Common Room 15:30PM
Rookie Challenge (Artistic) Committee Room 17:00PM
Beer Tasting Julia's House 18:00PM
BOAT Races Cafe Campus 02:00AM
Sports Semis & Finals Lower Field 11:00AM
Hot Chocolate Common Room 11:00AM
3-Man (Ranked) Cafe Campus 13:00PM
3-Man (Tiered) Cafe Campus 13:00PM
Lip Sync Cafe Campus 14:30PM
Drunken Debates Cafe Campus 16:00PM
Rookie Challenge (Intellectual) Common Room 21:00PM
Beer Die Common Room 21:00PM
Iron Bartender Chris Sarlos' Apartment 18:00PM
FOAT Races Common Room 20:00PM
Century Club Entrepot Dominion 03:00AM
Final Breakfast Common Room 10:00AM
Mystery Challenge Common Room 11:00AM
Fear of Food Common Room 12:00PM
Chariot Races Campus 15:30PM
Therapy Dogs Common Room 15:00PM
Hot Chocolate Common Room 16:30PM
Ultimate Pres Montreal 21:00PM
Closing Ceremonies Queue Leu Leu 02:00AM


Bulleted

Criteria
Start Time > 201811271900 (2018-11-27 19:00)

Expression error: Unexpected > operator.Expression error: Unexpected > operator.

  • Event: Captain's Challenge , located at Campus
  • Event: Sustainability Challenge , located at
  • Event: Beer Die , located at Common Room
  • Event: Rookie Challenge (Physical) , located at McConnell Basement Elevators
  • Event: DUSTED/Time Trials , located at ???
  • Event: Breakfast 1 , located at Common Room
  • Event: Broomball , located at Lower Field
  • Event: Fort Building , located at Lower Field
  • Event: Hot Chocolate , located at Common Room
  • Event: Innertube Water Polo , located at McGill Gym Pool
  • Event: Video Games , located at Common Room
  • Event: Mario Kart Double Dash , located at Common Room
  • Event: Super Smash , located at Common Room
  • Event: Just Dance , located at Common Room
  • Event: FIFA , located at Common Room
  • Event: Pub Crawl (Walking) , located at Montreal
  • Event: Pub Crawl (Running) , located at Montreal
  • Event: Beer Olympics , located at Sky
  • Event: Flip Cup , located at Sky
  • Event: Tummies , located at Sky
  • Event: Civil War , located at Sky
  • Event: Stacks/Basketball , located at Sky
  • Event: Creative Chug , located at Sky
  • Event: Relay Races , located at Sky
  • Event: Musical Beers (Rookie) , located at Sky
  • Event: Chug Ladder BEST , located at Sky
  • Event: Chug Ladder WORST , located at Sky
  • Event: Mountain Run , located at Mount Royal
  • Event: Big Breakfast , located at Common Room
  • Event: Trivia , located at Common Room
  • Event: Aptitude Test , located at Common Room
  • Event: WMC , located at Common Room
  • Event: Design Comp , located at Trottier Mezzanine
  • Event: Iron Chef , located at Common Room
  • Event: Rookie Challenge (Artistic) , located at Committee Room
  • Event: Beer Tasting , located at Julia's House
  • Event: BOAT Races , located at Cafe Campus
  • Event: Sports Semis & Finals , located at Lower Field
  • Event: Hot Chocolate , located at Common Room
  • Event: 3-Man (Ranked) , located at Cafe Campus
  • Event: 3-Man (Tiered) , located at Cafe Campus
  • Event: Lip Sync , located at Cafe Campus
  • Event: Drunken Debates , located at Cafe Campus
  • Event: Rookie Challenge (Intellectual) , located at Common Room
  • Event: Beer Die , located at Common Room
  • Event: Iron Bartender , located at Chris Sarlos' Apartment
  • Event: FOAT Races , located at Common Room
  • Event: Century Club , located at Entrepot Dominion
  • Event: Final Breakfast , located at Common Room
  • Event: Mystery Challenge , located at Common Room
  • Event: Fear of Food , located at Common Room
  • Event: Chariot Races , located at Campus
  • Event: Therapy Dogs , located at Common Room
  • Event: Hot Chocolate , located at Common Room
  • Event: Ultimate Pres , located at Montreal
  • Event: Closing Ceremonies , located at Queue Leu Leu
Retrieved from "https://eus.wiki/index.php?title=Create_and_Query_Tables&oldid=52108"