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::Ss]]
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='Ss') 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_hash258const69Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt4refs_id, p_id, o_hash, s_id_2s_id8lexlepwebu54.t6.s_id, const1Using where
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4lexlepwebu54.t6.s_id1Using 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·43sursinistroverseNorth Italic script
BG·46ụ[ ]?usambiguousNorth Italic script
BI·1lukios/sipioniosdextroverseNorth Italic script
BI·6iouiku/uipiosdextroverseNorth Italic script
BS·15????tiossinistroverseNorth Italic script
BS·17koplutuṣdextroverseNorth Italic script
BS·18pisasinistroverseNorth Italic script
BS·19uasisinistroverseNorth Italic script
CO·15[pli]oiṣ[o]sinistroverseNorth Italic script
CO·24]ṃa[sinistroverseNorth Italic script
CO·25]tiasambiguousNorth Italic script
CO·26stụ[dextroverseNorth Italic script
CO·57sekezossinistroverseNorth Italic script
CO·62zvośorissinistroverseNorth Italic script
CO·68pelesị[dextroverseNorth Italic script
CO·79uitiliosdextroverseNorth Italic script
MI·26pliossinistroverseNorth Italic script
MN·1sekene·i·dextroverseNorth Italic script
NM·4pirakossinistroverseNorth Italic script
NM·7toutiopouossinistroverseNorth Italic script
NM·11kasiloidextroverseNorth Italic script
NM·17kasiosdextroverseNorth 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
PV·1esopnos kepisinistroverseNorth Italic script
TI·21ateratossinistroverseNorth Italic script
TI·36.2tisiui:piuotialui:palasinistroverseNorth Italic script
TI·40komoneos/uarsileossinistroverseNorth Italic script
TI·45.2aụaị:uesa?aị:palasinistroverseNorth Italic script
TI·48.2sendextroverseNorth Italic script
TV·1:pazros:pompeteχuaios/kaialoisosinistroverseNorth Italic script
VA·6pelkui:pruiam:teu:karite:iṣ́os:kaṛite:palaṃsinistroverseNorth Italic script
VA·10kasdextroverseNorth Italic script
VA·28.2asambiguousNorth Italic script
VA·28.3aesiadextroverseNorth Italic script
VB·3.1latumarui:sapsutai:pe:uinom:natomsinistroverseNorth Italic script
VB·4atiossinistroverseNorth Italic script
VB·8sadextroverseNorth Italic script
VB·23kiketu/ṛẹṭalosdextroverseNorth Italic script
VB·28namu/esopniodextroverseNorth Italic script
VR·20apiossinistroverseNorth Italic script
VR·24eskikorikossinistroverseNorth Italic script
VR·29eskikosinistroverseNorth Italic script
VS·3]ristịambiguousNorth Italic script