Catalogue

Browser

SELECT DISTINCT(item.id) as iditem FROM adl_omekaitems item INNER JOIN adl_omekaitem_types itemtype ON item.item_type_id=itemtype.id INNER JOIN (SELECT etexts.record_id FROM adl_omekaelement_texts etexts INNER JOIN adl_omekaelements elements ON etexts.element_id=elements.id WHERE ((elements.name='Orchestra' AND etexts.text LIKE '%SWR Radio-Sinfonieorchester Stuttgart%')) GROUP BY (etexts.record_id) HAVING COUNT(*) >= 1) c ON c.record_id = item.id WHERE (item.public=1 OR item.public=0) ORDER BY item.added DESC

Showing 1-2 of results for a total of 2

Page 1 of 1 :1

ID	Title	Composer	Author	Physical description
003889	["Orquestas" : encabezamiento Staatsorchester-Syracuse (...)] / Arxiu Alicia de Larrocha		Arxiu Alicia de Larrocha
001152	Alicia de Larrocha spielt/plays Mozart & Beethoven [Grabación sonora]	Beethoven, Ludwig van, 1770-1827; Mozart, Wolfgang Amadeus, 1756-1791		1 disco sonoro (CD) (73 min) : digital, stereo. ; 12 cm + 1 folleto (7 p.)

Showing 1-2 of results for a total of 2

Page 1 of 1 :1

Item type	Boolean operators	OR AND
Title	Concert hall
Composer	City
Performer	Country
Conductor	Year
Orchestra	Festival
Awards	Author
Tags