Semantic search
From CODECS: Online Database and e-Resources for Celtic Studies
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, t27.o_hash
FROM
`o2a5_smw_object_ids` AS t0
INNER JOIN
`o2a5_t1` AS t1 ON t0.smw_id=t1.id
INNER JOIN
`o2a5_smw_di_blob` AS t27 ON t0.smw_id=t27.s_id
WHERE
(t27.p_id=4978056)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t27.o_hash DESC
LIMIT
105
OFFSET
100
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, t27.o_hash
FROM
`o2a5_smw_object_ids` AS t0
INNER JOIN
`o2a5_t1` AS t1 ON t0.smw_id=t1.id
INNER JOIN
`o2a5_smw_di_blob` AS t27 ON t0.smw_id=t27.s_id
WHERE
(t27.p_id=4978056)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t27.o_hash DESC
LIMIT
105
OFFSET
100
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 | |
1 | SIMPLE | t27 | ref | s_id, p_id, s_id_2 | s_id | 8 | codecs2023.t1.id, const | 1 |
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:14Query-Depth:2
Errors and Warnings
NoneContributions to journals
Stokes, Whitley [ed. and tr.], “On the metrical glossaries of the mediaeval Irish”, Beiträge zur Kunde der indogermanischen Sprachen 29 (1893): 1–120.
Internet Archive: <link>
includes: Whitley Stokes, ‘Hibernica: I: The glosses in Palatine 68’, vol. 31 • Whitley Stokes, ‘Hibernica: II. The glosses in the Book of Armagh’, vol. 31 • Whitley Stokes, ‘Hibernica: III. The note in the Würzburg codex Mp. th. f. 61’, vol. 31 • Whitley Stokes, ‘Hibernica: IV. The fragments found in the Reichenau Baeda’, vol. 31 • Whitley Stokes, ‘Hibernica: V. Extracts from Palatine no. 830’, vol. 31 • Whitley Stokes, ‘Hibernica: VII. The notes in Laud 460’, vol. 31 • Whitley Stokes, ‘Hibernica: VI. The glosses in Bodleian 70’, vol. 31
Stokes, Whitley [ed. and tr.], “The Bóroma”, Revue Celtique 13 (1892): 32–124, 299–300.
Internet Archive – 33–124 (first page missing): <link>
Stokes, Whitley [ed. and tr.], “The Battle of Mag Mucrime”, Revue Celtique 13 (1892): 426–474.
Internet Archive: <link>
Stokes, Whitley, “On the linguistic value of the Irish annals”, Transactions of the Philological Society 21 (1888–90, 1891): 365–433.
Internet Archive: <link>
Stokes, Whitley, “Glosses from Turin and Rome”, Beiträge zur Kunde der indogermanischen Sprachen 17 (1891): 133–146.
Internet Archive: <link>
Stokes, Whitley, “On professor Atkinson’s edition of The passions and homilies in the Lebar Brecc”, Transactions of the Philological Society 21 (1888–90, 1891): 203–234.
Internet Archive: <link>
Stokes, Whitley, “On s-stems in the Celtic languages”, Transactions of the Philological Society 21 (1888–90, 1891): 100–111.
Internet Archive: <link>
Stokes, Whitley, “The Voyage of Mael Duin [part 2]”, Revue Celtique 10 (1889): 50–95.
Internet Archive: <link>
Stokes, Whitley, “Correspondence. The Tripartite Life of St Patrick; On Celtic Latinity and the Tripartite Life”, The Academy 34 (1888): 10–11; 354–355.
Internet Archive: <link>
Stokes, Whitley, “Correspondence. The legend of the oldest animals”, The Academy 34 (1888): 241–242.
Internet Archive: <link>
Stokes, Whitley, “Correspondence. St Patrick’s doctrines”, The Academy 34 (1888): 26, 54–55, 104.
Internet Archive: <link>
Stokes, Whitley, “Dr. MacCarthy’s ‘Fragmenta hibernica’”, The Academy 32 (1887): 72–73.
Google Books: <link>
Stokes, Whitley, “A few parallels between the Old-Norse and the Irish literatures and traditions”, Arkiv för nordisk filologi 2 (1885): 339–341.
Internet Archive: <link>
Stokes, Whitley, “Man octipartite: from the Middle-Irish, Cod. Clarend. (Mus. Brit.), vol. xv, fol. 7a, col. 1”, The Academy 26 (1884): 236.
Internet Archive: <link>
Stokes, Whitley, “Curiosities of official scholarship”, The Academy 26 (1884): 219.
Internet Archive: <link>
Stokes, Whitley, “Mélanges: Four new Gaulish inscriptions”, Revue Celtique 5 (1881–1883): 116–121.
Internet Archive: <link>
A revised version of the preface to Stokes 1880 (linked below).
Appended to Liebrecht's review of Stokes' edition of Togail Troí.
Stokes, Whitley, “On the Celtic comparisons in Bopp’s Comparative grammar”, Revue Celtique 3 (1876–1878): 31–39, 152, 512.
Internet Archive: <link>
Stokes, Whitley, “Mélanges: Cornica [1–3]”, Revue Celtique 3 (1876–1878): 85–86, 512.
Internet Archive: <link>
Whitley Stokes, “[Review of: Eugene O'Curry • Brian O'Looney • Joseph Ó Longáin • J. J. Gilbert, Leabhar Breac, the Speckled Book, otherwise styled Leabhar Mór Dúna Doighre, the Great Book of Dun Doighre (1872–1876)]”, in: Henri Gaidoz (ed.), Revue Celtique 3 (1876–1878): 274–278.
Stokes, Whitley, “Mélanges: A conjectural emendation of Pliny”, Revue Celtique 2 (1873–1875): 407.
Internet Archive: <link>
Stokes, Whitley, “Mélanges: The ancient Irish goddess of war: corrections and additions”, Revue Celtique 2 (1873–1875): 489–492.
Internet Archive: <link>
Stokes, Whitley, “Mythological notes”, Revue Celtique 2 (1873–1875): 197–203, 507.
Internet Archive: <link>
Stokes, Whitley [ed. and tr.], “A Middle-Irish homily on S. Martin of Tours”, Revue Celtique 2 (1873–1875): 381–402, 508.
Internet Archive: <link>
Stokes, Whitley, “Mélanges: Mythological notes”, Revue Celtique 1 (1870–1872): 256–262, 502.
comments: These notes continue those in the preface of Whitley Stokes, Three Irish glossaries: Cormac’s Glossary, O’Davoren’s Glossary and a glossary to the Calendar of Oengus the Culdee (1862) and in Whitley Stokes • John O'Donovan, Sanas Chormaic: Cormac’s Glossary (1868) and are continued in Whitley Stokes, ‘Mythological notes’, Revue Celtique 2 (1873–1875).
Internet Archive: <link>
comments: These notes continue those in the preface of Whitley Stokes, Three Irish glossaries: Cormac’s Glossary, O’Davoren’s Glossary and a glossary to the Calendar of Oengus the Culdee (1862) and in Whitley Stokes • John O'Donovan, Sanas Chormaic: Cormac’s Glossary (1868) and are continued in Whitley Stokes, ‘Mythological notes’, Revue Celtique 2 (1873–1875).
Stokes, Whitley, “Le Catholicon de J. Lagadeuc”, Revue Celtique 1 (1870–1872): 395–399.
Internet Archive: <link>
Stokes, Whitley [tr.], “Adamnan’s Vision”, Fraser's Magazine 83 (1871): 184–194. Reprinted in Margaret Stokes, Three months in the Forests of France, London 1895, pp. 265-79.
Internet Archive: <link>
Stokes, Whitley, “A Cornish glossary”, Transactions of the Philological Society 13 (1868–1869): 137–250.
HathiTrust: <link>
Stokes, Whitley, “Accusative plural in the British languages”, Transactions of the Philological Society 13 (1868–1869): 255–256.
HathiTrust: <link>
Stokes, Whitley, “Note on Endlicher’s Gaulish glossary”, Transactions of the Philological Society 13 (1868–1869): 251–254.
HathiTrust: <link>
Pictet, Adolphe, and Whitley Stokes, “Note sur le glossaire gaulois de Endlicher”, Revue Archéologique (NS) 17 (Jan-Jun, 1868): 340–344.
: <link>
Stokes, Whitley, “The Middle-Breton irregular verbs”, Transactions of the Philological Society 12 (1867 [issued 1868]): 114–166.
HathiTrust: <link>
Siegfried, R. T., and Whitley Stokes [ed.], “Miscellanea Celtica”, Transactions of the Philological Society 12 (1867 [issued 1868]): 252–304.
HathiTrust: <link>
Stokes, Whitley, “Remarks on a lately published Middle-Breton mystery”, Transactions of the Philological Society 12 (1867 [issued 1868]): 22–41.
HathiTrust: <link>