PresenterID ExhibitID mSysRowId
1 1 LJCVTnpeaVLKRic4sMWB2KyrDFR4OgDo9HGdzqAd8zI=-~X84V3n57z+gbvYmKO4wJ/Q==
1 4 P1swToDd63n0OaXZ9dILkMrDXrXWHtH52cNSLQPJBR4=-~01YyitGIDowQzSgSjDgcrA==
1 9 eZmRL1YJjlD3Q3n1FwfelLC5gDETT1IeDU3zz0CC558=-~FuoWiBEw2EKAur+/LVYbow==
1 10 Sb+tT+bBhyeD4XiWse8O37wgQuMWyaaohXBz4AY88WI=-~/ikJFnTRjZK5/7CqVBHxFQ==
1 13 18BhunCgHjFp8mBM008AGs2VNCLQjSLqfhqoB/p/A60=-~wmwSDnsFQNsUn8ci88jUrA==
1 14 y2gDomSiMIGSCe+JD1JKAocB47CNDqMC1ho6UZ97f1k=-~K6Wo/1J6LumQiYLFHpgW2Q==
2 1 vA5/Dkp5JqJg4WBM2nxoH64oU7PHA1pfcB1oCjiJOdA=-~HMZXqzDWFMXyPqfUMZCCCA==
3 2 E/jmGuWiarkS3I+hCZ4YRAM55ESSIC/BJk4hwzP2jnE=-~8FvZAw2KewgjoswLdQOsOQ==
3 6 Q8jVGcpRjWX5X6is5bfXzE/ldOf26eC3p0MkzJS7gGE=-~VHJeCHQTJqF6Qyc8YeD3ZQ==
3 9 nE/DCiv6ByiIxzRowmqAgk0cTRgb7Zuem9q/P+s/amk=-~e2FKGIFMIAfCGLy/1bbSkw==
4 9 mb0GZXdGCl2AnGn/J2gbDeUCPaTgEheGhPRyIAZK5Fg=-~hS6tBFe0y+ZwmY//l/QEsw==
4 12 MGXiwb3uprj8zYcsaZXpsFxw+xAEQOukqkf/XqGqC74=-~4tR8Tr0IMVnTtSnOLoAzpw==
5 2 45uS5kt5NMWSd1QNCa9Z/6OD2zMkVhbji2rt3K76xgQ=-~n7zcHSacl3BgTUYRn5BMQg==
5 7 AKDgZOhU6XckjyCho0dAPjl9AaEPMgP3y8qLDYkX6kk=-~6pCbA6ZQwrB/mJXFQ/45vw==
5 13 SLrGpAvBQ9Dyy/itHskQoir2oE1hENGEQwaIz84W+9U=-~hzmnuHzgx9QLNGMQmfeV4Q==
6 6 az+K/GDvOnxwiRoHd9bTj1NPQWWyyLebK9VHVrehFdk=-~bO+JFlfwBSLx/lJfUEozDA==
7 2 vM0gtP56GrUb3H9G5V9xvw1nawO4gxT66b+jYASlgQQ=-~NeVQtD4cDbducl0f2if4JQ==
7 3 vDHFOLd+OoFdR73LkiOrXA/f+QVe5LTcNT3GPCx7RZA=-~nXMUPYybwGNzFzV11QsBNw==
7 8 dx58CKkcJFX1KYSUWxDetb/h9k4h1ucBM5yGNToYDRA=-~zxe60vsqpQO5g4WWTW/s7Q==
7 12 lRW0pNa9QqmUl1oav2fQhIn+GvGk79PoZ7ouPTQvEKE=-~Sjk2SogFWhNpKwslbC7KxQ==
8 9 AvmokSXgLHN0LJhDYnEl5FSro/C2UqOWz1p3KQNxBJY=-~fbkWwi7vyElNaYTG2IzgGA==
8 10 JL7i99UJpzM9f1w7m8BTQz1zw0U6gvZqugs7Dl3ZOsw=-~dYi/IvWfKw+5bm7XMJke/Q==
9 13 +VZOorRelIbXXMrLgYuX57qM0q8YCpEoxT7q5hjRDqY=-~s8GromjqVkA356cOcfRRAg==
10 5 ut0ZPdYCNa1wd7vlHkai3eOqQAQgOMiP89mUHBiJc38=-~v9jjb05wNg24yealHeyFgA==
10 8 UzhXK6JpxIkUi6LMEXp5Qn/b9L6Nc8rwucXVBSV8sB4=-~SuHVN12bDOUi+K8rUcYg2Q==
10 11 QOzR0W7cNEUo6MJmvLxq2aQz26xHeTEELNPyTJN1V9I=-~hFR/mF7SYtco1lSKy/6naQ==
11 2 9tnd1j7GXnlFRKcGHcf4liRmuTCEuwaPePbP0pmh1l0=-~fUkJI4uhZ3F0KrJvj1r16w==
12 6 hMYCa2i0sirJOt151azrN1p8gTo1qUUOFidUJT6HXYk=-~hSoymLKznOo5/izcd0opyw==
13 2 OAXc/2j8yGXi7+OFcdARZBIUDV1vfY/jo97dg4t5fow=-~q0FIk6/AJEaGV7jhpR/pgA==
13 7 aEvtYod2Annld4EJqfUcoVeYSO4zQLM9MemqAFDhvWs=-~lp5WWlYZNRETnJTXzbYHhQ==
13 9 xxi0YDceFEHA4P2XZ0U6gE7lJ39x9hR45aV+vsQJjYs=-~7eRi9vh5ugats3fv2XI3Iw==
ExhibitID ExhibitTitle LocationID Date StartingTime mSysRowId
1 Skills Competition I 101 9/1/18 12/30/99 xt2LzSQa28f2NMDOQ1p3jjzKIRxh4aqwW0F3Ii307Co=-~nIFLBGr+IuX4B6/Jpm81Yw==
2 Rabbit Show 103 9/1/18 12/30/99 idckZWMX4JbMTDXp7hRJMmbGy3qgEATRsPbTqARpE2U=-~olUWyTbsTdtggk4Hnh1tOA==
3 Dairy Show 104 9/1/18 12/30/99 NJ6lfk8No3Y3roQWGMPEtIhaKAyeTgHgd6k5aVcYvPs=-~ma+u7G94oCkCgw47GMl18Q==
4 Sheep and Goat Show 101 9/1/18 12/30/99 01LVanM3NXjCfjyLdN3nIlQJu8FnCw/+6iX2LVd9Ugo=-~if2oc2xK6Il9vK7FRZpyIg==
5 Swine Show 101 9/2/18 12/30/99 zzng+lR7CSCfH7OJ+RAYqFyBnPAj6owmaeAh0GPEBIo=-~08MJ49a0w0I5wlLxptttrA==
6 Vegetable Exhibit 102 9/2/18 12/30/99 294DgtD7eg62XRtNFW/6ETJbhMre9DrH6SygY7qD1ZE=-~2GK/5eCVgDIiX3AJ0zwFCQ==
7 Breeding Techniques 105 9/2/18 12/30/99 Pz46xTH0ybiQeynrMF6XzomoC7y5jEpbSNVC4/aEaR8=-~9HGCX3QgKKuhEYTma0PcqA==
8 Virtual Garden Tour 105 9/2/18 12/30/99 7huuS/xOegF61N9GXk9ZYhp9lLzKM05nIRtn0MwQXmg=-~3J99KyjTtmUrelujOWFYYA==
9 Horticulture 104 9/2/18 12/30/99 NAstcqznYDcvzZ+7hxYwnd8mjtgiBmHVe0jaPvDncqY=-~+0kx0dWYz0KPc+3opMDxBQ==
10 Recruiting for Your Chapter 102 9/3/18 12/30/99 SaLg6Rt9ey3DFgu8P2jy9MaxXlI0c8lI/+XzLvrtEZ4=-~Sp6QSCXMWyjoBpriwcIMhg==
11 Herb Exhibit 103 9/3/18 12/30/99 RUlJuCJC0uFxusTF1Uaf4M1Tw99GSDKXUVc7luXng04=-~xGsdniFFvfYkHHSYSZ68jg==
12 Skills Competition II 101 9/3/18 12/30/99 LErMJfxE6SmTiKvVIVMFAA5CbEYPdOmZ/bMWZatwFA8=-~ejszdNJ8qQRpVDEsXiXjJw==
13 Basic Animal First Aid 104 9/3/18 12/30/99 s/XZ4OLZM97+uDGN/xRCRsvBJnQCTx3aigQWLzB10P0=-~PK+qcOUUgFRFT1PKMg75Xg==
14 Volunteer Opportunities 101 9/3/18 12/30/99 rFsuDnvQpRWQ7C/MQmdA2scq5+wvRx3VBJBKs4yfhAo=-~lySmiH0dB1yO3IzfiuhOEA==
LocationID Capacity Outdoors Refreshments Notes mSysRowId
101 150 true false Main stage j1EMyFu/wnHU2ZHOh7ZQDQQCiwUuJCb92aKI49afbWc=-~VNbSF3X+NTqGkcAjl0rKHw==
102 100 true true +rMlcAUud7+nEcen4dqr2NxVSLpWjE8KFSUA/A05bxU=-~xPgfM92Wmh37Usdo9IgIuA==
103 50 true true w1z+q2Va9Ar1PoqPieKYREcZ4n7I7gZsWQWwxheq040=-~xgTIfNDaKlPoVq3ZWCMJGQ==
104 25 true false Small display outside the main office ffKdsXzjiS+0Mq4gJv00om093GUwIFRlwenVZerw/DU=-~XKbAGnjdrTaBqr7hncmU6A==
105 75 false false 8Y1zfLKzDxnZHS8dVq7A5Ji2sTSvtNaGAfKiJ5IDa5E=-~p6Wfs1ReXQnCSQ36jDEPTw==
106 75 true true dui2XReBwK7uBiitN05TYj7EpDC5nw/YMjlM6cwbXbM=-~spkxwxz0LNMeDx+PJsdWpA==
107 50 true true h7N7eq7QSJYYp4o7W01EVfj4unQlhZckLUFIO2I0R2o=-~bMtEzDxHaokz5aGi114hlw==
ID mSysRowId
1 1n7tk+Ox/8daB0ZX3Vpo6NzxqqEPIxg54j0jgui1BrI=-~Q8YoQa5MUnf9tzbQx2TO6w==
PresenterID FirstName LastName Address City State ZipCode
1 Shannon Beck 368 Graham Avenue Graham KY 42344
2 Sheila Gibson 139 Park Avenue Benton IL 62812
3 Alexander Jackson 182 Route 20 Monroe LA 71207
4 Leroy Chavez 122 East 24th Street Guys TN 38339
5 Andrea Rose 244 Curtis Place Harrisburg PA 17128
6 Jennifer George 100 20th Avenue Waynesburg KY 40489
7 Robert Matthews 262 Graham Avenue Stem NC 27581
8 Kyle Shelton 355 Curtis Place Fort Totten ND 58335
9 Eric Ross 372 East 21st Street Bayamon PR 00958
10 Ida Walton 360 Graham Avenue Higden AR 72067
11 Phillip Perkins 15 Ryle Avenue Radersburg MT 59641
12 Harold Rogers 253 Main Street Deer Grove IL 61243
13 Janice Harvey 33 Main Street Willard UT 84340
14 Connie Hoffman 196 Curtis Place La Mirada CA 90637
15 Dana Taylor 44 Montclair Avenue Bloomington IL 61704
16 Marvin Rodriguez 166 Market Street Peoria IL 61641
17 Chetan Rana 10000 SW 59 Court Lake Norden SD 57248
ID FirstName LastName Address City StateProvince PostalCode FeePaid mSysRowId
8 Tatiana Toribio 124 West Windmore Dr New Fairfield CT 6812 true tb7qjK3wDZfEtstvo1ML8xCIorfZpCxic3m7q/cr2No=-~VmoPwYpJGnqx9KJM5KDNMA==
SELECT Rooms.RoomID FROM Rooms ORDER BY [RoomID];
PARAMETERS __SpeakerID Value; SELECT DISTINCTROW * FROM [SELECT [Speaker - Session Query].SpeakerID, [Speaker - Session Query].SessionID, [Speaker - Session Query].SessionTitle, [Speaker - Session Query].RoomID, [Speaker - Session Query].Date, [Speaker - Session Query].StartingTime FROM [Speaker - Session Query]]. AS [Speakers Form] WHERE ([__SpeakerID] = SpeakerID);
SELECT DISTINCTROW * FROM Locations;
SELECT Presenters.FirstName, Presenters.LastName, Exhibits.ExhibitTitle, Exhibits.LocationID, Exhibits.Date FROM Presenters INNER JOIN (Exhibits INNER JOIN ExhibitPresenter ON Exhibits.ExhibitID = ExhibitPresenter.[ExhibitID]) ON Presenters.PresenterID = ExhibitPresenter.[PresenterID];