Basketball - Women'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=613 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 |
Class |
No. |
Position |
Height |
Hometown |
Previous School |
| Ashlie Mayfield |
|
|
G |
5'10 |
Stafford, MO |
|
| Brittany Young |
FR |
5 |
G |
5'6" |
Mayfield, KY |
Graves County High |
| Ernesta Griciunaite |
SO |
13 |
C |
6'3 |
Silute, Lithuania |
Our Lady of Mount Carmel |
| Jordin Coleman |
SO |
15 |
G |
5'7 |
Jonesboro, AR |
Jonesboro H.S. |
| Tatiana Walker |
FR |
20 |
G |
5'6 |
Chicago, IL |
John Marshall Metro |
| LaTice Jones |
SO |
24 |
G/F |
5'11 |
Gary, IN |
Roosevelt High |
| Katelyn Main |
FR |
33 |
F |
5'11 |
Wheatland, MO |
Wheatland R-II |
| Antonia Jones |
FR |
34 |
G |
5'9 |
Ft. Smith, AR |
Spiro, OK |
| Valerie Blackwood |
FR |
41 |
C |
6'4 |
Toronto, Canada |
Thistletown Collegiate Institute |
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=613 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 |
| Darren Pannier |
Head Coach |
(660) 596-7232 |
dpannier@sfccmo.edu |
| Kevin Bucher |
Assistant Coach |
(660) 596-7457 |
kbucher@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=613 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 ;
