Advertisement
Guest User

Untitled

a guest
Nov 20th, 2019
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. SELECT * FROM (SELECT "413df8472eb3495de6137209d94c2539"."name" AS "Pickup Library",
  2. COUNT(DISTINCT "3b0d7d05c65006de7b2ca20f5fe39690"."id") AS "# of Holds Placed"
  3. FROM action.hold_request AS "3b0d7d05c65006de7b2ca20f5fe39690"
  4. INNER JOIN actor.usr AS "ec37b94ce77dcc7440f642f250a33297" ON ("3b0d7d05c65006de7b2ca20f5fe39690"."requestor" = "ec37b94ce77dcc7440f642f250a33297"."id")
  5. INNER JOIN permission.grp_tree AS "58c30ed48f89c2e0232304d60acec4c0" ON ("ec37b94ce77dcc7440f642f250a33297"."profile" = "58c30ed48f89c2e0232304d60acec4c0"."id")
  6. INNER JOIN actor.org_unit AS "413df8472eb3495de6137209d94c2539" ON ("3b0d7d05c65006de7b2ca20f5fe39690"."pickup_lib" = "413df8472eb3495de6137209d94c2539"."id")
  7. 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$)
  8. AND date("3b0d7d05c65006de7b2ca20f5fe39690"."request_time") BETWEEN $_32663$2019-11-18$_32663$ AND $_32663$2019-11-20$_32663$
  9. GROUP BY 1
  10. ORDER BY "413df8472eb3495de6137209d94c2539"."name" ASC, COUNT(DISTINCT "3b0d7d05c65006de7b2ca20f5fe39690"."id") ASC
  11. ) limited_to_1048576_hits LIMIT 1048576
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement