The Wiki for Tale 4 is in read-only mode and is available for archival and reference purposes only. Please visit the current Tale 11 Wiki in the meantime.
If you have any issues with this Wiki, please post in #wiki-editing on Discord or contact Brad in-game.
Semantic search
From A Tale in the Desert
Jump to navigationJump to searchDebug output SQLStore
ASK Query
[[Category:Resources]]
SQL Query
SELECT DISTINCT
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
`wikismw_object_ids` AS t0
INNER JOIN
(`wikismw_fpt_inst` AS t1
INNER JOIN
`wikit2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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
50
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
`wikismw_object_ids` AS t0
INNER JOIN
(`wikismw_fpt_inst` AS t1
INNER JOIN
`wikit2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | system | PRIMARY | 1 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 378 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | atitdwiki_tale4.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (21697).
SELECT s_id FROM `wikismw_fpt_subc` WHERE o_id=21697 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneWeight | Bulk | Description | |
---|---|---|---|
Carrot Juice | 1 | 1 | Juice, from carrots. |
Carrots | 1 | 1 | Orange and tasty. |
Cat Nip Mushroom | 1 | 1 | Cat Nip Mushroom |
Cement | |||
Charcoal | 1 | 1 | The main fuel that runs Egypt. |
Chickens | |||
Cistern | |||
Clay | 1 | 1 | Used to make jugs, mortars, and other items. |
Clay Bricks | 1 | 1 | "Made from wet clay bricks. " |
Clay Dome | 1 | 1 | Used to make a Rabbit Hutch. |
Clay Lamp | 1 | 1 | Clay Lamp |
Clay Mortars | 1 | 1 | Used in the construction of a kitchen. |
Cobra Hood Mushroom | |||
Cobra Skin | |||
Cobra's Hood Mushroom | |||
Coconut Meat | 1 | 1 | A basic foodstuff. |
Coconut Tree | |||
Coconut Water | 1 | 1 | A basic foodstuff. |
Coconuts | 1 | 3 | A basic foodstuff. |
Colt's Foot Mushroom | |||
Compound Extract | 1 | 1 | Made in a Chemistry Lab, used in chemistry recipes. |
Copper | 1 | 1 | Copper |
Copper Ore | 1 | 1 | Mined from the ground. |
Copper Pipe | 1 | 1 | Metal pipe made of copper. |
Copper Sheeting | 1 | 1 | Metal sheets made of copper. |
Copper Straps | 1 | 1 | Copper Straps made in a forge. |
Copper Wire | 1 | 1 | Copper metal extruded into wire. |
Crucibles | 1 | 1 | (Made out of a medium stone on a Mason's Bench). |
Crudely Carved Handle | 1 | 1 | Used in the assembly of simple tools. |
Crushed Eggshells | |||
Cut Stone | 1 | 1 | Finely cut blocks of stone. |
Cuttable Gems | |||
Cuttable Stone | 1 | 1 | Dig reward for small projects. |
Dates | 1 | 3 | A tasty fruit. |
Dawn of Ra Fertilizer | Improved flower fertilizer | ||
Dead Ant | 1 | 1 | {{{description}}} |
Dead Tongue Mushroom | |||
Deckle | 1 | 1 | Deckle. |
Dirt | 1 | 1 | Dirt. It's dirty. |
Dowsing Rod | 1 | 1 | Used to find veins of ore. |
Dried Flax | 1 | 1 | Dried, rotted flax. |
Dried Papyrus | 1 | 1 | Dried papyrus. |
Dueling Serpents Mushroom | |||
Dung | 1 | 1 | Produced by sheep and camels, in great quantities |
Dung Rot Mushroom | |||
Earth Light Mushroom | |||
Eggplant | |||
Eggs | 1 | 1 | Eggs |
Ei | 1 | 1 | Eggs |
Eisenerz | 1 | 1 | Mined from the ground. |