title: Drupal Views filtering by taxonomy term
body: <p>I have content type that has mandatory term reference field to four terms:</p>
  
  <pre><code>A
  B
  C
  D
  </code></pre>
  
  <p>I need to create query (list) which gives me back only the last 4 node associeated to each term.</p>
  
  <p>Basicly I want to run these queries in my view:</p>
  
  <pre><code>SELECT myfield FROM mytable WHERE term_field='A' LIMIT 1;
  SELECT myfield FROM mytable WHERE term_field='B' LIMIT 1;
  SELECT myfield FROM mytable WHERE term_field='C' LIMIT 1;
  SELECT myfield FROM mytable WHERE term_field='D' LIMIT 1;
  </code></pre>
  
  <p>Is it possible?</p>