Rettsinfo
  • Portal
  • Søk
    v
  • Treffliste
  • Min konto
  • Logg på
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.ean,t1.isbdfirst,t1.signature,t1.lenkethumb,t1.base,t1.gridord,t1.sorting,t1.ordsorting,t1.shortisbd,t1.note,t1.tkey as tkey2,'' as ulink 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','NS&8407:2011')) as TITLER where TITLER.base in ('002') and TITLER.base <> 255)