Help:SPARQL query service/bahai-library.com

This listing covers mappings in triples to the relevant database field. See also Help:SPARQL query service/examples/en, SPARQL tutorial, and Wikidata query optimization.

Types for subject and object are URI if beginning with "http/s" or if stated; otherwise are literals.

Subject (with database field) Predicate Object (database field)
https://bahai-library.com/author/<authors.URL> http://purl.org/dc/elements/1.1/description authors.AU_HUMAN
https://bahai-library.com/author/<authors.URL> http://purl.org/dc/elements/1.1/description authors.VARIANTS (semi-colon exploded/trimmed)
https://bahai-library.com/author/<authors.URL> http://purl.org/dc/terms/URI authors.REFS (semi-colon exploded/trimmed) (URI type)
https://bahai-library.com/chronology/<chrono.DATE_SORT> http://purl.org/dc/terms/URI "https://bahai-library.com/tags/" + chrono.TAGS_ID semi-colon exploded/trimmed and mapped to tags.TAG_CANONICAL (through `tags.id`)
https://bahai-library.com/chronologycanada/<chronocanada.DATE_SORT> http://purl.org/dc/terms/URI "https://bahai-library.com/tags/" + chronocanada.TAGS_ID semi-colon exploded/trimmed and mapped to space-to-underscore-replaced tags.TAG_CANONICAL (through `tags.id`)
https://bahai-library.com/tags/alltags-<tagtypes.URL> http://purl.org/dc/elements/1.1/description tagtypes.DESCRIPTION
https://bahai-library.com/tags/<space-to-underscore-replaced tagtypes.TAG_CANONICAL> http://purl.org/dc/elements/1.1/title trimmed tagtypes.TAG_HUMAN
https://bahai-library.com/tags/<space-to-underscore-replaced tagtypes.TAG_CANONICAL> http://purl.org/dc/elements/1.1/title semi-colon exploded/trimmed tagtypes.VARIANTS
https://bahai-library.com/tags/<space-to-underscore-replaced tagtypes.TAG_CANONICAL> http://purl.org/dc/elements/1.1/identifier "partial-inventory:" + tagtypes.PHELPS
https://bahai-library.com/tags/<space-to-underscore-replaced tagtypes.TAG_CANONICAL> http://purl.org/dc/elements/1.1/identifier "bahaidata:" + tagtypes.BAHAIDATA
https://bahai-library.com/tags/<space-to-underscore-replaced tagtypes.TAG_CANONICAL> http://purl.org/dc/elements/1.1/subject tags.TYPES semi-colon exploded/trimmed and mapped to tagtypes.NAME (through tagtypes.TYPE)
https://bahai-library.com/tags/<space-to-underscore-replaced tagtypes.TAG_CANONICAL> http://purl.org/dc/terms/URI "https://bahai-library.com/tags/alltags-" + tags.TYPES semi-colon exploded/trimmed and mapped to tagtypes.URL (through tagtypes.TYPE)
https://bahai-library.com/tags/<space-to-underscore-replaced tagtypes.TAG_CANONICAL> http://purl.org/dc/terms/URI tags.REFS (URI type)
https://bahai-library.com/tags/<space-to-underscore-replaced tagtypes.TAG_CANONICAL> http://purl.org/dc/elements/1.1/type "https://bahai-library.com/author/" + authors.URL (through tags.AUTHOR_ID)
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/type catalog.RIS_TYPE
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/identifier catalog.id
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/title "Baha'i Library Online"
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/terms/title trimmed combination of catalog.TITLE_PUNCTUATION, catalog.TITLE_THIS, catalog.SUBTITLE_THIS, catalog.TITLE_TRANSLATION, catalog.TITLE_TRANSLITERATION
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/terms/alternative tag-stripped catalog.TITLE_PARENT_PLAIN
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/terms/isPartOf tag-stripped and trimmed catalog.TITLE_JOURNAL_PLAIN
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/terms/isPartOf trimmed hard-coded journal abbreviation
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/creator Trimmed catalog.AUTHORS_ID semi-colon exploded/trimmed and mapped to combination of authors.NAME_SORT and authors.NAME_FIRST (through authors.id)
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/contributor catalog.CONTRIBS_ID semi-colon exploded/trimmed and mapped to combination of authors.NAME_SORT and authors.NAME_FIRST and hard-coded literals for contributor type (through authors.id)
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/contributor Tag-stripped catalog.VOLUME_ED
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/date Trimmed and hyphen-to-slash-replaced catalog.DATE_THIS
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/terms/bibliographicCitation Trimmed combination of catalog.VOLUME, catalog.PAGE_RANGE, and catalog.PAGE_TOTAL
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/publisher Trimmed combination of catalog.PUB_THIS and catalog.PUB_1ST
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/terms/spatial Combination of catalog.CITY_THIS and catalog.CITY_1ST
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/identifier catalog.PHELPS
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/type Combination of catalog.COLLECTION1, catalog.COLLECTION2, and catalog.COLLECTION3
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/identifier "ISSN:" + catalog.ISSN
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/identifier "ISBN:" + trimmed catalog.ISBN13_THIS
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/identifier "ISBN:" + trimmed catalog.ISBN_THIS
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/identifier "ISBN:" + trimmed catalog.ISBN13_1ST
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/identifier "ISBN:" + trimmed catalog.ISBN_1ST
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/language catalog.LANGUAGES_THIS semi-colon exploded/trimmed and mapped to languages.LANG (through languages.id)
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/terms/relation Trimmed catalog.CROSSREF
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/identifier "doi:" + trimmed catalog.DOI
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/description catalog.AUDIO
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/description catalog.EPUB
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/description catalog.OCLC
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/terms/abstract Tag-stripped catalog.ABSTRACT
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/description Tag-stripped catalog.NOTES
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/terms/description Trimmed catalog.HISTORY
https://bahai-library.com/<catalog.FILE_NAME> http://purl.org/dc/elements/1.1/subject catalog.TAGS_ID semi-colon exploded/trimmed and mapped to tags.TAG_HUMAN (through tags.id)