SELECT distinct  product_name name
, cost_price our_price
, cost_price * 1.3 retail_price
, cost_price * 0.3 savings
, external_url image_url
, category_description
, supplier_name
FROM category_translations, products_base, suppliers
WHERE products_base.category_id = category_translations.category_id
  AND products_base.supplier_id = suppliers.supplier_id
  AND products_base.product_id = nvl('##Param1##', 0)