[sitka/sitka-tools.git] / marc_export_custom / getbibidswithnoitems.sql

drop table if exists cotr.non_ebsco_ebibs;

create table cotr.non_ebsco_ebibs as select distinct record from asset.call_number c where deleted is false and owning_lib between 39 and 46 and label = '##URI##' and not exists (select * from metabib.full_rec where tag = '856' and subfield = 'u' and value like '%ebsco%' and record = c.record);


delete from cotr.non_ebsco_ebibs where record in (select record from asset.call_number ca, asset.copy c where ca.deleted is false and owning_lib between 39 and 46 and ca.id = c.call_number and circ_lib between 39 and 46 and c.deleted is false);
Commit	Line	Data
11561776 MB	1	drop table if exists cotr.non_ebsco_ebibs;
	2
	3	create table cotr.non_ebsco_ebibs as select distinct record from asset.call_number c where deleted is false and owning_lib between 39 and 46 and label = '##URI##' and not exists (select * from metabib.full_rec where tag = '856' and subfield = 'u' and value like '%ebsco%' and record = c.record);
	4
	5
	6	delete from cotr.non_ebsco_ebibs where record in (select record from asset.call_number ca, asset.copy c where ca.deleted is false and owning_lib between 39 and 46 and ca.id = c.call_number and circ_lib between 39 and 46 and c.deleted is false);