Semantic search
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_di_blob` AS t1
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Nunavut')
)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 2 | Using temporary; Using filesort | |||
1 | SIMPLE | t1 | ref | s_id,o_hash,s_id_2,p_id | p_id | 262 | mediawiki.t2.id,const | 4 | Using index condition |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | mediawiki.t1.s_id | 1 | Using where |
- Temporary table t2
Recursively computed hierarchy for element(s) ('1221').
SELECT s_id FROM `smw_fpt_subp` WHERE o_id='1221' LIMIT 1
Query-Depth:1
Arctagrostis latifolia subsp. arundinacea, Arctagrostis latifolia subsp. latifolia, Arctanthemum arcticum, Arctanthemum arcticum subsp. polare, Arctophila, Arctophila fulva, Arctostaphylos uva-ursi, Arctous alpina, Arctous rubra, Arenaria humifusa, Armeria maritima, Armeria maritima subsp. sibirica, Arnica angustifolia, Arnica angustifolia subsp. angustifolia, Arnica lonchophylla, Artemisia borealis, Artemisia borealis subsp. borealis, Artemisia borealis subsp. richardsoniana, Artemisia campestris, Artemisia campestris subsp. canadensis, Artemisia frigida, Artemisia furcata, Artemisia tilesii, Atriplex dioica, Aulacomnium acuminatum, Aulacomnium palustre, Aulacomnium turgidum, Bartramia ithyphylla, Bartramia pomiformis, Bartsia alpina, Beckmannia, Beckmannia syzigachne, Bidens hyperborea, Bistorta vivipara, Blindia acuta, Blysmopsis rufa, Brachythecium acutum, Brachythecium cirrosum, Brachythecium turgidum, Braya glabella, Braya glabella subsp. glabella, Braya glabella subsp. purpurascens, Braya humilis, Braya humilis subsp. humilis, Braya thorild-wulffii, Bromus, Bromus caroli-henrici, Bromus commutatus, Bromus hallii, Bromus inermis