title: MySQL Subquery Syntax + ZF2 Syntax
body: <p>I have a football database with 10k+ rows. My goal is to select one player by his id and get all other players which are in the same league or club or have the same nationality.
  My query so far is the following:</p>
  
  <pre><code> SELECT * 
   FROM  `characteristics` 
   WHERE `nation` = (SELECT `nation` 
                     FROM `characteristics` 
                     WHERE `id` = "1") 
   OR    `club`   = (SELECT `club` 
                     FROM `characteristics` 
                     WHERE `id` = "1") 
   OR   `league`  = (SELECT `league` 
                     FROM `characteristics` 
                     WHERE `id` = "1")
  </code></pre>
  
  <p>I think the query doesn't work as I expected, because it will return 1434 rows. For example: <code>Nation = Argentina</code>, <code>League = BBVA</code>, <code>Club = FC Barcelona</code> will return together something about 1500+ rows.</p>
  
  <p>Maybe you guys can help me with this subquery.</p>
  
  <p>Another problem is the subquery syntax in ZF2. I found something here on stackoverflow, but I can't figure the syntax out where to put something.</p>
  
  <p>EDIT: example of db data</p>
  
  <pre><code>id  firstname lastname age height nation     club          league
  1   Lionel    Messi    28  170 cm Argentina  FC Barcelona  Liga BBVA
  </code></pre>