<cfparam name="url.table" default="Theater">
<cfparam name="url.id" default="1">
<cfif not isnumeric(url.id)>
<cfset #url.id# = 1>
</cfif>
<cfif #url.table# eq '' or not parameterexists(url.table)>
<cfset #url.table# = 'Theater'>
</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 'BeautyHealth'
and #url.table# is not 'Travel'
and #url.table# is not 'Museums'>
<Cfabort>
</cfif>

<Cfif not parameterexists(url.r1) and not parameterexists(url.r)>



<cfquery name="getlistings" datasource="#ds#" cachedwithin="#createtimespan(0,1,0,0)#">
select id,name,address,city,state,zip,catid,description,website,phone,advertiser,fulldescription,enhancedlisting,ccainfo
from #url.table#
where id = #url.id#
</cfquery>



<cfif parameterexists(url.cat) and url.cat is not ''>
<cfquery name="getnamey" datasource="#ds#" cachedwithin="#createtimespan(0,1,0,0)#">
select cat,catid
from Cat#url.table#
where catid = #url.cat#
</cfquery>
</cfif>

<cfset today=#DateFormat(now(),"yyyy-mm-dd")#>
<Cfset yesterday=#dateadd('d',-1,today)#>
<Cfset yesterdayb=#dateadd('d',-2,today)#>
<cfset yesterday=#DateFormat(yesterday,"yyyy-mm-dd")#>
<cfset yesterdayb=#DateFormat(yesterdayb,"yyyy-mm-dd")#>
<cfquery name="getstats" datasource="#ds#">
select id from ListingsStats
where showdate = '#today#' and showid = #url.id# and tablename = '#url.table#'
</cfquery>

<Cfset zzz = randrange(2,5)>

<Cfif #getstats.recordcount# gt 0>

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

</CFIF>

<cfsavecontent variable="headercontent">
<cfoutput>
<title>#getlistings.name# (Concierge Choice Awards)</title>
<meta name="keywords" content="#getlistings.name#, New York, #getlistings.name# New York, #getlistings.name# New York City">
<Cfif #url.id# is not 103>
<meta name="description" content='#replacenocase(getlistings.fulldescription,"'","")#'>
</cfif>
</cfoutput>
</cfsavecontent>

<cfinclude template="header.cfm">
					<table border="0" cellpadding="4" cellspacing="0" width="600" >
					<tr>
					<td valign="top">




<cfoutput>
<font color="##534a3b" face="helvetica">

</font>
<p><span class="header"><font color="black" face=helvetica><b>#ucase(getlistings.name)#</b></span></strong><br>
<table width=100% cellspacing=0 cellpadding=0 bgcolor=#color#><tr><td></td></tr></table>
<font face=helvetica size=-2>
</cfoutput>


<Table width="550"><Tr><td>


<font face=helvetica size=-1>

<p>

<Cfif not parameterexists(url.year) or not isnumeric(url.year)>
<Cfset url.year = 2013>
</cfif>
<Cfquery name="findgraphic" datasource="#ds#">
select id,thumbnail
from ListingsPhotos
where tablename='#url.table#' and itemid=#url.id# and (mag =1 or mag =3)
</Cfquery>
<cfif #url.year# eq '2010'>

<cfquery name="getinfompic" datasource="#ds#">
select *
from ccapics2010
where company = '#getlistings.name#'
</cfquery>

<cfelse>

<cfparam name="url.category" default="Tour">
<cfparam name="url.year" default="2001">
<cfquery name="getinfompic" datasource="#ds#">
select *
from ccapics
where year = #url.year# and category = '#url.category#'
order by caption
</cfquery>

</cfif>

<cfquery name="getcoupons" datasource="cityguide">
select id,expire,description
from ListingsCoupons
where tablename='#url.table#' and itemid=#url.id# and (mag =1 or mag =3)
order by id desc
limit 0,1
</cfquery>

<cfquery name="getrelated" datasource="cityguide">
select id,linktitle,linktype
from ListingsRelated
where tablename='#url.table#' and itemid=#url.id# and (mag =1 or mag =3)
</cfquery>

