title: Symfony2 - Doctrine DQL - many to many query
body: <p>I have entities <code>Offer</code> and <code>Area</code> and here one <code>Offer</code> can have many <code>Areas</code> and one <code>Area</code> belong to many <code>Offers</code>:</p>
  
  <p><code>Offer</code> entity:</p>
  
  <pre><code>/**
   * @ORM\ManyToMany(targetEntity="Area")
   * @ORM\JoinTable(name="relationship_offer_areas",
   *      joinColumns={@ORM\JoinColumn(name="offer_id", referencedColumnName="id", onDelete="CASCADE")},
   *      inverseJoinColumns={@ORM\JoinColumn(name="area_id", referencedColumnName="id")}
   *      )
   */
  private $areas;
  </code></pre>
  
  <p>Now I am trying to get <code>Offers</code> by <code>Area</code> using DQL (not query builder!):</p>
  
  <pre><code>$query = 'SELECT o FROM IndexBundle:Offer o '.
      'LEFT JOIN IndexBundle:Area a '.
      'WHERE a = :area '.
      'ORDER BY o.startDate ASC';
  </code></pre>
  
  <p>Here <code>:area</code> is <code>Area</code> entity object. Unfortunately it is not working as expected. I get all offer rows with all the areas.</p>
  
  <p>Any ideas what am I missing? Working with Entities in query language really twist my mind. Thank you!</p>