Hi,
Below is my updated version of serials query for finding late issues based
on the already existing query in koha sql reports library.
Hope is it useful for other members.
SELECT @kp:=@kp+1 as S_No,serial.serialseq,
DATE_FORMAT(serial.planneddate, "%d %b %Y" ) as Planneddate,
Hi all, I have the following mysql query below to get biblio details based on
target audience/course 521$a which has authorized/pre-defined values TARGET.
Some records has more than one Target audience hence the ExtractValue(
b.marcxml, '//datafield[@tag="521"]/subfield[@code="a"][2]') and so on.
I'm looking, please, for some expertise in writing MySQL queries (Koha
reports.) I have a good report for listing high value items in our
collections (a requirement for our insurers), but need to add the special
case of multi volume biblios.
Example: a set of Britannicas (14th ed.) is a
Why not first select those biblios with item.price = XX
SELECT ...what you need...
FROM
(
SELECT sum(price) as totalprice, biblionumber
FROM items
WHERE price = XX
GROUP BY biblionumber
) as biblio_price
LEFT JOIN biblioitems on (biblio_price.biblionumber=**biblio
items.biblionumber)
LEFT
4 matches
Mail list logo
