Topic on Talk:Quarry

Jump to navigation Jump to search

cookbook for "classes" of queries

2
2601:1C1:867F:EA40:D896:7EC1:1E1F:AA9A (talkcontribs)

Not sure if i am missing some docs somewhere but i am looking to perform a set of queries where by i can select the title based upon the content available in the infobox (vcard? looking at the html).


It is unclear to me how to do this base upon the schema. No doubt others would like to do this as well.


I am very familiar with MYSQL but most of the queries I have seen appear to be very complex for data that seems to be straightforward.


For example I want to find all companies that are listed in the S&P_500 .not the page listing them but a list based upon a query that lists the url in the infobox.


Is this hard? easy? Can someone point me to a sql query that can do this?


thanks

Matěj Suchánek (talkcontribs)

Infobox cannot be queried using SQL (in fact, using nothing). You can query structured data on Wikidata using SPARQL endpoint.

Reply to "cookbook for "classes" of queries"