<cfif parameterexists(url.id) and isnumeric(url.id)>

<cfset today=#DateFormat(now(),"yyyy-mm-dd")#>
<cfquery name="getstats" datasource="#ds#">
select * from ListingsRelatedStats
where showdate = '#today#' and showid = #url.id# and mag = 1
</cfquery>

<Cfif #getstats.recordcount# gt 0>
<CFQUERY datasource="#ds#">
	UPDATE ListingsRelatedStats
	SET views = views + 1
	WHERE ID = #getstats.id#
	</CFQUERY>
<cfelse>
<cfquery name=addphoto datasource="#ds#">
INSERT INTO ListingsRelatedStats (showid,showdate,views,tablename,mag)
VALUES	(#url.id#,'#today#',1,'related',1)
</cfquery>

</CFIF>


<cfquery name="getlistings" datasource="#ds#">
select link
from ListingsRelated
where id = #url.id#
</cfquery>

<Cfif #getlistings.recordcount# eq 0 or getlistings.link eq ''>
Not found, <a href="/discounts.cfm">click here for the latest 
discounts</a>.
</cfif>

<cfquery name=addphoto datasource="#ds#">
INSERT INTO tickettrack (ticketid,datetime,ipadd,browser)
VALUES	(#url.id#,#currentdatetime#,'#CGI.REMOTE_ADDR#','#CGI.HTTP_USER_AGENT#')
</cfquery>
<Cfif #getlistings.link# is not ''>
<cflocation url="#getlistings.link#" addtoken="no" statuscode="301">
</cfif>
<cfelse>
<cflocation url="/discounts.cfm" addtoken="no" statuscode="301">
</cfif>