Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM (SELECT "413df8472eb3495de6137209d94c2539"."name" AS "Pickup Library",
- COUNT(DISTINCT "3b0d7d05c65006de7b2ca20f5fe39690"."id") AS "# of Holds Placed"
- FROM action.hold_request AS "3b0d7d05c65006de7b2ca20f5fe39690"
- INNER JOIN actor.usr AS "ec37b94ce77dcc7440f642f250a33297" ON ("3b0d7d05c65006de7b2ca20f5fe39690"."requestor" = "ec37b94ce77dcc7440f642f250a33297"."id")
- INNER JOIN permission.grp_tree AS "58c30ed48f89c2e0232304d60acec4c0" ON ("ec37b94ce77dcc7440f642f250a33297"."profile" = "58c30ed48f89c2e0232304d60acec4c0"."id")
- INNER JOIN actor.org_unit AS "413df8472eb3495de6137209d94c2539" ON ("3b0d7d05c65006de7b2ca20f5fe39690"."pickup_lib" = "413df8472eb3495de6137209d94c2539"."id")
- WHERE "58c30ed48f89c2e0232304d60acec4c0"."id" IN ($_32663$32$_32663$,$_32663$39$_32663$,$_32663$40$_32663$,$_32663$74$_32663$,$_32663$3$_32663$,$_32663$61$_32663$,$_32663$54$_32663$,$_32663$60$_32663$,$_32663$69$_32663$)
- AND date("3b0d7d05c65006de7b2ca20f5fe39690"."request_time") BETWEEN $_32663$2019-11-18$_32663$ AND $_32663$2019-11-20$_32663$
- GROUP BY 1
- ORDER BY "413df8472eb3495de6137209d94c2539"."name" ASC, COUNT(DISTINCT "3b0d7d05c65006de7b2ca20f5fe39690"."id") ASC
- ) limited_to_1048576_hits LIMIT 1048576
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement