Bots, emailconfirmed
8,882
edits
(recreate wiki page for Russian using upload_lang_page.py) |
(recreate wiki page for Russian using upload_lang_page.py) |
||
Line 145: | Line 145: | ||
PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/> | PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/> | ||
select ?bib_item (group_concat(?lemma; SEPARATOR="; ") as ?terms) | select ?bib_item ?authors_year ?title (group_concat(?lemma; SEPARATOR="; ") as ?terms) | ||
where { | where { | ||
?bib_item endp:P7 enwb:Q212; endp:P65 ?lexical_entry. | ?bib_item endp:P7 enwb:Q212; endp:P65 ?lexical_entry. | ||
?bib_item rdfs:label ?title; schema:description ?desc. | |||
filter(lang(?title)="en") filter(lang(?desc)="en") bind(replace(?desc, "Publication by ", "") as ?authors_year) | |||
?lexical_entry endp:P5 enwb:Q13; wikibase:lemma ?lemma. | ?lexical_entry endp:P5 enwb:Q13; wikibase:lemma ?lemma. | ||
} group by ?bib_item ?terms | } group by ?bib_item ?authors_year ?title ?terms | ||
</sparql> | </sparql> | ||