Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

import-annotation:

Additional annotated data are to be copied during the parsing of a subject

propsep:

The separator between the properties of a result entry

valuesep:

The separator between the values for a property of a result

template:

The name of a template with which to display the printouts

named args:

Name the arguments passed to the template

userparam:

A value passed into each template call, if a template is used

class:

An additional CSS class to set for the list

introtemplate:

The name of a template to display before the query results, if there are any

outrotemplate:

The name of a template to display after the query results, if there are any

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: <q>[[Concept:References]] [[Pub has contributor::Id:Stokes (Whitley)]] [[Type::article]] [[Pub is part of pub::None]] OR [[Class::Subject:publication items]] [[Pub has author::Id:Stokes (Whitley)]] [[Is item in publication.Type::journal volume]]</q>
 |?Class
 |?=Page
 |?Pub has year
 |?Textplain
 |?Title
 |?Pub is contribution
 |?Type
 |?Pub has summary
 |?Pub refers to text
 |?Pub has contributor (author)
 |?Pub reviews
 |?Pub is at
 |?Is item in publication
 |format=plainlist
 |limit=50
 |offset=200
 |link=none
 |sort=
 |order=asc
 |mainlabel=
 |intro=<h3>Contributions to journals</h3>
 |valuesep=;
 |template=Show publication for contributor
 |named args=yes
}}

Results 201 – 209 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "<q>[[Concept:References]] [[Pub has contributor::Id:Stokes (Whitley)]] [[Type::article]] [[Pub is part of pub::None]] OR [[Class::Subject:publication items]] [[Pub has author::Id:Stokes (Whitley)]] [[Is item in publication.Type::journal volume]]<\/q>",
    "query_source": "SMWSQLStore",
    "query_time": "0.0355",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Concept:References]] [[Pub has contributor::Id:Stokes (Whitley)]] [[Type::article]] [[Pub is part of pub::None]] OR [[Class::Subject:publication items]] [[Pub has author::Id:Stokes (Whitley)]] [[Is item in publication.Type::journal volume]]

SQL Query

SELECT DISTINCT
t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`o2a5_smw_object_ids` AS t0
INNER JOIN
`o2a5_t1` AS t1 ON t0.smw_id=t1.id
WHERE
t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
200

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ALL	PRIMARY				209		Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	codecs2023.t1.id	1		Using where

Auxilliary Tables

Temporary table t1
INSERT IGNORE INTO `o2a5_t1` SELECT DISTINCT t4.s_id FROM `o2a5_smw_di_wikipage` AS t4 INNER JOIN (`o2a5_smw_di_wikipage` AS t7 INNER JOIN `o2a5_t8` AS t8 ON t7.p_id=t8.id) ON t4.s_id=t7.s_id INNER JOIN `o2a5_smw_di_blob` AS t10 ON t4.s_id=t10.s_id INNER JOIN `o2a5_smw_di_wikipage` AS t12 ON t4.s_id=t12.s_id WHERE t4.p_id=3835477 AND t4.o_id=4125602 AND (t7.o_id=2661343) AND ((t10.o_hash='article') AND t10.p_id=4978065) AND (t12.p_id=4978060 AND t12.o_id=4978061)
INSERT IGNORE INTO `o2a5_t1` SELECT DISTINCT t16.s_id FROM `o2a5_smw_di_wikipage` AS t16 INNER JOIN `o2a5_smw_di_wikipage` AS t19 ON t16.s_id=t19.s_id INNER JOIN (`o2a5_smw_di_wikipage` AS t22 INNER JOIN `o2a5_smw_di_blob` AS t24 ON t22.o_id=t24.s_id) ON t16.s_id=t22.s_id WHERE t16.p_id=3835477 AND t16.o_id=2489295 AND (t19.p_id=4978047 AND t19.o_id=2661343) AND (t22.p_id=2485349 AND ((t24.o_hash='journal volume') AND t24.p_id=4978065))
Temporary table t8
Recursively computed hierarchy for element(s) (1796067).
SELECT s_id FROM `o2a5_smw_fpt_subp` WHERE o_id=1796067 LIMIT 1

Query Metrics

Query-Size:14
Query-Depth:2

Errors and Warnings

None

Contributions to journals

Corrigenda et addenda: O'Davoren's glossary

Stokes, Whitley, “Corrigenda et addenda: O'Davoren's glossary”, Archiv für celtische Lexikographie 3 (1907): 55.

Internet Archive: <link>

Nachträge und Verbesserungen

Stokes, Whitley, “Nachträge und Verbesserungen [Bänden I–II]”, Archiv für celtische Lexikographie 3 (1907): 327–329 (I), 329–333 (II).

Internet Archive: <link>

The training of Cúchulain

Stokes, Whitley [ed. and tr.], “The training of Cúchulain”, Revue Celtique 29 (1908): 109–152, 312–314 (add. and corr.).

CELT – edition: <link> CELT – translation: <link> Internet Archive: <link> Internet Archive: <link>

Miscellen 2. Notes on the second edition of the Martyrology of Oengus, London 1905

Stokes, Whitley, “Miscellen 2. Notes on the second edition of the Martyrology of Oengus, London 1905”, Zeitschrift für celtische Philologie 6 (1908): 235–242.

Internet Archive: <link>

Old Irish glosses at Laon

Stokes, Whitley, “Old Irish glosses at Laon”, Revue Celtique 29 (1908): 269–270.

Internet Archive: <link>, <link>

Gaelic glosses

Stokes, Whitley [ed. and tr.], “Gaelic glosses”, The Celtic Review 5:20 (April 1909, 1908–1909): 291–294.

Internet Archive – The Celtic Review 5: <link>

Tidings of Conchobar mac Nessa

Stokes, Whitley [ed. and tr.], “Tidings of Conchobar mac Nessa”, Ériu 4 (1910): 18–38.

Corrigenda

Stokes, Whitley, and H. d'Arbois de Jubainville, “Corrigenda”, Revue Celtique 17 (1896): 458–459.

Internet Archive: <link>

Errata du tome XI

Stokes, Whitley, H. d'Arbois de Jubainville, and Kuno Meyer, “Errata du tome XI”, Revue Celtique 12 (1891): 179.

Internet Archive: <link> Internet Archive: <link>