Correct CCK queries

Home ยป Tools
This tool will help you write PHP code with SQL queries involving CCK fields. If you are not sure what this is all about read my blog post.
One or more CCK field names.
Optional node type that will be added to the WHERE clause.
<?php

$fields_info['field_date'] = content_fields('field_date');
$db_info['field_date'] = content_database_info($fields_info['field_date']);

$result = db_query("
  SELECT * FROM {node} n
  INNER JOIN {". $db_info['field_date']['table'] ."} c0 ON n.vid = c0.vid
");
while ($row = db_fetch_object($result)) {
  dsm($row);
}