On 4 April 2012 15:19, Nicole Engard <[email protected]> wrote:
> From here: http://manual.koha-community.org/3.6/en/XSLTiTypes.html
>
> leader6 = a (and one of the leader7 values below)
>
> leader7 = a
>
> leader7 = c
>
> leader7 = d
>
> leader7 = m
>
> leader6 = t
>
Something like this then
SELECT * FROM biblioitems,
(SELECT biblioitemnumber,SUBSTR(marcxml,INSTR(marcxml,
"<leader>")+8+6,1) AS leader6,SUBSTR(marcxml,INSTR(marcxml,
"<leader>")+8+7,1) AS leader7 FROM biblioitems) AS leaders
WHERE biblioitems.biblioitemnumber=leaders.biblioitemnumber AND
(leaders.leader6 = 'a' AND (leader7 IN ('a','c','d','n')) OR leader6 =
't') AND itemtypes = 'your_itemtype goes here'
Chris
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
