title: MySQL Order a SELECT based on other SELECT
body: <p>I've got these two selects:</p>
  
  <pre><code>SELECT ent_user, ent_video_type, count(*) AS total 
  FROM entry WHERE ent_user='1' 
  GROUP BY ent_video_tipo 
  ORDER BY total DESC
  
  ent_user|ent_video_type|total
      1   |       1      |  3
      1   |       3      |  2
      1   |       4      |  1
  </code></pre>
  
  <p>And I've got this other select:</p>
  
  <pre><code>SELECT * FROM meta
  
  met_id|met_name|user_id|met_type
     10 |  bla   |   2   |    1
     11 | blabla |   4   |    2
     12 |  foo   |   1   |    3
     13 | blafoo |   3   |    4
     14 | foofoo |   5   |    4
  </code></pre>
  
  <p>How can I order the last select so it is like this:</p>
  
  <pre><code>met_id|met_name|user_id|met_type
     10 |  bla   |   2   |    1
     12 |  foo   |   1   |    3
     13 | blafoo |   3   |    4
     14 | foofoo |   5   |    4
     11 | blabla |   4   |    2
  </code></pre>
  
  <p>I want to order the last select by <code>met_type</code>depending on the first select. I want to make <code>ent_video_type</code>=<code>met_type</code> so I can order the last select by <code>met_type</code>.</p>
  
  <p>How can I do that ?</p>
  
  <p>I want to order the <code>met_type</code> column by the order of the column <code>ent_video_type</code>.</p>