Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[uses material::kertig]]
 |?=Item#-
 |?Source is
 |?Rare item
 |format=table
 |limit=50
 |offset=20
 |sort=
 |order=asc
 |mainlabel=Item
 |default=None yet
 |sep=,&nbsp;
}}

Results 21 – 70 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[uses material::kertig]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0305",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses material::Kertig]]

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=86807)
  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
20

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	index_merge	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	o_id,o_id_3	5,9		244		Using intersect(o_id,o_id_3); 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:2
Query-Depth:1

Errors and Warnings

None

Item	Source is	Rare item
Weapon:Deadly star-kissed kertig dart shrouded by umbral veins of maelstone	Hollow Eve Festival 443/Auction , Item:Ashen enaada wrist cuff with intricate blackened moonsilver mechanism	true
Item:Decorative kertig pocket-chain suspending an anvil-shaped fob	Knightly Attire (1)
Item: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
Weapon:Double-edged kertig gladius with a bloodmist garnet inlaid crossguard	Sleeping Dragon Corn Maze 428/End loot
Weapon:Double-ended kertig trident	Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 438/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage	true
Weapon:Dwarven iron bracer studded with kertig spikes	Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Sleeping Dragon Corn Maze 436/End loot, Sleeping Dragon Corn Maze 432/End loot, Sleeping Dragon Corn Maze 428/End loot, Sleeping Dragon Corn Maze 425/End loot
Item:Dwarven miner's boots secured by kertig and Gemfire ruby buckles	Return to the Keep 423/Supply Wagon
Item:Dwarven miner's boots with kertig toe caps	Droughtman's Challenge 426/Incidental loot
Weapon:Dwarven war hammer with an anvil-shaped kertig head	treasure map, Item:Worn and tattered map	true
Weapon:Ebony battle crossbow with a kertig prod	Droughtman's Challenge 426/Incidental loot
Item:Elegant long-stemmed smokewood pipe banded in kertig	Item:Elegant smokewood humidor with a Fortune's Star diamond closure
Elegant sana'ati khurmary depicting the singers of the Ru'atin Peri'el
Item:Elegant smokewood humidor with a Fortune's Star diamond closure	Guildfest 412/Auction
Weapon:Firestained cleaver falchion with a carmine leather wrapped grip	Sleeping Dragon Corn Maze 428/End loot
Weapon:Firestained kertig bola linked by a silversteel chain	Sleeping Dragon Corn Maze 425/End loot
Weapon:Firestained kertig bola linked by an indurium chain	Sleeping Dragon Corn Maze 428/End loot
Weapon:Folded tyrium and kertig katana with an elaborately watermarked blade	Hollow Eve Festival 399 Auction, Item:Gloomwood katana sheath wrapped in braided shadesatin dyed a deep wine red , Hollow Eve Festival 399/Auction, Item:Gloomwood katana sheath wrapped in braided shadesatin dyed a deep wine red
Item:Forging hammer detailed to resemble a fierce bear's maw	Skyward Crafting (3)	true
Item: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
Item:Frigid icesteel wand with a miniature scythe-shaped tip	Return to the Keep 423/Supply Wagon
Item: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
Weapon:Glaes and kertig-alloy katana capped with an ornate dragonfire amber pommel	Item:Steel katana sheath wrapped in dragonfire brocade cords , Hollow Eve Festival 403/Auction
Item:Green zibeline wool war kilt with a kertig buckle	Su Helmas 444: Make Haste!/Incidental loot , Su Helmas 440: Entrapped/Incidental loot, Su Helmas 438: The Forbidden Temple/Incidental loot	true
Weapon:Grey Raven warden's axe embellished with kertig banding	Item:Grey Raven warden's ring crafted in polished kertig , Item:Grey Raven warden's ring crafted in polished kertig
Item:Grey Raven warden's ring crafted in polished kertig	Hollow Eve Festival 406/Auction
Template:HE2020Metals
Item:Hammered gold flask adorned with kertig chasing and an Imperial topaz	treasure map, Item:Worn and tattered map	true
Item: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
Weapon:Heavy concussive baton crafted from kertig-studded Dwarven iron	No Guts , No Gory (3)
Weapon:Heavy flail with a spiked kertig head	Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Sleeping Dragon Corn Maze 436/End loot, Sleeping Dragon Corn Maze 432/End loot, Sleeping Dragon Corn Maze 428/End loot	true
Weapon:Heavy kertig mace shaped like a raised fist	Guildfest 409/Auction
Weapon:Heavy kertig mace shaped like a raised fist (2)
Item:Heavy kertig rings graced with spears of fractured zephyr's heart	Fancybeards (3) , Fancybeards (2), Fancybeards (1)	true
Weapon:Heavy mace with a kertig head carved to resemble a coiled dragon	treasure map, Item:Worn and tattered map	true
Talk:Hollow Eve Festival 436/Game prizes
Hollow Eve Festival 436/Game prizes/Material options
Armor:Hulking battle plate embellished with inlays of kertig	Sleeping Dragon Corn Maze 428/End loot
Weapon:Imbricated hurlable war hammer forged from a marbled vardite-kertig alloy	Sleeping Dragon Corn Maze 447/End loot , Aesthene's Close 449/End Loot	true
Item:Indigo dragonar thigh bag with a kertig clasp carved into a snarling coyote	Limited Treasures (1)
Item:Interlocking miniature tridents	Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Barbarian's earring carved from kertig to resemble a tiny forge
Item:Decorative kertig pocket-chain suspending an anvil-shaped fob
Item:Grey Raven warden's ring crafted in polished kertig
Item:Hammered gold flask adorned with kertig chasing and an Imperial topaz
Item:Ivory-handled forging hammer with a circular kertig head
Item:Kertig earring set with a large molten diamond
Item:Kertig prayer bead chain interspersed with faceted black diamond beads
Item:Kertig rifflers shaped like jagged lightning bolts
Item:Kertig ring set with a massive cloud ruby
Item:Kertig ring set with a massive morleenite

Semantic search

Query log

Navigation menu

Search