<cfif #url.year# eq '2010' and #getinfompic.recordcount# gt 0>
<cfoutput>
<img src="http://conciergechoiceawards.com/CCA2010pics/#getinfompic.imagename#" width="150"  vspace="10"><br><br>
</cfoutput>
</cfif>


<cfif #findgraphic.recordcount# gt 0><cfoutput>
<cfloop from="1" to="#findgraphic.recordcount#" index="i">
<img src="http://www.cityguideny.com/listingsphotos/#findgraphic.thumbnail[i]#" border="0" class="fotgal" align=right hspace=10></a>
</cfloop>
</cfoutput>
</cfif>


<cfif #findgraphic.recordcount# eq 0 and parameterexists(url.pic)>
<Cfoutput>
<img src="http://conciergechoiceawards.com/ccapics/#url.pic#" width="150" align="left" hspace="10" vspace="10"><br><br>
</cfoutput>
</cfif>

<cfif parameterexists(url.multiple)>
<cfquery name="getmultiple" datasource="cityguide">
select id,name,address,city,state,zip,catid,description,website,phone,advertiser,fulldescription
from #url.table#
where (match (name) against ('"#getlistings.name#"'))
</cfquery>
<cfoutput query="getlistings"><strong>Multiple Locations:</strong></strong><br></cfoutput>
<cfoutput query="getmultiple">
<cfif #address# is not 'none'>#address#<br></cfif>
#phone#<p>


</cfoutput><cfelse>
<cfoutput query="getlistings">

<cfif #address# is not 'none'>#address#<br></cfif>
#phone#<br>
</cfoutput>
</cfif>


<cfoutput query="getlistings">
<cfif #url.id# eq 22 and #url.table# eq 'CarServices'>
<a href="http://#website#" target="new" style="text-decoration:none"><font color="##534a3b">#website#</font></a></small><p>
<cfelse>

<a href="http://www.cityguideny.com/linktrack.cfm?id=#url.id#&table=#url.table#" target="new"  style="text-decoration:none"><Cfif #url.id# eq 900 and #url.table# eq 'shopping'><font color="##534a3b">Visit Web Site<cfelse>#website#</cfif></a><p>
</cfif>
</cfoutput>

<cfif #getcoupons.recordcount# gt 0>
<cfoutput query="getcoupons">
<cfif #dateformat(getcoupons.expire,'mm/dd/yyyy')# gt #dateformat(now(),'mm/dd/yyyy')#>
<a href="/discountlinktrack.cfm?id=#getcoupons.id#" style="text-decoration:none"><strong>Coupon (click here):</strong> #getcoupons.description#</a><br>
</cfif>
</cfoutput>
<p>



</cfif>
<Cfoutput>
<a target="_new" href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#">Check Us Out on City Guide<br></a>

</cfoutput>


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



<Table width="550"><Tr><td>



<font face=helvetica size=-1>
<cfoutput query="getlistings">

#paragraphformat(fulldescription)#
</cfoutput>
</td></tr></table>




<p>
<cfoutput>
<table><tr>
<cfif #getlistings.ccainfo# contains '2007nom' and #getlistings.ccainfo# does not contain '2007win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#"><img src="http://www.conciergechoiceawards.com/2007nominee.jpg" width="150" border="0"></a>
</Td>
</cfif>
<cfif #getlistings.ccainfo# contains '2007win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://www.conciergechoiceawards.com/2007winner.jpg" width="150" border="0"></a>
</Td>
</cfif>
<cfif #getlistings.ccainfo# contains '2008nom' and #getlistings.ccainfo# does not contain '2008win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://www.conciergechoiceawards.com/2008nominee.jpg" width="150" border="0"></a>
</Td>
</cfif>

<cfif #getlistings.ccainfo# contains '2008win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://www.conciergechoiceawards.com/2008winner.jpg" width="150" border="0"></a>
</Td>
</cfif>
<cfif #getlistings.ccainfo# contains '2009nom' and #getlistings.ccainfo# does not contain '2009win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://www.conciergechoiceawards.com/2009nominee.jpg" width="150" border="0"></a>
</Td>
</cfif>
<cfif #getlistings.ccainfo# contains '2009win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://www.conciergechoiceawards.com/2009winner.jpg" width="150" border="0"></a>
</Td>
</cfif>

