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::Brass]]||[[uses material::brass]]
 |?=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::Brass]]||[[uses material::brass]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1968",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses symbol::Brass]] OR [[Uses material::Brass]]

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				1377		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='Brass')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=28192
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
Armor:Polished chain gloves with clawed hands worked into them in brass links
Armor:Polished steel helm embellished with tiny seahorses
Armor:Steel chain greaves bordered by onyx-inlaid brass scales
Armor:Studded leather coat (1)
Armor:Studded leather trousers
Armor:Suit of double ring steel mail with a scale pattern worked in brass links
Armor:Articulated leather breastplate with brass rivets	Bukor's Leatherworks
Weapon:Arzfilt	Kilora's Weaponry
Item:Audrualm hide scraper etched with falling stars	Skyward Crafting (3)	true
Item:Audrualm hide scraper etched with flying gryphons	Skyward Crafting (2) , Skyward Crafting (1)	true
Template:BEMetals
Item:Bamboo repair case with brass hardware	Seastar Curios
Armor:Banded hauberk with interwoven brass and bronze bands	Sleeping Dragon Corn Maze 428/End loot
Item:Basic ebonwood telescope	Konezu's Lenses
Item:Basic silverwillow telescope	Konezu's Lenses
Weapon:Basket-hilted broadsword	Calorak's Weapons and Armor
Weapon:Basket-hilted sword rapier	Edword's Accoutrements (4) , Edword's Accoutrements (3), Edword's Accoutrements (2)
Item:Battered brass cartographer's spyglass	Jakuv's All-Trades Outlet (3) , Jakuv's All-Trades Outlet (2), Jakuv's All-Trades Outlet (1), Item:Grey sharkskin cartographer's toolbag clasped with a brass compass rose, Item:Grey sharkskin cartographer's toolbag clasped with a brass compass rose
Item:Battered brass compass with a cracked crystal	Sutler's Wagon
Item:Battered wicker basket with a wooden lid	Capture the Bag (2)	true
Item:Battlefield painting framed in blackened hickory	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 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot	true
Shield:Beaten brass shield	Wooden Shack, Wooden Shack
Item:Beaten brass vial with an ornately wrought lid	Paper Lion , Moveable Feast, Dusk-winged Duck, Dark Nighttrawler
Weapon:Belaying pin of oak studded with brass beads	Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot
Item:Belt of heavy beaten gold medallions etched with a sunburst design and linked with tiny brass bells	Isfahni's Paradise (1) , Item:Crimson silk pouch beaded with swirls of tiny gold stars, Auction 8/30/2008
Item:Bent brass candelabra encrusted with rich crimson wax	High End Raffle 409
Item:Bent brass sewing needle	House of the Revenant Fang 423/Incidental loot	true
Item:Beribboned watering can	Delightful Decor
Item:Birchwood door inlaid with green gold	Two Doors Down (2) , Two Doors Down (1)	true
Armor:Black and white cowhide leathers with brass rivets	Cowsmoopolitan (4) , Cowsmoopolitan (3)
Item:Black celestial charts foiled with brass	Future is Now (3) , Future is Now (2), Future is Now (1)
Item:Black damask tie set with a tiny brass tack	Hide and Silk (2) , Hide and Silk (1)
Item:Black latten teaspoon with an engraved stem	Snookie's Divine Spoons (3) , Snookie's Divine Spoons (2), Snookie's Divine Spoons (1)
Item:Black leather belt with a dragon buckle	Covered Dragon Wagon	true
Item:Black leather doublet held closed by heavy silver buttons	Item:Doublet of black suede fastened by heavy brass buttons , Bunglefoot's Tent (2), Bunglefoot's Tent (1)	true
Item:Black leather sheath with a brass spike at the cusp
Item:Black leather sheath with a brass throat and tip	Griniel's Cottage
Item:Black leather thigh sheath with an intricate darkened brass collar and tip	Scabbards 'n' Sheaths (2) , Scabbards 'n' Sheaths (1)
Item:Black top hat accented by a brass gear on the band	Hide and Silk (2) , Hide and Silk (1)
Item:Black velvet Hollow Eve trinket stitched with a tiny silver star	Snookie's Holiday Souvenirs (2) , Snookie's Holiday Souvenirs (1)
Item:Black walnut serpent fitted with soft bardic blue leather	Whimsical Winds (1)
Item:Blackened brass gear	Su Helmas: Seeds of Entropy/Incidental loot , Su Helmas: Revealed!/Incidental loot, Su Helmas 444: Make Haste!/Incidental loot, Su Helmas 440: Entrapped/Incidental loot, Su Helmas 438: The Forbidden Temple/Incidental loot, Su Helmas 434: The Forbidden Temple/Incidental loot, Su Helmas 424: The Forbidden Temple/Incidental loot
Armor:Blackened mail greaves embellished with tarnished brass crows	Beyond the Barrier: The Devastation of Lyras/Incidental Loot
Armor:Blackened steel half plate trimmed in tarnished brass	Curse of the Ghost Ship/Incidental Loot
Weapon:Blackened steel longsword with a bone hilt	Droughtman's Challenge 433/Incidental loot , Droughtman's Challenge 430/Incidental loot
Armor:Blackened steel plate with spikes protruding from brass shoulder guards	Goods For The Soul
Item:Blood-red cloak with a deep hood	Explorers' Outfitters (3) , Explorers' Outfitters (2), Explorers' Outfitters (1)	true
Item:Blooming brass dahlia with a rosy copper heart	Cacophony of Silver and Glass (4) , Cacophony of Silver and Glass (2), Cacophony of Silver and Glass (1)
Item:Blue leather togball case	Smash 'Em (2) , Smash 'Em (1)
Item:Blue plaid tip pouch fastened with a brass button	Empath Emporium (4) , Empath Emporium (3), Empath Emporium (2), Empath Emporium (1)	true

Semantic search

Query log

Navigation menu

Search