Search the SFO Museum Collection
There are no results where
the object has not been digitized
and
the category is 1762671311
and
the subcategory is 1511213567
and
the airline is 1159285415
or
1159285963
or
1159285413
or
1159285417
or
1159285423
and
the airport is 102551487
or
1746879101
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:category_id": "1762671311" } } ] } }, { "bool": { "should": [ { "term": { "millsfield:subcategory_id": "1511213567" } } ] } }, { "bool": { "should": [ { "bool": { "should": [ { "ids": { "values": "1159285415" } }, { "term": { "wof:depicts": "1159285415" } }, { "term": { "millsfield:airline_id": "1159285415" } } ] } }, { "bool": { "should": [ { "ids": { "values": "1159285963" } }, { "term": { "wof:depicts": "1159285963" } }, { "term": { "millsfield:airline_id": "1159285963" } } ] } }, { "bool": { "should": [ { "ids": { "values": "1159285413" } }, { "term": { "wof:depicts": "1159285413" } }, { "term": { "millsfield:airline_id": "1159285413" } } ] } }, { "bool": { "should": [ { "ids": { "values": "1159285417" } }, { "term": { "wof:depicts": "1159285417" } }, { "term": { "millsfield:airline_id": "1159285417" } } ] } }, { "bool": { "should": [ { "ids": { "values": "1159285423" } }, { "term": { "wof:depicts": "1159285423" } }, { "term": { "millsfield:airline_id": "1159285423" } } ] } } ] } }, { "bool": { "should": [ { "bool": { "should": [ { "ids": { "values": "102551487" } }, { "term": { "wof:depicts": "102551487" } }, { "term": { "millsfield:airport_id": "102551487" } } ] } }, { "bool": { "should": [ { "ids": { "values": "1746879101" } }, { "term": { "wof:depicts": "1746879101" } }, { "term": { "millsfield:airport_id": "1746879101" } } ] } } ] } } ], "must_not": [ { "bool": { "should": [ { "exists": { "field": "millsfield:images" } } ] } }, { "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, "1762671311" ], "size": 1000, "order": { "_key": "asc" } } }, "subcategory": { "terms": { "field": "millsfield:subcategory_id", "exclude": [ -1, "1511213567" ], "size": 1000, "order": { "_key": "asc" } } }, "airline": { "terms": { "field": "millsfield:airline_id", "exclude": [ -1, "1159285415", "1159285963", "1159285413", "1159285417", "1159285423" ], "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, "102551487", "1746879101" ], "size": 1000, "order": { "_key": "asc" } } }, "images": { "value_count": { "field": "millsfield:images" } }, "year": { "date_histogram": { "field": "date:inception_lower", "calendar_interval": "year", "min_doc_count": 1 } }, "exhibition": { "terms": { "field": "millsfield:exhibition_ids", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } } } }