<cfset NumberOfFeedItems = 99><cfquery name="getContent" datasource="#ds#">
	SELECT columntable.Title, columntable.DatePosted,columntable.seo_friendly,mainswapbig,mainswap
	FROM columntable
		WHERE columntable.status = 1  and (mag = 1)

order by columntable.id desc

limit 0,100

</cfquery><cfset theDatetime = "#dateformat(now(), "yyyy-mm-dd")#T#timeformat(now(), "HH:mm:ss")#EST"><cfheader name="Content-Type" value="text/xml"><cfsetting enablecfoutputonly="yes"><cfsavecontent variable="theXML">
<Cfoutput><?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
        xmlns:n="http://www.google.com/schemas/sitemap-news/0.9"
        xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">
        </Cfoutput>

<cfloop from="1" to = "#numberOfFeedItems#" index="ctr">
<Cfif #getContent.title[ctr]# does not contain "Are you Following">
    <cfscript>
      title = rereplace(getContent.title[ctr], "<", "&lt;", "ALL");
      title = rereplace(title, "&", "&amp;", "ALL");
	  title=REReplace(title,"&nbsp;","","all");
  	  title=REReplace(title, Chr(145),"'","all");
  	  title=REReplace(title, Chr(8217),"'","all");
   	  title=REReplace(title, Chr(146),"'","all");
  	  title=REReplace(title, Chr(147),"'","all");
   	  title=REReplace(title, Chr(148),"'","all");
  	  title=REReplace(title, Chr(8211),"-","all");
   	  title=REReplace(title, Chr(150),"-","all");
      title = rereplace(title, "-", "-", "ALL");
      date = dateformat(getContent.dateposted[ctr], "yyyy-mm-dd");
     time = timeformat(getContent.dateposted[ctr], "HH:mm:ss");
      pubDate = date;
    </cfscript>
    <cfoutput>
    <url>
    <loc>https://www.cityguideny.com/article/#getContent.seo_friendly[ctr]#</loc>
        <n:news>
     <n:publication>
        <n:name>City Guide NY</n:name>
        <n:language>en</n:language>
       </n:publication>
      <n:title>#title#</n:title>
<n:publication_date>#pubDate#</n:publication_date>
    <n:keywords>New York City, City Guide</n:keywords>
        </n:news><Cfif #getcontent.mainswap[ctr]# is not ''>
        <image:image>
   <image:loc><Cfif #getcontent.mainswapbig[ctr]# is not ''>#rereplace(getcontent.mainswapbig[ctr],'&','','ALL')#<Cfelse>#rereplace(getcontent.mainswap[ctr],'&','','ALL')#</Cfif></image:loc>
  </image:image></cfif>
</url></cfoutput></Cfif></cfloop><cfoutput></urlset></cfoutput></cfsavecontent><cfoutput>#theXml#</cfoutput><cfabort>