Domains & Types » Freebase » Freebase Query

Freebase Query

Type History
Also known as
  • MQL Query
This type is currently a placeholder. Will be used to store example MQL queries.

No filters have been created. Enter search terms in the text boxes above each column to filter the topic list. Select properties to add columns and create additional filters.

   
x name x image x Also Typed With x Query x article
previous page | next page
+

Do you know something that's missing from this view? Add it!

name

If you have a list you can use our wizard to match it with topics that may already be in Freebase.

Go to the import tool »
Metaweb staff in order of age     {"query":[{"!/type/usergroup/member":[{"name":"Metaweb Staff","type":"/type/usergroup"}],"/freebase/user_profile/person":{"/people/person/date_of_birth":{"value":null}},"name":null,"sort":"-/freebase/user_profile/person./people/person/date_of_birth.value","type":"/type/user"}]}
25 Songs with the word 'love' in the title, with release date, album and artist     { "query":[{ "album":{ "artist":[], "name":null, "release_date":null }, "id":null, "limit":25, "name":null, "name~=":"Love*", "type":"/music/track" }] }  
35 actors born in the 60's and two of their films     { "query":[{ "/people/person/date_of_birth":null, "/people/person/date_of_birth<":"1970", "/people/person/date_of_birth>=":"1960", "film":[{ "film":[{ "id":null, "name":null }], "limit":2 }], "id":null, "limit":35, "name":null, "type":"/film/actor" }] }  
Vietnamese restaurants in San Jose, CA     { "query":[{ "/business/retail_location/address":{ "citytown":"San Jose" }, "cuisine":"Vietnamese", "id":null, "name":null, "type":"/dining/restaurant" }] }  
A sorted list of cloud classifications     { "query":[{ "clouds":[], "id":null, "name":null, "sort":"name", "type":"/meteorology/cloud_classification" }] }  
50 People born in San Francisco in the 70's     { "query":[{ "/people/person/date_of_birth":null, "/people/person/date_of_birth<":"1980", "/people/person/date_of_birth>=":"1970", "/people/person/place_of_birth":"San Francisco", "limit":50, "name":null, "id":null, "type":"/people/person" }] }  
Ivy League Authors     { "query":[{ "b:type":"/book/author", "education":[{ "institution":[{ "name":null, "id":null, "tags":"Ivy League", "type":"/user/patrick/default_domain/tagged_topic" }] }], "name":null, "id":null, "type":"/people/person" }] }  
Graduates of Stanford born since 1960 who are board members of companies     { "query":[{"b:type":"/business/board_member","date_of_birth":null, "date_of_birth>=":"1960", "education":[{ "institution":"Stanford University","id":null }], "name":null, "id":null, "type":"/people/person" }] }  
Academy award winning musicals     { "query":[{ "awards":[{ "award_winner_person":null, "film_award_type":{ "awarding_organization":"Academy of Motion Picture Arts and Sciences", "id":null, "name":null }, "sort":"-year", "year":null }], "genre":{ "id":null, "name":"Musical" }, "id":null, "name":null, "sort":"-awards.year", "type":"/film/film" }] }  
Actors who made movies in the 1970s and 1980s     {"query":[{"a70s:film":[{"film":{"id":null,"initial_release_date":null,"initial_release_date<":"1980","initial_release_date>=":"1970","name":null},"limit":1}],"a80s:film":[{"film":{"id":null,"initial_release_date":null,"initial_release_date<":"1990","initial_release_date>=":"1980","name":null},"limit":1}],"id":null,"name":null,"type":"/film/actor"}]}  
Songs in Video Games     { "query":[{ "/type/reflect/any_reverse":[{ "id":null, "link":"/user/alecf/default_domain/musical_game/songs", "name":null }], "id":null, "name":null, "type":"/music/song" }] }  
Where are they now? Actors of canceled shows and the shows they're on now     { "query":[{ "air_date_of_final_episode":{ "limit":1, "value":null }, "id":null, "name":null, "regular_cast":[{ "actor":{ "id":null, "name":null, "starring_roles":[{ "series":{ "air_date_of_final_episode":{ "optional":"forbidden", "value":null }, "id":null, "name":null } }] } }], "sort":"-air_date_of_final_episode.value", "type":"/tv/tv_program" }] }  
Where did they come from? TV Actors on current shows and the shows they came from     { "query":[{ "air_date_of_final_episode":{ "optional":"forbidden", "value":null }, "id":null, "name":null, "regular_cast":[{ "actor":{ "id":null, "name":null, "starring_roles":{ "limit":1, "series":{ "air_date_of_final_episode":{ "limit":1, "value":null }, "id":null, "name":null, "sort":"-air_date_of_final_episode.value" }, "sort":"-series.air_date_of_final_episode.value" } }, "limit":10, "sort":"-actor.starring_roles.series.air_date_of_final_episode.value" }], "type":"/tv/tv_program" }] }
this is timing out... :(
What happened to the cast of Who's the Boss?     { "query":{ "id":null, "name":"Who's the Boss?", "regular_cast":[{ "actor":{ "name":null, "starring_roles":[{ "series":{ "id":null, "name":null } }] } }], "type":"/tv/tv_program" } }  
Films starring Jennifer Connelly with actors who have appeared in Steven Spielberg movies     { "query" : [ { "b:starring" : [ { "actor" : { "film" : [ { "film" : { "hide:directed_by" : "Steven Spielberg", "name" : null } } ], "name" : null } } ], "hide:starring" : [ { "actor" : "Jennifer Connelly" } ], "id" : null, "initial_release_date" : null, "name" : null, "sort" : "-initial_release_date", "type" : "/film/film" } ] }  
Malls in California with both a Zale's Jewelers and a Victoria's Secret     { "query" : [ { "/user/jeff/default_domain/addressed_topic/address" : { "citytown" : { "/location/location/containedby" : "California", "name" : null } }, "a:store" : [ { "parent_company" : "Victoria's Secret" } ], "b:store" : [ { "parent_company" : "Zales Jewelers" } ], "id" : null, "name" : null, "type" : "/user/tsegaran/default_domain/shopping_center" } ] }  
CFOs of companies in SF with >$1M in revenue     { "query" : [ { "employment_history" : [ { "company" : { "headquarters" : [ { "citytown" : "San Francisco" } ], "name" : null, "revenue" : [ { "amount" : null, "amount>" : 1000000 } ], "type" : "/business/company" }, "title" : "Chief Financial Officer" } ], "name" : null, "type" : "/people/person" } ] }  
Directors of $10M+ companies who have starred in movies     { "query" : [ { "/business/board_member/board_memberships" : [ { "company" : { "market_capitalization" : [ { "amount" : null, "amount>" : 10000000 } ], "name" : null } } ], "/film/actor/film" : [ { "film" : null } ], "a:type" : "/film/actor", "b:type" : "/business/board_member", "id" : null, "name" : null } ] }  
Military people who are now directors of companies (with industries)     { "query" : [ {"id":null, "/business/board_member/board_memberships" : [ { "company" : [ { "industry" : [], "name" : null } ] } ], "a:type" : "/military/military_person", "b:type" : "/business/board_member", "name" : null } ] }  
Prepackaged software companies that are losing money (with CEOs)     { "query" : [ { "/business/employer/employees" : [ { "person" : null, "title" : "Chief Executive Officer" } ], "id" : null, "industry" : [ { "name" : "Prepackaged software" } ], "name" : null, "operating_income" : [ { "amount" : null, "amount<" : 0, "valid_date" : null } ], "type" : "/business/company" } ] }  
Female CEOs of public companies in order of Market Cap     { "query" : [ { "employment_history" : [ { "company" : { "/business/company/market_capitalization" : [ { "amount" : null } ], "/business/company/ticker_symbol" : [ { "ticker_symbol" : null } ], "id" : null, "name" : null }, "title" : "Chief Executive Officer" } ], "hide:gender" : "female", "id" : null, "name" : null, "sort" : "-employment_history.company./business/company/market_capitalization.amount", "type" : "/people/person" } ] }  
French Actresses born before WWII     {"query":[{"type":"/film/actor","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"/people/person/gender":"female","/people/person/date_of_birth":null,"/people/person/date_of_birth<=":"1939","/people/person/nationality":"France","sort":"/people/person/date_of_birth"}]}  
Towns in Tuscany, Italy     {"query":[{"type":"/location/citytown","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":35,"name":null,"id":null,"/location/location/containedby":"Tuscany"}]}  
People born after 1980 who have died     { "query" : [ { "id":null, "/people/deceased_person/cause_of_death" :[ { "name" : null } ], "/people/deceased_person/date_of_death" : null, "/people/person/date_of_birth" : null, "hide:/people/person/date_of_birth>" : "1980", "name" : null, "hide:type" : "/people/deceased_person" } ]}  
Contributions over $50000 have been made to members of the US congress in the 2008 election cycle by companies headquartered outside of the United States     { "query" : [ { "/government/politician/election_campaigns" : { "/government/election_campaign/election" : { "/government/election/election_year" : "2008" } }, "/user/robert/us_congress/crp_contribution_recipient/crp_political_contributions_received" : [ { "/user/robert/us_congress/crp_contribution/amount" : null, "/user/robert/us_congress/crp_contribution/amount>" : 50000, "/user/robert/us_congress/crp_contribution/contributor" : { "/business/company/headquarters" : [ { "/location/mailing_address/citytown" : { "/location/location/containedby" : { "limit" : 1, "name" : null, "name!=" : "United States", "type" : "/location/country" }, "name" : null } } ], "name" : null } } ], "hide:/common/topic/image" : [ {} ], "id" : null, "name" : null } ] }  
Foreign donations to 2008 US Political Candidates     { "query" : [ { "crp_political_contributions_received" : [ { "amount" : null, "amount>" : 50000, "contributor" : { "/business/company/headquarters" : [ { "citytown" : { "/location/location/containedby" : { "name" : null, "name!=" : "United States", "type" : "/location/country" }, "name" : null } } ], "name" : null } } ], "hide:/common/topic/image" : [ {} ], "hide:/government/politician/election_campaigns" : { "/government/election_campaign/election" : { "/government/election/election_year" : "2008" } }, "id" : null, "name" : null, "type" : "/user/robert/us_congress/crp_contribution_recipient" } ] }
What contributions over $50000 have been made to members of the US congress in the 2008 election cycle by companies headquartered outsideof the United States?
Novels that have won the Hugo, Nebula, and Locus awards combined     { "query":[ { "/award/award_winning_work/awards_won" : [ { "hide:award" : { "id" : "/en/hugo_award_for_best_novel", "name" : null }, "award":null, "year" : null } ], "b:/award/award_winning_work/awards_won" : [ { "hide:award" : { "id" : "/en/nebula_award_for_best_novel", "name" : null }, "award":null, "year" : null } ], "c:/award/award_winning_work/awards_won" : [ { "hide:award" : { "id" : "/guid/9202a8c04000641f80000000080d4528", "name" : null }, "award":null, "year" : null } ], "name" : null, "id": null, "hide:type" : "/award/award_winning_work", "sort" : "/award/award_winning_work/awards_won.year", "/book/written_work/author": null } ]}  
Australian Aboriginal women ordered by date of birth     {"query": [ { "ethnicity" : "Indigenous Australians", "date_of_birth" : null, "gender" : "female", "id" : null, "name" : null, "sort" : "date_of_birth", "type" : "/people/person" } ]}  
Leading Ladies of Sidney Poitier     {"query":[{"type":"/film/actor","hide:/common/topic/image":[{"id":null,"limit":1}],"name":null,"id":null,"hide:/people/person/gender":"female","film":{"limit":1,"film":{"name":null,"initial_release_date":null,"hide:starring":{"actor":"sidney poitier"}}},"sort":"film.film.initial_release_date"}]}  
Characters created by Stan Lee     {"query":[{"type":"/fictional_universe/fictional_character","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"character_created_by":"stan lee","sort":"name"}]}