问查询Drupal7中的文章

EN

SELECT     node.title, body.body_value, FROM_UNIXTIME(node.created) AS Created, file_managed.uri AS image
FROM         node INNER JOIN
                  field_data_body AS body ON node.nid = body.entity_id INNER JOIN
                  file_usage ON file_usage.id = node.nid INNER JOIN
                  file_managed ON file_usage.fid = file_managed.fid
WHERE     (node.type = 'article')

$query = new EntityFieldQuery;
$results = $query->entityCondition('entity_type', 'node')
  ->entityCondition('bundle', 'article')
  ->execute();

if (isset($results['node'])) {
  $nodes = node_load_multiple(array_keys($results['node']));

  foreach ($nodes as $node) {
    $created = $node->created;
    $image_uri = $node->field_image[$node->language][0]['uri'];
    // ...
  }
}