Semantic 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
SQLStore debug output
ASK Query
[[Category:Carex]]
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 t1
INNER JOIN
  `t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
  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
  450
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt2ALLPRIMARY110Using temporary; Using filesort
1SIMPLEt1refs_id,o_id,s_id_2,o_id_2o_id_25mediawiki.t2.id12Using index
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4mediawiki.t1.s_id1Using where
Auxilliary Tables
  • Temporary table t2
      Recursively computed hierarchy for element(s) ('192114').
      SELECT s_id FROM `smw_fpt_subc` WHERE o_id='192114' LIMIT 1
Query Metrics
Query-Size:1
Query-Depth:0
Errors and Warnings
None
 Elevation
Carex schweinitzii100–600 m
Carex scirpoidea
Carex scirpoidea subsp. convoluta200 m
Carex scirpoidea subsp. pseudoscirpoidea3300–3900 m
Carex scirpoidea subsp. scirpoidea0–1200 m
Carex scirpoidea subsp. stenochlaena1600–2600 m
Carex scoparia
Carex scoparia var. scoparia0–2000 m
Carex scoparia var. tessellata0–30 m
Carex scopulorum
Carex scopulorum var. bracteosa1200–3000 m
Carex scopulorum var. prionophylla1000–1400 m
Carex scopulorum var. scopulorum3000–4500 m
Carex sect. Acrocystis
Carex sect. Albae
Carex sect. Ammoglochin
Carex sect. Anomalae
Carex sect. Aulocystis
Carex sect. Bicolores
Carex sect. Capituligerae
Carex sect. Carex
Carex sect. Careyanae
Carex sect. Ceratocystis
Carex sect. Chlorostachyae
Carex sect. Chordorrhizae
Carex sect. Circinatae
Carex sect. Clandestinae
Carex sect. Collinsiae
Carex sect. Cyperoideae
Carex sect. Deweyanae
Carex sect. Dispermae
Carex sect. Divisae
Carex sect. Dornera
Carex sect. Filifoliae
Carex sect. Firmiculmes
Carex sect. Foetidae
Carex sect. Glareosae
Carex sect. Glaucescentes
Carex sect. Granulares
Carex sect. Griseae
Carex sect. Hallerianae
Carex sect. Heleoglochin
Carex sect. Hirtifoliae
Carex sect. Hispidae
Carex sect. Holarrhenae
Carex sect. Hymenochlaenae
Carex sect. Inflatae
Carex sect. Lamprochlaenae
Carex sect. Laxiflorae
Carex sect. Leptocephalae