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=0
 |sort=
 |order=asc
 |mainlabel=Item
 |default=None yet
 |sep=,&nbsp;
}}

Results 1 – 50 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.0414",
    "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
0

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
Weapon:Abassi (1)	Kilora's Weaponry
Item:Adorable white bunny figure displaying sharp fangs	Greeter Gifts
Item:Arched white marble fireplace inlaid with matching jasper and emerald willows	Flowering Furniture (3) , Flowering Furniture (2), Flowering Furniture (1)	true
Weapon:Arzfilt	Kilora's Weaponry
Template:BEStones
Item:Black marble anvil amulet hanging from a darkened steel chain	Amulets by Liathe (6) , Amulets by Liathe (5)
Item:Black marble archway	Haunted House (4) , Haunted House (3)	true
Item:Black marble fireplace with a gilded mantle	Noble's Barn
Item:Black marble mortar engraved with coiling vipers	Thieves' Guild Shop (Crossing) , Ambika's NightCrafts	false
Item:Black marble mortar painted with a shimmering silver web	Thorkim Family Farm 429/Pig Maze	true
Item:Black marble mortar speckled with tiny silver veins	Beyond the Barrier: The Devastation of Lyras/Incidental Loot	true
Item:Black marble mortar with birds carved about the rim	Lyr's Tent	true
Item:Black marble pestle	Thieves' Guild Shop (Crossing) , Game of Chicken 425 prizes, Ambika's NightCrafts, Alchemist's Corner	false
Item:Black marble pestle speckled with tiny silver veins	Item:Black marble mortar speckled with tiny silver veins , Beyond the Barrier: The Devastation of Lyras/Incidental Loot	true
Item:Black marble spheres	Flight of Hand (2) , Flight of Hand (1)
Item:Black marble writing slate	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:Black-veined white marble fireplace flanked with ornately carved lions	Grate Expectations
Weapon:Blackened steel gladius capped with a marble sphere	Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot
Item:Blue marble brazier resting in an ornately chiseled base	Grate Expectations	true
Breaking and Entering/Rooms and Loot/Material options
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

Semantic search

Query log

Navigation menu

Search