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;
  tcn_value   |                        title                         |          author          | pubdate | circ_modifier | count
--------------+------------------------------------------------------+--------------------------+---------+---------------+-------
 ocm57139030  | Bleach                                               | Kubo, Tite.              | 2004    | book          |    62
 ocn244172853 | Amulet                                               | Kibuishi, Kazu 1978-     | 2008    | book          |    47
 ocn809933191 | Attack on Titan                                      | Isayama, Hajime 1986-    | 2012    | book          |    46
 ocn847868072 | Zoo Atlanta : wild explorer : history of Zoo Atlanta |                          | 2013    | dvd-0         |    45
 ocn768193195 | [Georgia state parks and historic sites ParkPass]    |                          | 2008    | statepass     |    30
 ocn886996833 | Acer chromebook.                                     |                          | 2013    | e-device      |    28
 ocm55999262  | Naruto                                               | Kishimoto, Masashi 1974- | 2003    | book          |    27
 ocn957506501 | Dog Man unleashed                                    | Pilkey, Dav 1966-        | 2017    | book          |    21
 on1016305674 | Where the crawdads sing                              | Owens, Delia             | 2018    | book          |    21
 on1060706560 | The wedding guest : an Alex Delaware novel           | Kellerman, Jonathan      | 2019    | book          |    21
 ocm18876819  | And to think that I saw it on Mulberry Street        | Seuss Dr                 | 1989    | book          |    20
 on1039905624 | The reckoning                                        | Grisham, John            | 2018    | book          |    20
 on1015343802 | Dog Man and Cat Kid                                  | Pilkey, Dav 1966-        | 2018    | book          |    20
 on1043044677 | Nine perfect strangers                               | Moriarty, Liane          | 2018    | book          |    20
 ocn505869795 | Black butler                                         | Toboso, Yana 1984-       | 2010    | book          |    20
 ocn919319539 | One-Punch Man                                        | ONE 1986-                | 2012    | book          |    19
 on1020450924 | Dark sacred night                                    | Connelly, Michael 1956-  | 2018    | book          |    19
 ocm04004766  | I can read with my eyes shut                         | Seuss Dr                 | 1978    | book          |    19
 on1037885662 | Past tense : a Jack Reacher novel                    | Child, Lee               | 2018    | book          |    19
 ocn917905307 | My hero academia                                     | Horikoshi, Kōhei 1986-   | 2015    | book          |    19
(20 rows)