get a CCK field by query

<?php
$field = content_fields(‘field_date’);
$db_info = content_database_info($field);
$result = db_query(“SELECT COUNT(*) AS count FROM {node} n
INNER JOIN {term_node} tn ON n.vid = tn.vid
INNER JOIN {“. $db_info['table'] .”} ctd ON n.vid = ctd.vid
WHERE tn.tid = 25 AND ctd.” . $db_info['columns']['value']['column'] . ” > NOW() AND n.changed > %d”, $newtime);
?>

thanks to drewish