Search the SFO Museum Collection
There are no results where
the subcategory is 1511213783
or
1511213365
or
1511213789
and
the airline is 1159284973
and
decade is 1970
and
the query mode is to match the entire phrase
.
Would you like to try a new search?
Click here to see the database query used to perform this search
{ "query": { "function_score": { "query": { "bool": { "must": [ { "term": { "sfomuseum:placetype": "object" } }, { "bool": { "should": [ { "term": { "millsfield:subcategory_id": "1511213783" } }, { "term": { "millsfield:subcategory_id": "1511213365" } }, { "term": { "millsfield:subcategory_id": "1511213789" } } ] } }, { "bool": { "should": [ { "bool": { "should": [ { "ids": { "values": "1159284973" } }, { "term": { "wof:depicts": "1159284973" } }, { "term": { "millsfield:airline_id": "1159284973" } } ] } } ] } }, { "range": { "date:inception_upper": { "gte": "1970-01-01", "format": "yyyy-mm-dd" } } }, { "range": { "date:cessation_lower": { "lte": "1979-12-13", "format": "yyyy-mm-dd" } } } ], "must_not": [ { "exists": { "field": "sfomuseum:image_id" } }, { "exists": { "field": "edtf:deprecated" } } ] } }, "functions": [], "boost_mode": "multiply", "score_mode": "multiply", "boost": 10, "max_boost": 500 } }, "sort": [ { "_script": { "type": "number", "script": "doc['millsfield:images'].size()", "order": "desc" } }, { "wof:name.keyword": "desc" }, { "date:inception_inner_start": "desc", "date:cessation_outer_end": "desc" } ], "aggs": { "collection": { "terms": { "field": "millsfield:collection_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "category": { "terms": { "field": "millsfield:category_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "subcategory": { "terms": { "field": "millsfield:subcategory_id", "exclude": [ -1, "1511213783", "1511213365", "1511213789" ], "size": 1000, "order": { "_key": "asc" } } }, "airline": { "terms": { "field": "millsfield:airline_id", "exclude": [ -1, "1159284973" ], "size": 1000, "order": { "_key": "asc" } } }, "aircraft": { "terms": { "field": "millsfield:aircraft_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "airport": { "terms": { "field": "millsfield:airport_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "images": { "value_count": { "field": "millsfield:images" } }, "exhibition": { "terms": { "field": "millsfield:exhibition_ids", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } } } }