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 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Nunavut') AND t1.p_id='14248')
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 | t1 | ref | s_id,p_id,s_id_2,o_hash | p_id | 262 | const,const | 1055 | Using index condition; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | mediawiki.t1.s_id | 1 | Using where |
Query-Depth:1
Arabidopsis arenicola, Arabis alpina, Arctagrostis, Arctagrostis latifolia, 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, Betula glandulosa, Betula nana, Betula nana subsp. exilis, Betula nana subsp. nana, Betula neoalaskana, Betula occidentalis, Betula papyrifera, Bidens hyperborea, Bistorta vivipara, Blindia acuta, Blysmopsis rufa, Botrychium lunaria, Brachythecium acutum, Brachythecium cirrosum