var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query help. newest distinct rows.
A prices table will list the prices of products, and will be updated often.
id product_id qty price timestamp
Each product ID will have multiple entry's.
What I want to select is the newest entry's for each unique combination of 'product_id' and 'qty'.
How do I fit max(timestamp) in with this query:
(SELECT DISTINCT product_id, qty FROM prices)?
, MAX(timestamp) AS latest