Semantic search
From CODECS: Online Database and e-Resources for Celtic Studies
Debug output SQLStore
ASK Query
[[:Id:Bec Loingsech mac Airist]]
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
WHERE
t0.smw_id=2666254
AND 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
0
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
WHERE
t0.smw_id=2666254
AND 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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t0 | const | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | const | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneBec Loingsech mac Airist
Bec(c) ‘the exile’, son of Airist, king of the Romans; in the Acallam na senórach he is said to have attempted the conquest of Ireland but drowned in a great wave that overcame Ireland: he died in the spot that came to be known as the estuary of Bec Loingsech (Inber Bic Loingsig) in Brega, later the site of the monastery of Drogheda (Mellifont Abbey, Co. Louth).
Index: Index: Bec Loingsech mac Airist
See also references for related subjects.