Price database and confusing SQL query

[eluser]obiron2[/eluser]
looks good to me.

SQL to get latest prices

select p.merchant_id,p.price,max(p.created_on),m.name,m.description
from prices p
join merchant m on p.merchant_id = m.id
where p.product_id = $productID
group by p.merchant_id,m.name,m.description
order by m.name


SQL to get prices at a specific date

select p.merchant_id,p.price,max(p.created_on),m.name,m.description
from prices p
join merchant m on p.merchant_id = m.id
where p.product_id = $productID
and p.created_on <= $PriceDate
group by p.merchant_id,m.name,m.description
order by m.name

Obiron