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 symbol::Marble]]||[[uses material::marble]]
 |?=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 symbol::Marble]]||[[uses material::marble]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0586",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses symbol::Marble]] OR [[Uses material::Marble]]

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
20

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ALL	PRIMARY				225		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='Marble')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=86989
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:4
Query-Depth:1

Errors and Warnings

None

Item	Source is	Rare item
Item:Cambrinth marble (1)	Zenastara's Magical Curios
Weapon:Carved marble and crystal paperweight	Scholar's Museum , Gift Shop	false
Item:Carved marble fireplace with a wrought iron grate	Home for the Fireplace
Item:Carved marble statuette of a dancing Prydaen woman	Beyond the Barrier: The Devastation of Lyras/Incidental Loot
Item:Chipped marble mortar	Random creature drop	true
Item:Chipped statuette of a young Prydaen woman	Beyond the Barrier: The Devastation of Lyras/Incidental Loot
Item:Chubby wire owl charm	Marnie's Elegance In Wire (3) , Marnie's Elegance In Wire (2), Marnie's Elegance In Wire (1)
Item:Columned white-marble fireplace	Frother's Beasts
Weapon:Confectioner's white marble rolling pin with polished oak handles
Item:Cracked marble floor	Amylia's Attic (2)
Item:Creamy marble columnar brazier inset with bouquets of golden lilies	Grate Expectations	true
Item:Cuboid mishar mysanda of polished stone	Hollow Eve Festival 447/Game prizes	true
Item:Cuddly stuffed wolf with heart-shaped eyes and a lolling pink tongue	Tavern Troupe Performing Order/Gifts and prizes , Rakash Moot 441
Item:Dark grey marble sarcophagus decorated with carved vines on the side	Grave New World	true
Weapon:Dark ilglaiks skefne capped with a black marble sphere	Hollow Eve Festival 421/Raffles
Item:Dark marble floor set with specks of white and grey	Haunted House (4) , Haunted House (3)	true
Item:Deep copper-banded firepit	Noble's Barn
Item:Deep green marble table	Knob, Knob
Item:Delicate black marble Demrris figurine	Twansic's Tent (5) , Twansic's Tent (4), Twansic's Tent (3), Twansic's Tent (2), Twansic's Tent (1)
Item:Delicate white marble Tenemlor figurine	Twansic's Tent (5) , Twansic's Tent (4), Twansic's Tent (3), Twansic's Tent (2), Twansic's Tent (1), Grave earth pile 432 prizes, Grave earth pile 428 prizes, Grave earth pile 425 prizes, Grave earth pile 421 prizes, Grave earth pile
Item:Ebonwood walking stick capped with a silver and marble sphere	Walk This Way (2)
Item:Elaborately carved marble fireplace	Knob
Item:Elegant silver belt knife etched with a lute resting on a stand	Quest for Kanton's Dagger
Item:Elliptical morlam mysanda of polished stone	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes	true
Weapon:Enameled lata	Kilora's Weaponry
Item:Etched marble manor charm	Chizelli's Charms (4)
Item:Faded felt backpack dangling a trio of carved black marble road emblems	Hollow Eve Festival 428/Raffles
Item:Fine marble mortar with platinum accents	Drathrok's Duskruin 426/Incidental loot , Drathrok's Duskruin 422/Incidental loot, Drathrok's Duskruin 421/Incidental loot	true
Item:Flecked black marble censer carved with the crest of the Clerics' Guild	Dunshade: Echo of Tears/End loot
Item:Fluted marble jar	Inner Beauty
Weapon:Folded uthamar masamune	House of the Revenant Fang 429/Shadowy Safehouse
Item:Frosted glass table	Knob
Weapon:Glossy white marble rolling pin with felwood handles	Droughtman's Challenge 444/End loot , Droughtman's Challenge 441/End loot, Droughtman's Challenge 437/End loot, Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot	true
Item:Gold marble quatrefoil firepit with a star-pierced brass lid	Grate Expectations
Item:Gold-flecked white marble mortar crafted to resemble a lion's head	On the Mend (1) , Item:Amber leather alchemist's kit graced by a burnished gold lion, Item:Amber leather alchemist's kit graced by a burnished gold lion	true
Item:Gold-veined black marble fireplace with frosted glass doors	Grate Expectations
Item:Green marble mortar carved with welkins	Tool as a Cucumber	true
Item:Green marble mortar with fire-breathing dragons carved about the rim	Survivalist Supplies	false
Item:Green marble mortar with gold inlay	Tool as a Cucumber	true
Item:Green marble pestle carved with welkins	Tool as a Cucumber	true
Item:Green marble pestle painted with the image of a fire-breathing dragon	Survivalist Supplies	false
Item:Green marble pestle with gold inlay	Tool as a Cucumber	true
Item:Green-veined marble mortar	Crin's Herbal Shop	false
Item:Green-veined marble pestle	Crin's Herbal Shop	false
Item:Grimy marble pestle	Random creature drop	false
Template:HE2020Stones
Item:Hammered gold ring set with a miniature marble mortar	Which Craft (1)
Item:Heavy Surlaenis gold marble signet ring embellished with a variety of gems	Hollow Eve Festival 414/Auction
Item:Heavy Surlaenis gold marble signet ring inset with the Trader's Guild crest in Imperial quartz	Owirvald Riverhaven Auction 427
Item:Heavy black marble slab	Argwesh's Alcove

Semantic search

Query log

Navigation menu

Search