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 distinct(t1.tkey),CASE WHEN subtitle IS NULL OR subtitle = '' THEN t1.title ELSE substring((t1.title || ' : ' || t1.subtitle),1,260) END as title,t1.subtitle,t1.authors,t1.material,t1.aar,t1.isbdfirst,t1.signature,t1.lenkethumb,t1.base,t1.gridord,t1.sorting,t1.ordsorting,t1.shortisbd,t1.note from titles t1 left join ex on ex.title = t1.tkey left join cat on cat.tkey = t1.tkey where to_tsvector('simple', t1."i102") @@ to_tsquery ('simple','TYPE&JD&JE&&&JN')) as TITLER where TITLER.base in ('035','036') and TITLER.base <> 255)