<Cfquery name="Geter" dataSource="#ds#">
	select *	from ParentsListings 
inner join ParentsListingsCat2011 on ParentsListings.id = ParentsListingsCat2011.pkid	
inner join ParentsListingsCatMain2011 on ParentsListingsCat2011.catid = ParentsListingsCatMain2011.id

<cfif parameterexists (url.basictoo)>
	where (advertiser = 1 or advertiser = 3) 
	<cfelse>
	where advertiser = 1

</cfif>




and ParentsListingsCatMain2011.mastercat = 	3

<cfif parameterexists (url.dedupe)>
	group by name
</cfif>
</cfquery>

<table border="1" cellpadding="4" cellspacing="0"> 
<cfoutput query="Geter">
	<tr>
		<Td>
			<a href="http://cityguideny.com/listingseditpk.cfm?id=#id#&table=ParentsListings&cat=0&catid=0">edit</a></Td>
		<Td>#name#</Td>
		
		<cfif  not parameterexists (url.dedupe)>
<td>#region#</td>
		</cfif>
		<td>
			<Cfif #advertiser# eq 1>Premium<cfelse>Basic</Cfif>
		</td>	
	<td>#dateformat(lastupdated,'m/d/yyyy')#</td>	
	
	<td>#contactfirst#</td>
	<td>#contactlist#</td>
	<td>#contactemail#</td>
	<td>#email#</td>
	<td>#Address#</td>
	<td>#city#</td>
	<td>#state#</td>
	<td>#zip#</td>
		
	</tr>	
</cfoutput>		
</table>