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
500
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
Cyperus fuscus, Cyperus haspan, Cyperus iria, Cyperus laevigatus, Cyperus ligularis, Cyperus odoratus, Cyperus papyrus, Cyperus pumilus, Cyperus rotundus, Cyperus squarrosus, Cyperus strigosus, Cyperus subg. Cyperus, Cypripedium, Cyrilla racemiflora, Dalechampia, Dalechampia scandens, Daphne, Daphne laureola, Daphne mezereum, Datisca, Decumaria, Decumaria barbara, Delphinium, Delphinium elatum, Dianthus, Dianthus armeria, Dianthus armeria subsp. armeria, Dianthus barbatus, Dianthus barbatus subsp. barbatus, Dianthus carthusianorum, Dianthus deltoides, Dianthus deltoides subsp. deltoides, Dianthus plumarius, Dianthus plumarius subsp. plumarius, Diapensia, Diapensia lapponica, Digitalis, Digitalis lutea, Digitalis purpurea, Digitalis purpurea subsp. purpurea, Dioscorea, Dioscorea alata, Dioscorea bulbifera, Dioscorea villosa, Diospyros, Diospyros virginiana, Dirca, Dirca palustris, Dodecatheon, Dodecatheon meadia