How to get content type data on basis of assigned taxonomy? I want to get the data of particular content type on the basis of taxonomy assigned to it. How can I get this using query.

$bloglist = db_select('node', 'n')
                    -&gt;fields('n', array('nid'))
                    -&gt;condition('type', 'product_list', '=')
                    -&gt;condition('status', 1, '=')
                    -&gt;orderBy('created', 'DESC')
                    -&gt;execute()
                    -&gt;fetchCol();

        // Get all of the article nodes.
        $bloglists2 = node_load_multiple($bloglist);


I have this query to get the data for product_list content type. Now I want to add one more condition of taxonomy to get data on basis of taxonomy and content type. How can I do that?
The EntityFieldQuery class was built to do pretty much exactly that:

$query = new EntityFieldQuery();
$result = $query
  -&gt;entityCondition('entity_type', 'node')
  -&gt;entityCondition('bundle', 'product_list')
  -&gt;propertyCondition('status', 1)
  -&gt;fieldCondition('field_foo', 'tid', $term_id)
  -&gt;propertyOrderBy('created', 'DESC')
  -&gt;execute();

if (isset($result['node'])) {
  $nodes = node_load_multiple(array_keys($result['node']));
}