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
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 | 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
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