Untitled

COLUMN Labels:
---------------
    FSCSKEY
    FSCS_SEQ
    Short (Policy) Name
    LAST Edit DATE/TIME
    Barcode
    Price
    Title Proper (normalized)
    Author (normalized)

SQL:
--------
SELECT  "899a715294bed0760ee23dfa08b4442c"."fscskey" AS "FSCSKEY",
    "899a715294bed0760ee23dfa08b4442c"."fscs_seq" AS "FSCS_SEQ",
    "899a715294bed0760ee23dfa08b4442c"."shortname" AS "Short (Policy) Name",
    DATE("7d74f3b92b19da5e606d737d339a9679"."edit_date") AS "Last Edit Date/Time",
    "7d74f3b92b19da5e606d737d339a9679"."barcode" AS "Barcode",
    "7d74f3b92b19da5e606d737d339a9679"."price" AS "Price",
    "08a109c5e84e28de69676ce8f4f8a6cb"."title" AS "Title Proper (normalized)",
    "08a109c5e84e28de69676ce8f4f8a6cb"."author" AS "Author (normalized)"
  FROM  asset.copy AS "7d74f3b92b19da5e606d737d339a9679"
    INNER JOIN asset.call_number AS "ed55d72666ad50c3c4b9652f5627aba0" ON ("7d74f3b92b19da5e606d737d339a9679"."call_number" = "ed55d72666ad50c3c4b9652f5627aba0"."id")
    INNER JOIN biblio.record_entry AS "1735d2b1c8f8641d9a68f4b357ee65d1" ON ("ed55d72666ad50c3c4b9652f5627aba0"."record" = "1735d2b1c8f8641d9a68f4b357ee65d1"."id")
    LEFT OUTER JOIN reporter.materialized_simple_record AS "08a109c5e84e28de69676ce8f4f8a6cb" ON ("1735d2b1c8f8641d9a68f4b357ee65d1"."id" = "08a109c5e84e28de69676ce8f4f8a6cb"."id")
    INNER JOIN actor.org_unit AS "899a715294bed0760ee23dfa08b4442c" ON ("ed55d72666ad50c3c4b9652f5627aba0"."owning_lib" = "899a715294bed0760ee23dfa08b4442c"."id")
  WHERE "899a715294bed0760ee23dfa08b4442c"."id" IN ($_97469$1$_97469$,$_97469$6$_97469$,$_97469$18$_97469$,$_97469$7$_97469$,$_97469$9$_97469$,$_97469$11$_97469$,$_97469$13$_97469$,$_97469$19$_97469$,$_97469$10$_97469$,$_97469$20$_97469$,$_97469$14$_97469$,$_97469$8$_97469$,$_97469$12$_97469$,$_97469$17$_97469$,$_97469$16$_97469$,$_97469$15$_97469$,$_97469$275$_97469$,$_97469$278$_97469$,$_97469$276$_97469$,$_97469$408$_97469$,$_97469$282$_97469$,$_97469$279$_97469$,$_97469$280$_97469$,$_97469$281$_97469$,$_97469$46$_97469$,$_97469$366$_97469$,$_97469$47$_97469$,$_97469$48$_97469$,$_97469$49$_97469$,$_97469$51$_97469$,$_97469$50$_97469$,$_97469$52$_97469$,$_97469$53$_97469$,$_97469$54$_97469$,$_97469$357$_97469$,$_97469$221$_97469$,$_97469$225$_97469$,$_97469$222$_97469$,$_97469$224$_97469$,$_97469$223$_97469$,$_97469$211$_97469$,$_97469$212$_97469$,$_97469$344$_97469$,$_97469$345$_97469$,$_97469$216$_97469$,$_97469$219$_97469$,$_97469$220$_97469$,$_97469$217$_97469$,$_97469$218$_97469$,$_97469$213$_97469$,$_97469$361$_97469$,$_97469$215$_97469$,$_97469$214$_97469$,$_97469$124$_97469$,$_97469$126$_97469$,$_97469$125$_97469$,$_97469$127$_97469$,$_97469$128$_97469$,$_97469$129$_97469$,$_97469$405$_97469$,$_97469$130$_97469$,$_97469$267$_97469$,$_97469$269$_97469$,$_97469$272$_97469$,$_97469$270$_97469$,$_97469$32$_97469$,$_97469$271$_97469$,$_97469$273$_97469$,$_97469$268$_97469$,$_97469$122$_97469$,$_97469$123$_97469$,$_97469$260$_97469$,$_97469$265$_97469$,$_97469$263$_97469$,$_97469$261$_97469$,$_97469$264$_97469$,$_97469$318$_97469$,$_97469$266$_97469$,$_97469$33$_97469$,$_97469$34$_97469$,$_97469$35$_97469$,$_97469$38$_97469$,$_97469$36$_97469$,$_97469$37$_97469$,$_97469$21$_97469$,$_97469$23$_97469$,$_97469$24$_97469$,$_97469$22$_97469$,$_97469$106$_97469$,$_97469$109$_97469$,$_97469$111$_97469$,$_97469$107$_97469$,$_97469$113$_97469$,$_97469$108$_97469$,$_97469$369$_97469$,$_97469$110$_97469$,$_97469$112$_97469$,$_97469$114$_97469$,$_97469$65$_97469$,$_97469$67$_97469$,$_97469$66$_97469$,$_97469$394$_97469$,$_97469$373$_97469$,$_97469$365$_97469$,$_97469$284$_97469$,$_97469$287$_97469$,$_97469$289$_97469$,$_97469$288$_97469$,$_97469$291$_97469$,$_97469$285$_97469$,$_97469$286$_97469$,$_97469$290$_97469$,$_97469$156$_97469$,$_97469$157$_97469$,$_97469$160$_97469$,$_97469$161$_97469$,$_97469$351$_97469$,$_97469$162$_97469$,$_97469$158$_97469$,$_97469$159$_97469$,$_97469$182$_97469$,$_97469$183$_97469$,$_97469$140$_97469$,$_97469$143$_97469$,$_97469$300$_97469$,$_97469$144$_97469$,$_97469$367$_97469$,$_97469$141$_97469$,$_97469$142$_97469$,$_97469$152$_97469$,$_97469$155$_97469$,$_97469$154$_97469$,$_97469$153$_97469$,$_97469$226$_97469$,$_97469$230$_97469$,$_97469$227$_97469$,$_97469$228$_97469$,$_97469$229$_97469$,$_97469$252$_97469$,$_97469$253$_97469$,$_97469$254$_97469$,$_97469$255$_97469$,$_97469$259$_97469$,$_97469$343$_97469$,$_97469$256$_97469$,$_97469$257$_97469$,$_97469$258$_97469$,$_97469$328$_97469$,$_97469$331$_97469$,$_97469$330$_97469$,$_97469$333$_97469$,$_97469$335$_97469$,$_97469$329$_97469$,$_97469$336$_97469$,$_97469$337$_97469$,$_97469$115$_97469$,$_97469$117$_97469$,$_97469$360$_97469$,$_97469$118$_97469$,$_97469$116$_97469$,$_97469$376$_97469$,$_97469$377$_97469$,$_97469$378$_97469$,$_97469$379$_97469$,$_97469$380$_97469$,$_97469$381$_97469$,$_97469$382$_97469$,$_97469$383$_97469$,$_97469$384$_97469$,$_97469$393$_97469$,$_97469$385$_97469$,$_97469$386$_97469$,$_97469$387$_97469$,$_97469$388$_97469$,$_97469$389$_97469$,$_97469$390$_97469$,$_97469$391$_97469$,$_97469$392$_97469$,$_97469$395$_97469$,$_97469$396$_97469$,$_97469$397$_97469$,$_97469$398$_97469$,$_97469$399$_97469$,$_97469$362$_97469$,$_97469$74$_97469$,$_97469$403$_97469$,$_97469$70$_97469$,$_97469$233$_97469$,$_97469$374$_97469$,$_97469$237$_97469$,$_97469$239$_97469$,$_97469$246$_97469$,$_97469$248$_97469$,$_97469$247$_97469$,$_97469$401$_97469$,$_97469$241$_97469$,$_97469$240$_97469$,$_97469$57$_97469$,$_97469$250$_97469$,$_97469$243$_97469$,$_97469$56$_97469$,$_97469$244$_97469$,$_97469$242$_97469$,$_97469$251$_97469$,$_97469$236$_97469$,$_97469$235$_97469$,$_97469$245$_97469$,$_97469$234$_97469$,$_97469$249$_97469$,$_97469$238$_97469$,$_97469$2$_97469$,$_97469$4$_97469$,$_97469$5$_97469$,$_97469$3$_97469$,$_97469$96$_97469$,$_97469$99$_97469$,$_97469$97$_97469$,$_97469$100$_97469$,$_97469$101$_97469$,$_97469$98$_97469$,$_97469$231$_97469$,$_97469$232$_97469$,$_97469$340$_97469$,$_97469$342$_97469$,$_97469$145$_97469$,$_97469$146$_97469$,$_97469$147$_97469$,$_97469$150$_97469$,$_97469$350$_97469$,$_97469$151$_97469$,$_97469$148$_97469$,$_97469$149$_97469$,$_97469$353$_97469$,$_97469$354$_97469$,$_97469$356$_97469$,$_97469$355$_97469$,$_97469$292$_97469$,$_97469$295$_97469$,$_97469$293$_97469$,$_97469$297$_97469$,$_97469$294$_97469$,$_97469$298$_97469$,$_97469$296$_97469$,$_97469$299$_97469$,$_97469$197$_97469$,$_97469$198$_97469$,$_97469$199$_97469$,$_97469$200$_97469$,$_97469$201$_97469$,$_97469$202$_97469$,$_97469$203$_97469$,$_97469$208$_97469$,$_97469$136$_97469$,$_97469$210$_97469$,$_97469$205$_97469$,$_97469$206$_97469$,$_97469$207$_97469$,$_97469$204$_97469$,$_97469$209$_97469$,$_97469$58$_97469$,$_97469$60$_97469$,$_97469$62$_97469$,$_97469$59$_97469$,$_97469$61$_97469$,$_97469$63$_97469$,$_97469$64$_97469$,$_97469$102$_97469$,$_97469$104$_97469$,$_97469$103$_97469$,$_97469$105$_97469$,$_97469$184$_97469$,$_97469$188$_97469$,$_97469$190$_97469$,$_97469$407$_97469$,$_97469$196$_97469$,$_97469$189$_97469$,$_97469$193$_97469$,$_97469$191$_97469$,$_97469$192$_97469$,$_97469$371$_97469$,$_97469$194$_97469$,$_97469$186$_97469$,$_97469$187$_97469$,$_97469$195$_97469$,$_97469$185$_97469$,$_97469$87$_97469$,$_97469$88$_97469$,$_97469$94$_97469$,$_97469$90$_97469$,$_97469$89$_97469$,$_97469$91$_97469$,$_97469$92$_97469$,$_97469$93$_97469$,$_97469$95$_97469$,$_97469$85$_97469$,$_97469$86$_97469$,$_97469$25$_97469$,$_97469$27$_97469$,$_97469$29$_97469$,$_97469$121$_97469$,$_97469$28$_97469$,$_97469$26$_97469$,$_97469$120$_97469$,$_97469$30$_97469$,$_97469$131$_97469$,$_97469$132$_97469$,$_97469$134$_97469$,$_97469$135$_97469$,$_97469$137$_97469$,$_97469$138$_97469$,$_97469$139$_97469$,$_97469$133$_97469$,$_97469$80$_97469$,$_97469$82$_97469$,$_97469$83$_97469$,$_97469$81$_97469$,$_97469$84$_97469$,$_97469$301$_97469$,$_97469$306$_97469$,$_97469$307$_97469$,$_97469$304$_97469$,$_97469$308$_97469$,$_97469$305$_97469$,$_97469$404$_97469$,$_97469$303$_97469$,$_97469$310$_97469$,$_97469$309$_97469$,$_97469$177$_97469$,$_97469$178$_97469$,$_97469$181$_97469$,$_97469$180$_97469$,$_97469$179$_97469$,$_97469$39$_97469$,$_97469$42$_97469$,$_97469$43$_97469$,$_97469$45$_97469$,$_97469$44$_97469$,$_97469$40$_97469$,$_97469$41$_97469$,$_97469$311$_97469$,$_97469$313$_97469$,$_97469$314$_97469$,$_97469$316$_97469$,$_97469$315$_97469$,$_97469$317$_97469$,$_97469$312$_97469$,$_97469$68$_97469$,$_97469$71$_97469$,$_97469$72$_97469$,$_97469$73$_97469$,$_97469$79$_97469$,$_97469$69$_97469$,$_97469$75$_97469$,$_97469$76$_97469$,$_97469$77$_97469$,$_97469$78$_97469$,$_97469$402$_97469$,$_97469$321$_97469$,$_97469$323$_97469$,$_97469$322$_97469$,$_97469$326$_97469$,$_97469$324$_97469$,$_97469$163$_97469$,$_97469$166$_97469$,$_97469$167$_97469$,$_97469$176$_97469$,$_97469$375$_97469$,$_97469$352$_97469$,$_97469$173$_97469$,$_97469$358$_97469$,$_97469$168$_97469$,$_97469$349$_97469$,$_97469$169$_97469$,$_97469$170$_97469$,$_97469$171$_97469$,$_97469$320$_97469$,$_97469$164$_97469$,$_97469$172$_97469$,$_97469$372$_97469$,$_97469$174$_97469$,$_97469$175$_97469$,$_97469$165$_97469$,$_97469$319$_97469$,$_97469$346$_97469$,$_97469$262$_97469$,$_97469$119$_97469$,$_97469$31$_97469$,$_97469$55$_97469$,$_97469$347$_97469$)
    AND "7d74f3b92b19da5e606d737d339a9679"."deleted" = $_97469$t$_97469$
    AND DATE("7d74f3b92b19da5e606d737d339a9679"."edit_date") BETWEEN SYMMETRIC $_97469$2021-07-01$_97469$ AND $_97469$2022-06-30$_97469$
  GROUP BY 1, 2, 3, 4, 5, 6, 7, 8
  ORDER BY "899a715294bed0760ee23dfa08b4442c"."fscskey" ASC, "899a715294bed0760ee23dfa08b4442c"."fscs_seq" ASC, "899a715294bed0760ee23dfa08b4442c"."shortname" ASC, DATE("7d74f3b92b19da5e606d737d339a9679"."edit_date") ASC, "7d74f3b92b19da5e606d737d339a9679"."barcode" ASC, "7d74f3b92b19da5e606d737d339a9679"."price" ASC, "08a109c5e84e28de69676ce8f4f8a6cb"."title" ASC, "08a109c5e84e28de69676ce8f4f8a6cb"."author" ASC
--------

SQL GROUP BY list: 1,2,3,4,5,6,7,8
Perl GROUP BY list: 0,1,2,3,4,5,6,7