Søk i Norsk luftfartsmuseum
  • Portal
  • Søk
    v
  • Treffliste
  • Mine lån
  • Utlån
  • Innlevering
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','ALCOCK&&&BROWN')) as TITLER where TITLER.base in ('001') and TITLER.base <> 255)