403Webshell
Server IP : 104.21.21.239  /  Your IP : 216.73.216.11
Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5
System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64
User : ec2-user ( 1000)
PHP Version : 8.4.23
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /home/home2/cgny/public_html/newadmin/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/home2/cgny/public_html/newadmin/listingsedit.cfm
<cfif not parameterexists(url.id) or not isnumeric(url.id)>
<cfabort>
</cfif>
<Cfif #url.id# eq 12340>
	<cfabort>
</cfif>
	

<Cfif #Url.table# is not 'ToursAttractions'
and #url.table# is not 'Galleries'
and #url.table# is not 'CulturalArts'
and #url.table# is not 'Nightlife'
and #url.table# is not 'Theater'
and #url.table# is not 'Restaurants'
and #url.table# is not 'Shopping'
and #url.table# is not 'CarServices'
and #url.table# is not 'FamilyFun'
and #url.table# is not 'RealEstate'
and #url.table# is not 'LuggageStorage'

and #url.table# is not 'BeautyHealth'
and #url.table# is not 'Travel'
and #url.table# is not 'Museums'>
<Cfabort>
</cfif>



<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfif DirectoryExists('/home/home2/cgny/public_html/listingsupload/#url.id#')>

<cfelse>

   <cfdirectory action = "create" directory = "/home/home2/cgny/public_html/listingsupload/#url.id#" mode="777" >
</cfif>



<cfif DirectoryExists('/home/home2/cgny/public_html/2019/uploads2/#url.id#')>

<cfelse>

   <cfdirectory action = "create" directory = "/home/home2/cgny/public_html/2019/uploads2/#url.id#" mode="777" >
</cfif>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<link rel="stylesheet" type="text/css" href="/bwwstyles1.css" media="all">





<cfif not parameterexists(session.email) or #session.email# eq '' or #session.email# eq '-1'>
<Cfabort>
</cfif>


<cfparam name="getsubq.subcatid" default="0">

<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#><cfif session.email eq ''><cfset Session.email = -1></cfif><cfif IsDefined("Cookie.email")><cfset Session.email = Cookie.email></cfif>
<cfinclude template="header.cfm">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
	  
<cfoutput>

<font face=verdana size=-1><cfif not parameterexists(url.edit)>
<a href="uploadlistingsphoto.cfm?itemid=#url.id#&tablename=#url.table#">Upload Photos</a> | 

<a href="listingsmultimedia.cfm?itemid=#url.id#&tableme=#url.table#">Upload Video</a> | 
<a href="uploadcoupon.cfm?itemid=#url.id#&tablename=#url.table#">Manage Coupons</a> | <a href="uploadrelated.cfm?itemid=#url.id#&tablename=#url.table#">Related Links</a> | <a href="managehighlight.cfm?itemid=#url.id#&tablename=#url.table#">Manage Highlights</a>  | <a href="deletelisting.cfm?itemid=#url.id#&tablename=#url.table#" onClick="return confirm('Delete this listing?');">Delete Listing</a>

</cfif></cfoutput>
<p>

<cfif not parameterexists(url.edit)>
<Cfquery name="findgraphic" datasource="cg22">
select *
from ListingsPhotos
where tablename='#url.table#' and itemid=#url.id#
</Cfquery></cfif>

<cfif parameterexists(url.edit)>

<cfparam name="form.adrankml" default="0">
<cfif #form.adrankml# eq '0'>
<cfset #form.adrankml# = 0>
</cfif>

<cfparam name="form.ccainfo" default="">
<cfparam name="form.ccadesc" default="">
<cfparam name="form.socialfb" default="">
<cfparam name="form.socialig" default="">
<cfparam name="form.socialtt" default="">
<cfparam name="form.maplink" default="">

<cfparam name="form.ticketlink" default="">
<cfparam name="form.trackingpixel" default="">
<cfparam name="form.tags" default="">
<cfparam name="form.image_url" default="">
<cfparam name="form.featured" default="">
<cfparam name="form.status_code" default="">
<cfparam name="form.hours" default="">
<cfparam name="form.ticketprice" default="">
<cfparam name="form.free_days" default="">
<cfparam name="form.exhibit1" default="">
<cfparam name="form.exhibit2" default="">
<cfparam name="form.exhibit_open_date_1" default="">
<cfparam name="form.exhibit_close_date_1" default="">
<cfparam name="form.exhibit_open_date_2" default="">
<cfparam name="form.exhibit_close_date_2" default="">
<CFQUERY datasource="cg22">
	UPDATE #url.table#
	SET
	name = '#form.name#',
	Address = '#form.Address#',
