Skip to content

Instantly share code, notes, and snippets.

@voltgister
Created February 4, 2016 17:27
Show Gist options
  • Save voltgister/815e4b37f33dd04a5ca9 to your computer and use it in GitHub Desktop.
Save voltgister/815e4b37f33dd04a5ca9 to your computer and use it in GitHub Desktop.
select id, advertiser_id, bid_amount
from bids
where current_timestamp between ts_start and ts_end
and contains(region, ?)
order by bid_amount desc, id
limit 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment