|
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(', Women''s Lacrosse,',', ' + Category + ',') > 0 )
ORDER BY PublishStart Desc, ListPosition - Sophomore sisters Ashley and Justine Leggio earn spots on the second team
- Ashley Leggio and Brittany Hodnik each tally two goals and two assists
- Ashley Leggio surpasses the 100 point plateau for the season
- Leggio twins combine for 12 goals and six assists in the loss
|
