title: Get image url in prestashop
body: <p>I need to make a feed for my site for a comparing site. It has to be a sql statement.
  For now I have this:</p>
  
  <pre><code>select  pl.name as Titel,
      ROUND(p.price*1.21,2) as Price,
      replace(concat('http://', ifnull(conf.value,'domain/'), cl.name, '/', p.id_product, '-' , pl.name, '.html'),' ','-') as Link,
       concat('http://', ifnull(conf.value,'domain'), '/img/p/', p.id_product, '-' , pi.id_image, '.jpg') as "Image-location",
       cl.name as Categorie,
      p.id_product AS ID
  from dbrb_product p
  left join dbrb_image pi on p.id_product = pi.id_product
  left join dbrb_product_lang pl on p.id_product = pl.id_product
  left join dbrb_category_lang cl on p.id_category_default = cl.id_category
  left join dbrb_configuration conf on conf.name = 'dbrb_SHOP_DOMAIN'
  left join dbrb_product_carrier x on p.id_product = x.id_product
  group by p.id_product
  </code></pre>
  
  <p>But now with the new prestashop version 1.6 the image doesn't work anymore.</p>
  
  <p>Now the image path is: domain.com/img/p/number/number/number/image.png
  I don't get the logic from it, can somebody tell me?</p>
  
  <p>There is also another problem I have to deal with, because there are some products which have the same image.</p>
  
  <p>Can somebody complete the SQL code or help me further?</p>
  
  <p>Thanks!</p>