title: MySQL query convert in Laravel DB query
body: <p>This is a product catalog page, and I need to get 1 image for a preview.</p>
  
  <p>My query now:</p>
  
  <pre><code>DB::select('SELECT  
                  h.*
                , (SELECT link 
                   FROM media_libs m 
                   where h.id=m.have_videos_id limit 1) as link 
              FROM have_videos h')
  </code></pre>
  
  <p>But I need pagination.</p>
  
  <pre><code>DB::select('SELECT 
                  h.*
                  , (SELECT link 
                      FROM media_libs m 
                      where h.id=m.have_videos_id limit 1) as link 
              FROM have_videos h')-&gt;paginate(15)
  </code></pre>
  
  <p>So naturally nothing works</p>
  
  <p>How to convert a query in the Facade DB?</p>