What should the dynamic query for the following SQL string be? What should the dynamic query for the following SQL string be?
SELECT p.id, p.name, GROUP_CONCAT(s.name) AS site_list
FROM sites s
INNER JOIN publications p ON(s.id = p.site_id)
GROUP BY p.id;
$query = db_select('sites', 's')
  -&gt;fields('p', array('id', 'name'))
  -&gt;groupBy('p.id');

$query-&gt;addExpression('GROUP_CONCAT(s.name)', 'site_list');
$query-&gt;join('publications', 'p', 's.id = p.site_id');