title: How to edit my query show only one image per product?
body: <p>I have two tables, products and product_images. Product_images has entries of images for each product. There are a lot of images per product.</p>
  
  <p>I am using the following SQL query, however I want to show only one image per product. Now I get as many entries per product as the images.</p>
  
  <p>In this purpose I will show a lot of products, like all the products of a category, not a single product.</p>
  
  <pre><code>select products.product_id, product_images.image,
         products.name, products.description
  from product_images
  left join products on products.product_id = product_images.product_id 
  where products.category_child= 1
  </code></pre>
  
  <p>How to show only one image (the first) per product?</p>