<cfsetting requesttimeout =500>
<Cfset today = dateadd('d',-60,currentdatetime)>
<cfsavecontent variable="reporter">

<Cfoutput><h1>Report for Last 60 Days</h1></Cfoutput>

<Cfquery name="Geter" dataSource="#ds#">
select columntable.title, columntable.postedby,columnmaster.authorname, datesubmitted,columntable.id,columntable.dateposted as dtentered, columntable.region, regions.name,  count(newmastertrack.id) as views,columntable.seo_friendly
from newmastertrack FORCE INDEX (statme)   inner join columntable on newmastertrack.idnumber = columntable.id inner join regionstable on regionstable.colid = columntable.ID
inner join regions on regionstable.regionsid = regions.id
inner join columnmaster on columntable.columnnum = columnmaster.id

where newmastertrack.mag = 5
and newmastertrack.typer = 'article'
and date(columntable.dateposted) >= '2020-04-01'
and date(newmastertrack.datetime) >= '2020-04-01'

and columntable.status = 1
and columntable.mag = 5
and newmastertrack.idnumber > 10000
group by newmastertrack.idnumber
order by views desc
limit 0,1000

</cfquery>

<H2>New Articles</H2>
<table width="600" border="1" cellpadding="4" cellspacing="0">
<tr style="background-color: black;">
<td><font color="white"><b>Headline</b></td>
<td><font color="white"><b>Category</b></td>
<td><font color="white"><b>Posted</b></td>
<td><font color="white"><b>Author</b></td>
<td><font color="white"><b>Region</b></td>
<td><font color="white"><b>Submitted</b></td>

<td><font color="white"><b>Views</b></td>
<td><font color="white"><b>Total Views</b></td>

</tr>		
	
<cfoutput query="geter">
<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#"><Td><a href="https://www.nymetroparents.com/article/#seo_friendly#"><b>#title#</b></a></Td><td>#name#</td><td>#postedby#</td><td>#authorname#</td>
<td>#region#</td>
<Td>#dateformat(datesubmitted,'m/d/yy')#</Td>
<cfquery name="getcount" dataSource="#ds#">
	select count(newmastertrack.id) as views
	from newmastertrack
	where newmastertrack.mag = 5
and newmastertrack.typer = 'article'
and newmastertrack.idnumber = #id#
and date(newmastertrack.datetime) >= '#dateformat(today,'yyyy-mm-dd')#'
and newmastertrack.ipaddress not like '%63.147.237%'
and newmastertrack.ipaddress not like '%96.224.32.98%'
and newmastertrack.ipaddress not like '%109.239.235.196%'


</cfquery>
<td>#getcount.views#</td>



<cfquery name="getcounttotal" dataSource="#ds#">
	select count(newmastertrack.id) as views
	from newmastertrack
	where newmastertrack.mag = 5
and newmastertrack.typer = 'article'
and newmastertrack.idnumber = #id#
and newmastertrack.ipaddress not like '%63.147.237%'
and newmastertrack.ipaddress not like '%96.224.32.98%'
and newmastertrack.ipaddress not like '%109.239.235.196%'


</cfquery>
<td>#getcounttotal.views#</td>


</tr>
</cfoutput>
</table>




<Cfquery name="Geter" dataSource="#ds#">
select columntable.title, columntable.postedby, columnmaster.authorname,columntable.id,columntable.dateposted as dtentered, regions.name,  columntable.region,count(newmastertrack.id) as views,columntable.seo_friendly,editedby,datesubmitted
from newmastertrack FORCE INDEX (statme)   inner join columntable on newmastertrack.idnumber = columntable.id inner join regionstable on regionstable.colid = columntable.ID
inner join regions on regionstable.regionsid = regions.id
inner join columnmaster on columntable.columnnum = columnmaster.id
where newmastertrack.mag = 5
and newmastertrack.typer = 'article'
and date(columntable.lastedit) = '#dateformat(today,'yyyy-mm-dd')#'
and date(columntable.dateposted) <> '#dateformat(today,'yyyy-mm-dd')#'

and columntable.status = 1
and columntable.mag = 5

and newmastertrack.idnumber > 10000
group by newmastertrack.idnumber
order by views desc
limit 0,1000

</cfquery>

<H2>Updated Articles</H2>
<table width="600" border="1" cellpadding="4" cellspacing="0">
	<tr style="background-color: black;">
<td><font color="white"><b>Headline</b></td>
<td><font color="white"><b>Category</b></td> 
<td><font color="white"><b>Posted</b></td>
<td><font color="white"><b>Author</b></td>
<td><font color="white"><b>Region</b></td>
<td><font color="white"><b>Submitted</b></td>

<td><font color="white"><b>Views</b></td>
<td><font color="white"><b>Total Views</b></td>

</tr>		
<cfoutput query="geter">
<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#"><Td><a href="https://www.nymetroparents.com/article/#seo_friendly#"><b>#title#</b></a></Td><td>#name#</td><td>#rereplace(editedby,'@davlermedia.com','')#</td><td>#authorname#</td>

<td>#region#</td>
<Td>#dateformat(datesubmitted,'m/d/yy')#</Td>

<Cfset newd = dateadd('d',-1,today)>
<td><cfquery name="getcount" dataSource="#ds#">
	select count(newmastertrack.id) as views
	from newmastertrack
	where newmastertrack.mag = 5
and newmastertrack.typer = 'article'
and date(newmastertrack.datetime) > '#dateformat(newd,'yyyy-mm-dd')#'
and newmastertrack.ipaddress not like '%63.147.237%'
and newmastertrack.ipaddress not like '%96.224.32.98%'
and newmastertrack.ipaddress not like '%109.239.235.196%'

and newmastertrack.idnumber = #id#
</cfquery>
#getcount.views#
</td>

<td><cfquery name="getcounttotal" dataSource="#ds#">
	select count(newmastertrack.id) as views
	from newmastertrack
	where newmastertrack.mag = 5
and newmastertrack.typer = 'article'
and newmastertrack.ipaddress not like '%63.147.237%'
and newmastertrack.ipaddress not like '%96.224.32.98%'
and newmastertrack.ipaddress not like '%109.239.235.196%'

and newmastertrack.idnumber = #id#
</cfquery>
#getcounttotal.views#
</td>


</tr>
</cfoutput>
</table>
</cfsavecontent>

<Cfoutput>
	#reporter#</Cfoutput>