77 : <cfquery name="News" datasource="#Request.settings.dsn#" cachedwithin="#NewsCache#">
78 : Select top 1 News.Newsid,News.Topic,News.EmbededVideo,News.PublishDate,ContentType,ContentThumbnail,News.ArticleWriter,News.Media,News.Description,News.CommentsFlag,News.AudioEmbedURL, News.BREAKINGNEWSFLAG, News.HomeSliderCategory,News.IsSurvey,News.SurveyURL,country.* from News,NewsCategoryListing,newscountry,country
79 : where News.NewsId = <cfqueryparam value="#Idz#" cfsqltype="CF_SQL_INTEGER">
80 : and news.switch = 1
81 : and newscategorylisting.newsid = newscountry.newsid
|