Make sure queries select where date=max (if not powering a time-series)

[luke-strange]

Where we want most recent date's values only, add sort by date and limit 1 (or get latest available)