Semantic search
From CODECS: Online Database and e-Resources for Celtic Studies
Debug output SQLStore
ASK Query
[[Category:Noda]] [[N component has position::Superscript]]
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, t7.o_hash
FROM
`o2a5_smw_object_ids` AS t0
INNER JOIN
(`o2a5_smw_fpt_inst` AS t2
INNER JOIN
`o2a5_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`o2a5_smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`o2a5_smw_di_blob` AS t7 ON t0.smw_id=t7.s_id
WHERE
(
((t4.o_hash='Superscript') AND t4.p_id=2169)
)
AND (t7.p_id=2021)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t7.o_hash ASC
LIMIT
55
OFFSET
31
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, t7.o_hash
FROM
`o2a5_smw_object_ids` AS t0
INNER JOIN
(`o2a5_smw_fpt_inst` AS t2
INNER JOIN
`o2a5_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`o2a5_smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`o2a5_smw_di_blob` AS t7 ON t0.smw_id=t7.s_id
WHERE
(
((t4.o_hash='Superscript') AND t4.p_id=2169)
)
AND (t7.p_id=2021)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t7.o_hash ASC
LIMIT
55
OFFSET
31
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2, o_hash | o_hash | 258 | const | 33 | Using index condition; Using where; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | codecs2023.t4.s_id | 1 | Using where | |
1 | SIMPLE | t7 | ref | s_id, p_id, s_id_2 | s_id | 8 | codecs2023.t4.s_id, const | 1 | ||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 4 | codecs2023.t4.s_id | 1 | Using where; Using index; Distinct | |
1 | SIMPLE | t3 | eq_ref | PRIMARY | PRIMARY | 4 | codecs2023.t2.o_id | 1 | Distinct |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (78487).
SELECT s_id FROM `o2a5_smw_fpt_subc` WHERE o_id=78487 LIMIT 1
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None
spiritus asper
Represents: □h (Irish)
Notational device: Allograph Allograph of: punctum delens (lenition)
Examples in context:
no image available
no image available
no image available
suspension stroke (wavy)
Represents: □()r, □ir, □er, □ar, ir□ (Irish)
Notational device: Allograph Allograph of: suspension strokeExamples in context:
i (superscript), angular variant
Represents: □ri, □ir (Irish)□ri, □ir (Latin)
m stroke
Represents: □m, □um, □()m (Irish)
Examples in context:
no image available
no image available
no image available
no image available
m (superscript allograph)
Represents: □m (Irish)□m (Latin)
Examples in context:
Examples in context:
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
no image available
suspension stroke (double)
Represents: □nn (Irish)
Notational device: Superscript symbol
o (superscript)
Represents: □ro, □or, □oir (Irish)□uo, □()o (Latin)
er (vertical tilde or 'flame')
Represents: □er, □ear, □r (Irish)
a (superscript)
Represents: □ra (Irish)□ra (Latin)
a (superscript rounded)
Represents: □ra (Irish)□ra (Latin)
Examples in context:
e (superscript)
Represents: □er, □re, □e (Irish)□er, □re, □e (Latin)
i (superscript rounded)
Represents: □ri / □ir (Irish)□ri / □ir (Latin)
Notational device: Allograph Allograph of: i (superscript), angular variant
u (superscript rounded)
Represents: □ur, □ru, □uir (Irish)
u (superscript v)
Represents: □ru, □ur, □uir (Irish)
Examples in context:
Examples in context:
ur (superscript wavy)
Represents: □ur, □ru, u□ (rare) (Irish)
s (superscript)
Represents: □s (Irish)
Examples in context:
apostrophe (superscript)
Represents: □s, □()s (Irish)□us, □()s, □() (Latin)
t (superscript)
Represents: □t, □()t (Irish)□t, □()t (Latin)
ur (superscript lemniscate)
Represents: □ur (Irish)□ur, □tur (Latin)
Examples in context:
ur (superscript hook)
Represents: □ur (Irish)□ur (Latin)