<Cfquery name="geter" dataSource="#ds#">
select id,hours,activityname,name,address,address2,phone,website,ages,price,description,datestart,dateend,seo_friendly,usepicprint,photo,cgpriority,age6
    from ActivityPlanner
    where 1=1
    and dateend > '2017-11-01'
and activityname = 'West Village Chorale Annual Messiah Sing'
    and id <> 255477
    and status=0
and (catid > 0 or catid2 > 0)
and (catid3 = 0 and catid4 = 0)


    order by datestart,name
 </cfquery>
 
<Cfoutput query="Geter">
	 <a href="https://www.cityguideny.com/admin/editcalendar.cfm?id=#id#">#activityname# at #name#</a> -  #dateformat(datestart,'m/d/yyyy')# to #dateformat(datestart,'m/d/yyyy')# @ #hours# 
	<Cfif #activityname# eq #activityname[currentrow-1]#
		and datestart eq #datestart[currentrow-1]#
		and dateend eq #datestart[currentrow-1]#
			
			><font color="red"><b>DUPE <cfif hours eq #hours[currentrow-1]#> HOURS SAME
				
				<cfquery name="del" dataSource="#ds#">
					delete from ActivityPlanner where id = #id#
				</cfquery>	
				
				- #ID#
				
				<cfelse>

<Font color="black">#hours[currentrow-1]#, #hours#</Font>	
				
				<Cfquery name="upds" dataSource="#ds#">
					update ActivityPlanner
					set hours = '#hours[currentrow-1]#, #hours#'
					where id = #id[currentrow-1]#
				</cfquery>
				
						
				<cfquery name="del" dataSource="#ds#">
					delete from ActivityPlanner where id = #id#
				</cfquery>	
					
				
				HOURS DIFFERENT</cfif></b></font></Cfif>
	
	<br>
	
 </Cfoutput>