Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Tamboti]]OR[[Uses material::Tamboti]]
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
`smw_object_ids` AS t0
INNER JOIN
`t1` AS t1 ON t0.smw_id=t1.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
10
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
`t1` AS t1 ON t0.smw_id=t1.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
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 82 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE (t2.o_hash='Tamboti')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=479450 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rarity is |
---|---|---|
Item:Exquisite windstorm gossamer recliner set in an ornate stormwood frame | Hollow Eve Festival 436/Auction | auction |
Item:Feathery seaweed fronds dappled with swirls | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Item:Folding chair with a cushioned seat | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Fragile sea globe with a polished base | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Template:HE2020Woods | ||
Item:Heavily fortified warship with a tamboti figurehead | Siegery Shop (5) | |
Item:Helical tamboti cane crowned with a Hav'roth's ambrosia compass rose | Limited Treasures (1) | |
Item:Hollow Eve 439 gift | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439 | end loot |
Talk:Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options | ||
Item:Honed tyrium chisels with carved tamboti handles | Hollow Eve Festival 421/Auction | auction |
Item:Intricate tamboti trinket box | Finer Things (5) | |
Item:Jewelry pest | Mishli , Hollow Eve Festival 447 | gift |
Item:Lacquered abacus strung with polished beads | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Lacquered band set with a tiny clownfish | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Lacquered tamboti oboe with delicate gilt fittings | Lute the Room | |
Item:Lacquered tamboti scroll tube with two braided leather leg straps | Excess Baggage (2) | |
Item:Lacquered tamboti scroll tube with two cobalt silken cord tail straps | Excess Baggage (2) | |
Item:Lacquered tamboti scroll tube with two green silken cord ankle straps | Excess Baggage (2) | |
Item:Lacquered tamboti scroll tube with two steelsilk arm straps | Excess Baggage (2) | |
Item:Large tamboti chest with a circular silver clasp | Hollow Eve Festival 417/Auction | |
Weapon:Large tamboti kelpbell inlaid with anloral | Natural Beauty (2) | |
Item:Large tri-level picnic basket made of lustrous tamboti planks | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Item:Latticed picnic basket tied with sea otters | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | incidental |
Item:Lifesculpted double harp made of shark jaw with a tamboti soundboard | Hollow Eve Festival 414/Auction | auction |
Item:Miniature lemon-scented Teija figurine carrying a massive tamboti armoire | Siegery Shop (2) | |
Item:Miniature turtles | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Pair of dice with shell-shaped pips | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Pilgrim's badge sculpted with the emblem of an Immortal | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | incidental |
Item:Plague doctor's bag of sanguine thornweave structured by a tamboti frame | Limited Treasures (1) | |
Item:Plague doctor's mask of sanguine-streaked black jaspe with a curved tamboti beak | Item:Plague doctor's bag of sanguine thornweave structured by a tamboti frame , Limited Treasures (1) | |
Item:Polished cane entangled by a sprawling kraken | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Polished comb with blossoms in bas-relief | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Polished tamboti box with a circular gold clasp | Quick Bite (4) | festival |
Item:Polished tamboti tapani fitted with gold filigree | Lute the Room | |
Item:Polished tamboti telescope with gold adjustment rings | ||
Item:Polished wand topped with a starfish | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | incidental |
Weapon:Polytheistic war icon set atop a haft of lustrous blood-hued tamboti | Misenseor Goods (6) | |
Item:Portable orichalcum-framed cire lobster trap dangling a defunct tamboti buoy | This Little Piggy (6) | |
Item:Portable tamboti vanity with a white mistglass mirror | Hollow Eve Festival 432/Auction | auction |
Item:Repair case of polished wood with fittings | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | incidental |
Item:Round yo-yo engraved with blossoms | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Weapon:Salt-stained boarding axe with a tamboti haft and a jagged coralite head | Salvage Finds of the Reshal Sea | |
Item:Shallow tamboti mortar carved to look like a leaf | Garden of Plenty | festival |
Weapon:Shark's tooth dagger with a handle of carved tamboti | Natural Beauty (2) | |
Item:Sharpened copper razor with a polished handle | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Short tamboti plank | Finest Box of Gems (3) , Finest Box of Gems (2) | |
Item:Slender kaleidoscope with burnished bands | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Spacious flat-top travel trunk plastered with numerous faded sideshow posters | Limited Treasures (1) | |
Item:Squat barkcloth tree stump covered in dried moss | Hollow Eve Festival 447/Auction | auction |