Hi,

You could also try the following query:

    SELECT ?software ?softwareLabel
    WHERE
    {
      [] wdt:P4290 ?software.
      OPTIONAL{?software wdt:P31 wd:Q341.}
      SERVICE wikibase:label { bd:serviceParam wikibase:language
        "[AUTO_LANGUAGE]". }
    }

This will give you all the mobile applications (currently 30). As Nicolas says, you may need to use licence information or other properties like software repository.

Best,
John Samuel

On Mon, Jun 4, 2018 at 2:00 PM, <wikidata-request@lists.wikimedia.org> wrote:
Send Wikidata mailing list submissions to
        wikidata@lists.wikimedia.org

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.wikimedia.org/mailman/listinfo/wikidata
or, via email, send a message with subject or body 'help' to
        wikidata-request@lists.wikimedia.org

You can reach the person managing the list at
        wikidata-owner@lists.wikimedia.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Wikidata digest..."


Today's Topics:

   1. SPARQL to retrieve a list of open source mobile apps
      (Sebastian Kürten)
   2. Re: SPARQL to retrieve a list of open source mobile apps
      (Nicolas VIGNERON)


----------------------------------------------------------------------

Message: 1
Date: Mon, 4 Jun 2018 13:50:32 +0200
From: Sebastian Kürten <sebastian.kuerten@fu-berlin.de>
To: wikidata@lists.wikimedia.org
Subject: [Wikidata] SPARQL to retrieve a list of open source mobile
        apps
Message-ID: <20180604135032.0ddabce3@pluto>
Content-Type: text/plain; charset=US-ASCII

Hello,

I'm trying to retrieve a list of open source mobile applications using
the Wikidata Query Service. After identifying the item for K9-Mail
(Q14565723), I can see that it has "instance of" (P31) set to both
"free software" (Q341) and "mobile app" (Q620615). I hence derived the
following SPARQL query, to retrieve similar items:

    SELECT ?software ?softwareLabel
    WHERE
    {
      ?software wdt:P31 wd:Q341, wd:Q620615.
      SERVICE wikibase:label { bd:serviceParam wikibase:language
        "[AUTO_LANGUAGE]". }
    }

It returns three results, but to my suprise, it does not return the
item for K9-Mail. Given that the query is such a simple one, I'm
wondering what I am doing wrong here? Or is something else possibly not
working correctly?

Thanks for your help,
Sebastian



------------------------------

Message: 2
Date: Mon, 4 Jun 2018 13:58:21 +0200
From: Nicolas VIGNERON <vigneron.nicolas@gmail.com>
To: Discussion list for the Wikidata project
        <wikidata@lists.wikimedia.org>
Subject: Re: [Wikidata] SPARQL to retrieve a list of open source
        mobile apps
Message-ID:
        <CANTrCmg7si9EwObJNX5momWzsxburkWbAPfxOFnHPh2dFWioVg@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

Hi Sebastian,

There was a rank on https://www.wikidata.org/wiki/Q14565723#P31 third
value. By default, SPARQL query only give the best ranked values. It is
useful for series of values, like for population to give only the more cent
one by default.
Here I see no reason why the rank was used, I removed it. Now there is 4
results, including K9-Mail.

That said, maybe a better way to request would be with P275 (license).

Cheers, ~nicolas

2018-06-04 13:50 GMT+02:00 Sebastian Kürten <sebastian.kuerten@fu-berlin.de>
:

> Hello,
>
> I'm trying to retrieve a list of open source mobile applications using
> the Wikidata Query Service. After identifying the item for K9-Mail
> (Q14565723), I can see that it has "instance of" (P31) set to both
> "free software" (Q341) and "mobile app" (Q620615). I hence derived the
> following SPARQL query, to retrieve similar items:
>
>     SELECT ?software ?softwareLabel
>     WHERE
>     {
>       ?software wdt:P31 wd:Q341, wd:Q620615.
>       SERVICE wikibase:label { bd:serviceParam wikibase:language
>         "[AUTO_LANGUAGE]". }
>     }
>
> It returns three results, but to my suprise, it does not return the
> item for K9-Mail. Given that the query is such a simple one, I'm
> wondering what I am doing wrong here? Or is something else possibly not
> working correctly?
>
> Thanks for your help,
> Sebastian
>
> _______________________________________________
> Wikidata mailing list
> Wikidata@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikidata
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/wikidata/attachments/20180604/72cdd23c/attachment-0001.html>

------------------------------

Subject: Digest Footer

_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata


------------------------------

End of Wikidata Digest, Vol 79, Issue 3
***************************************