Advertisement
chrissharp123

Untitled

Mar 12th, 2019
449
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.36 KB | None | 0 0
  1. evergreen=# select rmsr.tcn_value, rmsr.title, rmsr.author, rmsr.pubdate, cp.circ_modifier, count(*) from action.circulation c join asset.copy cp on (c.target_copy = cp.id) join asset.call_number cn on (cp.call_number = cn.id) join reporter.materialized_simple_record rmsr on (cn.record = rmsr.id) join actor.org_unit cl on (c.circ_lib = cl.id) where cn.id > 0 and date(c.xact_start) between date(now()) - '1 month'::interval and date(now()) - '1 day'::interval and cl.shortname ~ '^PIED' group by 1, 2, 3, 4, 5 order by 6 desc limit 20;
  2. tcn_value | title | author | pubdate | circ_modifier | count
  3. --------------+------------------------------------------------------+--------------------------+---------+---------------+-------
  4. ocm57139030 | Bleach | Kubo, Tite. | 2004 | book | 62
  5. ocn244172853 | Amulet | Kibuishi, Kazu 1978- | 2008 | book | 47
  6. ocn809933191 | Attack on Titan | Isayama, Hajime 1986- | 2012 | book | 46
  7. ocn847868072 | Zoo Atlanta : wild explorer : history of Zoo Atlanta | | 2013 | dvd-0 | 45
  8. ocn768193195 | [Georgia state parks and historic sites ParkPass] | | 2008 | statepass | 30
  9. ocn886996833 | Acer chromebook. | | 2013 | e-device | 28
  10. ocm55999262 | Naruto | Kishimoto, Masashi 1974- | 2003 | book | 27
  11. ocn957506501 | Dog Man unleashed | Pilkey, Dav 1966- | 2017 | book | 21
  12. on1016305674 | Where the crawdads sing | Owens, Delia | 2018 | book | 21
  13. on1060706560 | The wedding guest : an Alex Delaware novel | Kellerman, Jonathan | 2019 | book | 21
  14. ocm18876819 | And to think that I saw it on Mulberry Street | Seuss Dr | 1989 | book | 20
  15. on1039905624 | The reckoning | Grisham, John | 2018 | book | 20
  16. on1015343802 | Dog Man and Cat Kid | Pilkey, Dav 1966- | 2018 | book | 20
  17. on1043044677 | Nine perfect strangers | Moriarty, Liane | 2018 | book | 20
  18. ocn505869795 | Black butler | Toboso, Yana 1984- | 2010 | book | 20
  19. ocn919319539 | One-Punch Man | ONE 1986- | 2012 | book | 19
  20. on1020450924 | Dark sacred night | Connelly, Michael 1956- | 2018 | book | 19
  21. ocm04004766 | I can read with my eyes shut | Seuss Dr | 1978 | book | 19
  22. on1037885662 | Past tense : a Jack Reacher novel | Child, Lee | 2018 | book | 19
  23. ocn917905307 | My hero academia | Horikoshi, Kōhei 1986- | 2015 | book | 19
  24. (20 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement