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
105
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, Allium canadense var. canadense, Allium cepa, Allium fistulosum, Allium nigrum, Allium oleraceum, Allium paniculatum, Allium paniculatum var. paniculatum, Allium rotundum, Allium sativum, Allium sativum var. sativum, Allium schoenoprasum, Allium triquetrum, Allium victorialis, Allium vineale, Aloe, Alstroemeria, Althaea, Althaea cannabina, Althaea hirsuta, Althaea officinalis, Alyssum, Amaranthus, Amaranthus albus, Amaranthus blitum, Amaranthus caudatus, Amaranthus cruentus, Amaranthus deflexus, Amaranthus graecizans, Amaranthus hybridus, Amaranthus hypochondriacus, Amaranthus polygonoides, Amaranthus retroflexus, Amaranthus spinosus, Amaranthus subg. Amaranthus, Amaranthus tricolor, Amaranthus viridis, Ambrosia, Ambrosia artemisiifolia, Ambrosia trifida, Ammannia, Ammannia latifolia, Anagallis, Anagallis arvensis, Anagallis monelli, Andromeda, Andromeda polifolia, Andromeda polifolia var. polifolia, Androsace, Androsace elongata, Androsace septentrionalis