|
65 West South Street
Wilkes-Barre,
Pennsylvania 18766
Phone: 570-408-4590
Fax: 570-408-4591
Email: apkc@wilkes.edu
Dr. Jeffrey Alves, Allen P Kirby Jr Professor
(570) 408-4592 • Email
Ms. Lorna Galliford, Office Assistant
(570) 408-4590 • Email
Ms Jenna Strzelecki - Graduate Assistant
(570) 408-2117 • Email
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(', Sidhu/Business,',', ' + Category + ',') > 0 )
ORDER BY PublishStart Desc, ListPosition
|
