title: show all products which has discounts (specific price) - Prestashop
body: <p>I'm looking for a way to display all products that has specific prices to them, and display like  any other category page.</p>
  
  <p>I've created the front controller and the class in a module.</p>
  
  <p>I'm not really into sql so I want a query that would fetch all data in one place, like id_image, id_product, etc.</p>