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 group by 1, 2, 3, 4, 5 order by 6 desc limit 20;

  tcn_value   |                        title                         |              author              | pubdate | circ_modifier | count
--------------+------------------------------------------------------+----------------------------------+---------+---------------+-------
 PIN71097469  | Internet Station.                                    |                                  |         | book-ff       |  1346
 ocn768193195 | [Georgia state parks and historic sites ParkPass]    |                                  | 2008    | statepass     |   656
 ocn847868072 | Zoo Atlanta : wild explorer : history of Zoo Atlanta |                                  | 2013    | dvd-0         |   638
 on1039905624 | The reckoning                                        | Grisham, John                    | 2018    | book          |   497
 on1037885662 | Past tense : a Jack Reacher novel                    | Child, Lee                       | 2018    | book          |   466
 on1032356732 | A delicate touch                                     | Woods, Stuart                    | 2018    | book          |   437
 on1028521687 | Long road to mercy                                   | Baldacci, David                  | 2018    | book          |   427
 on1054005696 | Liar Liar                                            | Patterson, James 1947-           | 2019    | book          |   401
 on1031916546 | Turning point : a novel                              | Steel, Danielle                  | 2019    | book          |   386
 on1020450924 | Dark sacred night                                    | Connelly, Michael 1956-          | 2018    | book          |   384
 on1049577570 | Look alive twenty-five : a Stephanie Plum novel      | Evanovich, Janet                 | 2018    | book          |   368
 on1054093119 | Ambush                                               | Patterson, James 1947-           | 2018    | book          |   361
 on1051779599 | Diary of a wimpy kid : the meltdown                  | Kinney, Jeff                     | 2018    | book          |   344
 on1030446221 | Every breath                                         | Sparks, Nicholas                 | 2018    | book          |   340
 on1043045282 | Target Alex Cross                                    | Patterson, James 1947-           | 2018    | book          |   338
 on1048049711 | The New Iberia blues : a Dave Robicheaux novel       | Burke, James Lee 1936-           | 2019    | book          |   328
 on1036105450 | Connections in death                                 | Robb, J. D. 1950-                | 2019    | book          |   328
 ocn957281994 | Dog Man                                              | Pilkey, Dav 1966-                | 2016    | book          |   326
 on1030415866 | Holy ghost                                           | Sandford, John 1944 February 23- | 2018    | book          |   314
 on1043479424 | The boy : a novel                                    | Hoag, Tami                       | 2018    | book          |   313
(20 rows)