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='Proc. Amer. Acad. Arts') AND t1.p_id='1211')
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,o_hash,s_id_2,p_id | o_hash | 258 | const | 695 | Using index condition; Using where; 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
Abutilon berlandieri, Abutilon malacum, Abutilon palmeri, Abutilon parishii, Abutilon reventum, Acamptopappus, Acamptopappus shockleyi, Acamptopappus sphaerocephalus, Acamptopappus sphaerocephalus var. sphaerocephalus, Achyronychia, Achyronychia cooperi, Adolphia californica, Allium bolanderi, Allium bolanderi var. bolanderi, Allium brandegeei, Allium campanulatum, Allium fimbriatum, Allium fimbriatum var. fimbriatum, Allium geyeri, Allium geyeri var. geyeri, Allium haematochiton, Allium lacunosum, Allium lacunosum var. lacunosum, Allium lemmonii, Allium macrum, Allium madidum, Allium nevii, Allium parishii, Allium parryi, Allium platycaule, Allium plummerae, Allium scilloides, Alsia, Alsia californica, Amaranthus blitoides, Amaranthus greggii, Amaranthus palmeri, Amaranthus powellii, Amaranthus wrightii, Ambrosia pumila, Ancistrocarphus, Ancistrocarphus filagineus, Anemone occidentalis, Anemone oregana, Anemone oregana var. oregana, Anoda abutiloides, Anoda reticulata, Anoda thurberi, Antennaria flagellaris, Antennaria stenophylla