https://koha.se/wiki/index.php?action=history&feed=atom&title=L%C3%A5ntagarr%C3%B6rlighet 2026-04-25T18:23:42Z Versionshistorik för denna sida på wikin MediaWiki 1.35.10 https://koha.se/wiki/index.php?title=L%C3%A5ntagarr%C3%B6rlighet&diff=679&oldid=prev 2020-04-27T09:45:38Z

<p>Skapade sidan med &#039;==Låntagarrörlighet== Hur många låntagare använder andra bibliotek än sitt hembibliotek, och hur många låna gör de? &lt;pre&gt; SELECT hembibl.branchname AS &#039;Låntagarens...&#039;</p> <p><b>Ny sida</b></p><div>==Låntagarrörlighet==<br /> <br /> Hur många låntagare använder andra bibliotek än sitt hembibliotek, och hur många låna gör de?<br /> <br /> &lt;pre&gt;<br /> SELECT hembibl.branchname AS &#039;Låntagarens hembibliotek&#039;,utlbibl.branchname AS &#039;Utlånande bibliotek&#039;,COUNT(*) AS &#039;Antal lån&#039;,COUNT(DISTINCT statistics.borrowernumber) AS &#039;Antal låntagare&#039;<br /> <br /> FROM statistics<br /> LEFT JOIN borrowers ON (borrowers.borrowernumber=statistics.borrowernumber)<br /> LEFT JOIN branches hembibl ON (hembibl.branchcode=borrowers.branchcode)<br /> LEFT JOIN branches utlbibl ON (utlbibl.branchcode=statistics.branch)<br /> <br /> WHERE statistics.branch LIKE &lt;&lt;Utlånande bibliotek|branches:all&gt;&gt;<br /> AND borrowers.branchcode LIKE &lt;&lt;Låntagarens hembibliotek|branches:all&gt;&gt; <br /> AND borrowers.categorycode LIKE &lt;&lt;Låntagarkategori|categorycode:all&gt;&gt;<br /> AND statistics.datetime BETWEEN &lt;&lt;Datum från|date&gt;&gt;-INTERVAL 1 DAY AND &lt;&lt;Datum till |date&gt;&gt;+INTERVAL 1 DAY AND statistics.branch IS NOT NULL<br /> <br /> GROUP BY borrowers.branchcode,statistics.branch<br /> <br /> ORDER BY 2,4<br /> &lt;/pre&gt;<br /> <br /> ==Låntagarrörlighet med postnummer==<br /> <br /> Samma som ovan, men sorterat på låntagarens postnummer så man kan se vilka områden man täcker in<br /> &lt;pre&gt;<br /> select <br /> hembibl.branchname AS &#039;Hembibliotek&#039;,utlbibl.branchname AS &#039;Utlånande bibliotek&#039;,<br /> CONCAT(&#039;&lt;a href=\&quot;https://kartor.eniro.se/sok/&#039;, REPLACE(zipcode, &#039; &#039;, &#039;&#039; ), &#039;\&quot; target=&quot;_blank&quot;&gt;&#039;, REPLACE(zipcode, &#039; &#039;, &#039;&#039; ), &#039;&lt;/a&gt;&#039; ) AS &#039;Postnummer&#039;,<br /> COUNT(*) &#039;Antal lån&#039;, COUNT(DISTINCT statistics.borrowernumber) AS &#039;Antal låntagare&#039;<br /> <br /> FROM<br /> statistics<br /> LEFT JOIN borrowers ON (borrowers.borrowernumber=statistics.borrowernumber)<br /> LEFT JOIN branches utlbibl ON (utlbibl.branchcode=statistics.branch)<br /> LEFT JOIN branches hembibl On (hembibl.branchcode=borrowers.branchcode)<br /> WHERE categorycode!=&#039;BIBLIOTEK&#039; <br /> AND statistics.itemtype IS NOT NULL <br /> AND statistics.type=&#039;issue&#039; <br /> AND statistics.branch LIKE &lt;&lt;Utlånanade bibliotek|branches:all&gt;&gt;<br /> AND borrowers.branchcode LIKE &lt;&lt;Låntagarens hembibliotek|branches:all&gt;&gt;<br /> AND borrowers.categorycode LIKE &lt;&lt;Låntagarkategori|categorycode:all&gt;&gt;<br /> AND statistics.datetime BETWEEN &lt;&lt;Datum från|date&gt;&gt;-INTERVAL 1 DAY AND &lt;&lt;Datum till |date&gt;&gt;+INTERVAL 1 DAY <br /> AND CHAR_LENGTH(REPLACE(zipcode, &#039; &#039;, &#039;&#039; ))=5<br /> GROUP BY statistics.branch,borrowers.branchcode,REPLACE(zipcode, &#039; &#039;, &#039;&#039; )<br /> ORDER BY REPLACE(zipcode, &#039; &#039;, &#039;&#039; ),utlbibl.branchname,hembibl.branchname<br /> &lt;/pre&gt;</div>

KlasBlomberg