<Cfquery name="geter" dataSource="#ds#">
SELECT DISTINCT Neighborhood,region FROM neighborhoodnymp 
group by neighborhood 
order by region,neighborhood
</cfquery>

<table border="1" cellpadding="4" cellspacing="0">
<cfloop from="1" to="#Geter.recordcount#" index="i"> 
<tr>
	<td><Cfoutput>#geter.region[i]#</Cfoutput></td>
	<td> 
<cfquery name="Getzips" dataSource="#ds#">
	select zip from neighborhoodnymp
	where neighborhood = '#geter.neighborhood[i]#'
</cfquery>
<Cfset listme = ''>
<cfoutput query="getzips">
	<Cfif #listme# eq ''>
				<cfset listme = '#getzips.zip#'>	

		<cfelse>
		
		<cfset listme = '#listme#,#getzips.zip#'>	
	</Cfif>
</cfoutput>
<Cfoutput>
#geter.neighborhood[i]#</Cfoutput></td>
<Td>
	
	 <cfquery name="getstuff" datasource="#ds#">
 select issueguide.writeup, issueguide.pkid, issueguide.editedby,issueguidecat.issue,issueguidecat.mags,issueguide.offer,issueguide.expirationdate,issueguidecat.issueguideid,ParentsListings.*,ParentsListingsCatMain.catname as category
 from issueguide inner join issueguidecat on issueguidecat.issueguideid = issueguide.id inner join ParentsListings on issueguide.pkid = ParentsListings.id inner join ParentsListingsCatMain on issueguide.catid = ParentsListingsCatMain.id
 where
 ParentsListings.zip in (#listme#)
 and issueguide.catid in (382,386,340,341,339)
and issueguidecat.issuemy like '%2015%'
group by name
  order by category,ParentsListings.name
 </cfquery>

<Cfoutput>#getstuff.recordcount#</cfoutput>

</Td>
<td>
	<small>
	<Cfoutput query="Getstuff">
		#name#<cfif #currentrow# is not #recordcount#>,</cfif> </Cfoutput>
			<small>

</td>
	
<Td>	<small>

	<cfoutput>#listme#</cfoutput></small>
</Td>

</cfloop>
 </table>