Skip to content

Instantly share code, notes, and snippets.

@moxie

moxie/gist:3177522

Created July 25, 2012 17:54
Show Gist options
  • Save moxie/3177522 to your computer and use it in GitHub Desktop.
Save moxie/3177522 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
select u.app_id, u.property_id from ad_units u
left join ad_impressions i on i.ad_unit_id = u.id and date(i.date) > '2012-05-01'
where i.id is null
group by u.app_id, u.property_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment