Semantic search
From CODECS: Online Database and e-Resources for Celtic Studies
Debug output SQLStore
ASK Query
[[Category:Components]]
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_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=2183)
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
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_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=2183)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 93 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | codecs2023.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneImage | Name | Represents | Device | Position | Sign type |
n (regular) | n | Baseline | Alphabetic letter | ||
na (digraph) | na | Digraph | |||
o (open allograph) | o | Allograph | Baseline | Alphabetic letter | |
o (regular letter) | o | Baseline | Alphabetic letter | ||
o (superscript) | □ro, □or, □oir, □uo, □()o | Superscript | Alphabetic letter | ||
Irish ocus, Latin et, etc. (Tironian note) | ocus, agus, et, ead | Baseline | Symbol | ||
oe (ligature with allograph e) | oe | Ligature | |||
p (regular) | p | Baseline | Alphabetic letter | ||
per (p with cross stroke) | per, par, por | Baseline symbol | |||
phi (critical sign) | (marks out verse) | Baseline | Alphabetic letter, Critical sign | ||
punctum delens (lenition) | □h | Superscript | Symbol | ||
punctum delens (nasalisation) | (indicates nasalisation) | Superscript | Symbol, Critical sign | ||
punctums delens (subscript) | (marks symbol for deletion) | Subscript | Symbol, Miscellaneous | ||
punctus superscript (abbreviating device) | miscellaneous | Superscript | Symbol | ||
punctus with comma positura | (marks end of section) | Baseline symbol, Punctuation | |||
q (allograph open) | Allograph | Baseline | Alphabetic letter | ||
q (regular) | cu, cú, q | Baseline | Alphabetic letter | ||
r (regular) | r | Baseline | Alphabetic letter | ||
s (insular) | s | Baseline | Alphabetic letter | ||
s (long) | s | Allograph | Baseline | Alphabetic letter | |
S (short) | S | Baseline | Alphabetic letter | ||
s (superscript) | □s | Superscript | Alphabetic letter | ||
síneadh fada | (length mark) | Superscript | Symbol, Miscellaneous | ||
spiritus asper | □h | Allograph | Superscript | Symbol | |
suspension stroke | □n, □(), n□, ()□ | Superscript | Symbol | ||
suspension stroke (double) | □nn | Superscript symbol | Superscript | Symbol | |
suspension stroke (sinuous) | □ar, □air | Superscript | Symbol | ||
suspension stroke (wavy) | □()r, □ir, □er, □ar, ir□ | Allograph | Superscript | Symbol | |
suspension stroke and punctum delens | □()h, □()he, □aigh(e), □aidh(e), □aibh(e) | Superscript symbol | |||
suspension stroke with m stroke | □nm, □()m | Superscript symbol | |||
t (regular) | t | Baseline | Alphabetic letter | ||
t (superscript) | □t, □()t | Superscript | Alphabetic letter | ||
u (broken) | u | Allograph | Baseline | Alphabetic letter | |
u (regular letter) | u | Baseline | Alphabetic letter | ||
u (rounded allograph) | u, v | Allograph | Baseline | Alphabetic letter | |
u (superscript rounded) | □ur, □ru, □uir | Superscript | Alphabetic letter | ||
u (superscript v) | □ru, □ur, □uir | Superscript | Alphabetic letter | ||
u (superscript) | □ur, □ru, □uir | Superscript | Alphabetic letter | ||
u (v-shaped) | u, v | Allograph | Baseline | Alphabetic letter | |
ur (superscript hook) | □ur | Superscript | Symbol | ||
ur (superscript lemniscate) | □ur, □tur | Superscript | Alphabetic letter | ||
ur (superscript wavy) | □ur, □ru, u□ (rare) | Superscript | Symbol | ||
x (regular) | x, 10, deich, decem | Baseline | Alphabetic letter, Numeral |