|
ListCustomSQL:
select ItemID,Title,SourceURL,SourceURLPopWin,SubTitle,TeaserText,RelatedURL,RelatedURLPopWin,c.DetailURL, Subtitle,StartDateTime,StopDateTime,publishstart,listposition FROM ChannelData cd, Channel c WHERE (cd.ChannelID IN ('{CEB164A8-7C12-461A-B447-F42FE6537AEE}')) AND cd.ChannelID = c.ChannelID AND cd.Status IN (1) AND ( CharIndex(', Men''s Soccer,',', ' + Category + ',') > 0 )
ORDER BY PublishStart Desc, ListPosition - Finish season with 11-8-3 record
- Soccer to play at 1:30 p.m. at King's, Field Hockey at 1 p.m. at home
- Moore gets assist and scores game-winning goal
- Vona and Jankowski placed on first team, Miller and Moore on second team
|
