Contatore nodi su più content type

$counter = db_query("SELECT COUNT(node.nid) AS total_nid FROM {node} node WHERE node.type= :type1 OR node.type= :type2 AND node.status= :status", array(
':type1' => 'scheda1',
':type2' => 'scheda2',
':status' => 1,
))->fetchField();
drupal_set_message(' ' . print_r($counter, TRUE) . '');

>> Well Done!

Oppure
$query = db_select('node', 'n')
->fields('n', array('nid'));
$db_or = db_or();
$db_or->condition('type', 'scheda1', '=');
$db_or->condition('type', 'scheda2', '=');
$query->condition($db_or);
$query->condition('status', 1, '=');
$result = $query->execute();
$num_of_results = $result->rowCount();

Forse più articolato ma funzionale...