https://intranet.bywatersolutions.com/cgi-bin/koha/reports/guided_reports.pl?reports=1&phase=Export&format=csv&sql=select%0D%0A%0D%0A%20%20%20%20%20%20%20%20concat(b.title%2C%20%27%20%27%2C%20%20ExtractValue(bi.marcxml%2C%20%27%2F%2Fdatafield%5B%40tag%3D%22245%22%5D%2Fsubfield%5B%40code%3D%22b%22%5D%27))%20AS%20%27title%27%2C%0D%0A%0D%0A%20%20%20%20ExtractValue(bi.marcxml%2C%20%27%2F%2Fdatafield%5B%40tag%3D%22100%22%5D%2Fsubfield%5B%40code%3D%22a%22%5D%27)%20AS%20%27author%27%20%2C%0D%0A%0D%0A%20%20%20%20b.copyrightdate%2C%0D%0A%0D%0A%20%20%20%20SUBSTR(ExtractValue(bi.marcxml%2C%27%2F%2Fcontrolfield%5B%40tag%3D%22008%22%5D%27)%2C8%2C4)%20as%20%27pub%20year%27%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20i.barcode%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20i.itemnumber%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20i.location%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20i.itype%2C%0D%0A%0D%0A%20%20%20%20%20%20%20i.copynumber%20AS%20%27Copy%20Number%27%2C%0D%0A%0D%0A%20%20%20%20i.dateaccessioned%20as%20%22Date%20Accessioned%22%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20i.datelastseen%20AS%20%22Date%20Last%20Seen%22%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20i.datelastborrowed%20as%20%22Date%20Last%20Borrowed%22%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20i.itemcallnumber%20AS%20%22Callnumber%22%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20i.cn_sort%20AS%20%22Call%20Number%20Sort%22%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20i.itemlost%20AS%20%22Item%20Lost%20Status%22%2C%0D%0A%0D%0A%20%20%20%20i.issues%20as%20%22Checkouts%22%2C%0D%0A%0D%0A%20SUM(IF(s.type%20%3D%20%27localuse%27%2C%201%2C%200))%20AS%20%27Local%20Uses%27%2C%0D%0A%0D%0A%20%0D%0A%0D%0A%20%20%20%20s.datetime%20AS%20%27Last%20Local%20Use%27%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20ExtractValue(bi.marcxml%2C%20%27%2F%2Fdatafield%5B%40tag%3D%22561%22%5D%2Fsubfield%5B%40code%3D%22a%22%5D%27)%20as%20%27Named%20Collection%27%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20ExtractValue(bi.marcxml%2C%20%27%2F%2Fdatafield%5B%40tag%3D%22250%22%5D%2Fsubfield%5B%40code%3D%22a%22%5D%27)%20as%20%27Edition%20Info%27%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20ExtractValue(bi.marcxml%2C%20%27%2F%2Fdatafield%5B%40tag%3D%22590%22%5D%2Fsubfield%5B%40code%3D%22a%22%5D%27)%20as%20%27localnote%27%2C%0D%0A%0D%0A%20%20i.itemnotes%2C%0D%0A%0D%0A%20%20i.itemnotes_nonpublic%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20ExtractValue(bi.marcxml%2C%20%27%2F%2Fdatafield%5B%40tag%3D%22035%22%5D%2Fsubfield%5B%40code%3D%22a%22%5D%27)%20as%20%27oclc_num%2035a%27%2C%0D%0A%0D%0A%20%20%20%20%20%20%20%20ExtractValue(bi.marcxml%2C%20%27%2F%2Fcontrolfield%5B%40tag%3D%22001%22%5D%27)%20as%20%27field001%27%0D%0A%0D%0Afrom%20authorised_values%20v%0D%0A%0D%0A%20%0D%0A%0D%0Aleft%20join%20items%20i%20%20ON%20(i.location%3Dv.authorised_value)%0D%0A%0D%0ALEFT%20JOIN%20biblioitems%20bi%20USING%20(biblionumber)%0D%0A%0D%0ALEFT%20JOIN%20biblio%20b%20ON%20(b.biblionumber%20%3D%20i.biblionumber)%0D%0A%0D%0ALEFT%20JOIN%20itemtypes%20ON%20(i.itype%3Ditemtypes.itemtype)%0D%0A%0D%0ALEFT%20JOIN%20(SELECT%20*%20FROM%20statistics%20%20WHERE%20type%20%3D%20%27localuse%27)%20s%20using%20(itemnumber)%0D%0A%0D%0AWHERE%20i.barcode%20IN%20(%0D%0A%0D%0A32467000528417%2C%2032467001392300%2C%2032467001392318%2C%2032467000526890%2C%2032467001374027%2C%2032467001374035%2C%2032467001374043%2C%2032467001178808%2C%2032467001030256%2C%2032467001015869%2C%2032467000875552%2C%2032467001218984%2C%2032467000671415%2C%2032467000597305%2C%2032467001015851%2C%2032467001015810%2C%2032467000586514%2C%2032467000298201%2C%2032467000538952%2C%2032467000466774%2C%2032467000713043%2C%2032467000191539%2C%2032467000982994%2C%2032467000611437%2C%2032467000608029%2C%2032467000748437%2C%2032467000712318%2C%2032467000509052%2C%2032467000704687%2C%2032467000647811%2C%2032467000532146%2C%2032467000758246%2C%2032467000684145%2C%2032467000362593%2C%2032467001883571%2C%2032467000290950%2C%2032467002315557%2C%2032467001165243%2C%2032467001175028%2C%2032467000266125%2C%2032467000607088%2C%2032467002375007%2C%2032467001512790%2C%2032467001043283%2C%2032467000724644%2C%2032467001075665%2C%2032467000210925%2C%2032467000563711%2C%2032467000526502%2C%2032467001016198%2C%2032467002532789%2C%2032467000803927%2C%2032467000699762%2C%2032467002169319%2C%2032467000552391%2C%2032467000682107%2C%2032467000736143%2C%2032467000737224%2C%2032467000478431%2C%2032467001219206%2C%2032467000245111%2C%2032467000795214%2C%2032467000657711%2C%2032467000496763%2C%2032467000489909%2C%2032467000239700%2C%2032467000276900%2C%2032467000292329%2C%2032467000468325%2C%2032467000354434%2C%2032467000465586%2C%2032467000732514%2C%2032467000536519%2C%2032467001711384%2C%2032467001016164%2C%2032467001235350%2C%2032467001016016%2C%2032467001823858%2C%2032467001824146%2C%2032467000765803%2C%2032467000886260%2C%2032467000459860%2C%2032467000306236%2C%2032467000459886%2C%2032467001626913%2C%2032467001670481%2C%2032467001619470%2C%2032467001626921%2C%2032467000600893%2C%2032467001647570%2C%2032467001647588%2C%2032467001342156%2C%2032467001645228%2C%2032467001670002%2C%2032467000576929%2C%2032467001643629%2C%2032467001626939%2C%2032467000702772%2C%2032467000461437%2C%2032467001041071%2C%2032467001060345%2C%2032467000948755%2C%2032467001460495%2C%2032467000485048%2C%2032467000970346%2C%2032467000812464%2C%2032467000210016%2C%2032467000210172%2C%2032467000210339%2C%2032467000210495%2C%2032467000210008%2C%2032467001702151%2C%2032467001718579%2C%2032467000228430%2C%2032467000228422%2C%2032467000228448%2C%2032467000766900%2C%2032467001336554%2C%2032467001044091%2C%2032467001142002%2C%2032467000871320%2C%2032467000987894%2C%2032467000210156%2C%2032467000772965%2C%2032467000209992%2C%2032467001064933%2C%2032467001193054%2C%2032467000751738%2C%2032467001073702%2C%2032467001015828%2C%2032467000505092%2C%2032467000584493%2C%2032467000942915%2C%2032467000519168%2C%2032467000959406%2C%2032467001000606%2C%2032467002375106%2C%2032467000210115%2C%2032467000985526%2C%2032467001227647%2C%2032467001351694%2C%2032467001151722%2C%2032467001065468%2C%2032467001064941%2C%2032467000931314%2C%2032467000658081%2C%2032467001745424%2C%2032467001061665%2C%2032467000701485%2C%2032467000708092%2C%2032467000800915%2C%2032467000889280%2C%2032467001338766%2C%2032467000321607%2C%2032467000315468%2C%2032467001015844%2C%2032467000311343%2C%2032467000239544%2C%2032467000977200%2C%2032467000587835%2C%2032467001255077%2C%2032467001015836%2C%2032467000768419%2C%2032467000657646%2C%2032467000865769%2C%2032467000666969%2C%2032467001015943%2C%2032467000923741%2C%2032467000723299%2C%2032467002375031%2C%2032467002403437%2C%2032467001714222%2C%2032467002209420%2C%2032467000239619%2C%2032467001250722%2C%2032467000830318%2C%2032467000210438%2C%2032467001059578%2C%2032467000238132%2C%2032467000629595%2C%2032467000209968%2C%2032467001065443%2C%2032467001008955%2C%2032467000732282%2C%2032467000598436%2C%2032467000841463%2C%2032467001937294%2C%2032467002369893%2C%2032467001724627%2C%2032467002143991%2C%2032467001345548%2C%2032467001892184%2C%2032467000656036%2C%2032467001701872%2C%2032467001218240%2C%2032467001734931%2C%2032467000573405%2C%2032467000780547%2C%2032467001058968%2C%2032467001015448%2C%2032467001351843%2C%2032467000592975%2C%2032467001905721%2C%2032467000823248%2C%2032467001110843%2C%2032467001158594%2C%2032467002346230%2C%2032467002363631%2C%2032467000362619%2C%2032467000600810%2C%2032467001439770%2C%2032467001439788%2C%2032467000811870%2C%2032467001251225%2C%2032467001252322%2C%2032467001149452%2C%2032467000240492%2C%2032467000280621%2C%2032467002238379%2C%2032467000741036%2C%2032467000268212%2C%2032467000667942%2C%2032467000308497%2C%2032467000584600%2C%2032467002432238%2C%2032467001359713%2C%2032467000308430%2C%2032467000257611%2C%2032467000799968%2C%2032467001164030%2C%2032467000289390%2C%2032467000308471%2C%2032467001232134%2C%2032467000308489%2C%2032467001403768%2C%2032467002238056%2C%2032467000927395%2C%2032467000606643%2C%2032467000053416%2C%2032467000597685%2C%2032467000053390%2C%2032467000274244%2C%2032467000927536%2C%2032467000965882%2C%2032467001255739%2C%2032467000308448%2C%2032467000735640%2C%2032467000484447%2C%2032467000484447%2C%2032467001344723%2C%2032467000157837%2C%2032467000611114%2C%2032467000289655%2C%2032467000327224%2C%2032467000352545%2C%2032467001251860%2C%2032467000810716%2C%2032467000285315%2C%2032467001254682%2C%2032467000308505%2C%2032467000309347%2C%2032467000347909%2C%2032467000731722%2C%2032467000520273%2C%2032467000308513%2C%2032467000240138%2C%2032467000538218%2C%2032467000484041%2C%2032467001664963%2C%2032467001664971%2C%2032467000700453%2C%2032467001692584%2C%2032467000516594%2C%2032467000792120%2C%2032467001234874%2C%2032467000847106%2C%2032467000053440%2C%2032467000053465%2C%2032467002238403%2C%2032467000718331%2C%2032467001218844%2C%2032467000289770%2C%2032467001187783%2C%2032467000247257%2C%2032467000538861%2C%2032467000314453%2C%2032467000284813%2C%2032467001172991%2C%2032467001345530%2C%2032467002298001%2C%2032467002298019%2C%2032467001229635%2C%2032467001754632%2C%2032467001759052%2C%2032467002237967%2C%2032467000308646%2C%2032467001787624%2C%2032467000599806%2C%2032467000769300%2C%2032467000226640%2C%2032467000314438%2C%2032467000524747)%0D%0A%0D%0AGROUP%20BY%20i.itemnumber%0D%0A%0D%0AORDER%20BY%20i.cn_sort%2C%20s.datetime%20DESC&reportname=test