Søk i Marinemuseet (MMU)
  • Portal
  • Søk
  • Treffliste
  • Mine lån
Feil i søkestrengen
(select * from (select tkey,CASE WHEN subtitle IS NULL OR subtitle = '' THEN title ELSE substring((title || ' : ' || subtitle),1,260) END as title,subtitle,authors,material,aar,isbdfirst,signature,lenkethumb,base,gridord,sorting,ordsorting,shortisbd,t1.note from titles t1 left join serie on serie.k_serie = t1.seriekey where t1.marctags like '%*440__$aKgl.Nor.Fr.Univ.program,1ste sem.1896 %' or t1.marctags like '%*440__$aKgl.Nor.Fr.Univ.program,1ste sem.1896' or serie.seriename = 'Kgl.Nor.Fr.Univ.program,1ste sem.1896') as TITLER where TITLER.base in ('035','036') and TITLER.base <> 255)