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