Søk i bibliotekbasen til Rødberg bibliotek
  • Portal
  • Søk
  • Treffliste
  • Mine lån
  • Utlån
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,ean,isbdfirst,signature,lenkethumb,base,gridord,sorting,ordsorting,shortisbd,t1.note,t1.tkey as tkey2,'' as ulink from titles t1 where (t1.seriekey = 1618 or t1.marctags like '%*440__$aAgatha Christie's Poirot %' or t1.marctags like '%*440__$aAgatha Christie's Poirot')) as TITLER where TITLER.base in ('001','002','004','005','006') and TITLER.base <> 255)