Semantic search
From CODECS: Online Database and e-Resources for Celtic Studies
Debug output SQLStore
ASK Query
[[Concept:Agents]] [[-For page.Has publication source::ODNB 2004]] OR[[-Pub refers to agents::ODNB 2004]]
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
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, 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
100
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ALL | PRIMARY | 166 | 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 t16.o_id FROM `o2a5_smw_di_wikipage` AS t16 INNER JOIN `o2a5_smw_di_wikipage` AS t18 ON t16.s_id=t18.s_id INNER JOIN `o2a5_t4` AS t4 ON t16.o_id=t4.id WHERE t16.p_id=3882814 AND (t18.p_id=5217780 AND t18.o_id=23839)
INSERT IGNORE INTO `o2a5_t1` SELECT DISTINCT t21.o_id FROM `o2a5_smw_di_wikipage` AS t21 WHERE t21.p_id=2554944 AND t21.s_id=23839 - Temporary table t4
INSERT IGNORE INTO `o2a5_t4` SELECT DISTINCT t5.s_id FROM `o2a5_smw_di_wikipage` AS t5 WHERE t5.p_id=3835477 AND t5.o_id=2554929
INSERT IGNORE INTO `o2a5_t4` SELECT DISTINCT t8.o_id FROM `o2a5_smw_di_wikipage` AS t8 INNER JOIN `o2a5_t9` AS t9 ON t8.p_id=t9.id
INSERT IGNORE INTO `o2a5_t4` SELECT DISTINCT t11.o_id FROM `o2a5_smw_di_wikipage` AS t11 INNER JOIN `o2a5_t12` AS t12 ON t11.p_id=t12.id INNER JOIN `o2a5_smw_di_wikipage` AS t13 ON t11.s_id=t13.s_id WHERE (t13.p_id=3835477 AND t13.o_id=2554929) - Temporary table t9
Recursively computed hierarchy for element(s) (2156058).
SELECT s_id FROM `o2a5_smw_fpt_subp` WHERE o_id=2156058 LIMIT 1 - Temporary table t12
Recursively computed hierarchy for element(s) (2659966).
SELECT s_id FROM `o2a5_smw_fpt_subp` WHERE o_id=2659966 LIMIT 1
Query Metrics
Query-Size:6Query-Depth:2
Errors and Warnings
NoneMáel Muru OthnaMáel Muru Othna
(d. 887)
Máel Muru of Othain
Early Irish poet and historian, who was apparently attached to the monastery of Othain (now Fahan, Inishowen barony, Co. Donegal), as his epithet suggests
See more Máel Sechnaill mac DomnaillMáel Sechnaill mac Domnaill
(d. 1022)
Máel Sechnaill II
King of Mide and high-king of Ireland from the Clann Cholmáin branch of the Uí Néill.
See more Maredudd ab OwainMaredudd ab Owain
(d. 999)
No short description available
See more Narcissus MarshMarsh (Narcissus)
(1638–1713)
English churchman in the Church of Ireland, who served as bishop of Ferns and Leighlin (1683–1689), archbishop of Cashel (1691–1694), archbishop of Dublin (1694–1703) and finally as archbishop of Armagh (1703–1713). He founded Marsh's Library in Dublin.
See more William MauriceMaurice (William)
(d. 1680)
Welsh antiquary, collector of manuscripts
See more Lewis Morris [d. 1765]Morris (Lewis) ... Llewelyn Ddu o Fôn
(1701–1765)
Llewelyn Ddu o Fôn ... d. 1765
Welsh scholar and land surveyor. He and his brother Richard founded the Honourable Society of Cymmrodorion.
See more Fynes MorysonMoryson (Fynes)
(1565/66–1630)
English official, traveller and travel writer born in Lincolnshire, who is best known for his Itenerary (1617),a multi-volume work in which he offers descriptions of and observations on the many lands he visited abroad. This includes an account of his experiences in Ireland, where he had been secretary to Lord Mountjoy, the Lord Deputy of Ireland.
See more Muirchertach mac MuiredaigMuirchertach mac Muiredaig
Muirchertach mac Erca
No short description available
See more Muirchertach mac NéillMuirchertach mac Néill
(d. 943)
Muirchertach na Cochall Craicinin, Muirchertach of the Leather Cloaks
King of Ailech from the Cenél nÉogain, son of Níall Glúndub mac Áeda.
See more Muiredach of KillalaMuiredach of Killala
(supp. fl. early 6th century)
Muiredach mac Echdach, saint associated with Cell Alaid (Killala, Co. Mayo).
See more Robert Morton NanceNance (Robert Morton)
(d. 1959)
No short description available
See more Saint NeotSaint Neot
(d. in or before 878)
Saint associated with St Neot, Cornwall. According to his first Life, he was an English monk of Glastonbury abbey who retreated to a life of isolation and private prayer in what became the location for the foundation of his monastery in Cornwall; his relics are said to have been translated to St Neots, Huntingdonshire.
See more Níall mac EochadaNíall mac Eochada
(d. 1063)
king of Ulaid, son of Eochada mac Ardgair
See more Níall NoígíallachNíall Noígíallach
(supp. fl. 4th/5th century)
Níall mac Echach Muigmedóin
high-king of Ireland in early and medieval Irish tradition
See more NinianNinian
(supp. fl. 5th–6th century)
Saint Ninian
saint, missionary and reputed founder of Candida Casa (Whithorn, Galloway, Scotland).
See more Dáibhí Ó BruadairÓ Bruadair (Dáibhí)
(fl. 1625–c.1698(?))
Ó Bruadair (Dáibhídh), Ó Bruadair (David)
Prolific Irish poet.
See more Eoghan Ó CaoimhÓ Caoimh (Eoghan)
(1656–1726)
Munster poet and scribe.
See more Aonghus Ruadh Ó DálaighÓ Dálaigh (Aonghus Ruadh)
(d. 1617)
Aonghus na n-Aor, an Bard Ruadh, O'Daly (Aengus)
Irish poet; composed a series of satirical verses on Gaelic families that is known collectively as Muintir fhiodhnacha na mionn.
See more Rudhraighe mac Aodha meic Maghnusa Ó DomhnaillÓ Domhnaill (Rudhraighe mac Aodha meic Maghnusa)
(d. 1608)
Brother of Aodh Ruadh Ó Domhnaill.
See more Uilliam Ó DomhnaillÓ Domhnaill (Uilliam)
(d. 1628)
Irish churchman, archbishop of Tuam (Church of Ireland); scholar of Trinity College, Dublin; continued an Irish translation of the New Testament
See more Seaán Mór Ó DubhagáinÓ Dubhagáin (Seaán Mór)
(d. 1372)
Ó Dubhagáin (Seán Mór)
Irish poet and historian.
See more Tomás Ó GormáinÓ Gormáin (Tomás)
(1732–1809)
Ó Gormáin (Chevalier)
No short description available
See more Eochaidh Ó hEodhasaÓ hEodhasa (Eochaidh)
(c.1560–1612)
O'Hussey (Eochaidh)
No short description available
See more Giolla Brighde Ó hEodhusaÓ hEodhusa (Giolla Brighde)
(c.1570(?)–d. 1614)
O'Hussey (Bonaventura), Bonaventura
Irish scholar and poet, who after being trained in Ireland, pursued his theological studies abroad, first at Douai and later at St Anthony's College, Louvain (est. 1607), where he was accepted as friar and later as lecturer by the religious name of Bonaventura; author of an Irish catechism, An teagasg críosdaidhe (1611/1614), the first Catholic work to be printed in Irish; a treatise on Irish grammar and prosody entitled Rudimenta grammaticae Hibernicae; and a number of vernacular poems.
See more Seán Ó NeachtainÓ Neachtain (Seán)
(c.1640–1729)
Naughton (John)
Irish poet, prose writer, and teacher; was born in Co. Roscommon and settled in Dublin.
See more Tadhg Ó NeachtainÓ Neachtain (Tadhg)
(c.1670–c. 1752)
Irish scribe and scholar, son of Seán Ó Neachtain.
See more Toirdhealbhach Luineach Ó NéillÓ Néill (Toirdhealbhach Luineach)
(c.1530–1595)
O'Neill (Turlough Luineach), Ó Néill (Toirdhealbhach Luinneach)
Irish lord, son of Niall Connallach Ó Néill. His mother was Rose, sister to Maghnus Ó Domhnaill.
See more Pilib mac Aodha mic Sheáin mic Aodha Conallaigh Ó RaghallaighÓ Raghallaigh (Pilib mac Aodha mic Sheáin mic Aodha Conallaigh)
(b. 1599–d. in or after 1664)
Irish member of parliament, rebel and military leader based in County Cavan.
See more Aogán Ó RathailleÓ Rathaille (Aogán)
(c.1670–1729)
Ó Rathaille (Aodhagán), O'Rahilly (Egan)
Aogán/Aodhagán Ó Rathaille (Egan O'Rahilly), Irish poet.
See more Eoghan Rua Ó SúilleabháinÓ Súilleabháin (Eoghan Rua)
(1748–1784)
No short description available
See more John O'Brien [of Cloyne]O'Brien (John) ... of Cloyne
(1701–1769)
Ó Briain (Seán) ... of Cloyne
bishop of Cork and Cloyne; compiler of an Irish-English dictionary (publ. 1768)
See more Owain ap HywelOwain ap Hywel
(b. before 929–d. 988)
King of Deheubarth, son of Hywel Dda.
See more George Owen [of Henllys]Owen (George) ... of Henllys
(c.1552–c.1613)
Harry (George Owen)
Welsh clergyman in the Church of England, antiquarian, genealogist and cartographer.
See more Goronwy OwenOwen (Goronwy)
(1723–1769)
Gronwy Ddu
Welsh poet and cleric.
See more Matthew ParkerParker (Matthew)
(1504–1575)
archbishop of Canterbury, antiquarian and patron.
See more Paul AurelianPaul Aurelian
(supp. fl. late 5th/6th century)
British saint known for his legendary career in Wales and Brittany, where he is said to have founded a monastery and episcopate at Saint-Pol-de-Léon, which bears his name.
See more PelagiusPelagius
(fl. c.390–418)
theologian and author, who was identified by contemporaries as being of British origin.
See more PetrocPetroc
(fl. 6th century)
Cornish saint whose cult spread across both Cornwall and Brittany. In Cornwall, he is primarily associated with the foundation at Padstow (Lanwethenek), which relocated to Bodmin; in Brittany, with the community of Saint-Méen.
See more Thomas PhillippsPhillipps (Thomas)
(1792–1872)
Sir Thomas Phillipps, English antiquary and collector of manuscripts
See more Henry PiersPiers (Henry)
(d. 1623)
Perse (Henry)
Anglo-Irish landowner who lived at Tristernagh (Co. Westmeath), the estate of a former monastery that went into disuse during the Dissolution.
See more Richard PolwhelePolwhele (Richard)
(1760–1838)
Cornish clergyman based at Truro, who was also a historian and author of a seven-volume history of Cornwall.
See more Francis PorterPorter (Francis)
(1631/2–1702)
Walter Porter, whose religious name is Francis Porter, was an Irish Franciscan friar associated with St Isidore’s College in Rome;a native of Meath; author of several works of ecclesiastical history.
See more William PrycePryce (William)
(d. 1790)
A medical practitioner based in Redruth, Cornwall, who was also an author on mining and mineralogy, an antiquary and an advocate of the Cornish language.
See more Anthony RaymondRaymond (Anthony)
(1675–1726)
Irish Protestant minister, scholar and patron of native Irish scholars
See more Rhygyfarch ap SulienRhygyfarch ap Sulien
(1056/7–1099)
No short description available
See more Robert of ChichesterRobert of Chichester
(d. 1160?)
Chichester (Robert of)
Bishop of Exeter (elected and consecrated in 1155) in succession to Robert (de) Warelwast; previously a canon of London in Islington and dean of Salisbury.
See more J. Armitage RobinsonRobinson (J. Armitage)
(1858–1933)
priest in the Church of England, dean of Winchester and subsequently of Wells, who was also a scholar and historian.
See more Richard Robinson [first Baron Rokeby]Robinson (Richard) ... first Baron Rokeby
(bap. 1708, d. 1794)
Anglo-Irish churchman, baron Rokeby, Church of Ireland archbishop of Armagh, founder of the Robinson Library in Armagh.
See more William SalesburySalesbury (William)
(c. 1520–c. 1584)
Salusbury (William)
No short description available
See more William ScawenScawen (William)
(1600–1689)
Cornish politician and antiquary. He is author of Antiquities Cornu-Brittanic, an unpublished work on the history and language of Cornwall (even if he did not speak Cornish).
See more
(d. 887)
Máel Muru of Othain
Early Irish poet and historian, who was apparently attached to the monastery of Othain (now Fahan, Inishowen barony, Co. Donegal), as his epithet suggests
See more Máel Sechnaill mac DomnaillMáel Sechnaill mac Domnaill
(d. 1022)
Máel Sechnaill II
King of Mide and high-king of Ireland from the Clann Cholmáin branch of the Uí Néill.
See more Maredudd ab OwainMaredudd ab Owain
(d. 999)
No short description available
See more Narcissus MarshMarsh (Narcissus)
(1638–1713)
English churchman in the Church of Ireland, who served as bishop of Ferns and Leighlin (1683–1689), archbishop of Cashel (1691–1694), archbishop of Dublin (1694–1703) and finally as archbishop of Armagh (1703–1713). He founded Marsh's Library in Dublin.
See more William MauriceMaurice (William)
(d. 1680)
Welsh antiquary, collector of manuscripts
See more Lewis Morris [d. 1765]Morris (Lewis) ... Llewelyn Ddu o Fôn
(1701–1765)
Llewelyn Ddu o Fôn ... d. 1765
Welsh scholar and land surveyor. He and his brother Richard founded the Honourable Society of Cymmrodorion.
See more Fynes MorysonMoryson (Fynes)
(1565/66–1630)
English official, traveller and travel writer born in Lincolnshire, who is best known for his Itenerary (1617),a multi-volume work in which he offers descriptions of and observations on the many lands he visited abroad. This includes an account of his experiences in Ireland, where he had been secretary to Lord Mountjoy, the Lord Deputy of Ireland.
See more Muirchertach mac MuiredaigMuirchertach mac Muiredaig
Muirchertach mac Erca
No short description available
See more Muirchertach mac NéillMuirchertach mac Néill
(d. 943)
Muirchertach na Cochall Craicinin, Muirchertach of the Leather Cloaks
King of Ailech from the Cenél nÉogain, son of Níall Glúndub mac Áeda.
See more Muiredach of KillalaMuiredach of Killala
(supp. fl. early 6th century)
Muiredach mac Echdach, saint associated with Cell Alaid (Killala, Co. Mayo).
See more Robert Morton NanceNance (Robert Morton)
(d. 1959)
No short description available
See more Saint NeotSaint Neot
(d. in or before 878)
Saint associated with St Neot, Cornwall. According to his first Life, he was an English monk of Glastonbury abbey who retreated to a life of isolation and private prayer in what became the location for the foundation of his monastery in Cornwall; his relics are said to have been translated to St Neots, Huntingdonshire.
See more Níall mac EochadaNíall mac Eochada
(d. 1063)
king of Ulaid, son of Eochada mac Ardgair
See more Níall NoígíallachNíall Noígíallach
(supp. fl. 4th/5th century)
Níall mac Echach Muigmedóin
high-king of Ireland in early and medieval Irish tradition
See more NinianNinian
(supp. fl. 5th–6th century)
Saint Ninian
saint, missionary and reputed founder of Candida Casa (Whithorn, Galloway, Scotland).
See more Dáibhí Ó BruadairÓ Bruadair (Dáibhí)
(fl. 1625–c.1698(?))
Ó Bruadair (Dáibhídh), Ó Bruadair (David)
Prolific Irish poet.
See more Eoghan Ó CaoimhÓ Caoimh (Eoghan)
(1656–1726)
Munster poet and scribe.
See more Aonghus Ruadh Ó DálaighÓ Dálaigh (Aonghus Ruadh)
(d. 1617)
Aonghus na n-Aor, an Bard Ruadh, O'Daly (Aengus)
Irish poet; composed a series of satirical verses on Gaelic families that is known collectively as Muintir fhiodhnacha na mionn.
See more Rudhraighe mac Aodha meic Maghnusa Ó DomhnaillÓ Domhnaill (Rudhraighe mac Aodha meic Maghnusa)
(d. 1608)
Brother of Aodh Ruadh Ó Domhnaill.
See more Uilliam Ó DomhnaillÓ Domhnaill (Uilliam)
(d. 1628)
Irish churchman, archbishop of Tuam (Church of Ireland); scholar of Trinity College, Dublin; continued an Irish translation of the New Testament
See more Seaán Mór Ó DubhagáinÓ Dubhagáin (Seaán Mór)
(d. 1372)
Ó Dubhagáin (Seán Mór)
Irish poet and historian.
See more Tomás Ó GormáinÓ Gormáin (Tomás)
(1732–1809)
Ó Gormáin (Chevalier)
No short description available
See more Eochaidh Ó hEodhasaÓ hEodhasa (Eochaidh)
(c.1560–1612)
O'Hussey (Eochaidh)
No short description available
See more Giolla Brighde Ó hEodhusaÓ hEodhusa (Giolla Brighde)
(c.1570(?)–d. 1614)
O'Hussey (Bonaventura), Bonaventura
Irish scholar and poet, who after being trained in Ireland, pursued his theological studies abroad, first at Douai and later at St Anthony's College, Louvain (est. 1607), where he was accepted as friar and later as lecturer by the religious name of Bonaventura; author of an Irish catechism, An teagasg críosdaidhe (1611/1614), the first Catholic work to be printed in Irish; a treatise on Irish grammar and prosody entitled Rudimenta grammaticae Hibernicae; and a number of vernacular poems.
See more Seán Ó NeachtainÓ Neachtain (Seán)
(c.1640–1729)
Naughton (John)
Irish poet, prose writer, and teacher; was born in Co. Roscommon and settled in Dublin.
See more Tadhg Ó NeachtainÓ Neachtain (Tadhg)
(c.1670–c. 1752)
Irish scribe and scholar, son of Seán Ó Neachtain.
See more Toirdhealbhach Luineach Ó NéillÓ Néill (Toirdhealbhach Luineach)
(c.1530–1595)
O'Neill (Turlough Luineach), Ó Néill (Toirdhealbhach Luinneach)
Irish lord, son of Niall Connallach Ó Néill. His mother was Rose, sister to Maghnus Ó Domhnaill.
See more Pilib mac Aodha mic Sheáin mic Aodha Conallaigh Ó RaghallaighÓ Raghallaigh (Pilib mac Aodha mic Sheáin mic Aodha Conallaigh)
(b. 1599–d. in or after 1664)
Irish member of parliament, rebel and military leader based in County Cavan.
See more Aogán Ó RathailleÓ Rathaille (Aogán)
(c.1670–1729)
Ó Rathaille (Aodhagán), O'Rahilly (Egan)
Aogán/Aodhagán Ó Rathaille (Egan O'Rahilly), Irish poet.
See more Eoghan Rua Ó SúilleabháinÓ Súilleabháin (Eoghan Rua)
(1748–1784)
No short description available
See more John O'Brien [of Cloyne]O'Brien (John) ... of Cloyne
(1701–1769)
Ó Briain (Seán) ... of Cloyne
bishop of Cork and Cloyne; compiler of an Irish-English dictionary (publ. 1768)
See more Owain ap HywelOwain ap Hywel
(b. before 929–d. 988)
King of Deheubarth, son of Hywel Dda.
See more George Owen [of Henllys]Owen (George) ... of Henllys
(c.1552–c.1613)
Harry (George Owen)
Welsh clergyman in the Church of England, antiquarian, genealogist and cartographer.
See more Goronwy OwenOwen (Goronwy)
(1723–1769)
Gronwy Ddu
Welsh poet and cleric.
See more Matthew ParkerParker (Matthew)
(1504–1575)
archbishop of Canterbury, antiquarian and patron.
See more Paul AurelianPaul Aurelian
(supp. fl. late 5th/6th century)
British saint known for his legendary career in Wales and Brittany, where he is said to have founded a monastery and episcopate at Saint-Pol-de-Léon, which bears his name.
See more PelagiusPelagius
(fl. c.390–418)
theologian and author, who was identified by contemporaries as being of British origin.
See more PetrocPetroc
(fl. 6th century)
Cornish saint whose cult spread across both Cornwall and Brittany. In Cornwall, he is primarily associated with the foundation at Padstow (Lanwethenek), which relocated to Bodmin; in Brittany, with the community of Saint-Méen.
See more Thomas PhillippsPhillipps (Thomas)
(1792–1872)
Sir Thomas Phillipps, English antiquary and collector of manuscripts
See more Henry PiersPiers (Henry)
(d. 1623)
Perse (Henry)
Anglo-Irish landowner who lived at Tristernagh (Co. Westmeath), the estate of a former monastery that went into disuse during the Dissolution.
See more Richard PolwhelePolwhele (Richard)
(1760–1838)
Cornish clergyman based at Truro, who was also a historian and author of a seven-volume history of Cornwall.
See more Francis PorterPorter (Francis)
(1631/2–1702)
Walter Porter, whose religious name is Francis Porter, was an Irish Franciscan friar associated with St Isidore’s College in Rome;a native of Meath; author of several works of ecclesiastical history.
See more William PrycePryce (William)
(d. 1790)
A medical practitioner based in Redruth, Cornwall, who was also an author on mining and mineralogy, an antiquary and an advocate of the Cornish language.
See more Anthony RaymondRaymond (Anthony)
(1675–1726)
Irish Protestant minister, scholar and patron of native Irish scholars
See more Rhygyfarch ap SulienRhygyfarch ap Sulien
(1056/7–1099)
No short description available
See more Robert of ChichesterRobert of Chichester
(d. 1160?)
Chichester (Robert of)
Bishop of Exeter (elected and consecrated in 1155) in succession to Robert (de) Warelwast; previously a canon of London in Islington and dean of Salisbury.
See more J. Armitage RobinsonRobinson (J. Armitage)
(1858–1933)
priest in the Church of England, dean of Winchester and subsequently of Wells, who was also a scholar and historian.
See more Richard Robinson [first Baron Rokeby]Robinson (Richard) ... first Baron Rokeby
(bap. 1708, d. 1794)
Anglo-Irish churchman, baron Rokeby, Church of Ireland archbishop of Armagh, founder of the Robinson Library in Armagh.
See more William SalesburySalesbury (William)
(c. 1520–c. 1584)
Salusbury (William)
No short description available
See more William ScawenScawen (William)
(1600–1689)
Cornish politician and antiquary. He is author of Antiquities Cornu-Brittanic, an unpublished work on the history and language of Cornwall (even if he did not speak Cornish).
See more
