Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::dolphin]]OR[[Uses material::Dolphin]]
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
0
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 303 | 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='dolphin')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=69020 - 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 | Rare item |
---|---|---|
Weapon:Abassi (1) | Kilora's Weaponry | |
Item:Aged cherrywood humidor trimmed with a thin golden band | Dunshade: Echo of Tears/End loot | |
Item:Ammolite dolphin icon affixed to a base of Imperial coral | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade | true |
Item:Anloral dolphin pin | Soulful Trinkets (2) , Soulful Trinkets (1) | true |
Item:Aquamarine gem pouch sewn with the image of a dolphins leaping through whitecaps | Treasures of the Spirit (1) | |
Weapon:Arzfilt | Kilora's Weaponry | |
Item:Ayabere-framed window with a center medallion | Pane in the Glass | |
Item:Azure armure cloak clasped by a coral dolphin charm | treasure map | true |
Weapon:Black short bow carved into the shape of a stylized dolphin | Voi's Fine Heirlooms (2) , Voi's Fine Heirlooms (1) | |
Item:Black walnut lyre with bright flamewood carvings inlaid along the crossbar | Item:Sturdy burlap brewer's knapsack with a heavy leather flap | |
Item:Blown-glass "E" pendant suspended from a black leather cord | Initial Idea (2) , Initial Idea (1) | |
Item:Blue velvet gem pouch adorned with a shark, dolphin and an albatross | ||
Weapon:Blue-bladed longsword bearing a dolphin-shaped agate on its pommel | Sputkin's Wagon , Iormethani's Godly Objects (2), Iormethani's Godly Objects (1) | |
Weapon:Blue-bladed longsword bearing a dolphin-shaped dwalgim on its pommel | Sputkin's Splendors (5) , Sputkin's Splendors (4) | |
Item:Blue-grey dolphin pinata | In The Hollow (2) | |
Item:Braided white gold ring set with a large cambrinth dolphin | Forever Faithful (2) , Forever Faithful (1) | |
Weapon:Brass-edged scimitar with a hilt molded into the shape of dolphin | Morum Melgorehn/End loot | |
Item:Bright silver dolphin amulet suspended from a heavy chain | Amulets by Liathe (3) , Amulets by Liathe (1) | |
Item:Bronze anklet inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | |
Item:Bronze armband inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | true |
Item:Bronze cambrinth armband in the shape of a leaping dolphin | Drogor Shrine | true |
Item:Bronze dolphin-shaped amulet | Drogor Shrine | |
Item:Bronze dolphin-shaped circlet | Drogor Shrine | |
Item:Bronze dolphin-shaped necklace | Drogor Shrine | |
Item:Bronze dolphin-shaped pendant | Drogor Shrine | |
Item:Brown leather scribe's rucksack with a darkened silver clasp | Jakuv's All-Trades Outlet (3) , Jakuv's All-Trades Outlet (2), Jakuv's All-Trades Outlet (1) | |
Item:Cambrinth ankle cuff inlaid with grey pearl dolphins to spell ELUNED | Forever Faithful (2) , Forever Faithful (1) | |
Item:Cambrinth armband carved into the shape of interlocked leaping dolphins | ||
Item:Cambrinth dolphin accented with tiny jet eyes | Drathrok's Duskruin 442/Incidental loot , Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 435/Incidental loot, Drathrok's Duskruin 430/Incidental loot, Drathrok's Duskruin 426/Incidental loot | |
Item:Carved bamboo hichiriki banded with pale blue coral | Item:Supple leather case fastened with a coral dolphin , Hollow Eve Festival 414/Raffles, Auction Tent - Ice Festival | true |
Item:Carved featherstone resembling a leaping dolphin | Hollow Eve Festival 436/Raffles | |
Item:Cascading mantle of shimmering sea-hued silk clasped with a silvery grey pearl | Trevellyn's of Leth Deri'el | |
Item:Ceremonial robes of stiff sapphire silk | Visions of Holiness (2) , Visions of Holiness (1) | |
Item:Ceremonial shell necklace suspending a sapphire dolphin | Outer Beauty (2) | |
Item:Cerulean watersilk scroll case secured with a silver clasp | Blood and Gourd (5) | |
Item:Chalcedony prayer beads carved into miniature dolphins | Visions of Holiness (2) | |
Item:Chef's apron stitched with tiny marine animal patterns | Jakuv's All-Trades Outlet (3) , Jakuv's All-Trades Outlet (2), Jakuv's All-Trades Outlet (1) | |
Item:Circlet of creamy pearls looped to fall in cascading tiers | Divinely Dressed | |
Item:Cloisonne dolphin (1) | Heavenly Entrances (1) | |
Item:Clouded glass armband strung with a constellation of tiny stars | Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot | |
Item:Copper cambrinth armband in the shape of a leaping dolphin | Drogor Shrine | true |
Item:Copper dolphin-shaped amulet | Drogor Shrine | |
Item:Copper dolphin-shaped necklace | Drogor Shrine | |
Item:Coralite pin shaped to resemble a leaping dolphin | ||
Item:Coralite-covered sigil tome etched with an aquatic scene | Skyward Crafting (8) | |
Item:Creamy white cotton tabard dyed with the sea green emblem of the dolphin of Eluned on it | Sign of the Crescent Moon (3) , Sable's Tent (2), Sable's (2), Hollow Eve Festival 392/Raffles | |
Item:Crystal cowbell with an adderwood albatross handle | Joys of Noise (6) | |
Item:Crystal sculpture of a leaping dolphin | Sanji Osrel | |
Weapon:Curved scimitar inlaid with a leaping sapphire dolphin | Visions of Holiness (2) , Visions of Holiness (1) | |
Weapon:Damascened throwing dagger with a covellite hilt shaped like a dolphin's head | Ophyr's Tent |