Søk i bibliotekbasen til Rødberg bibliotek
Tidemann Websøk 5.0
Loading…
Portal
Søk
Treffliste
Mine lån
Utlån
Avansert søk
Enkelt søk
Kun fritekst
Kommandosøk
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','GÅRDS-OG&BRUKSNR&:&127-1')) as TITLER where TITLER.base in ('001','002','004','005','006') and TITLER.base <> 255)