<cfif #getlistings.ccainfo# contains '2010nom' and #getlistings.ccainfo# does not contain '2010win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://www.conciergechoiceawards.com/2010nominee.jpg" width="150" border="0"></a>
</Td>
</cfif>
<cfif #getlistings.ccainfo# contains '2010win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://www.conciergechoiceawards.com/2010winner.jpg" width="150" border="0"></a>
</Td>
</cfif>


<cfif #getlistings.ccainfo# contains '2011nom' and #getlistings.ccainfo# does not contain '2011win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://www.conciergechoiceawards.com/2011nominee.jpg" width="150" border="0"></a>
</Td>
</cfif>
<cfif #getlistings.ccainfo# contains '2011win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://www.conciergechoiceawards.com/2011winner.jpg" width="150" border="0"></a>
</Td>
</cfif>

<cfif #getlistings.ccainfo# contains '2012nom' and #getlistings.ccainfo# does not contain '2012win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://cityguideny.com/2012Nominee-CCAlogo.jpg" width="150" border="0"></a>
</Td>
</cfif>
<cfif #getlistings.ccainfo# contains '2012win'>
<Td>
<a href="http://cityguideny.com/listingsinfo.cfm?id=#url.id#&table=#url.table#" target="new"><img src="http://cityguideny.com/2012Winner-CCAlogo.jpg" width="150" border="0"></a>
</Td>
</cfif>

</cfoutput>

 </tr></table>
<p>


<p>
<font face=helvetica size=-1>
<div align="right">
<a href="javascript: history.go(-1)" style="text-decoration:none"><font color="#534a3b"><u>Back...</u> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></a><br><br>

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

</center>



<Cfquery name="randomme" datasource="#ds#">
select showid,tablename
from ListingsStats
where mag = 5
and ShowDate = '#today#'
and views > 5
order by rand()
limit 0,2
</cfquery>

<Cfoutput>
<cfloop from="1" to="3" index="i">
<iframe id='ac87b609' name='ac87b609' src='http://www.nymetroparents.com/bestbetsinfo.cfm?id=#randomme.showid[i]#&table=#randomme.tablename[i]#&r=on' framespacing='0' frameborder='no' scrolling='no' width='1' height='1'></iframe>
</cfloop>
</cfoutput>

<cfif not parameterexists(url.r)>

<Cfquery name="randomme" datasource="#ds#">
select tableid,tablename
from cgmaster
where advertiser = 1 or advertiser = 2
order by rand()
limit 0,15
</cfquery>

<Cfoutput>
<cfloop from="1" to="7" index="i">
<iframe id='ac87b609' name='ac87b609' src='/listingsinfo.cfm?loadbanner=19612786123876123761961278612387612376&id=#randomme.tableid[i]#&table=#randomme.tablename[i]#&r=on' framespacing='0' frameborder='no' scrolling='no' width='0' height='0'></iframe>
</cfloop>
</cfoutput>

<iframe id='ac87b609' name='ac87b609' src='/listingscat.cfm?id=7&r=on' framespacing='0' frameborder='no' scrolling='no' width='1' height='1'></iframe>
<iframe id='ac87b609' name='ac87b609' src='/listingscat.cfm?id=7&r=on' framespacing='0' frameborder='no' scrolling='no' width='1' height='1'></iframe>
<iframe id='ac87b609' name='ac87b609' src='/listingscat.cfm?id=7&r=on' framespacing='0' frameborder='no' scrolling='no' width='1' height='1'></iframe>
<iframe id='ac87b609' name='ac87b609' src='/listingscat.cfm?id=7&r=on' framespacing='0' frameborder='no' scrolling='no' width='1' height='1'></iframe>
<iframe id='ac87b609' name='ac87b609' src='/listingscat.cfm?id=7&r=on' framespacing='0' frameborder='no' scrolling='no' width='1' height='1'></iframe>


</cfif>
<cfinclude template="footer.cfm">
<cfelse>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-642804-2");
pageTracker._setDomainName(".cityguideny.com");
pageTracker._trackPageview();
} catch(err) {}</script>
</cfif>