title: Limit the results of join on 2nd table
body: <p>I have the query below, and it gets the correct data, but I need to limit the results of the join so that only the first row from the photos table is included. Here's what I have:</p>
  
  <pre><code>SELECT `listings`.*, `photos`.* 
  FROM `listings` JOIN `photos` 
  ON `photos`.`listing_id` = `listings`.`id` 
  WHERE `listings`.`date_expires` &gt;= '2016-08-10' AND `listings`.`visible` = '1'  AND `listings`.`spotlightListing` &gt;= '2016-08-10'
  </code></pre>
  
  <p>How do I limit the above so I only get the first row from the photos table? Thanks!</p>