Both your questions are duplicates, but I’ll try to add interesting facts to existing answers. Question 1 is a duplicate of SPARQL query to get only results with the most recent date. This technique does the trick: FILTER NOT EXISTS { ?country p:P1081/pq:P585 ?hdi_date_ . FILTER (?hdi_date_ > ?hdi_date) } However, you should add this … Read more
Useful links on the Wikidata data model: RDF dump format Wikidata qualifiers, references and ranks Help:qualifiers Your query should be of this kind: SELECT ?wdLabel ?ps_Label ?wdpqLabel ?pq_Label { VALUES (?company) {(wd:Q95)} ?company ?p ?statement . ?statement ?ps ?ps_ . ?wd wikibase:claim ?p. ?wd wikibase:statementProperty ?ps. OPTIONAL { ?statement ?pq ?pq_ . ?wdpq wikibase:qualifier ?pq … Read more
The wrong way: trying to parse HTML Use (cURL/jQuery/file_get_contents/requests/wget/more jQuery) to fetch the HTML article code of the article, then use a DOM parser to extract table.infobox tr[3] td / use a regex. This is actually a really bad idea most of the time. Wikipedia’s HTML code is not particularly parsing-friendly (especially infoboxes which are … Read more