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
0
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
Acalypha, Acalypha australis, Acalypha virginica, Achillea, Achillea alpina, Achillea millefolium, Achillea nobilis, Achillea ptarmica, Achyranthes, Achyranthes aspera, Achyranthes aspera var. aspera, Aconitum, Aconitum uncinatum, Acorus, Acorus calamus, Acrostichum, Acrostichum aureum, Actaea, Adelia, Adiantum, Adiantum capillus-veneris, Adiantum pedatum, Adonis, Adonis aestivalis, Adonis annua, Adonis vernalis, Agave, Agave americana, Agave americana subsp. americana, Agave americana var. americana, Ageratum, Ageratum conyzoides, Agrimonia, Agrostemma, Agrostemma githago, Agrostemma githago var. githago, Alcea, Alcea rosea, Alchemilla, Alchemilla alpina, Aletris, Aletris farinosa, Alisma, Alisma plantago-aquatica, Allionia, Allionia incarnata, Allionia incarnata var. incarnata, Allium, Allium ampeloprasum, Allium canadense