Unnamed

<?php  $count = db_result(db_query("SELECT COUNT(DISTINCT(a.nid)) FROM {content_type_action} a, {node} n, {term_node} t WHERE n.type='action' AND n.nid = a.nid AND n.vid = a.vid AND n.nid = t.nid AND t.tid='85' AND a.field_status_value='In Progress' AND a.field_type_of_action_value='Site CIR' AND a.field_origin_date_value='2007-11-00T00:00:00'"));  echo $count;?>