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::CIL]]
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=2179)
  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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id_39const, const92Using 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
)isoniWord
)iunθanaχaWord
BS·3.1Inscription
CIL V 8111.4.pngFile
MI·7 Cernusco sul NaviglioObject
MI·7.1Inscription
MI·7.2Inscription
Mennella 1992Reference
PV·5Inscription
VC·1.1Inscription
aesiaWord
alkouinosWord
anteśiluWord
ass-Morpheme
ateratosWord
aterioWord
atiloneiWord
aśkonetiWord
aśkonetioWord
biu̯-Morpheme
bog-Morpheme
brist-Morpheme
caledonosWord
dieupalaWord
diuconisWord
dugiauaWord
dut-Morpheme
esopnosWord
inutuWord
kasikosWord
kiketuWord
koiliosWord
koi̯l-Morpheme
komeuiosWord
koplutusWord
kuaśoniWord
kuimpaluiWord
leu̯k-Morpheme
lukiosWord
lutoWord
lutuWord
mako(Word
metaluiWord
minukuWord
musuWord
nemetieśWord
oletuWord
otiuiWord
palaWord
penn-Morpheme