Basketball - Men's Roster
select c.ItemID, c.title as name, c.subtitle as phone, c.sourceurl as email, channel.detailurl, link.customvc128_3 as no, link.Customvc128_2 as year, link.CustomVC128_1 as position, c.customvc256_1 as height, c.customvc256_2 as weight, c.location as hometown, c.source as previousschool, ss.sourceURL as RosterPDFLink from channeldatalink link, channeldata c, channeldata ss, channel where ss.itemid=1026 AND ss.itemid = link.owningitemid AND c.itemid = link.owneditemid AND c.channelid = channel.channelid AND ss.status in (0,1) and c.status in (0,1) and channel.status=1 and GetDate() BETWEEN IsNull(ss.PublishStart,GetDate()) AND IsNull(ss.PublishStop,GetDate()+1) and GetDate() BETWEEN IsNull(c.PublishStart,GetDate()) AND IsNull(c.PublishStop,GetDate()+1) AND link.customint1=1 order by c.listposition, link.customint1, link.customint2, cast(link.customvc128_3 as int), c.customvc128_3, c.customvc128_1 ;
PLAYERS
| Name |
No. |
Position |
Height |
Year |
Hometown |
Previous School |
| Dominic Williams |
1 |
G |
6'1 |
SO |
San Antonio, TX |
Sam Houston High School |
| Jay Lee |
3 |
G |
6'0 |
FR |
Glasgow, MO |
Glasgow High School |
| Vatroslav Batinic |
10 |
F |
6'7 |
FR |
Split, Croatia |
Obrtnicka School Split |
| Dominique Newton |
15 |
G |
6'0 |
FR |
Raytown, MO |
Raytown South/Central Ark. |
| Filip Toric |
20 |
G |
6'6 |
FR |
Zagreb, Croatia |
II Economic |
| Clifton Fleming |
21 |
G |
5'10 |
SO |
Chicago, IL |
St. Anne Community High |
| George Williams |
22 |
G |
6'5 |
SO |
Houston, TX |
Brookville High/Seminole College (FL) |
| Justyn Watkins |
23 |
F |
6'5 |
SO |
Orlando, FL |
Dr. Phillips High School |
| Bosko Ognenovski |
24 |
F |
6'8 |
FR |
Bitola, Macedonia |
Bethel Christian Academy |
| Cameron Yates |
25 |
F |
6'4 |
FR |
Preston, MO |
Skyline High School |
| Wesley Fritz |
31 |
G |
6'4 |
FR |
Warrensburg, MO |
Warrensburg High/Westminster |
| Travis Jordan |
33 |
G/F |
6'6 |
FR |
Brooklyn, NY |
Genesis One Christian School |
| Timothy Kiewel |
34 |
C |
6'10 |
SO |
Parma, OH |
Valley Forge High/Eastern Arizona College |
| Brandon Scaife |
45 |
C |
6'7 |
SO |
Blue Springs, MO |
Raytown/Seminole College (OK) |
| Matthew Webb |
50 |
F |
6'8 |
FR |
Kansas City, MO |
Lees's Summit Christian |
select c.ItemID, c.title as name, c.subtitle as phone, c.sourceurl as email, channel.detailurl, link.customvc128_3 as no, link.Customvc128_2 as year, link.CustomVC128_1 as position, c.customvc256_1 as height, c.customvc256_2 as weight, c.location as hometown, c.source as previousschool, ss.sourceURL as RosterPDFLink from channeldatalink link, channeldata c, channeldata ss, channel where ss.itemid=1026 AND ss.itemid = link.owningitemid AND c.itemid = link.owneditemid AND c.channelid = channel.channelid AND ss.status in (0,1) and c.status in (0,1) and channel.status=1 and GetDate() BETWEEN IsNull(ss.PublishStart,GetDate()) AND IsNull(ss.PublishStop,GetDate()+1) and GetDate() BETWEEN IsNull(c.PublishStart,GetDate()) AND IsNull(c.PublishStop,GetDate()+1) AND link.customint1=2 order by c.listposition, link.customint1, link.customint2, cast(link.customvc128_3 as int), c.customvc128_3, c.customvc128_1 ;
COACHES
| Name |
Position |
Phone |
E-Mail |
| Dale Ribble |
Head Coach |
(660) 596-7240 |
dribble@sfccmo.edu |
| Kevin Thomas |
Asst. Coach |
(660) 596-7344 |
kthomas10@sfccmo.edu |
select c.ItemID, c.title as name, c.subtitle as phone, c.sourceurl as email, channel.detailurl, link.customvc128_3 as no, link.Customvc128_2 as year, link.CustomVC128_1 as position, c.customvc256_1 as height, c.customvc256_2 as weight, c.location as hometown, c.source as previousschool, ss.sourceURL as RosterPDFLink from channeldatalink link, channeldata c, channeldata ss, channel where ss.itemid=1026 AND ss.itemid = link.owningitemid AND c.itemid = link.owneditemid AND c.channelid = channel.channelid AND ss.status in (0,1) and c.status in (0,1) and channel.status=1 and GetDate() BETWEEN IsNull(ss.PublishStart,GetDate()) AND IsNull(ss.PublishStop,GetDate()+1) and GetDate() BETWEEN IsNull(c.PublishStart,GetDate()) AND IsNull(c.PublishStop,GetDate()+1) AND link.customint1=3 order by c.listposition, link.customint1, link.customint2, cast(link.customvc128_3 as int), c.customvc128_3, c.customvc128_1 ;
OTHER STAFF
