select b.commodity_id, b.market_id, c.system, c.station, max(a.sell_price) as max_price, datetime(b.last_ts, 'unixepoch') from commoditiesPrice a, (select commodity_id, market_id, max(timestamp) as last_ts from commoditiesPrice group by commodity_id, market_id having commodity_id = 144) b, markets c where a.commodity_id = b.commodity_id and a.market_id = b.market_id and a.timestamp = b.last_ts and a.market_id = c.id group by b.commodity_id, b.market_id, b.last_ts order by max_price;

select b.commodity_id, b.market_id, c.system, c.station, max(a.sell_price) as max_price, datetime(b.last_ts, 'unixepoch')
from commoditiesPrice a, (
    select commodity_id, market_id, max(timestamp) as last_ts
    from commoditiesPrice
    where timestamp <= 1589025600
    group by commodity_id, market_id having commodity_id = 144
) b,
markets c
where a.commodity_id = b.commodity_id and a.market_id = b.market_id and a.timestamp = b.last_ts and a.market_id = c.id
group by b.commodity_id, b.market_id, b.last_ts
order by max_price;

select *, datetime(timestamp, 'unixepoch') from commoditiesPrice where market_id = 3228369152 and commodity_id=144 order by timestamp;