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='Nunavut') 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 | 1055 | 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
Abietinella abietina, Achillea millefolium, Agrostis, Agrostis anadyrensis, Agrostis mertensii, Agrostis nebulosa, Agrostis scabra, Agrostis tolucensis, Allium schoenoprasum, Alnus alnobetula, Alnus alnobetula subsp. crispa, Aloina brevirostris, Aloina rigida var. rigida, Alopecurus, Alopecurus magellanicus, Amaranthus retroflexus, Amblyodon dealbatus, Amblystegium serpens, Amerorchis rotundifolia, Amphidium lapponicum, Amphidium mougeotii, Andreaea blyttii, Andreaea obovata, Andreaea rupestris, Andromeda polifolia, Andromeda polifolia var. polifolia, Androsace chamaejasme, Androsace chamaejasme subsp. lehmanniana, Androsace septentrionalis, Anemone parviflora, Anemone richardsonii, Anomobryum julaceum, Antennaria alpina, Antennaria friesiana, Antennaria friesiana subsp. friesiana, Antennaria microphylla, Antennaria monocephala, Antennaria monocephala subsp. angustata, Antennaria rosea, Antennaria rosea subsp. confinis, Antennaria rosea subsp. pulvinata, Anthoxanthum, Anthoxanthum arcticum, Anthoxanthum hirtum, Anthoxanthum monticola, Anthoxanthum monticola subsp. alpinum, Anthoxanthum monticola subsp. monticola, Anthoxanthum nitens, Anthoxanthum occidentale, Aplodon wormskioldii