SELECT * FROM (SELECT	"640e9f1ba83104cf4de312413f51b877"."id" AS "Record ID",
	"cab191964860c9a54637c6cd1832c6fa"."barcode" AS "Barcode",
	"bdd43e1440a00047b1e66cb9619865c0"."name" AS "Owning Library",
	"a8320a2dc02e11185f45deb71183cdbc"."name" AS "Shelving Location",
	"70739dc8d7946c9ed789eb60d6175fb1"."value" AS "Subject"
  FROM	asset.copy AS "ed55d72666ad50c3c4b9652f5627aba0"
	LEFT OUTER JOIN asset.call_number AS "286d7899ae25bee8bdd7dcde49f9e0b7" ON ("ed55d72666ad50c3c4b9652f5627aba0"."call_number" = "286d7899ae25bee8bdd7dcde49f9e0b7"."id")
	LEFT OUTER JOIN asset.copy AS "cab191964860c9a54637c6cd1832c6fa" ON ("286d7899ae25bee8bdd7dcde49f9e0b7"."id" = "cab191964860c9a54637c6cd1832c6fa"."call_number")
	LEFT OUTER JOIN config.circ_modifier AS "89628fb07ed77fa519e3db3e3f3609a5" ON ("cab191964860c9a54637c6cd1832c6fa"."circ_modifier" = "89628fb07ed77fa519e3db3e3f3609a5"."code")
	LEFT OUTER JOIN asset.copy_location AS "a8320a2dc02e11185f45deb71183cdbc" ON ("cab191964860c9a54637c6cd1832c6fa"."location" = "a8320a2dc02e11185f45deb71183cdbc"."id")
	LEFT OUTER JOIN biblio.record_entry AS "640e9f1ba83104cf4de312413f51b877" ON ("286d7899ae25bee8bdd7dcde49f9e0b7"."record" = "640e9f1ba83104cf4de312413f51b877"."id")
	LEFT OUTER JOIN metabib.subject_field_entry AS "70739dc8d7946c9ed789eb60d6175fb1" ON ("640e9f1ba83104cf4de312413f51b877"."id" = "70739dc8d7946c9ed789eb60d6175fb1"."source")
	INNER JOIN actor.org_unit AS "bdd43e1440a00047b1e66cb9619865c0" ON ("286d7899ae25bee8bdd7dcde49f9e0b7"."owning_lib" = "bdd43e1440a00047b1e66cb9619865c0"."id")
  WHERE	(("bdd43e1440a00047b1e66cb9619865c0"."id") IS NULL OR "bdd43e1440a00047b1e66cb9619865c0"."id" IN ($_42913$150$_42913$))
	AND (("286d7899ae25bee8bdd7dcde49f9e0b7"."deleted") IS NULL OR "286d7899ae25bee8bdd7dcde49f9e0b7"."deleted" = $_42913$f$_42913$)
	AND (("cab191964860c9a54637c6cd1832c6fa"."deleted") IS NULL OR "cab191964860c9a54637c6cd1832c6fa"."deleted" = $_42913$f$_42913$)
	AND (("70739dc8d7946c9ed789eb60d6175fb1"."value") IS NULL OR "70739dc8d7946c9ed789eb60d6175fb1"."value" ILIKE $_42913$%western%$_42913$)
	AND (("89628fb07ed77fa519e3db3e3f3609a5"."code") IS NULL OR "89628fb07ed77fa519e3db3e3f3609a5"."code" IN ($_42913$DVD$_42913$,$_42913$Movie$_42913$,$_42913$Videos$_42913$))
  GROUP BY 1, 2, 3, 4, 5
  ORDER BY "640e9f1ba83104cf4de312413f51b877"."id" ASC, "cab191964860c9a54637c6cd1832c6fa"."barcode" ASC, "bdd43e1440a00047b1e66cb9619865c0"."name" ASC, "a8320a2dc02e11185f45deb71183cdbc"."name" ASC, "70739dc8d7946c9ed789eb60d6175fb1"."value" ASC
) limited_to_1048575_hits LIMIT 1048575