Søk i Norsk luftfartsmuseum
  • Portal
  • Søk
    v
  • Treffliste
  • Mine lån
  • Utlån
  • Innlevering
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.class1 = '940.534844'41' or t1.class2 = '940.534844'41' or t1.class3 = '940.534844'41') as TITLER where TITLER.base in ('001') and TITLER.base <> 255)