[Freebase-discuss] Querying Games with specific Web Pages

[Will Merydith]

Thanks Thad.  I've actually been using that view for most of the afternoon.
The build query link is cool, and that's what I used to get (what I thought)
was the right syntax.  I feel like I understand the relationships between
games and webpage, but what's holding me back is I'm just not understanding
how to build complex queries.

And some of the examples in mql editor (in particular ones that would be
helpful to figuring out this solution) are broken.


On Wed, Dec 15, 2010 at 9:48 PM, Thad Guidry <thadguidry at gmail.com> wrote:

> How about I just teach you to fish instead...(and using our new Schema
> view)  http://www.freebase.com/schema/games/game
>
> So let's take a look at the DIAGRAM view first.  Using this view, you
> can see the schema in a nice layout:
> http://www.freebase.com/schema/games/game?view=diagram
>
> You can then just hover your mouse over the blue colored links to see
> what the path really is and all those inherited properties like
> Webpage.
>
> Also you can click back onto the TABLE view instead of that neat
> DIAGRAM view.  You'll see that Topic is collapsed with a + sign, click
> on it and you'll see more.  Then notice when you hover over Webpage
> property that you get a grey arrow drop down, using this you can click
> on Inspect, but you really want to use Build a query and from there,
> your taken to Query editor with the correct MQL structure on how to
> query that property & type !  Pretty cool I'd say.
>
> Also note that Webpage is really a mediator when you hover over it and
> you can read more about mediators (CVT's of sorts) on our wiki.
>
> I bet you can figure it out now.  Enjoy!
>
> -Thad
>
> On Wed, Dec 15, 2010 at 9:16 PM, Will Merydith <will.merydith at gmail.com>
> wrote:
> > This query below should work, but it complains that there is no property
> > "webpage" in games.  But there is - here is a game schema:
> >
> http://api.freebase.com/api/experimental/topic/standard?id=/en/settlers_of_catan
> >
> >
> > [{
> >   "webpage": [{
> >     "topic": null,
> >     "uri":   null,
> >     "name": "Wikipedia"
> >   }],
> >   "name": null,
> >   "id":   null,
> >   "type": "/games/game"
> > }]
> >
> > On Wed, Dec 15, 2010 at 9:08 PM, Will Merydith <will.merydith at gmail.com>
> > wrote:
> >>
> >> Well that helped a little . . .
> >>
> >> I managed to produce this query that finds the webpage "Wikipedia":
> >>
> >> [{
> >>   "name~=":          "Wikipedia",
> >>   "type":          "/common/topic",
> >>   "/common/topic/webpage": [{"uri":null, "id" : null, "topic": null,
> >> "category": null}]
> >> }]
> >>
> >>
> >> But I cannot get that working in the context of "show me all games with
> >> Wikipedia webpages".
> >>
> >>
> >> On Wed, Dec 15, 2010 at 8:36 PM, Thad Guidry <thadguidry at gmail.com>
> wrote:
> >>>
> >>> I'll let others answer your direct question.
> >>>
> >>> However, I just wanted to mentioned that you can also get basic info
> >>> and descriptions using the Topic API
> >>>
> >>> http://wiki.freebase.com/wiki/Topic_API
> >>>
> >>> I was thinking you could just use the &domains= parameter ?  Like so,
> >>>
> >>>
> >>>
> http://api.freebase.com/api/experimental/topic/standard?id=/en/sgt_peppers_lonely_hearts_club_band&domains=/en/wikipedia
> >>>
> >>> -Thad
> >>>
> >>> On Wed, Dec 15, 2010 at 8:27 PM, Will Merydith <
> will.merydith at gmail.com>
> >>> wrote:
> >>> > I read through the mql tutorial and have been unsuccessful at
> building
> >>> > the
> >>> > following search in mql:
> >>> >
> >>> > I want to find all /games/game with a webpage for "Wikipedia".
> >>> >
> >>> > The game schema is (partly):
> >>> >
> >>> >     "text": "Settlers of Catan",
> >>> >     "type": [
> >>> >       {
> >>> >         "id": "/games/game",
> >>> >         "text": "Game"
> >>> >       },
> >>> >       {
> >>> >         "id": "/award/award_winning_work",
> >>> >
> >>> >         "text": "Award-Winning Work"
> >>> >       },
> >>> >       {
> >>> >         "id": "/media_common/adapted_work",
> >>> >         "text": "Adapted Work"
> >>> >       }
> >>> >     ],
> >>> >
> >>> >     "url": "http://www.freebase.com/view/en/settlers_of_catan",
> >>> >     "webpage": [
> >>> >       {
> >>> >         "text": "Wikipedia",
> >>> >
> >>> >         "url": "http://en.wikipedia.org/wiki/index.html?curid=36727"
> >>> >       },
> >>> >       {
> >>> >         "text": "German Wikipedia",
> >>> >
> >>> >         "url": "http://de.wikipedia.org/wiki/Die_Siedler_von_Catan"
> >>> >       }
> >>> >
> >>> >
> >>> > _______________________________________________
> >>> > You are receiving this message because you are subscribed to the
> >>> > Freebase-discuss mailing list.
> >>> > To post a message to the list: Freebase-discuss at freebase.com
> >>> > To unsubscribe, view archives, etc:
> >>> > http://lists.freebase.com/mailman/listinfo/freebase-discuss
> >>> >
> >>> _______________________________________________
> >>> You are receiving this message because you are subscribed to the
> >>> Freebase-discuss mailing list.
> >>> To post a message to the list: Freebase-discuss at freebase.com
> >>> To unsubscribe, view archives, etc:
> >>> http://lists.freebase.com/mailman/listinfo/freebase-discuss
> >>
> >
> >
> > _______________________________________________
> > You are receiving this message because you are subscribed to the
> > Freebase-discuss mailing list.
> > To post a message to the list: Freebase-discuss at freebase.com
> > To unsubscribe, view archives, etc:
> > http://lists.freebase.com/mailman/listinfo/freebase-discuss
> >
> _______________________________________________
> You are receiving this message because you are subscribed to the
> Freebase-discuss mailing list.
> To post a message to the list: Freebase-discuss at freebase.com
> To unsubscribe, view archives, etc:
> http://lists.freebase.com/mailman/listinfo/freebase-discuss
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freebase.com/pipermail/freebase-discuss/attachments/20101215/d368089a/attachment-0001.htm>