Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Tel'athi]]
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
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=759925)
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
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
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=759925)
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
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id | 5 | const | 108 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Competition siegery repair case composed of tel'athi and sandalwood panels | Besieged (2) , Besieged (1) | true |
Curved wood shaper painted with chevrons | Breaking and Entering/Work Room loot | false |
Dainty tel'athi promise ring inland with emeralds | Great Outdoors, Great Outdoors (5) | |
Dainty tel'athi wedding band inlaid with emeralds | Great Outdoors, Great Outdoors (5) | |
Damascened throwing dagger with a tel'athi hilt shaped like a hooded cobra | Ophyr's Tent | |
Delicate bracelet of interlocking striped seaperch | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Etched tel'athi tailband | Male Persuasion (4) | |
Exquisite haircomb twined in blossoms | Breaking and Entering/Bedroom loot | |
Filigree earrings threaded with beads | Breaking and Entering/Bedroom loot | |
Fine metal pins | Breaking and Entering/Work Room loot | false |
Foliate helm mounted with a stag's antlers | Shiny's Shinies (2) , In Shining Armor | |
Fragile blossom with delicate petals | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Frosted seaglass cowbell inlaid with sea-calves along the rim | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Gaethzen blossom with a short stem | Breaking and Entering/Sanctum loot | false |
HE2020Metals | ||
Hammered toe bells in the shape of 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 | true |
Heart-shaped filigree locket inlaid with chips | Breaking and Entering/Bedroom loot | |
Heavy bracer patterned with geometric cambrinth symbols | Breaking and Entering/Sanctum loot | false |
Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options | ||
Interlocking miniature tridents | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Jade-eyed tel'athi night adder charm | Snake Pit | |
Large crystal prism suspended from a fine chain | Breaking and Entering/Sanctum loot | |
Massive tel'athi battle armor with a lush viridian estrildite set into the chestplate | Bacon Man's Birthday Bash 419 Auction | true |
Metal scissors with wood handles | Breaking and Entering/Work Room loot | false |
Miniature toy crossbow composed of wood | Breaking and Entering/Armory loot | |
Mist grey and emerald tartan greatkilt secured with a tel'athi pin | Finer Things (4) , Finer Things (3) | |
Mist grey thornweave waistcoat with tel'athi toggles | Finer Things (4) , Finer Things (3) | |
Mottled cambrinth wristcuff inlaid with vibrant tel'athi palm trees | Drogor Shrine | true |
Narrow recipe box with hinges | Breaking and Entering/Kitchen loot | |
Nightmare-black leather haversack reinforced with thick tel'athi bands | Order of the White Rose/Gifts and prizes | |
Pair of inky-black leather sandals with tel'athi buckles | Male Persuasion (4) | |
Pocket-sized kaleidoscope | Breaking and Entering/Sanctum loot | |
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 | |
Polished imbuement rod flecked with slivers | Breaking and Entering/Work Room loot | false |
Polished medal encircled by tiny sea 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 | |
Polished shark | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes | true |
Polished steel cheese knife with a whale-shaped handle | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Polished yardstick set with markings | Breaking and Entering/Work Room loot | false |
Portable stove with a fluted grate | Breaking and Entering/Kitchen loot | |
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 | true |
Round sipar with a raised boss | Breaking and Entering/Armory loot | |
Rugged leathers fit with toggles | Breaking and Entering/Armory loot | |
Rusty kitchen pot helm | Breaking and Entering/Kitchen loot | |
Sea urchin mirror with gilding along the spines | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Simple burin with spirals | Breaking and Entering/Work Room loot | false |
Simple razor with a polished wood-handle | Breaking and Entering/Bedroom loot | |
Sinuous tel'athi necklace coiled in the shape of a cobra | Ophyr's Tent | |
Sleek brigandine hauberk riveted with studs | Breaking and Entering/Armory loot | |
Sleek lootpouch fastened with a leviathan | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes |