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='Ont.') AND t1.p_id='14248')
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 | 3763 | 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
Abies balsamea, Abietinella abietina, Abutilon theophrasti, Acalypha rhomboidea, Acanthospermum hispidum, Acaulon muticum var. rufescens, Acaulon triquetrum, Achillea alpina, Achillea millefolium, Achillea ptarmica, Acorus americanus, Acorus calamus, Acroptilon repens, Actaea pachypoda, Actaea rubra, Adenocaulon bicolor, Adiantum pedatum, Adlumia fungosa, Agalinis gattingeri, Agalinis purpurea, Agalinis purpurea var. parviflora, Agalinis purpurea var. purpurea, Agalinis skinneriana, Agalinis tenuifolia, Ageratina altissima, Ageratina altissima var. altissima, Agoseris glauca, Agoseris glauca var. glauca, Agrimonia gryposepala, Agrimonia parviflora, Agrimonia pubescens, Agrimonia striata, Agropyron, Agropyron cristatum, Agrostemma githago, Agrostemma githago var. githago, Agrostis, Agrostis anadyrensis, Agrostis capillaris, Agrostis gigantea, Agrostis hyemalis, Agrostis mertensii, Agrostis nebulosa, Agrostis perennans, Agrostis scabra, Agrostis stolonifera, Agrostis tolucensis, Alcea rosea, Alchemilla filicaulis, Alchemilla filicaulis subsp. filicaulis