Koha sql acqiosition dep

SELECT biblio.title, items.coded_location_qualifier
FROM biblio
LEFT JOIN items ON (biblio.biblionumber=items.biblionumber)
WHERE items.coded_location_qualifier='ДП'

с издателство:
SELECT biblio.title, items.coded_location_qualifier, biblioitems.publishercode
FROM biblio
LEFT JOIN items ON (biblio.biblionumber=items.biblionumber)
LEFT JOIN biblioitems ON (biblio.biblionumber=biblioitems.biblionumber)
WHERE items.coded_location_qualifier='ДП'