Advertisement
Dyrcona

auto-renew-by-usr.sql

Mar 5th, 2020
841
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. copy(select usr, state, count(*)
  2. from action.circulation
  3. join action_trigger.event
  4. on circulation.id = event.target
  5. where date(event.add_time) = '2019-12-26'
  6. and event_def = 124
  7. group by usr, state)
  8. to stdout with csv header;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement