Semantic search
From CODECS: Online Database and e-Resources for Celtic Studies
Debug output SQLStore
ASK Query
[[Concept:Agents]] [[-For page.Has publication source::Ainm.ie]] OR[[-Pub refers to agents::Ainm.ie]]
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
50
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 104 | 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=223930)
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=223930 - 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
NoneMuircheartach Ó CiongaÓ Cionga (Muircheartach)
(c.1562– c.1639)
King (Murtagh)
Member of an Irish family of bardic poets and scribes, whose services were enlisted by William Bedell for the translation of the Old Testament into Irish.
See more Cú Choigcríche Ó CléirighÓ Cléirigh (Cú Choigcríche)
(d. in or after 1664)
Irish scholar, poet, historian and scribe; one of the so-named ‘Four Masters’.
See more Lughaidh Ó CléirighÓ Cléirigh (Lughaidh)
(c.1580–c.1630)
Irish historian and poet, known best as the author of a ‘biography’ of Aodh Ruadh Ó Domhnaill (Beatha Aodha Ruaidh Uí Dhomhnaill) and as one of the initiators of the ‘Contention of the Bards’; was one of the sons of Mac Con Ó Cléirigh and a cousin of Mícheál Ó Cléirigh.
See more Mícheál Ó CléirighÓ Cléirigh (Mícheál)
(d. 1643)
O'Clery (Michael)
Irish scholar, historian and scribe.
See more Domhnall Ó ColmáinÓ Colmáin (Domhnall)
(c.1645–c.1704)
Irish Catholic priest, author of Párliament na mban.
See more Peadar Ó Conaill [d. 1826]Ó Conaill (Peadar) ... d. 1826
(1755–1826)
O'Connell (Peter)
Irish lexicographer
See more Seán Ó Conaire [ob. 1773]Ó Conaire (Seán) ... ob. 1773
(c.1739–1773)
Irish priest and scholar
See more Tomás Ó ConcheanainnÓ Concheanainn (Tomás)
(d. 2015)
No short description available
See more Aonghus Fionn Ó DálaighÓ Dálaigh (Aonghus Fionn)
(c.1548–c.1602)
also Aonghus Ó Dálaigh Fionn;
See more Peadar Ó DoirnínÓ Doirnín (Peadar)
(c.1700–1769)
Ulster poet and (hedge)schoolmaster.
See more Maghnus Ó DomhnaillÓ Domhnaill (Maghnus)
(d. 1563)
anglicised Manus O’Donnell; chief of the Ó Domhnaill family (O’Donnells); lord of Donegal (since 1537); married to Eleanor Fitzgerald; poet and author; compiled Beatha Cholaim Chille.
See more Maoghnas Ó DomhnaillÓ Domhnaill (Maoghnas)
(c.1900–1965)
No short description available
See more Tadhg Ó DonnchadhaÓ Donnchadha (Tadhg)
(1874–1949)
No short description available
See more Seán Ó DreadaÓ Dreada (Seán)
(c.1770–1840)
Draddy (John)
Irish scribe and sculptor based in Cork.
See more Dáibhí Ó DuibhgeannáinÓ Duibhgeannáin (Dáibhí)
(fl. 1651–1696)
Ó Duibhgeannáin (Dáibhidh)
Irish professional scribe, member of the Ó Duibhgeannáin family.
See more Brian Ó FearghailÓ Fearghail (Brian)
(1715–c.1788)
Irish scribe and agricultural worker.
See more Donnchadh Ó Floinn [d. 1830]Ó Floinn (Donnchadh) ... d. 1830
(d. 1830)
Ó Floinn (Donncha), O'Flynn (Denis)
Donnchadh (Bán) Ó Floinn, Irish scribe, scholar and publisher from Cork.
See more Fearghal Ó GadhraÓ Gadhra (Fearghal)
lord of Cúil Abhainn (Coolavin, Co. Sligo) and patron of the Annals of the Four Masters
See more Fear Flatha Ó GnímhÓ Gnímh (Fear Flatha)
(fl. early 17th century)
Irish poet
See more Tomás Ó GormáinÓ Gormáin (Tomás)
(1732–1809)
Ó Gormáin (Chevalier)
No short description available
See more Brendan O HehirO Hehir (Brendan)
(1927–1991)
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 Pól Ó hUiginnÓ hUiginn (Pól)
(1628–1724)
Higgins (Paul)
Irish Jesuit and scholar, Church of Ireland convert, who was involved in bringing the first Irish translation of the Old Testament to publication.
See more Tadhg Dall Ó hUiginnÓ hUiginn (Tadhg Dall)
(fl. c.1550–c.1591)
Irish bardic poet and scholar, member of the Ó hUiginn family, son of Mathghamhain Ó hUiginn.
See more Diarmuid Ó LaoghaireÓ Laoghaire (Diarmuid)
(1915–2001)
No short description available
See more Mícheál Óg Ó LongáinÓ Longáin (Mícheál Óg)
(1766–1837)
Irish scribe; son of Mícheál mac Peadair Ó Longáin
See more Pól Ó LongáinÓ Longáin (Pól)
(1801–1866)
scribe who was based in Co. Cork and belonged to the Ó Longáin family of scribes; son of Mícheál Óg and brother of Peadar Ó Longáin.
See more Seosamh Ó LongáinÓ Longáin (Seosamh)
(1817–1880)
O'Longan (Joseph)
No short description available
See more Toirdhealbhach Ó MealláinÓ Mealláin (Toirdhealbhach)
(fl.1641–1647)
Ó Mealláin (Tarlach)
Franciscan friar of Brantry (Co. Tyrone), who has been identified as the author of a journal describing the first years (1641-1647) of the Irish Confederate Wars.
See more Lorcán Ó MuireadhaighÓ Muireadhaigh (Lorcán)
(1883–1941)
Murray (Laurence Patrick), Murray (Laurence P.)
Irish Catholic priest (diocese of Armagh), historian, Irish language activist and collector; founder of the magazine An tUltach and co-founder of the County Louth Archaeological Society.
See more Énrí Ó MuirgheasaÓ Muirgheasa (Énrí)
(1874–1945)
Morris (Henry), Mac Róigh (Feargus)
Irish scholar and author, collector of oral traditions.
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 Pádraig Ó PronntaighÓ Pronntaigh (Pádraig)
(d. c.1760)
O'Prunty (Patrick)
Ulster poet and scribe, who in one of his manuscripts gives his name as Pádraig Ua Pronntaigh mhic Néill mhic Seadhain, ó Loch Eírne.
See more Tomás Ó RaghallaighÓ Raghallaigh (Tomás)
(1883–1966)
Irish writer and scholar, professor of Irish at National University of Ireland Galway.
See more Pádraig Ó SiochfhradhaÓ Siochfhradha (Pádraig)
(1883–1964)
An Seabhac
Irish writer, storyteller and teacher, brother of Mícheál Ó Siochfhradha.
See more Eoghan Rua Ó SúilleabháinÓ Súilleabháin (Eoghan Rua)
(1748–1784)
No short description available
See more Éamonn Ó TuathailÓ Tuathail (Éamonn)
(1880–1956)
Irish scholar and collector of folklore.
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 Dermod O'ConnorO'Connor (Dermod)
(?–1732)
Ó Conchubhair (Diarmuid)
No short description available
See more John O'DalyO'Daly (John)
(1800–1878)
Irish author, editor, bookseller and publisher.
See more Michael O'FlanaganO'Flanagan (Michael)
(1876–1942)
Ó Flannagáin (Mícheál)
No short description available
See more Theophilus O'FlanaganO'Flanagan (Theophilus)
(c.1760–1814)
No short description available
See more Brian O'LooneyO'Looney (Brian)
(d. 1901)
Ó Luanaigh (Brian), O'Looney (Bryan)
No short description available
See more Séamus PenderPender (Séamus)
(d. 1990)
No short description available
See more Risteard PluincéadPluincéad (Risteard)
(fl. 1662)
Pluincéad (Risdeard)
Franciscan friar of Trim and compiler of a Latin-Irish dictionary.
See more Anthony RaymondRaymond (Anthony)
(1675–1726)
Irish Protestant minister, scholar and patron of native Irish scholars
See more David RotheRothe (David)
(1573–1650)
Bishop of Ossory
See more Andrew FitzBennet SallSall (Andrew FitzBennet)
(1612–1686)
Irish Jesuit, cousin of Andrew FitzJohn Sall.
See more Andrew FitzJohn SallSall (Andrew FitzJohn)
(1624–1682)
Irish Jesuit, Church of Ireland convert, who was involved in bringing the Irish Bible to publication.
See more
(c.1562– c.1639)
King (Murtagh)
Member of an Irish family of bardic poets and scribes, whose services were enlisted by William Bedell for the translation of the Old Testament into Irish.
See more Cú Choigcríche Ó CléirighÓ Cléirigh (Cú Choigcríche)
(d. in or after 1664)
Irish scholar, poet, historian and scribe; one of the so-named ‘Four Masters’.
See more Lughaidh Ó CléirighÓ Cléirigh (Lughaidh)
(c.1580–c.1630)
Irish historian and poet, known best as the author of a ‘biography’ of Aodh Ruadh Ó Domhnaill (Beatha Aodha Ruaidh Uí Dhomhnaill) and as one of the initiators of the ‘Contention of the Bards’; was one of the sons of Mac Con Ó Cléirigh and a cousin of Mícheál Ó Cléirigh.
See more Mícheál Ó CléirighÓ Cléirigh (Mícheál)
(d. 1643)
O'Clery (Michael)
Irish scholar, historian and scribe.
See more Domhnall Ó ColmáinÓ Colmáin (Domhnall)
(c.1645–c.1704)
Irish Catholic priest, author of Párliament na mban.
See more Peadar Ó Conaill [d. 1826]Ó Conaill (Peadar) ... d. 1826
(1755–1826)
O'Connell (Peter)
Irish lexicographer
See more Seán Ó Conaire [ob. 1773]Ó Conaire (Seán) ... ob. 1773
(c.1739–1773)
Irish priest and scholar
See more Tomás Ó ConcheanainnÓ Concheanainn (Tomás)
(d. 2015)
No short description available
See more Aonghus Fionn Ó DálaighÓ Dálaigh (Aonghus Fionn)
(c.1548–c.1602)
also Aonghus Ó Dálaigh Fionn;
See more Peadar Ó DoirnínÓ Doirnín (Peadar)
(c.1700–1769)
Ulster poet and (hedge)schoolmaster.
See more Maghnus Ó DomhnaillÓ Domhnaill (Maghnus)
(d. 1563)
anglicised Manus O’Donnell; chief of the Ó Domhnaill family (O’Donnells); lord of Donegal (since 1537); married to Eleanor Fitzgerald; poet and author; compiled Beatha Cholaim Chille.
See more Maoghnas Ó DomhnaillÓ Domhnaill (Maoghnas)
(c.1900–1965)
No short description available
See more Tadhg Ó DonnchadhaÓ Donnchadha (Tadhg)
(1874–1949)
No short description available
See more Seán Ó DreadaÓ Dreada (Seán)
(c.1770–1840)
Draddy (John)
Irish scribe and sculptor based in Cork.
See more Dáibhí Ó DuibhgeannáinÓ Duibhgeannáin (Dáibhí)
(fl. 1651–1696)
Ó Duibhgeannáin (Dáibhidh)
Irish professional scribe, member of the Ó Duibhgeannáin family.
See more Brian Ó FearghailÓ Fearghail (Brian)
(1715–c.1788)
Irish scribe and agricultural worker.
See more Donnchadh Ó Floinn [d. 1830]Ó Floinn (Donnchadh) ... d. 1830
(d. 1830)
Ó Floinn (Donncha), O'Flynn (Denis)
Donnchadh (Bán) Ó Floinn, Irish scribe, scholar and publisher from Cork.
See more Fearghal Ó GadhraÓ Gadhra (Fearghal)
lord of Cúil Abhainn (Coolavin, Co. Sligo) and patron of the Annals of the Four Masters
See more Fear Flatha Ó GnímhÓ Gnímh (Fear Flatha)
(fl. early 17th century)
Irish poet
See more Tomás Ó GormáinÓ Gormáin (Tomás)
(1732–1809)
Ó Gormáin (Chevalier)
No short description available
See more Brendan O HehirO Hehir (Brendan)
(1927–1991)
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 Pól Ó hUiginnÓ hUiginn (Pól)
(1628–1724)
Higgins (Paul)
Irish Jesuit and scholar, Church of Ireland convert, who was involved in bringing the first Irish translation of the Old Testament to publication.
See more Tadhg Dall Ó hUiginnÓ hUiginn (Tadhg Dall)
(fl. c.1550–c.1591)
Irish bardic poet and scholar, member of the Ó hUiginn family, son of Mathghamhain Ó hUiginn.
See more Diarmuid Ó LaoghaireÓ Laoghaire (Diarmuid)
(1915–2001)
No short description available
See more Mícheál Óg Ó LongáinÓ Longáin (Mícheál Óg)
(1766–1837)
Irish scribe; son of Mícheál mac Peadair Ó Longáin
See more Pól Ó LongáinÓ Longáin (Pól)
(1801–1866)
scribe who was based in Co. Cork and belonged to the Ó Longáin family of scribes; son of Mícheál Óg and brother of Peadar Ó Longáin.
See more Seosamh Ó LongáinÓ Longáin (Seosamh)
(1817–1880)
O'Longan (Joseph)
No short description available
See more Toirdhealbhach Ó MealláinÓ Mealláin (Toirdhealbhach)
(fl.1641–1647)
Ó Mealláin (Tarlach)
Franciscan friar of Brantry (Co. Tyrone), who has been identified as the author of a journal describing the first years (1641-1647) of the Irish Confederate Wars.
See more Lorcán Ó MuireadhaighÓ Muireadhaigh (Lorcán)
(1883–1941)
Murray (Laurence Patrick), Murray (Laurence P.)
Irish Catholic priest (diocese of Armagh), historian, Irish language activist and collector; founder of the magazine An tUltach and co-founder of the County Louth Archaeological Society.
See more Énrí Ó MuirgheasaÓ Muirgheasa (Énrí)
(1874–1945)
Morris (Henry), Mac Róigh (Feargus)
Irish scholar and author, collector of oral traditions.
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 Pádraig Ó PronntaighÓ Pronntaigh (Pádraig)
(d. c.1760)
O'Prunty (Patrick)
Ulster poet and scribe, who in one of his manuscripts gives his name as Pádraig Ua Pronntaigh mhic Néill mhic Seadhain, ó Loch Eírne.
See more Tomás Ó RaghallaighÓ Raghallaigh (Tomás)
(1883–1966)
Irish writer and scholar, professor of Irish at National University of Ireland Galway.
See more Pádraig Ó SiochfhradhaÓ Siochfhradha (Pádraig)
(1883–1964)
An Seabhac
Irish writer, storyteller and teacher, brother of Mícheál Ó Siochfhradha.
See more Eoghan Rua Ó SúilleabháinÓ Súilleabháin (Eoghan Rua)
(1748–1784)
No short description available
See more Éamonn Ó TuathailÓ Tuathail (Éamonn)
(1880–1956)
Irish scholar and collector of folklore.
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 Dermod O'ConnorO'Connor (Dermod)
(?–1732)
Ó Conchubhair (Diarmuid)
No short description available
See more John O'DalyO'Daly (John)
(1800–1878)
Irish author, editor, bookseller and publisher.
See more Michael O'FlanaganO'Flanagan (Michael)
(1876–1942)
Ó Flannagáin (Mícheál)
No short description available
See more Theophilus O'FlanaganO'Flanagan (Theophilus)
(c.1760–1814)
No short description available
See more Brian O'LooneyO'Looney (Brian)
(d. 1901)
Ó Luanaigh (Brian), O'Looney (Bryan)
No short description available
See more Séamus PenderPender (Séamus)
(d. 1990)
No short description available
See more Risteard PluincéadPluincéad (Risteard)
(fl. 1662)
Pluincéad (Risdeard)
Franciscan friar of Trim and compiler of a Latin-Irish dictionary.
See more Anthony RaymondRaymond (Anthony)
(1675–1726)
Irish Protestant minister, scholar and patron of native Irish scholars
See more David RotheRothe (David)
(1573–1650)
Bishop of Ossory
See more Andrew FitzBennet SallSall (Andrew FitzBennet)
(1612–1686)
Irish Jesuit, cousin of Andrew FitzJohn Sall.
See more Andrew FitzJohn SallSall (Andrew FitzJohn)
(1624–1682)
Irish Jesuit, Church of Ireland convert, who was involved in bringing the Irish Bible to publication.
See more