Search the SFO Museum Collection
There are no results where
the object has not been digitized
and
the airline is 1159284991
or
1159284989
or
1159285903
or
1159284993
and
aircraft is 1159291137
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": [ { "bool": { "should": [ { "ids": { "values": "1159284991" } }, { "term": { "wof:depicts": "1159284991" } }, { "term": { "millsfield:airline_id": "1159284991" } } ] } }, { "bool": { "should": [ { "ids": { "values": "1159284989" } }, { "term": { "wof:depicts": "1159284989" } }, { "term": { "millsfield:airline_id": "1159284989" } } ] } }, { "bool": { "should": [ { "ids": { "values": "1159285903" } }, { "term": { "wof:depicts": "1159285903" } }, { "term": { "millsfield:airline_id": "1159285903" } } ] } }, { "bool": { "should": [ { "ids": { "values": "1159284993" } }, { "term": { "wof:depicts": "1159284993" } }, { "term": { "millsfield:airline_id": "1159284993" } } ] } } ] } }, { "bool": { "should": [ { "bool": { "should": [ { "ids": { "values": "1159291137" } }, { "term": { "wof:depicts": "1159291137" } }, { "term": { "millsfield:aircraft_id": "1159291137" } } ] } } ] } } ], "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 ], "size": 1000, "order": { "_key": "asc" } } }, "subcategory": { "terms": { "field": "millsfield:subcategory_id", "exclude": [ -1 ], "size": 1000, "order": { "_key": "asc" } } }, "airline": { "terms": { "field": "millsfield:airline_id", "exclude": [ -1, "1159284991", "1159284989", "1159285903", "1159284993" ], "size": 1000, "order": { "_key": "asc" } } }, "aircraft": { "terms": { "field": "millsfield:aircraft_id", "exclude": [ -1, "1159291137" ], "size": 1000, "order": { "_key": "asc" } } }, "airport": { "terms": { "field": "millsfield:airport_id", "exclude": [ -1 ], "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" } } } } }