<cfset myArray = ["BeautyHealth", "CarServices", "CulturalArts", "FamilyFun","Museums","Nightlife","Restaurants","Shopping","Theater","ToursAttractions"] >
<!--- 	and lastupdated > '2018-03-01'
 ---->
<cfset myArray = [ "CulturalArts", "Nightlife","ToursAttractions"] >
<cfsetting requesttimeout=5000>
<table border="1" cellspacing="0" cellpadding="4">
<cfloop array="#myArray#" index="idx">
<cfquery name="geter" datasource="cityguidero">
	select * from #idx#
	where hide = 0
	</cfquery>	
	
<Cfoutput query="Geter">
	<tr>

<Td>#idx#</Td>	
<td>#name#</td>	
<td>#address#</td>	
<td>#city#</td>	
<td>#state#</td>	
<td>#zip#</td>	
<td>#phone#</td>	

   <td>#website#</td>	
<td>
	
	<Cfif #geter.email2020# is not '-1' and #geter.email# does not contain '@'>
		
		

	<cfquery name="findcontact" datasource="cityguidero">
		select contactemail from ActivityPlanner
		where name like '%#name#%' and contactemail <> ''
		order by id desc
		limit 0,1
	</cfquery>
	

	
	<cfif #findcontact.recordcount# eq 0>
		
			<cfquery name="upds" datasource="#ds#">
		update #idx#
		set email2020 = '-1'
		where id = #id#
	</cfquery>
		<cfelse>
	<cfquery name="upds" datasource="#ds#">
		update #idx#
		set email2020 = '#findcontact.contactemail#'
		where id = #id#
	</cfquery>
	
		</cfif>

		</Cfif>
		
		<cfif #geter.email# contains '@'>
			#geter.email#
		</cfif>
</td>
   
</tr>   
</Cfoutput>	

</cfloop>


</table>