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
`mr_smw_object_ids` AS t0
INNER JOIN
(`mr_smw_fpt_inst` AS t2
INNER JOIN
`mr_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`mr_smw_object_ids` AS t4 ON t2.s_id=t4.smw_id
INNER JOIN
`mr_smw_di_blob` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.smw_sortkey!='Templates')
AND (t5.p_id=2871)
)
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 | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t3 | ALL | PRIMARY | 2 | 100.00 | Using temporary; Using filesort | |||
| 1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | rimworld_wiki_new.t3.id | 42 | 100.00 | Using index |
| 1 | SIMPLE | t4 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | rimworld_wiki_new.t2.s_id | 1 | 70.13 | Using where |
| 1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | rimworld_wiki_new.t2.s_id | 1 | 50.00 | Using where |
| 1 | SIMPLE | t5 | ref | s_id, p_id, s_id_2 | s_id | 8 | rimworld_wiki_new.t2.s_id, const | 1 | 100.00 | Using index; Distinct |
- Temporary table t3
Recursively computed hierarchy for element(s) (15094).
SELECT s_id FROM `mr_smw_fpt_subc` WHERE o_id=15094 LIMIT 1
Query-Depth:1
The remarkably soft wool of an alpaca. It is warm, protects well from heat, and fetches a high price.
Alpaca wool is a type of fabric gathered by animal handlers by shearing tamed alpacas. Alpaca wool is a very good insulator, and is therefore recommended in clothing like parkas and tuques.
Thick and coarse wool of a bison. Quite warm.
Bison wool is a type of fabric gathered by animal handlers by shearing tamed bison.
Cloth woven from organic fibers.
Cloth is a basic plant-based fabric that can be grown by planting the cotton plant. It can be used to create clothing and a few specialty items like carpets. It is 20% more flammable than most other textiles.
Fabric spun from microfibers extracted from devilstrand mushrooms. It is very tough, good at insulating, and protects exceptionally well against flame.
Devilstrand is a valuable fabric obtained from the devilstrand mushroom. It is an extremely strong fabric, much more protective than cloth and most types of leather.
Nano-fibers woven into sheets molecule-by-molecule using specialized production mechanites. While it flexes freely most of the time, it stiffens to absorb blows as they land, and is incredibly difficult to break. The secrets of its production are known only to the most advanced glitterworld cultures.
Hyperweave is a space age, highly protective and rare fabric produced only on high-tech Glitterworlds.
While somewhat coarse, megasloth wool's long fibers make it very strong. It is very warm.
Megasloth wool is a type of fabric gathered by animal handlers by shearing tamed megasloth. Megasloth wool is the second warmest textile in the game, after Guinea pig fur and tied with Thrumbofur, and is essential for colonies on cold biomes like sea ice and ice sheet. It can be hard to obtain lots of it as it takes quite a while for megasloth's to produce the wool (usually only enough to make one parka) and it is rarely sold by traders.
Soft, light and provides very good insulation. Muffalo wool clothes can keep the body warm even in very cold conditions.
Muffalo wool is a type of fabric gathered by animal handlers by shearing tamed muffalos.
Sheep's wool. It provides good insulation.
Sheep wool is a type of fabric gathered by animal handlers by shearing tamed sheep.
Spacer-tech synthetic fabric designed for making ordinary clothes. It is soft, light, strong, and insulates well.
Synthread is a space age type of fabric only available through trading or through random drops.