Semantic search

From Lexicon Leponticum
Jump to navigationJump to search
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[index::AcS]]
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
  `lexlep_smw_object_ids` AS t0
INNER JOIN
  `lexlep_smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.p_id=1199323 AND t1.o_id=4551772)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  505
OFFSET
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id_39const, const82Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4lexlepwebu54.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
 Category
)iuka(Word
)iunθanaχaWord
)rkomuiWord
-at-Morpheme
-ed-Morpheme
-en-Morpheme
-il(l)-Morpheme
MI·7.2Inscription
MN·1Inscription
NM·2Coin
UD·1Inscription
VC·1.2Inscription
ad-Morpheme
aesiaWord
aged-Morpheme
alk-Morpheme
ambi-Morpheme
amu?Word
ande-Morpheme
anteśiluWord
arimaiWord
at(t)-Morpheme
atepuWord
aśkonetiWord
aśkonetioWord
aśoip(Word
bir(r)-Morpheme
bit-Morpheme
biu̯-Morpheme
bog-Morpheme
buđ-Morpheme
ciamiWord
dut-Morpheme
dēu̯-Morpheme
dī-Morpheme
dūr-Morpheme
ep-Morpheme
gi̯am-Morpheme
gon(n)-Morpheme
iakirWord
iazusWord
in-Morpheme
inutuWord
i̯ant-Morpheme
kass-Morpheme
kat-Morpheme
kint-Morpheme
kituaretosWord
kom-Morpheme
kualuiWord
medi̯-Morpheme
meśiolanoWord
mīn-Morpheme
pauWord
pelkuiWord
pirakosWord
piriχioWord
pli-Morpheme
raneniWord
ređ-Morpheme
rii̯-Morpheme
ritukalosWord
rupelosWord
rēm-Morpheme
rūn-Morpheme
seg-Morpheme
sekeneiWord
sekezosWord
sent-Morpheme
set-Morpheme
seuuonisWord
sipiuWord
siuiliosWord
sunaleiWord
taiWord
tekialuiWord
teromuiWord
teđ-Morpheme
tisiuiWord
ueniaWord
u̯en-Morpheme
u̯ik-Morpheme