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
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Nunavut')
)
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 | t2 | ALL | PRIMARY | 2 | Using temporary; Using filesort | |||
1 | SIMPLE | t1 | ref | s_id,o_hash,s_id_2,p_id | p_id | 262 | mediawiki.t2.id,const | 4 | Using index condition |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | mediawiki.t1.s_id | 1 | Using where |
- Temporary table t2
Recursively computed hierarchy for element(s) ('1221').
SELECT s_id FROM `smw_fpt_subp` WHERE o_id='1221' LIMIT 1
Query-Depth:1
Abietinella abietina, Achillea millefolium, Agrostis, Agrostis anadyrensis, Agrostis mertensii, Agrostis nebulosa, Agrostis scabra, Agrostis tolucensis, Allium schoenoprasum, 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, 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, Arabidopsis arenicola, Arabis alpina, Arctagrostis, Arctagrostis latifolia