Semantic search

From Thesaurus Inscriptionum Raeticarum
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]] [[letter height min::≥0 cm]] [[letter height min::≤0.9999 cm]]
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
  `smw_object_ids` AS t0
INNER JOIN
  (`smw_fpt_inst` AS t2
INNER JOIN
  `smw_di_number` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
  `smw_di_number` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=643
   AND (
   (t4.o_sortkey>='0') AND t4.p_id=3697)
   AND (
   (t6.o_sortkey<='0.9999') AND t6.p_id=3697)
  )
  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
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt4ranges_id, p_id, o_sortkey, p_id_2, s_id_2p_id13334Using index condition; Using temporary; Using filesort
1SIMPLEt6refs_id, p_id, o_sortkey, p_id_2, s_id_2s_id_28tirwebspas52.t4.s_id, const1Using where; Using index
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id_29tirwebspas52.t4.s_id, const1Using index
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4tirwebspas52.t4.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:5
Query-Depth:1
Errors and Warnings
None
 letter height min
SZ-2.10.7 cm
SZ-200.7 cm
SZ-290.9 cm
SZ-30.8 cm
SZ-310.6 cm
SZ-330.8 cm
SZ-350.8 cm
SZ-37.10.8 cm
SZ-37.20.8 cm
SZ-39.20.9 cm
SZ-4.10.6 cm
SZ-45.20.9 cm
SZ-480.4 cm
SZ-490.9 cm
SZ-5.10.5 cm
SZ-500.5 cm
SZ-510.9 cm
SZ-520.4 cm
SZ-540.5 cm
SZ-580.4 cm
SZ-60.8 cm
SZ-65.10.6 cm
SZ-65.20.6 cm
SZ-670.8 cm
SZ-680.5 cm
SZ-70.6 cm
SZ-720.9 cm
SZ-740.9 cm
SZ-750.6 cm
SZ-780.8 cm
SZ-79.10.9 cm
SZ-79.20.9 cm
SZ-8.10.9 cm
SZ-800.7 cm
SZ-810.5 cm
SZ-860.8 cm
SZ-9.10.7 cm
SZ-9.20.3 cm
VN-160.9 cm
VN-40.9 cm
VN-7.10.9 cm
VN-90.7 cm
VR-170.8 cm
VR-30.7 cm
VR-70.6 cm
VR-80.8 cm
WE-10.8 cm