query-feb92e44fcbf8d43749d210e628cffbe

rq turtle/ttl

English descriptions starting with "a"Hi there, 22:53, 6 January 2022 (UTC)) talk (EpicPupper to SPARQL? The original database table used (wb_terms) is no longer existing. Thanks! this SQL queryCould someone please convert 23:01, 7 January 2022 (UTC)) talk (EpicPupperThanks for the docs link! 00:34, 7 January 2022 (UTC)) talk (MisterSynergy is documentation how to query the new database schema with SQL. —HereCorrect, no way SPARQL can do this. 00:22, 7 January 2022 (UTC)) talk (Dipsacus fullonumIt cannot be converted to a SPARQL query that can run in WDQS without timeout as that type of text searches are ineffective in SPARQL. I suggest you instead rewrite the SQL to use the current database or use some other tool or even a database dump. --Something more limited can work in sparql:

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?d 
{
  ?item wdt:P17 wd:Q16 ; schema:description ?d .
  FILTER( lang(?d) = "en" && strstarts(?d, "a ") )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 100

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/01