metatitle = '#form.metatitle#',
	city = '#form.city#',
	state = '#form.state#',
	zip = '#form.zip#',
	neighborhood = '#form.neighborhood#',
	AdRankML = #form.AdRankML#,
	contactname = '#form.contactname#',
	phone = '#form.phone#',
	ticketlink = '#form.ticketlink#',
	maplink = '#form.maplink#',
	Advertiser = #form.Advertiser#,
	fax = '#form.fax#',
	socialtt = '#form.socialtt#',
	socialfb = '#form.socialfb#',
	socialig = '#form.socialig#',
	hide = #form.hide#,
	email = '#form.email#',
    iguide = '#form.iguide#',
    trackingpixel = '#form.trackingpixel#',
	ccainfo = '#form.ccainfo#',
    ccadesc = '#form.ccadesc#',
freeer = #form.freeer#,
	website = '#form.website#',
	lastupdated = #currentdatetime#,
	description = '#form.description#',
	fulldescription = '#form.fulldescription#',
	kidfriendly = #form.kidfriendly#,
	contactfirst='#form.contactfirst#',
	contactlist='#form.contactlast#',
	enhancedlisting = '#form.copyedit#',
	contacttitle='#form.contactitle#',
	salesperson = '#form.salesperson#',
    venuedesc='#form.venuedesc#',
	contactemail='#form.contactemail#',
	contactphone='#form.contactphone#',
	mlAdRankML = #form.mlAdRankML#
<cfif url.table eq 'CulturalArts'>
	,
	tags = '#form.tags#',
	image_url = '#form.image_url#',
	featured = '#form.featured#',
	status_code = '#form.status_code#',
	hours = '#form.hours#',
	ticket_price = '#form.ticket_price#',
	free_days = '#form.free_days#',
	exhibit1 = '#form.exhibit1#',
	exhibit2 = '#form.exhibit2#',
	exhibit_open_date_1 = '#form.exhibit_open_date_1#',
	exhibit_close_date_1 = '#form.exhibit_close_date_1#',
	exhibit_open_date_2 = '#form.exhibit_open_date_2#',
	exhibit_close_date_2 = '#form.exhibit_close_date_2#'
</cfif>
<cfif url.table eq 'ToursAttractions'>
	,
	tags = '#form.tags#',
	hours = '#form.hours#',
	ticketprice = '#form.ticketprice#'
</cfif>

	WHERE ID = #form.id#
</CFQUERY>
done

