Find distinct co-types : Help - Freebase

From a question posted to the Developer's email list:

I'm trying to form an MQL read query that specifies a type (e.g. /business/company), finds all topics of that type, lists all other types linked to those topics, and returns a distinct list of those other types (as per a SQL SELECT DISTINCT... query).

Is there an MQL "shortcut" equivalent to SQL's SELECT DISTINCT?

The trick to this, in MQL, is to turn the query inside out.

You want to find all types that have instances shared with a target type /business/company.

{
   "query":[
     {
       "type":"/type/type",
       "name":null,
       "id":null,
       "instance":[
         {
           "type":"/business/company",
           "limit":1
         }
       ]
     }
   ]
}

(The limit clause is included to improve the readability of the result and to decrease the likelihood of timeout.)

Edit description

Search Help Center

Discussions

There are no conversations on this topic. Would you like to start one?

Start the Discussion »