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
1
| 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.16 | 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.01 | 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) (102837).
SELECT s_id FROM `mr_smw_fpt_subc` WHERE o_id=102837 LIMIT 1
Query-Depth:1
Limestone blocks
Blocks of solid limestone.
Besides being the second most durable stone type after granite, limestone blocks have no practical advantage over other stone blocks.
Marble blocks
Blocks of solid marble. Marble is a soft, beautiful stone, known for being easy to sculpt.
Of all stone block materials, marble has the highest Beauty factor and stands alone as the sole stone to have a beauty bonus, and so is best suited to create art for your base. It is also a close second in terms of market value per unit of work, after sandstone, so is well suited to craft items for sale in bulk.
Sandstone blocks
Blocks of solid sandstone. Sandstone is a relatively soft rock and chips easily.
Sandstone is the quickest stone type to work with, making it well suited for stone constructions that need to be built quickly. It also has the highest market value per unit of work so is the best stone type for crafting items for sale in bulk.
Slate blocks
Blocks of solid slate. A dull-looking rock that chips easily.
The only advantage of slate blocks is that they are the least heavy. If for some reason you need to carry stone blocks or chunks in a caravan in bulk, slate might be the best choice.
Jade
A hard, green stone. Because of its beauty and rarity, jade is often used for ornaments and decorations. Its hardness and density also makes it a good material for blunt weapons.
Jade is a rare material with high beauty, but with little other purpose.