<cfquery name="addtw" dataSource="cg22">
insert delayed INTO columntablehistory (colid, copy,datetime,type) VALUES(#form.id#, '#form.copyedit#',#currentdatetime#,'listing');
</cfquery>


</p>
<Cfquery name="cleartable" datasource="cg22">
delete from
CGListingsCat
where pkid = #form.id#
</CFQUERY>

<Cfquery name="cleartable" datasource="cg22">
delete from
CGListingsCat2
where pkid = #form.id#
</CFQUERY>

<cfif parameterexists(form.regions)>
<cfset myArray = ArrayNew(1)>
<cfloop from="1" to="#ListLen(form.regions)#"index="listCount">
    <cfset myArray[listCount] =ListGetAt(form.regions,listCount,",")>

<cfquery name=addphoto datasource="cg22">
INSERT INTO CGListingsCat (pkid,catid)
VALUES	(#form.id#,#myArray[listCount]#)
		</cfquery>


<Cfquery name="getcat" datasource="cg22">
select catname
from CGListingsCatMain
where id = #myArray[listCount]#
</CFQUERY>

</cfloop>
</cfif>


<cfif parameterexists(form.regions2)>
<cfset myArray = ArrayNew(1)>
<cfloop from="1" to="#ListLen(form.regions2)#"index="listCount">
    <cfset myArray[listCount] =ListGetAt(form.regions2,listCount,",")>

<cfquery name=addphoto datasource="cg22">
INSERT INTO CGListingsCat2 (pkid,catid)
VALUES	(#form.id#,#myArray[listCount]#)
		</cfquery>


<Cfquery name="getcat" datasource="cg22">
select catname
from CGListingsCatMain2
where id = #myArray[listCount]#
</CFQUERY>

</cfloop>
</cfif>

<cflocation url="listall.cfm" addtoken="no">
<cfelse>
<p>
<Table><tr>
<cfoutput query="findgraphic">
<td style="padding:5px;" ><font face=verdana size=-2>
<img src="/listingsphotos/#thumbnail#"><br>
<cfif #mag# eq '1'>(CityGuide) <a href="makeboth.cfm?id=#id#&both=bothcg">Make Both</a></cfif>
<br />
<a href="deletelistingsphoto.cfm?id=#id#&table=#url.table#&itemid=#url.id#"  onClick="return confirm('Are you sure?');">delete pic</a>
</font>
</td>
</cfoutput>
</tr>
</Table>

<cfquery name="getrecord" datasource="cg22">
select *
from #url.table#
where id = #url.id#
</cfquery>

<cfoutput><FORM action="listingsedit.cfm?edit=on&table=#url.table#&id=#url.id#" method="post"></cfoutput>
<cfoutput><input NAME="id"  MAXLENGTH="200" TYPE="hidden" value="#url.id#">
<table>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Name:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="Name" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.Name#"></td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Meta Title Name:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="metatitle" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.metatitle#"></td>
</tr>

<cfif #currentdatetime# gt '2022-04-18'>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Article Intent Embed:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><Small>
    <textarea style="width:100%;height:300px;"><iframe src="https://www.cityguideny.com/intendembed.cfm?id=#url.id#&table=#url.table#&981" width="100%" height="280" style="height:280px;" frameborder="0"></iframe>
</textarea>
<cfquery name="getint" dataSource="#ds#">
    select rating, count(rating) as countrating from ArticleRatings where calendarid = #url.id# and tablename = '#url.table#' group by rating
</cfquery>
<cfoutput query="getint">


    
   <Cfif #rating# eq 1>I intend to go<cfelseif #rating# eq 2>Not Sure<cfelse>Not for Me</Cfif> - #countrating#<br>
</cfoutput>

</Small></td>
</tr>
</cfif>



<tr>
<td style="padding:5px;" ><b><font face="Arial" size="+0">Advertiser #getrecord.Advertiser#:</font></b></td>

<td style="padding:5px;" ><SELECT SIZE="1" NAME="Advertiser">
<cfif #getrecord.Advertiser# eq 0>
  <OPTION VALUE="0">No</option>

</cfif>
<cfif #getrecord.Advertiser# eq 1>
  <OPTION VALUE="1">Basic</option>

</cfif>
<cfif #getrecord.Advertiser# eq 2>
    <OPTION VALUE="2">Premium</option>

</cfif>
<cfif #getrecord.Advertiser# eq 3>
    <OPTION VALUE="3">Digital</option>

</cfif>

  <OPTION VALUE="0">No</option>
  <OPTION VALUE="1">Basic</option>
    <OPTION VALUE="2">Premium</option>
    <OPTION VALUE="3">Digital</option>


  </SELECT></td>
</tr>


<tr>
<td style="padding:5px;" ><b><font face="Arial" size="+0">Include in International Guide:</font></b></td>

<td style="padding:5px;" ><SELECT SIZE="1" NAME="iguide">
<cfif #getrecord.iguide# eq 'No'>
  <OPTION VALUE="No">No</option>
  <OPTION VALUE="Yes">Yes</option>
<cfelse>
  <OPTION VALUE="Yes">Yes</option>
  <OPTION VALUE="No">No</option>
</cfif>
  </SELECT></td>
</tr>



<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Ad Rank:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="adrankml" MAXLENGTH="200" TYPE="text" SIZE="30" value="<cfif #getrecord.adrankml# is ''>0<cfelse>#getrecord.adrankml#</cfif>"></td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Mark Listing as New Until<small> (Optional - yyyy-mm-dd):</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="newuntil" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.newuntil#">
</td>
</tr>

<tr>
<td style="padding:5px;" ><b><font face="Arial" size="+0">Hide Listing:</font></b></td>

<td style="padding:5px;" ><SELECT SIZE="1" NAME="hide">
<cfif #getrecord.hide# eq 0>
  <OPTION VALUE="0">No</option>
  <OPTION VALUE="1">Yes</option>
<cfelse>
  <OPTION VALUE="1">Yes</option>
  <OPTION VALUE="0">No</option>
</cfif>
  </SELECT></td>
</tr>


<tr>
<td style="padding:5px;" ><b><font face="Arial" size="+0">Price:</font></b></td>

<td style="padding:5px;" ><SELECT SIZE="1" NAME="freeer">
<cfif #getrecord.freeer# eq 0>
  <OPTION VALUE="0">Not Set</option>
  <OPTION VALUE="1">FREE</option>
<cfelse>
  <OPTION VALUE="1">FREE</option>
  <OPTION VALUE="0">Not Set</option>
</cfif>
  </SELECT></td>
</tr>



<tr>
<td style="padding:5px;" ><b><font face="Arial" size="+0">Kid Friendly:</font></b></td>

<td style="padding:5px;" ><SELECT SIZE="1" NAME="kidfriendly">
<cfif #getrecord.kidfriendly# eq 0>
  <OPTION VALUE="0">No</option>
  <OPTION VALUE="1">Yes</option>
<cfelse>
  <OPTION VALUE="1">Yes</option>
  <OPTION VALUE="0">No</option>
</cfif>
  </SELECT></td>
</tr>


<tr>
<td style="padding:5px;" ><b><font face="Arial" size="+0">Salesperson:</font></b></td>

<td style="padding:5px;" ><SELECT SIZE="1" NAME="salesperson">
<option value="#getrecord.salesperson#">#getrecord.salesperson#</option>
<option value="[email protected]">[email protected]</option>
<option value="[email protected]">[email protected]</option>
<option value="[email protected]">[email protected]</option>
  </SELECT></td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Address:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="Address" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.Address#">
</td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">City:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="City" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.City#">
</td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">State:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="State" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.State#">
</td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Zip:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="Zip" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.Zip#">
</td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Neighborhood:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP>

<Select name="neighborhood">
<option value="#getrecord.neighborhood#">#getrecord.neighborhood#</option>
<cfquery name="Getneis" dataSource="cg22">
select * from neighborhood2014
order by neighborhood
</cfquery>

<Cfloop from="1" to="#getneis.recordcount#" index="i">
<option value="#getneis.neighborhood[i]#">#getneis.neighborhood[i]#</option>
</Cfloop>
</Select>

</td>
</tr>


<tr>
<td style="padding:5px;"  VALIGN=TOP width=20><b><font face="Arial" size="+0">Contact:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="contactname" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.contactname#">
</td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Phone:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="Phone" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.Phone#">
</td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Fax:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="Fax" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.Fax#">
</td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Email:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="Email" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.Email#">
</td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Web Site:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="website" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.website#">
</td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Tickets:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="ticketlink" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.ticketlink#">
</td>
</tr>


<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Map Link:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="maplink" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.maplink#">
</td>
</tr>
<cfif url.table eq 'CulturalArts'>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Tags:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="tags" MAXLENGTH="255" TYPE="text" SIZE="60" value="#getrecord.tags#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Image URL:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="image_url" MAXLENGTH="255" TYPE="text" SIZE="60" value="#getrecord.image_url#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Featured:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="featured" MAXLENGTH="255" TYPE="text" SIZE="30" value="#getrecord.featured#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Status Code:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="status_code" MAXLENGTH="255" TYPE="text" SIZE="30" value="#getrecord.status_code#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Hours:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="hours" cols="60" rows="3">#getrecord.hours#</textarea></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Ticket Price:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="ticket_price" cols="60" rows="3">#getrecord.ticket_price#</textarea></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Free Days:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="free_days" cols="60" rows="2">#getrecord.free_days#</textarea></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Exhibit 1:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="exhibit1" MAXLENGTH="255" TYPE="text" SIZE="60" value="#getrecord.exhibit1#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Exhibit 2:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="exhibit2" MAXLENGTH="255" TYPE="text" SIZE="60" value="#getrecord.exhibit2#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Exhibit Open Date 1:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="exhibit_open_date_1" MAXLENGTH="255" TYPE="text" SIZE="30" value="#getrecord.exhibit_open_date_1#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Exhibit Close Date 1:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="exhibit_close_date_1" MAXLENGTH="255" TYPE="text" SIZE="30" value="#getrecord.exhibit_close_date_1#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Exhibit Open Date 2:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="exhibit_open_date_2" MAXLENGTH="255" TYPE="text" SIZE="30" value="#getrecord.exhibit_open_date_2#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Exhibit Close Date 2:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="exhibit_close_date_2" MAXLENGTH="255" TYPE="text" SIZE="30" value="#getrecord.exhibit_close_date_2#"></td>
</tr>
</cfif>
<cfif url.table eq 'ToursAttractions'>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Hours:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="hours" cols="60" rows="3">#getrecord.hours#</textarea></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Ticket Price:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="ticketprice" cols="60" rows="3">#getrecord.ticketprice#</textarea></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Tags:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="tags" cols="60" rows="3">#getrecord.tags#</textarea></td>
</tr>
</cfif>


<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Facebook:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="socialfb" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.socialfb#">
</td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Instagram:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="socialig" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.socialig#">
</td>
</tr>


<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">TikTok:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="socialtt" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.socialtt#">
</td>
</tr>

 <tr><td style="padding:5px;" >
	  <b><font SIZE="+0" FACE="arial">Contact First Name:</font></b>
  </td><td style="padding:5px;" >
	  <input NAME="contactfirst" SIZE="10" value="#getrecord.contactfirst#">
  </td></tr>

	    <tr><td style="padding:5px;" >
	  <b><font SIZE="+0" FACE="arial">Contact Last Name:</font></b>
  </td><td style="padding:5px;" >
	  <input NAME="contactlast" SIZE="15" value="#getrecord.contactlist#">
  </td></tr>

      <tr><td style="padding:5px;" >
	  <b><font SIZE="+0" FACE="arial">Contact Title:</font></b>
  </td><td style="padding:5px;" >
	  <input NAME="contactitle" SIZE="15" value="#getrecord.contacttitle#">
  </td></tr>

      <tr><td style="padding:5px;" >
	  <b><font SIZE="+0" FACE="arial">Contact Phone Number:</font></b>
  </td><td style="padding:5px;" >
	  <input NAME="contactphone" SIZE="15" value="#getrecord.contactphone#">
  </td></tr>

      <tr><td style="padding:5px;" >
	  <b><font SIZE="+0" FACE="arial">Contact E-Mail:</font></b>
  </td><td style="padding:5px;" >
	  <input NAME="contactemail" SIZE="15" value="#getrecord.contactemail#">
  </td></tr>


<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Short Description:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="description" cols="40" rows=10>#getrecord.description#</textarea>
</td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Full Description:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="fulldescription" cols="40" rows=10>#getrecord.fulldescription#</textarea>
</td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Venue Description:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="venuedesc" cols="40" rows=10>#getrecord.venuedesc#</textarea>
</td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Optional Tracking Pixel:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="trackingpixel" cols="40" rows=3>#getrecord.trackingpixel#</textarea>
</td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP colspan=2><b><font face="Arial" size="-1">Enhanced Listing:</font></b><Br />

   <cfcookie name = "folderme"
    value = "#Now()#"
    expires = "NOW">

<cfcookie name = "folderme" value = "/uploads2/#url.id#/">
<Cfparam name="url.beta" default="on">


	<script src="ckeditor46z27e/ckeditor.js?asd" charset="utf-8"></script>

<script type="text/javascript" src="ckfinder34/ckfinder.js?asd" charset="utf-8"></script>
<textarea id="myarea12" class="ckeditor" name="copyedit" style="height:600px;">#htmlEditFormat(getrecord.enhancedlisting)#</textarea>
<script type="text/javascript">

CKEDITOR.on( 'dialogDefinition', function( ev ) {
                                // Take the dialog name and its definition from the event data.
                                var dialogName = ev.data.name;
                                var dialogDefinition = ev.data.definition;
                                // Check if the definition is from the dialog we're interested on (the "Link" dialog).
                                if ( dialogName == 'link' ){
                                        var targetTab = dialogDefinition.getContents( 'target' );
                                        var targetDropdown = targetTab.get( 'linkTargetType' );
                                        targetDropdown.default = '_blank';
                                }
                        }       );



CKFinder.setupCKEditor( editor, 'ckfinder34/' ) ;


var editor = CKEDITOR.replace( 'copyedit',{
   height: '500px',
   extraAllowedContent : 'object(*);param(*);embed(*);p(*);script(*);form(*);input(*);div(*);blockquote(*)'
});


editor.on( 'instanceReady', function() {
console.log( editor.filter.allowedContent );
} );
</script>



<!-- /tinyMCE -->

</td>
</tr>

<!---
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Concierge Choice Description:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><textarea name="ccadesc" cols="40" rows=10>#getrecord.ccadesc#</textarea>
</td>
</tr>



<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Concierge Choice Awards:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP>
	  <input name="ccainfo" type="checkbox"  value="2007nom" <cfif #getrecord.ccainfo# contains '2007nom'>checked</cfif>>2007 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2007win" <cfif #getrecord.ccainfo# contains '2007win'>checked</cfif>>2007 Winner<br />
	  <input name="ccainfo" type="checkbox"  value="2008nom" <cfif #getrecord.ccainfo# contains '2008nom'>checked</cfif>>2008 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2008win" <cfif #getrecord.ccainfo# contains '2008win'>checked</cfif>>2008 Winner<br />
	  <input name="ccainfo" type="checkbox"   value="2009nom" <cfif #getrecord.ccainfo# contains '2009nom'>checked</cfif>>2009 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2009win" <cfif #getrecord.ccainfo# contains '2009win'>checked</cfif>>2009 Winner<br />
	  <input name="ccainfo" type="checkbox"  value="2010nom" <cfif #getrecord.ccainfo# contains '2010nom'>checked</cfif>>2010 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2010win" <cfif #getrecord.ccainfo# contains '2010win'>checked</cfif>>2010 Winner<br />
	  <input name="ccainfo" type="checkbox"  value="2011nom" <cfif #getrecord.ccainfo# contains '2011nom'>checked</cfif>>2011 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2011win" <cfif #getrecord.ccainfo# contains '2011win'>checked</cfif>>2011 Winner<br />
	  	  <input name="ccainfo" type="checkbox"  value="2012nom" <cfif #getrecord.ccainfo# contains '2012nom'>checked</cfif>>2012 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2012win" <cfif #getrecord.ccainfo# contains '2012win'>checked</cfif>>2012 Winner<br />

	  	  <input name="ccainfo" type="checkbox"  value="2013nom" <cfif #getrecord.ccainfo# contains '2013nom'>checked</cfif>>2013 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2013win" <cfif #getrecord.ccainfo# contains '2013win'>checked</cfif>>2013 Winner<br />


	  <input name="ccainfo" type="checkbox"  value="2014nom" <cfif #getrecord.ccainfo# contains '2014nom'>checked</cfif>>2014 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2014win" <cfif #getrecord.ccainfo# contains '2014win'>checked</cfif>>2014 Winner<br />


	  <input name="ccainfo" type="checkbox"  value="2015nom" <cfif #getrecord.ccainfo# contains '2015nom'>checked</cfif>>2015 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2015win" <cfif #getrecord.ccainfo# contains '2015win'>checked</cfif>>2015 Winner<br />

	  <input name="ccainfo" type="checkbox"  value="2016nom" <cfif #getrecord.ccainfo# contains '2016nom'>checked</cfif>>2016 Nomination<br />
	  <input name="ccainfo" type="checkbox"  value="2016win" <cfif #getrecord.ccainfo# contains '2016win'>checked</cfif>>2016 Winner<br />
	  
	  	  <input name="ccainfo" type="checkbox"  value="2017nom" <cfif #getrecord.ccainfo# contains '2017nom'>checked</cfif>>2017 Finalist<br />
	  <input name="ccainfo" type="checkbox"  value="2017win" <cfif #getrecord.ccainfo# contains '2017win'>checked</cfif>>2017 Winner<br />

	  	  <input name="ccainfo" type="checkbox"  value="2018nom" <cfif #getrecord.ccainfo# contains '2018nom'>checked</cfif>>2018 Finalist<br />
	  <input name="ccainfo" type="checkbox"  value="2018win" <cfif #getrecord.ccainfo# contains '2018win'>checked</cfif>>2018 Winner<br />

</td>
</tr>--->




</cfoutput>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Sub Category:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><font face=verdana size=-1>
<cfif #url.table# eq 'CulturalArts'>
<cfset #url.table# = 'Cultural Arts'>
</cfif>
<cfif #url.table# eq 'FamilyFun'>
<cfset #url.table# = 'Family Fun'>
</cfif>
<cfparam name="getsubq.subcatid" default="0">
<Cfquery name="getsubq" datasource="cg22">
select subcatid
from _SubCat
where SubCatName = '#url.table#'
</Cfquery>

<!---a<cfoutput>#getsubq.subcatid#</cfoutput>a--->
<Cfquery name="Getregions" datasource="cg22">
SELECT distinct catname,id
FROM CGListingsCatMain
where mastercat = <Cfif not parameterexists(getsubq.subcatid) or #getsubq.subcatid# eq ''>0<Cfelse>#getsubq.subcatid#</Cfif>
group by catname
order by catname
</CFQUERY>



<cfquery name="Getarticleregions" datasource="cg22">
select *
from CGListingsCat
where pkid = #url.id#
</cfquery>

<select name="regions" multiple size="10">
<Cfoutput query="getregions">
<Cfset ab = 'on'>
<cfloop from="1" to="#Getarticleregions.recordcount#" index="i">
<cfif #Getarticleregions.catid[i]# eq #getregions.id#>
 <Cfset ab = 'off'>
 <option value="#getregions.id#" selected>#getregions.catname#</option>
 <cfelse>

  </cfif>
</cfloop>
<Cfif parameterexists(ab) and #ab# eq 'on'>
  <option value="#getregions.id#">#getregions.catname#</option>
</CFIF>

 </CFOUTPUT>
</select>
<br>


</td>
</tr>

<!---
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Sub Sub Category:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><font face=verdana size=-1>
<cfif #url.table# eq 'CulturalArts'>
<cfset #url.table# = 'Cultural Arts'>
</cfif>
<cfif #url.table# eq 'FamilyFun'>
<cfset #url.table# = 'Family Fun'>
</cfif>


<Cfquery name="Getregions2" datasource="cg22">
SELECT *
FROM CGListingsCatMain2
where id <> 230
order by catname
</CFQUERY>



<cfquery name="Getarticleregions2" datasource="cg22">
select *
from CGListingsCat2
where pkid = #url.id#
</cfquery>

<select name="regions2" multiple size="10">
<Cfoutput query="getregions2">
<Cfset ab = 'on'>
<cfloop from="1" to="#Getarticleregions2.recordcount#" index="i">
<cfif #Getarticleregions2.catid[i]# eq #getregions2.id#>
 <Cfset ab = 'off'>
 <option value="#getregions2.id#" selected>#getregions2.catname#</option>
 <cfelse>

  </cfif>
</cfloop>
<Cfif parameterexists(ab) and #ab# eq 'on'>
  <option value="#getregions2.id#">#getregions2.catname#</option>
</CFIF>

 </CFOUTPUT>
</select>
<br>


</td>
</tr>
--->

</table>


<input NAME="mlhide" type="hidden" value="0">
<input NAME="mladrankml" type="hidden" value="0">
<input NAME="mlAdvertiser" type="hidden" value="0">
<input NAME="mldescription" type="hidden" value="">
<input NAME="mlfulldescription" type="hidden" value="">




<p><input type="submit" value="Submit the form"></form></center>


<!---
<br><br><br><strong>Stats</strong><br><Br><br>

<fORM action="listingsstatsendCG.cfm" method="post">

<font face=verdana size=-1><strong>Send Stats To:</strong>
<input name="emailto" size="20" />
<cfoutput>
<input name="idnum" value="#url.id#" type="hidden">
<input name="placename" value="#getrecord.name#" type="hidden">
<input name="table" value="#url.table#" type="hidden" />
</cfoutput>
<INPUT type=submit value="Go!" class="search">

</fORM>


<br /><br />
<cfif #url.table# eq 'Cultural Arts'>
<cfset #url.table# = 'CulturalArts'>
</cfif>




<table width="100%"><Tr><td style="padding:5px;"  valign="top" width="50%">




<table border="1">
<Tr><td style="padding:5px;" ><strong>Month</strong></TD><td style="padding:5px;" ><strong>Views</strong></td><td style="padding:5px;" ><strong>Clicks</strong></td></Tr>

<!---
<Cfif #url.table# eq 'Cultural Arts'>
<cfset #url.table# = 'CulturalArts'>
</Cfif><Cfif #url.table# eq 'Family Fun'>
<cfset #url.table# = 'FamilyFun'>
</Cfif>
<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2008 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2008 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2009 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =6 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>
<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>
<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2010 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =1 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =2 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =3 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =4 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =5 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =6 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2011 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>





<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =1 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =2 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =3 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =4 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =5 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =6 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>
<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2012 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December 2012</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =1 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =1 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =2 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =2 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =3 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =3 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =4 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =4 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =5 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =5 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =6 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =6 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2013 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December 2013</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =1 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =1 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =2 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =2 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =3 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =3 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =4 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =4 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =5 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =5 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =6 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =6 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




	<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2014 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December 2014</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


		<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =1 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =1 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

		<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =2 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =2 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


		<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =3 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =3 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

		<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =4 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =4 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>
--->


<cfif #url.table# eq 'Family Fun'>
	<cfset #url.table# = 'FamilyFun'>
	</cfif>
	<!--- 
		<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =5 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =5 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =6 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =6 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =7 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =8 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =9 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =10 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =11 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =12 and year(showdate) = 2015 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December 2015</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) =1 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2016 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December 2016</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>
<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>
	

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2017 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December 2017</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

--->


	<Cfif #session.email# eq '[email protected]'>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2018</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2018</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2018</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2018</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2018</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

	</Cfif>


	<Cfif #session.email# eq '[email protected]'>
		
		
		<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2018</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2018</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2018</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2018 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2018</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>

<cfif parameterexists(getuser.email) and getuser.email eq '[email protected]'>
<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsStats.views) as viewsva
from ListingsStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2019 and tablename = '#url.table#'
</cfquery>
<cfquery name="Getstatsa" datasource="cg22">
select sum(ListingsLinkStats.views) as viewsva
from ListingsLinkStats
where showid = #url.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2019 and tablename = '#url.table#'
</cfquery></cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2019</td><td style="padding:5px;" >#getstats.viewsva#</td><td style="padding:5px;" >#getstatsa.viewsva#</td></tr>
</Cfoutput>
</cfif>
		
		
</Cfif>
</table>



 <td style="padding:5px;"  valign="top" width="50%">

<cfquery name="getcoupons" datasource="cg22">
select *
from ListingsRelated
where tablename='#url.table#' and itemid=#url.id#
</cfquery>

<strong>Related Links:</strong>

<cfif #getcoupons.recordcount# gt 0>
<cfoutput query="getcoupons">
<li><a href="#link#">#linktitle#</a>
</li></cfoutput>









<table border="1">
<Tr><td style="padding:5px;" ><strong>Month</strong></TD><td style="padding:5px;" ><strong>Clicks</strong></td></Tr>



<Cfif #url.table# eq 'Cultural Arts'>
<cfset #url.table# = 'CulturalArts'>
</Cfif><Cfif #url.table# eq 'Family Fun'>
<cfset #url.table# = 'FamilyFun'>
</Cfif>


<!---

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2008
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2009 </cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2009 </cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2009
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July </td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2010
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>





<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2011
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>





<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2012
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>





<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September  2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October  2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November  2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2013
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December  2013</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>
<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput><cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput><cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2014
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December 2014</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>
<cfoutput>

<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>
<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>
--->

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>




<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2015
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December 2015</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 11 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >November 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 12 and year(showdate) = 2016
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >December 2016</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 1 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >January 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 2 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >February 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 3 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >March 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 4 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >April 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 5 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >May 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>



<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 6 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >June 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 7 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >July 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 8 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >August 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>


<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 9 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >September 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>

<cfoutput>
<cfquery name="Getstats" datasource="cg22">
select sum(ListingsRelatedStats.views) as viewsva
from ListingsRelatedStats
where showid = #getcoupons.id# and mag = 1 and month(showdate) = 10 and year(showdate) = 2017
</cfquery>
</cfoutput>
<Cfoutput>
<tr><td style="padding:5px;" >October 2017</td><td style="padding:5px;" >#getstats.viewsva#</td></tr>
</Cfoutput>
</table>


</cfif>









 </td></tr></table>









--->
</cfif>


</td><td style="padding:5px;"  valign="top">
<br>
<Cfquery name="Getregions" datasource="cg22">
SELECT *
FROM mainlistingscats
order by maincatname
</CFQUERY>

<cfquery name="Getarticleregions" datasource="cg22">
select *
from mainlistings
where listingsid = #url.id# and tablename = '#url.table#'</cfquery>


<FORM action="managehighlight2.cfm" method=post>
<br><cfoutput>
<input name="id" type="hidden" value="#url.id#">
<input name="tablename" type="hidden" value="#url.table#"></cfoutput>
<select name="regions" multiple size="20">
<Cfoutput query="getregions">
<Cfset ab = 'on'>
<cfloop from="1" to="#Getarticleregions.recordcount#" index="i">
<cfif #Getarticleregions.maincatid[i]# eq #getregions.maincatid#>
 <Cfset ab = 'off'>
 <option value="#getregions.maincatid#" selected>#getregions.maincatname#</option>
 <cfelse>

  </cfif>
</cfloop>
<Cfif parameterexists(ab) and #ab# eq 'on'>
  <option value="#getregions.maincatid#">#getregions.maincatname#</option>
</CFIF>

 </CFOUTPUT>
</select>
<br>

<input type="submit" Value="Update Listing">
</form></Td></tr></table>


<Br><Br>
<Cfoutput>
<a href="viewhistory.cfm?id=#url.id#&type=listing">View Enhanced Description History</a>
</Cfoutput>

<p>

Youez - 2016 - github.com/yon3zu
LinuXploit