distinct query

gistfile1.sql

SELECT node.nid                               AS nid, 
       node.TYPE                              AS node_type, 
       node.vid                               AS node_vid, 
       apci_game_results.result_rendered      AS 
       apci_game_results_result_rendered, 
       Distinct(apci_game_results.tid)        AS apci_game_results_tid, 
       node_data_field_date.field_date_value  AS 
       node_data_field_date_field_date_value, 
       node_data_field_date.field_date_value2 AS 
       node_data_field_date_field_date_value2, 
       node_data_field_date.field_date_rrule  AS 
       node_data_field_date_field_date_rrule, 
       node_data_field_date.delta             AS node_data_field_date_delta 
FROM   node node 
       LEFT JOIN og_ancestry og_ancestry 
         ON node.nid = og_ancestry.nid 
       INNER JOIN node node_og_ancestry 
         ON og_ancestry.group_nid = node_og_ancestry.nid 
       LEFT JOIN term_node term_node 
         ON node.vid = term_node.vid 
       LEFT JOIN term_data term_data 
         ON term_node.tid = term_data.tid 
       LEFT JOIN vocabulary vocabulary 
         ON term_data.vid = vocabulary.vid 
       LEFT JOIN content_field_date node_data_field_date 
         ON node.vid = node_data_field_date.vid 
       LEFT JOIN apci_game_results apci_game_results 
         ON node.nid = apci_game_results.nid 
WHERE  ( ( node.TYPE IN ( 'vevent' ) ) 
         AND ( node.status <> 0 ) 
         AND ( vocabulary.module IN ( 'features_event_category' ) ) 
         AND ( ( term_data.name ) = ( 'Game' ) ) ) 
       AND ( Date_format(Addtime(Str_to_date( 
                                 node_data_field_date.field_date_value, 
                                       '%Y-%m-%dT%T'), 
                                           Sec_to_time(-21600)), '%Y-%m-%d') >= 
                 '2007-12-10' ) 
ORDER  BY node_data_field_date_field_date_value ASC