View Main View CV View Publications Research & Courses Email Ken Website Office: Phone: Fax: Stark Learning Center RM 351 570-408-4758 570-408-7862	Ken Klemow Courses BIO 344 - Ecology BIO 361 - Plant Form and Function BIO 362 - Plant Diversity BIO 366 - Field Botany BIO 368 - Medical Botany FYF 101J - Alternative Energy

ListCustomSQL:
select ItemID,Title,SourceURL,SourceURLPopWin,null as SubTitle,null as TeaserText,RelatedURL,RelatedURLPopWin,c.DetailURL, Subtitle,StartDateTime,StopDateTime,publishstart,listposition FROM ChannelData cd, Channel c WHERE (cd.ChannelID IN ('{EFE2D943-25CE-4E20-BE8F-8EF6B3919D4F}')) AND cd.ChannelID = c.ChannelID AND cd.Status IN (1) AND ( CharIndex(', Biology Chemistry & Health Sciences,',', ' + Category + ',') > 0 OR CharIndex(', Geoenvironmental Sciences & Engineering,',', ' + Category + ',') > 0 ) ORDER BY PublishStart Desc, ListPosition