<cfset requesttimeout="5000"><CFCONTENT TYPE="text/xml"><?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<cfswitch expression="#url.typer#">
<cfcase value="nyl">
<cfquery name="Getstuff" datasource="#ds#">
select seo_friendly
from columntable
where mag = 15
and status = 1
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>http://www.nyluxury.com/article/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>


<cfcase value="cg">
<cfquery name="Getstuff" datasource="#ds#">
select seo_friendly
from columntable
where mag = 1
and columntable.status = 1
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.cityguideny.com/article/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="nymp">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly,lastedit
from columntable
where mag = 5
and columntable.status = 1
order by id desc
limit 0,45000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/article/#seo_friendly#</loc>
<changefreq>daily</changefreq>
<lastmod>#dateformat(lastedit,'yyyy-mm-dd')#</lastmod>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="nymp2">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly
from columntable
where mag = 5
and columntable.status = 1
order by id
limit 0,45000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/article/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="cgevents">
<cfquery name="Getstuff" datasource="#ds#">
select id,seo_friendly
from ActivityPlanner
where cg = 'on'
order by id DESC
limit 0,50000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.cityguideny.com/event/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>


<cfcase value="cgevents2">
<cfquery name="Getstuff" datasource="#ds#">
select id,seo_friendly
from ActivityPlanner
where cg = 'on'
order by id DESC
limit 50000,50000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.cityguideny.com/event/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>

<cfcase value="nympevents">
<cfquery name="Getstuff" datasource="#ds#">
select id
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid = 0
and catid2 = 0
and  id < 50000

</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/2015neweventinfo.cfm?id=#getstuff.id#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="nympevents2">
<cfquery name="Getstuff" datasource="cityguidero">
select id
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid2 = 0

and id > 55000 and id < 100000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/2015neweventinfo.cfm?id=#getstuff.id#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="nympevents3">
<cfquery name="Getstuff" datasource="cityguidero">
select id
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid2 = 0

and id > 100000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/2015neweventinfo.cfm?id=#getstuff.id#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>

<cfcase value="nympeventsnew">
<cfquery name="Getstuff" datasource="cityguidero">
select id,seo_friendly
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid = 0
and catid2 = 0
order by id desc
limit 0,50000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/event/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="nympevents2new">
<cfquery name="Getstuff" datasource="cityguidero">
select id,seo_friendly
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid2 = 0

and id > 55000 and id < 100000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/event/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="nympevents3ew">
<cfquery name="Getstuff" datasource="cityguidero">
select id,seo_friendly
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid2 = 0

and id > 100000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/event/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>


<cfcase value="nymplistings1">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly
from ParentsListings
where id < 50000 and delflag = 0  and delflag = 0 and hide = 0
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/listing/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="nymplistings2">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly
from ParentsListings
where id > 50000 and id < 100000 and delflag = 0  and delflag = 0 and hide = 0
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/listing/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="nymplistings3">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly
from ParentsListings
where id > 100000 and delflag = 0 and hide = 0
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.nymetroparents.com/listing/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>

<cfcase value="campfair">
<cfquery name="Getstuff" datasource="#ds#">
select seo_friendly
from CampListings
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>http://www.westchestercampfair.com/listing/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>

<!---- RP START ---->


<cfcase value="rpnymp">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly,lastedit
from columntable
where mag = 5
	   and columntable.region = 'Rockland' 

and columntable.status = 1
order by id desc
limit 0,45000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/article/#seo_friendly#</loc>
<changefreq>daily</changefreq>
<lastmod>#dateformat(lastedit,'yyyy-mm-dd')#</lastmod>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="rpnymp2">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly
from columntable
where mag = 5
and columntable.status = 1
	   and columntable.region = 'Rockland' 

order by id
limit 0,45000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/article/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>

<cfcase value="rpnympevents">
<cfquery name="Getstuff" datasource="cityguidero">
select id
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid = 0
and nympregion = 'Rockland'
and catid2 = 0
and  id < 50000

</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/2015neweventinfo.cfm?id=#getstuff.id#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="rpnympevents2">
<cfquery name="Getstuff" datasource="cityguidero">
select id
from ActivityPlanner
where cg <> 'on'
and nympregion = 'Rockland'

and (catid3 > 0 or catid4 > 0)
and catid2 = 0

and id > 55000 and id < 100000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/2015neweventinfo.cfm?id=#getstuff.id#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="rpnympevents3">
<cfquery name="Getstuff" datasource="cityguidero">
select id
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid2 = 0
and nympregion = 'Rockland'

and id > 100000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/2015neweventinfo.cfm?id=#getstuff.id#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>

<cfcase value="rpnympeventsnew">
<cfquery name="Getstuff" datasource="cityguidero">
select id,seo_friendly
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid = 0
and catid2 = 0
and nympregion = 'Rockland'

order by id desc
limit 0,50000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/event/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="rpnympevents2new">
<cfquery name="Getstuff" datasource="cityguidero">
select id,seo_friendly
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid2 = 0
and nympregion = 'Rockland'

and id > 55000 and id < 100000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/event/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="rpnympevents3ew">
<cfquery name="Getstuff" datasource="cityguidero">
select id,seo_friendly
from ActivityPlanner
where cg <> 'on'
and (catid3 > 0 or catid4 > 0)
and catid2 = 0
and nympregion = 'Rockland'

and id > 100000
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/event/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>


<cfcase value="rpnymplistings1">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly
from ParentsListings
where id < 50000 and delflag = 0  and delflag = 0 and hide = 0
and region = 'Rockland'
</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/listing/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="rpnymplistings2">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly
from ParentsListings
where id > 50000 and id < 100000 and delflag = 0  and delflag = 0 and hide = 0
and region = 'Rockland'

</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/listing/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<cfcase value="rpnymplistings3">
<cfquery name="Getstuff" datasource="cityguidero">
select seo_friendly
from ParentsListings
where id > 100000 and delflag = 0 and hide = 0
and region = 'Rockland'

</cfquery>
<Cfoutput query="getstuff">
<url>
<loc>https://www.rocklandparent.com/listing/#seo_friendly#</loc>
<changefreq>daily</changefreq>
</url>
 </Cfoutput>
</cfcase>
<!---- RP END ---->




</cfswitch>
</urlset>