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
[[Category:Word]]
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_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.o_id=1170)
  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, s_id_2, o_id_2o_id_25const653Using index; Using 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:1
Query-Depth:0
Errors and Warnings
None
WordWord typeTranslationStatusLanguage
)??ipaitit(undeterminableunknownunknown
)??paiei?undeterminableundeterminableuncertainunknown
)?anundeterminableunknownunknown
)?ele(undeterminableundeterminableprobableunknown
)?rkimu(undeterminableunknownLepontic
)?uka(undeterminableunknownprobableunknown
)ae?(undeterminableunknownuncertainunknown
)ais(undeterminableunknownunknown
)aki??iosproper noun'°ak??ios'Celtic
)akle(undeterminableunknownunknown
)akur(undeterminableunknownLepontic
)aluiproper noun'for the son of ...'Celtic
)aniuiproper noun'for °anios'Celtic
)apauatosnoununknownCeltic
)arsuproper noun'°arsu'Celtic
)auśiprob. nounundeterminableCeltic
)ei(undeterminableunknownunknown
)enaprob. nounundeterminableCeltic
)euprob. noununknownCeltic
)ias(undeterminableunknownunknown
)iknosproper noun"son of (...)"Cisalpine Gaulish
)ioniosproper noun'(son) of °iu'Celtic
)iponiaproper noun']iponia'uncertainCeltic
)isoniproper noun'for °isu'Celtic
)iuka(prob. proper noun"(...)iuka"?Celtic
)iunθanaχaprob. proper noununknownunknown
)kicrisiproper noun'of Kikrisos'unlikelyunknown
)kioneiproper noun'for °kiu' or 'for °kionis'Celtic
)kiφisiproper noun'of Kibisos'unlikelyLepontic
)m(undeterminableunknownunknown
)mit(undeterminableunknownunknown
)miu(undeterminableunknownunknown
)nundeterminableunknownunknown
)n?k??tesasonoun-Cisalpine Gaulish
)neiproper nounundeterminableerroneousCeltic
)ner(undeterminableunknownunknown
)nerio?o(undeterminableunknownprobableunknown
)niproper noun'for °u'Celtic
)nialuiproper noun'for the son of °nios'Celtic
)onesnounundeterminableunknown
)oniproper noun'for °ū'Celtic
)onisnounundeterminableCeltic
)osik(undeterminableunknownprobableunknown
)otukiosproper noun'(son) of °otuk(i)os' (?)uncertainCeltic
)ouki?(undeterminableunknownunknown
)pa(undeterminableunknownunknown
)pat(undeterminableunknownuncertainunknown
)pet(undeterminableunknownuncertainunknown
)peuesaproper noun')peuesa'probableCisalpine Gaulish
)piośaprob. proper noununknowndubiousCeltic