title: MySQL - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
body: <p>this is the code what im using</p>
  
  <pre><code>    $Last_Video         = $db-&gt;fetch_all('
      SELECT VID, thumb
      FROM video
      WHERE VID IN (
          SELECT VID
          FROM video
          WHERE title LIKE "%'.$Channel['name'].'%"
          ORDER BY viewtime DESC
          LIMIT 5)
      ORDER BY RAND()
      LIMIT 1
  ');
  </code></pre>
  
  <p>This is the error what give me<br /></p>
  
  <pre><code> Message:   Error during SQL execution: SELECT VID, thumb FROM video WHERE VID IN ( SELECT VID FROM video WHERE title LIKE "%funny%" ORDER BY viewtime DESC LIMIT 5) ORDER BY RAND() LIMIT 1&lt;br /&gt;
   MySQL Error:   This version of MySQL doesn't yet support 'LIMIT &amp; IN/ALL/ANY/SOME subquery'&lt;br /&gt;
  MySQL Errno:    1235
  </code></pre>
  
  <p>how i can fix this problem ? its other way to make it ... so i dont get the error ...</p>