Tidemann Websøk

(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','BØ&TELEMARK&-&OTERHOLT&--------------------------------------------------------------------------------&BIBLIOTEK&HVOR&ER&DOKUMENTET&UTLÅNSSTATUS&_&MERKNAD&HØGSKOLEN&I&TELEMARK&BIBLIOTEKET&-&BØ&BØ&948&118&BØ&R&NASJONALBIBLIOTEKET&DEPOTBIBLIOTEKET&KART&NB_DEP&M&DEPOTBIBLIOTEKET&KART&NB_DEP&M&DEPOTBIBLIOTEKET&KART&NB_DEP&M&NB_BEV&KART&NB_BEV&B&[IKKE&UTLÅN]&NBO&KART&NB_BRU&SER&1379_6&H&TIL&BRUK&PÅ&NB&OSLOS&LESESAL&UNIVERSITETSBIBLIOTEKET&I&TRONDHEIM&GUNNERUSBIBLIOTEKET&KART&GUNNERUS&T&13051_2007:6&[KORTTID]&--------------------------------------------------------------------------------&SEND&TIL&ENDNOTE&PROCITE&REF&MANAGER&REFWORKS&OK&SEND&TIL&E-POST&PÅ&FORMAT&FORTEKST&FORTEKST&M_EKSEMPLARER&BIBSYS-MARC&RIS&OK&-------------------------------------------------------------------------&-------&S')) as TITLER where TITLER.base <> 255)