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:Inscription]] [[script::North Italic script]] [[character variant::Td]]
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, t9.o_hash
FROM
  `lexlep_smw_object_ids` AS t0
INNER JOIN
  (`lexlep_smw_fpt_inst` AS t2
INNER JOIN
  `lexlep_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
  `lexlep_smw_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
  `lexlep_smw_di_blob` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
  `lexlep_smw_di_blob` AS t9 ON t0.smw_id=t9.s_id
WHERE
  (
   ((t4.o_hash='North Italic script') AND t4.p_id=1199499)
   AND (
   (t6.o_hash='Td') AND t6.p_id=776)
  )
   AND (t9.p_id=1199080)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t9.o_hash ASC
LIMIT
  55
OFFSET
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt6refs_id, p_id, o_hash, s_id_2o_hash258const45Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4lexlepwebu54.t6.s_id1Using where
1SIMPLEt4refs_id, p_id, o_hash, s_id_2s_id8lexlepwebu54.t6.s_id, const1Using where
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id_24lexlepwebu54.t6.s_id1Using where; Using index
1SIMPLEt9refs_id, p_id, s_id_2s_id8lexlepwebu54.t6.s_id, const1
1SIMPLEt3eq_refPRIMARYPRIMARY4lexlepwebu54.t2.o_id1Distinct
Auxilliary Tables
  • Temporary table t3
      Recursively computed hierarchy for element(s) (1276).
      SELECT s_id FROM `lexlep_smw_fpt_subc` WHERE o_id=1276 LIMIT 1
Query Metrics
Query-Size:5
Query-Depth:1
Errors and Warnings
None
 TransliterationText directionScript
BG·28.1pit[dextroverseNorth Italic script
BG·29taudextroverseNorth Italic script
BG·30pitdextroverseNorth Italic script
BG·34ụitilidextroverseNorth Italic script
BI·3]ọṭụḳịosdextroverseNorth Italic script
BI·4esonius:urenti/akitu:esonius/ueriounosdextroverseNorth Italic script
BS·1piuon·tadextroverseNorth Italic script
BS·16atlat'udextroverseNorth Italic script
BS·17koplutuṣdextroverseNorth Italic script
CO·25]tiasambiguousNorth Italic script
CO·26stụ[dextroverseNorth Italic script
CO·64.1kiratidextroverseNorth Italic script
CO·65atiakidextroverseNorth Italic script
CO·79uitiliosdextroverseNorth Italic script
MI·7.1ritukaḷosdextroverseNorth Italic script
MI·7.2ḷẹtiusiuilịos/??????????????dextroverseNorth Italic script
MI·12vatdextroverseNorth Italic script
NO·20]ọ[/]ṭọ[]iknos/matopokios/sola/nimoniknạdextroverseNorth Italic script
NO·21.1tanotaliknoi/kuitos/lekatos/anokopokios/setupokios/esanekoti/anareuiśeos/tanotalos/karnitusdextroverseNorth Italic script
NO·21.2takoṣ:toutas:p̣ụ[/]ṇ?ḳ??tesaso:poikaṇịdextroverseNorth Italic script
NO·27komeuioṣ/kalatikn/osdextroverseNorth Italic script
NO·28akluśamo/ụalos/leukur/uritudextroverseNorth Italic script
TI·19iiu·o·tovedextroverseNorth Italic script
TI·41alkouinos/aśkonetidextroverseNorth Italic script
TI·43]ọni:kuimpaḷui:pạḷạdextroverseNorth Italic script
VA·7ateuloipitusdextroverseNorth Italic script
VA·23etudextroverseNorth Italic script
VA·31?ịạtuịṇịdextroverseNorth Italic script
VB·19lutudextroverseNorth Italic script
VB·23kiketu/ṛẹṭalosdextroverseNorth Italic script
VB·27atekua/aśounịdextroverseNorth Italic script
VC·1.2akisios:arkatokok/materekos:toṣ́o/kote:aṭom:teuoχ/tom:koneudextroverseNorth Italic script
VR·3.2utmedextroverseNorth Italic script
VR·26toutorisdextroverseNorth Italic script
VS·1ritiliọ[/]iponiạboustrophedonNorth Italic script