User:Trivenichandriki

select items.barcode, biblio.title, biblio.author, biblioitems.place, biblioitems.publishercode, biblio.copyrightdate as Year, items.price, biblioitems.isbn from items left join biblio on biblio.biblionumber = items.biblionumber left join biblioitems on biblioitems.biblionumber = biblio.bi blionumber where items.homebranch = <>  and items.itype = <> order by CONCAT( REPEAT( "0", 18 - LENGTH( LEFT( barcode, 10 ) ) ) , LEFT( barcode , 10 ) )

SELECT os.name AS "Set", COUNT(osb.biblionumber) AS Count FROM oai_sets_biblios osb LEFT JOIN oai_sets os ON (os.id=osb.set_id) ORDER BY os.name ASC
 * 1) LEFT JOIN biblio b ON (b.biblionumber=osb.biblionumber)