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='Linnaeus') AND t1.p_id='14244')
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
250
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 | 1751 | 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
Canna glauca, Canna indica, Cannabis, Cannabis sativa, Capraria, Capraria biflora, Cardamine, Cardamine bellidifolia, Cardamine hirsuta, Cardamine impatiens, Cardamine parviflora, Cardamine pratensis, Carduus, Carduus acanthoides, Carduus acanthoides subsp. acanthoides, Carduus crispus, Carduus nutans, Carduus pycnocephalus, Carduus pycnocephalus subsp. pycnocephalus, Carex, Carex arenaria, Carex atrata, Carex canescens, Carex canescens subsp. canescens, Carex capillaris, Carex capitata, Carex distans, Carex flava, Carex folliculata, Carex hirta, Carex limosa, Carex loliacea, Carex muricata, Carex pallescens, Carex panicea, Carex pseudocyperus, Carex saxatilis, Carex sect. Carex, Carex squarrosa, Carex vesicaria, Carica, Carica papaya, Carlina, Carlina vulgaris, Carlina vulgaris subsp. vulgaris, Carpinus, Carthamus, Carthamus creticus, Carthamus lanatus, Carthamus tinctorius