Thanks to everyone who added their answers - this all did the trick! :)

On Mon, Nov 9, 2015 at 1:59 PM, Tom Morris <tfmorris@gmail.com> wrote:
This StackExchange answer describes how to get site links:

http://opendata.stackexchange.com/questions/6050/get-wikipedia-urls-sitelinks-in-wikidata-sparql-query#

You could graft in the appropriate clause from that answer to get enwiki sitelinks.  It looks like there are a total of 37092 Twitter handles, of which 29945 have links to enwiki and 29930 have an English label as well (of course you could get the English names for the others by looking at the title of the Wikipedia article).

Two things to be aware of are that this isn't a one-to-one correspondence and the quality of the links varies, so, for example, @ADFP_Peru has 7 English wikipedia articles nominally "about" it, but none of them actually describe the Peruvian professional football association. That article is the rather generically named https://en.wikipedia.org/wiki/Professional_Football_Sports_Association

There are only ~160 Twitter accounts with multiple articles though.  All 22 the links for the account @status should be ignored as their the result of a bots bad parse of things like the link to https://twitter.com/WAFCA/status/410033143148978176 in https://en.wikipedia.org/wiki/Tye_Sheridan#cite_note-22

Tom

prefix schema: <http://schema.org/>

SELECT ?Twitter ?item ?item_label ?article WHERE {
  {?item wdt:P2002 ?Twitter FILTER(?Twitter = "ADFP_Peru") }
  {?item rdfs:label ?item_label filter (lang(?item_label) = "en") .}
  {
      ?article schema:about ?item .
      FILTER (SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/")
  }
}



On Mon, Nov 9, 2015 at 12:25 PM, Hampton Snowball <hamptonsnowball@gmail.com> wrote:
Thank you for doing what you could! In terms of wikipedia links it does look like the wikidata records do link to wikpedia, e.g. at the bottom of this record:


Since there is multiple wikpedia entries, I guess I'd be going for the "en" english one. 

Best,
HS


On Mon, Nov 9, 2015 at 12:18 PM, Remko de Keijzer <remko@remkodekeijzer.nl> wrote:
No. The label is the label in Wikidata. Not a sitelink. You're not querying Wikipedia, but Wikidata.
If you really need the sitelink, I hope someone else can help you further, since I'm a mere beginner at SPARQL and was happy I could get this result.

-- 
Mbch331

When you have eliminated the impossible, whatever remains, however improbable, must be the truth.
(Sir Arthur Conan Doyle)
Op 9-11-2015 om 18:13 schreef Hampton Snowball:
Maybe I misunderstood.  I think the item label is actually what's used in the wikipedia article url, just convert spaces to underscores?

Thanks!

On Mon, Nov 9, 2015 at 11:47 AM, Hampton Snowball <hamptonsnowball@gmail.com> wrote:
Thank you. Is there a way to export it though with the Wikipedia Article name with underscores or wikipedia url?  So like Barack_Obama or en.wikipedia.org/wiki/Barack_Obama.

On Mon, Nov 9, 2015 at 11:34 AM, Remko de Keijzer <remko@remkodekeijzer.nl> wrote:
I think this: http://tinyurl.com/o5lahko is what you wanted. It's got the item ID, the label and the value of P2002.

-- 
Mbch331

When you have eliminated the impossible, whatever remains, however improbable, must be the truth.
(Sir Arthur Conan Doyle)
Op 9-11-2015 om 17:09 schreef Hampton Snowball:
I'm looking to use the https://query.wikidata.org/ interface to export to csv all wikidatas with this property P2002.


I am looking for the Wikipedia Article_Name + the value associated with that property.

Thanks in advance!



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


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





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


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



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



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