<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
<!--
@font-face
        {font-family:Calibri}
@font-face
        {font-family:Tahoma}
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif"}
span.EmailStyle17
        {font-family:"Arial","sans-serif";
        color:windowtext;
        font-weight:normal;
        font-style:normal}
span.BalloonTextChar
        {font-family:"Tahoma","sans-serif"}
.MsoChpDefault
        {font-family:"Calibri","sans-serif"}
@page WordSection1
        {margin:70.85pt 70.85pt 70.85pt 70.85pt}
-->
</style><style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1" vlink="purple" lang="FR-CH" link="blue">
<div style="direction: ltr; font-family: Tahoma; color: rgb(0, 0, 0); font-size: 13px;">
<div style="">I use biblio.copyrightdate in SQL<br>
<br>
This is a modifed Super Weeder from the blog.&nbsp; It's great in a downloadable Excel report!<br>
<br>
SELECT CONCAT( '&lt;a href=\&quot;/cgi-bin/koha/cataloguing/additem.pl?biblionumber=',biblio.biblionumber,&nbsp;
<br>
&nbsp; '\&quot;&gt;',items.barcode,'&lt;/a&gt;' ) AS 'Barcode',items.barcode,items.itemcallnumber,biblio.title,biblio.author,biblio.copyrightdate AS<br>
&nbsp; 'Copyright',items.dateaccessioned AS<br>
&nbsp; 'Accessioned',items.itype,items.issues,items.itemnumber,items.renewals,(IFNULL(items.issues,0)&#43;IFNULL(items.renewals,0)) AS
<br>
Total_Circ,items.datelastborrowed,items.itemlost,items.onloan,items.damaged,items.itemnotes,items.holdingbranch<br>
&nbsp; FROM items <br>
&nbsp; LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON<br>
&nbsp; (biblioitems.biblionumber=biblio.biblionumber) <br>
&nbsp; WHERE items.holdingbranch='FARMINGTON' <br>
ORDER BY items.itemcallnumber<br>
<br>
<br>
<br>
Use these parameters in the WHERE (in red) conneced with AND<br>
<br>
items.holdingbranch='FARMINGTON'&nbsp; <br>
items.itemcallnumber LIKE 'FAST %'&nbsp; <br>
items.itype='BOOK' <br>
items.ccode='ADULT'<br>
<br>
Hal&nbsp; Bright <br>
Farmington Libraies<br>
</div>
<div style="font-family: Times New Roman; color: rgb(0, 0, 0); font-size: 16px;">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF137242"><font color="#000000" face="Tahoma" size="2"><b>From:</b> koha-bounces@lists.katipo.co.nz [koha-bounces@lists.katipo.co.nz] on behalf of Peel Lisa [lisa.peel@ritz.edu]<br>
<b>Sent:</b> Thursday, June 02, 2011 9:45 AM<br>
<b>To:</b> 'koha@lists.katipo.co.nz'<br>
<b>Subject:</b> [Koha] Help with report - again!<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;">Hello</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;">&nbsp;</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">I need to create a list which will give me details of all the items at one library including the year of publication. Have tried adding publication year to the
 guided search but no data appears in the column.</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">&nbsp;</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">Apologies for making such a basic request but I have been asked for the report to be done urgently!</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">&nbsp;</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">Any help appreciated</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">&nbsp;</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">Regards</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">&nbsp;</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">Lisa</span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;;" lang="EN-GB">&nbsp;</span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><span style="font-size: 12pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;; color: black;"><img id="Picture_x0020_1" src="cid:image001.jpg@01CC213B.21A96B40" alt="Description: Description: Description: CR_logo_POS_COULEUR b" width="227" height="51"></span><b><span style="color: black;" lang="EN-US"></span></b></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><b><span style="color: black;" lang="EN-US">&nbsp;</span></b></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><b><span style="color: black;" lang="EN-US">&nbsp;</span></b></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><b><span style="color: black;">LISA PEEL, PGDip, MA.</span></b><b><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; color: black;"></span></b></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><span style="color: black;">Librarian</span><span style="color: black;"></span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><span style="color: black;">César Ritz Colleges Switzerland</span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><span style="color: black;">1897 Le Bouveret - Switzerland</span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><span style="color: black;" lang="EN-US">Tel: &#43;41 24 482 82 82 Fax: &#43;41 24 482 82 80</span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><span style="color: black;" lang="EN-US">E-mail:
<b><a href="mailto:hortense.hofer@ritz.edu" target="_blank"><span style="color: blue;">lisa.peel@ritz.edu</span></a></b></span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;"><span style="color: black;" lang="EN-US"><a href="http://www.ritz.edu/" target="_blank"><span style="color: blue;">http://www.ritz.edu</span></a> -
<a href="http://www.culinaryarts.ch/" target="_blank"><span style="color: blue;">http://www.culinaryarts.ch</span></a></span></p>
<p class="MsoNormal">&nbsp;</p>
</div>
</div>
</div>
</div>
</body>
</html>