Search the SFO Museum Collection
There are no results where
the collection is 1511214207
and
the subcategory is 1511213437
and
the airline is 1159285415
or
1159285963
or
1159285413
or
1159285417
or
1159285423
or
1159284093
and
decade is 2010
and
the query mode is to match the entire phrase
.
Would you like try the same search matching the individual words in your query rather than the whole phrase?
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:collection_id": "1511214207"
}
}
]
}
},
{
"bool": {
"should": [
{
"term": {
"millsfield:subcategory_id": "1511213437"
}
}
]
}
},
{
"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": [
{
"ids": {
"values": "1159284093"
}
},
{
"term": {
"wof:depicts": "1159284093"
}
},
{
"term": {
"millsfield:airline_id": "1159284093"
}
}
]
}
}
]
}
},
{
"range": {
"date:inception_upper": {
"gte": "2010-01-01",
"format": "yyyy-mm-dd"
}
}
},
{
"range": {
"date:cessation_lower": {
"lte": "2019-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,
"1511214207"
],
"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,
"1511213437"
],
"size": 1000,
"order": {
"_key": "asc"
}
}
},
"airline": {
"terms": {
"field": "millsfield:airline_id",
"exclude": [
-1,
"1159285415",
"1159285963",
"1159285413",
"1159285417",
"1159285423",
"1159284093"
],
"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"
}
}
}
}