bookbag query #2

SELECT "ccs".id AS "status_code",
oils_i18n_xlate('config.copy_status', 'ccs', 'name', 'id', "ccs".id::TEXT, 'en-US') AS "copy_status",
"ccs".holdable AS "status_holdable",
"acn".label AS "call_number_label",
"acn".id AS "call_number",
"acn".owning_lib AS "call_number_owning_lib",
"acns".label AS "call_number_suffix_label",
"acns".id AS "call_number_suffix",
"bmp".label AS "part_label",
oils_i18n_xlate('asset.copy_location', 'acpl', 'name', 'id', "acpl".id::TEXT, 'en-US') AS "copy_location",
"acpl".holdable AS "location_holdable",
"acnp".label AS "call_number_prefix_label",
"acnp".id AS "call_number_prefix",
"circ".due_date AS "due_date",
"acp".id AS "id",
"acp".barcode AS "barcode",
"acp".circ_lib AS "circ_lib",
"acp".create_date AS "create_date",
"acp".active_date AS "active_date",
"acp".age_protect AS "age_protect",
"acp".holdable AS "holdable",
"acp".copy_number AS "copy_number"
FROM ( asset.copy AS "acp"
INNER JOIN asset.call_number AS "acn" ON ( "acn".id = "acp".call_number AND ( "acn".deleted = 'f' ) AND ( "acn".record = '109974144' ) ) )
INNER JOIN asset.copy_location AS "acpl" ON ( "acpl".id = "acp".location AND "acpl".opac_visible = 't' AND "acpl".deleted = 'f' )
INNER JOIN config.copy_status AS "ccs" ON ( "ccs".id = "acp".STATUS AND "ccs".opac_visible = 't' )
LEFT JOIN asset.copy_part_map AS "acpm" ON ( "acpm".target_copy = "acp".id )
LEFT JOIN biblio.monograph_part AS "bmp" ON ( "bmp".id = "acpm".part )
INNER JOIN actor.org_unit AS "aou" ON ( "aou".id = "acp".circ_lib AND "aou".id IN (SELECT (actor.org_unit_descendants("aou".id,'0' ))."id" AS "id" FROM actor.org_unit AS "aou" WHERE "aou".id = 487) )
LEFT JOIN action.circulation AS "circ" ON ( "circ".target_copy = "acp".id AND "circ".checkin_time IS NULL )
INNER JOIN asset.call_number_suffix AS "acns" ON ( "acns".id = "acn".suffix )
INNER JOIN asset.call_number_prefix AS "acnp" ON ( "acnp".id = "acn".prefix )
WHERE ( "acp".opac_visible = 't' AND "acp".deleted = 'f' )
AND ( "aou".opac_visible = 't' )
ORDER BY evergreen.rank_ou("aou".id,'487','487' ), "aou".name, "acn".label_sortkey, "acp".copy_number, "acp".barcode, evergreen.rank_cp_status("acp".STATUS )
LIMIT 6 OFFSET 0;