Søk i Marinemuseet (MMU)
Tidemann Websøk 5.0
Loading…
Portal
Søk
Treffliste
Mine lån
Avansert søk
Enkelt søk
Kun fritekst
Kommandosøk
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,note from titles t1 where (t1.seriekey = 5215 or t1.marctags like '%*440__$aExtraits du Memorial de l'Artillerie de la Marine no XLIII %' or t1.marctags like '%*440__$aExtraits du Memorial de l'Artillerie de la Marine no XLIII')) as TITLER where TITLER.base in ('035','036') and TITLER.base <> 255)