title: Select unique rows in mysql query
body: <p>I have query </p>
  
  <pre><code>SELECT DISTINCT employer.id, employer.name
  FROM employers 
  LEFT JOIN positions ON positions.id = employers.id 
  LEFT JOIN statuses ON statuses.position = positions.some 
  WHERE statuses.number = 2
  </code></pre>
  
  <p>And the thing is some i need unique records from employers but i am getting duplicates because statuses.number do repeat like 222 6 777 etc i need to grab them only once.
  I dont want to use DISTINCT is there other way?</p>