|
|
Brian E. Whitman
Associate Professor of Environmental Engineering
Ph, D. 1998 Michigan Technological University
Research interests:
Biological process design, hydrologic and hydraulic design, water and
wastewater process design, bioremediation, soil microbiology, ecosystem
restoration
|
|
|
|
|
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
|