Unnamed

$sub = db_select('comment', 'c');
$sub->addField('c', 'cid');
$sub->condition('c.uid', 1);
$sub = $sub->countQuery();
$sub->preExecute();

$select = db_select('node', 'n');
$select->addField('n', 'nid');
$select->condition($sub, '0', '<');

$select->execute();

dsm((string) $select);