Semantic search
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
502
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
502
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 110 | Using temporary; Using filesort | |||
1 | SIMPLE | t1 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | mediawiki.t2.id | 12 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | mediawiki.t1.s_id | 1 | Using 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:1Query-Depth:0
Errors and Warnings
None- Carex sect. Longicaules
- Carex sect. Lupulinae
- Carex sect. Macrocephalae
- Carex sect. Mitratae
- Carex sect. Multiflorae
- Carex sect. Nardinae
- Carex sect. Obtusatae
- Carex sect. Ovales
- Carex sect. Paludosae
- Carex sect. Paniceae
- Carex sect. Phacocystis
- Carex sect. Phaestoglochin
- Carex sect. Phyllostachyae
- Carex sect. Physoglochin
- Carex sect. Pictae
- Carex sect. Porocystis
- Carex sect. Racemosae
- Carex sect. Rhynchocystis
- Carex sect. Rostrales
- Carex sect. Rupestres
- Carex sect. Schiedeanae
- Carex sect. Scirpinae
- Carex sect. Scitae
- Carex sect. Shortianae
- Carex sect. Spirostachyae
- Carex sect. Squarrosae
- Carex sect. Stellulatae
- Carex sect. Thuringiaca
- Carex sect. Triquetrae
- Carex sect. Vesicariae
- Carex sect. Vulpinae
- Carex senta (Elevation: 0–3000 m)
- Carex seorsa (Elevation: 0–300 m)
- Carex serpenticola (Elevation: 60–1200 m)
- Carex serratodens (Elevation: 100–1400 m)
- Carex sheldonii (Elevation: 1200–1900 m)
- Carex shinnersii (Elevation: 100–300 m)
- Carex shortiana (Elevation: 10–500 m)
- Carex siccata (Elevation: 0–3600 m)
- Carex silicea (Elevation: 0 m)
- Carex simulata (Elevation: 600–3100 m)
- Carex socialis (Elevation: 50–500 m)
- Carex sparganioides (Elevation: 50–300 m)
- Carex specifica (Elevation: 1200–3500 m)
- Carex spectabilis (Elevation: 300–3500 m)
- Carex specuicola (Elevation: 1100–2000 m)
- Carex spicata (Elevation: 0–300 m)
- Carex spissa (Elevation: lower than 600 m in Calif.)
- Carex sprengelii
- Carex squarrosa (Elevation: 0–1000 m)