<cfquery name="getListing" datasource="#Application.dsn#">
  SELECT
         CL.category_id
    ,     CL.category_icon
    ,     CL.category_sequence
    ,     CL.category_isActive                  
    ,     C.language_abbr
    ,     C.category_name
    ,     CH.photo
    ,     AL.activity_id
    ,     A.language_abbr
    ,     A.activity_name
    ,     A.activity_title
    ,     A.activity_description
    ,     DATE_FORMAT( activity_date, '%d/%m') AS newDate
    ,     AD.activity_date
  FROM
      category_list CL
  INNER
    JOIN categories C
      ON CL.category_id = C.category_id
     AND C.language_abbr = <cfqueryparam cfsqltype="cf_sql_char" value="#Trim( Session.language )#" />    
  LEFT
    JOIN category_headers CH
      ON CL.category_id = CH.category_id
  INNER
    JOIN activity_list AL
      ON CL.category_id = AL.category_id
  INNER
    JOIN activities A
      ON AL.activity_id = A.activity_id
  AND    A.language_abbr = <cfqueryparam cfsqltype="cf_sql_char" value="#Trim( Session.language )#" />            
  INNER
    JOIN      activity_dates AD
      ON     AL.activity_id = AD.activity_id                 
  ORDER
      BY category_sequence, activity_name,  MONTH(AD.activity_date), DAY(AD.activity_date)                                            
</cfquery>
<cfquery name="getDates" dbtype="query">
  SELECT
      DISTINCT newDate
  FROM
               getListing
</cfquery>
<cfset result = valueList ( getDates.newDate, ", " )>