Using entity queries in Drupal 7

entity_queries.php

<?php

// A. The old way using node_load
$nodes = node_load_multiple(NULL, array('type' => 'example_content_type'));

// B. The new way using entity queries.
// The point of entity queries is you can add field filters here before the
// node has to be actually loaded, making your code execution a load lighter.

// Get a list of nids for nodes that match our request
// Remember that this only return nids, no full node objects!
$query = new EntityFieldQuery();
$entities = $query->entityCondition('entity_type', 'node')
              ->entityCondition('bundle', 'example_content_type')
              ->propertyCondition('status', NODE_PUBLISHED)
              ->propertyCondition('language', $language)
              ->fieldCondition('target_access', 'value', $target_access, '=')
              ->execute();
if (count($entities)) {
    $nids = array_keys($entities['node']);
    $nodes = node_load_multiple($nids);
}