|
|
Edward F. Foote, PharmD, FCCP, Professor and Department Chairperson
edward.foote@wilkes.edu
Shelli Holt-Macey, RPh, Director of Experiential Programs
shelli.holtmacey@wilkes.edu
Kristen Billek, RPh, Experiential Coordinator
kristen.billek@wilkkes.edu
Tracy Polumbo, Office Assistant, Experiential Programs
tracy.polumbo@wilkes.edu
Tina Koerber, Office Assistant, Department
tina.koerber@wilkes.edu
Faculty...
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(', Nursing,',', ' + Category + ',') > 0 OR CharIndex(', Pharmacy,',', ' + Category + ',') > 0 )
ORDER BY PublishStart Desc, ListPosition
|