How to query the last 5 nodes of multiple content types?

Question

I want to query last 5 nodes of multiple content types, say, typeA, typeB, typeC, typeD.

It was originally only one content type, and I did it using EntityFieldQuery:

$query->entityCondition('entity_type', 'node')
  ->entityCondition('bundle', 'typeA')
  ->propertyCondition('status', 1)
  ->propertyOrderBy('created', 'DESC')
  ->range(0, 5);

$result = $query->execute();

But now I need to include 3 other content types to the list.

Is there any way to expend this query to include the last 5 nodes of the other 3 content types as well. So that the result will have 5 last nodes from all 4 content types, altogether 20 nodes.

Or should I do it with 4 individual queries?

Answer 1

I think the only thing you need is alter the second line of your EntityFieldQuery to this:

->entityCondition('bundle', array('typeA', 'typeB', 'typeC', 'typeD'), 'IN')

Haven't tested this particular though, but you can query multiple content types this way.

Cheers

EDIT: Maybe this can help you more: https://www.drupal.org/node/2048345

Answer 2

Try something like the following codes:

$types= array('type1','type2','type3');

foreach ($types as $type) {
  $query->entityCondition('entity_type', 'node')
    ->entityCondition('bundle', 'typeA')
    ->propertyCondition('status', 1)
    ->propertyOrderBy('created', 'DESC')
    ->range(0, 5);
  $temp = $query->execute();

  if (isset($temp['node'])) {
    $result[$type]['nids'] = array_keys($temp['node']); 
    $result[$type]['nodes'] = node_load_multiple($result[$type]['nids']);
  } 
}

/// then you can load them by 

Answer 3

I think as other have suggested using UNION is going to be the easiest way to do it with one query:

$nids = db_query("(SELECT nid FROM node WHERE type = 'typeA' ORDER BY changed LIMIT 0, 5)
UNION
(SELECT nid FROM node WHERE type = 'typeB' ORDER BY changed LIMIT 0, 5)
UNION
(SELECT nid FROM node WHERE type = 'typeC' ORDER BY changed LIMIT 0, 5)
UNION
(SELECT nid FROM node WHERE type = 'typeD' ORDER BY changed LIMIT 0, 5)")->fetchCol();
$nodes = node_load_multiple($nids);

I was playing with a way to do it using numbered rows but it doesn't get the latest nodes so I gave up, but here is the sql in case your interested in fixing it:

SELECT nid, title, type, changed
FROM (
    SELECT nid, title, type, changed,
    @num := if(@group = type, @num + 1, 1) as row_number,
    @group := type as dummy
    FROM   node
    WHERE type IN ('typeA', 'typeB', 'typeC', 'typeD')
    ORDER BY type, title
) AS x
WHERE  row_number <= 5
ORDER BY type

Also see this very relevant SO question MySQL:How to get n latest rows of a distinct type

Answer 4

the best way you can do it is to user db_select(); I would do something like this:

Set the array with the content type machine names.

$arrayofnodetypes = array('page','post','poll');

here you select the table

$query = db_select('node','n'); 
$query->fields('n',array('nid','title','status','type')); // this are the fields your want to fetch
$query->condition('n.status','1','='); // node is published
$query->condition('n.type',$arrayofnodetypes,'IN'); // this is where you call the content types.
$query->orderBy('created','DESC');
$query->range(0,20);

$results = $query->execute()->fetchAll();

Then you have 2 options.

the first:
if you want to fetch all fields in the node, you need to manualy join the fields in the $query see the following resource if you want to learn more: https://www.drupal.org/node/1848348

the second: the $results variable will have the results of the query.

I would then foreach each result of the array.

like the folowing;

$nodes = array();
foreach($results as $item) {
  $nodes []= node_load($item->nid);
}

then the $nodes array will contain the results you need.

Answer 5

You could also use node_load_multiple.

$types = array('content_type_1', 'content_type_2', 'etc');
$query = db_select('node', 'n')
  ->fields('n', array('nid'))
  ->condition('type', $type, 'IN');


$result = $query->execute()->fetchAll();

$nids = array();
foreach ($result as $row) {
  $nids[] = $row->nid;
}

$nodes = node_load_multiple($nids);