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
100
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
Amelanchier humilis, Amelanchier interior, Amelanchier intermedia, Amelanchier laevis, Amelanchier sanguinea, Amelanchier spicata, Amerorchis rotundifolia, Ammannia robusta, Ammophila, Ammophila breviligulata, Ammophila breviligulata subsp. breviligulata, Ammophila breviligulata subsp. champlainensis, Amphidium lapponicum, Amphidium mougeotii, Anacamptodon splachnoides, Anagallis arvensis, Anaphalis margaritacea, Andreaea rothii, Andreaea rupestris, Andromeda polifolia, Andromeda polifolia var. latifolia, Andromeda polifolia var. polifolia, Andropogon, Andropogon gerardii, Andropogon liebmannii, Andropogon sect. Andropogon, Andropogon sect. Leptopogon, Andropogon virginicus, Andropogon virginicus var. glaucus, Andropogon virginicus var. virginicus, Androsace occidentalis, Androsace septentrionalis, Anemone acutiloba, Anemone americana, Anemone canadensis, Anemone cylindrica, Anemone multifida, Anemone multifida var. multifida, Anemone parviflora, Anemone patens, Anemone patens var. multifida, Anemone quinquefolia, Anemone quinquefolia var. quinquefolia, Anemone virginiana, Anemone virginiana var. alba, Anemone virginiana var. cylindroidea, Anemone virginiana var. virginiana, Anoda cristata, Anomodon attenuatus, Anomodon minor