Norsk maritimt museum
Tidemann Websøk 5.0
Loading…
Portal
Søk
Treffliste
Mine lån
Utlån
Innlevering
Avansert søk
Enkelt søk
Kun fritekst
Kommandosøk
Bokmål
English
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,ean,isbdfirst,signature,lenkethumb,base,gridord,sorting,ordsorting,shortisbd,t1.note,t1.tkey as tkey2,'' as ulink from titles t1 where t1.class1 = '629.128(44) Chantiers de l'Atlantique' or t1.class2 = '629.128(44) Chantiers de l'Atlantique' or t1.class3 = '629.128(44) Chantiers de l'Atlantique') as TITLER where TITLER.base <> 255)