By lehuuphuc on

how do I create a query like this with db_select:

select u.uid, u.name, count(n.id) from users u
join node n where u.uid = n.uid
group by u.uid

⋅ Categories: Drupal 7.x

Comments

nevets’s picture

nevets commented

How about

$query = db_select('users', 'u')
   ->join('node', 'n', 'u.uid = n.uid')
   ->fields('u', array('uid', 'name');

$query->addExpression('COUNT(nid)', 'node_count');

$results = $query->execute();
lehuuphuc’s picture

lehuuphuc commented

It works. Thanks man.

lucas.matias’s picture

lucas.matias commented

$result->execute()->rowCount();

you can count the row after the query.