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: <q> <q>[[Uses symbol::Rainbow sapphire]]</q>  OR  <q>[[Uses material::Rainbow sapphire]]</q> </q>
 |?Source is
 |?Rarity is
 |format=table
 |limit=50
 |offset=10
 |sort=
 |order=asc
 |mainlabel=Item
 |default=None yet
 |sep=,&nbsp;
}}

Results 11 – 60 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "<q> <q>[[Uses symbol::Rainbow sapphire]]<\/q>  OR  <q>[[Uses material::Rainbow sapphire]]<\/q> <\/q>",
    "query_source": "SMWSQLStore",
    "query_time": "0.0366",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses symbol::Rainbow sapphire]] OR [[Uses material::Rainbow sapphire]]

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
10

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ALL	PRIMARY				72		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='Rainbow sapphire')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=526723
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	Rarity is
Delicate chain bracelet sparkling with tiny rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Elegantly styled wirework circlet centered with a trilliant-cut rainbow sapphire	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Fancy friendship ring displaying a pair of square-cut rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Floor-length organza skirt belted with rainbow sapphires	All That Glitters	festival
Fluted silver wedding torque with square rainbow sapphire-inlaid terminals	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Fragile milk glass torque draping acenite chains scattered with rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3)
Gleaming musical notes carved from faceted rainbow sapphires	Item:Oversized minstrel's satchel crafted from treasureweave , Limited Treasures (4)
Glittery diamond-hide whip dangling with heart-shaped rainbow sapphire charms	Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage	end loot
Glorious goldweave doughnut purse drizzled with rainbow sapphire sprinkles	Puffs of Glitter (2) , Puffs of Glitter (1)
Golden stud earring set with a trillion-cut rainbow sapphire	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Hibiscus-pink hummingbird with iridescent plumage	Tildi's Blooms (2)
High-waisted whitleather skirt tailored for a slim fit	Explorers' Outfitters (3) , Explorers' Outfitters (2), Explorers' Outfitters (1)	festival
Hollow Eve 439 gift	Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439	end loot
Huge rencate dye case inlaid with winged rainbow sapphire pigs	Item:Colorful Imperial weave satchel clasped with a winged rencate and rainbow sapphire pig , Bacon Man's Birthday Bash 419 Auction	auction
Ilithic applewood trinket box edged with rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3)
Knife-edged oath ring gypsy-set with three rainbow sapphires	Item:Simple parcel wrapped with cobalt-blue paper , Shimmer Shack (4), Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Leather-trimmed brushed steel armband flush-set with a trio of rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Length of sunset-yellow bourde	Shard's South Bridge Street Faire 415 raffle center
Low-backed ivory raw silk gown with a white gold halter neck	Explorers' Outfitters (3) , Explorers' Outfitters (2), Explorers' Outfitters (1)	festival
Lustrous bangle of flame-kissed gold gypsy-set with rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Lustrous platinum nuptial band with a magnificent cathedral-set rainbow sapphire	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Narrow rencate bauble coffer inlaid with rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3)
Narrow rose gold toe-ring dangling a rainbow sapphire bead	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Narrow wedding toe-ring set with a prominent oval-cut rainbow sapphire	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Niniam-belled bandeau top of multihued silveress with off-the-shoulder sleeves	Limited Treasures (1)
Pair of brushed steel bracers displaying large rainbow sapphire cabochons	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Pair of pendent rainbow sapphire earrings	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Pallid whitleather cloak clasped with a whirl-cut rainbow sapphire	Explorers' Outfitters (3) , Explorers' Outfitters (2), Explorers' Outfitters (1)	festival
Perfectly matched pair of whirl-cut rainbow sapphires	Bacon Man's Birthday Bash 419/Pig Maze
Platinum engagement ring set with an antique miner-cut rainbow sapphire	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Polychromatic silveress pantaloons with a niniam and rainbow sapphire belt	Limited Treasures (1)
Promise ring comprised of linked rose gold hearts set with rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Pyramid-shaped Elven gold jewelry chest	Shimmer Shack (4) , Shimmer Shack (3)
Rainbow sapphire		incidental
Rainbow sapphire amulet strung upon an Elven silver chain	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Rainbow sapphire ring spiral-set in gold	Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage, Drathrok's Duskruin 442/Drathrok's Assemblage, Aesthene's Close 449/End Loot	end loot
Rencate bracer graced by interlocking wildling spiders	Accents for the Arachnophile (7)
Sensational indigo thornweave tailcoat embellished with spun rainbow	Wedding Belles (2) , Wedding Belles (1)
Series of blue gold armbands lit by rainbow sapphires and indicolite tourmalines	Item:Small stately blue gold jewel safe , Shimmer Shack (4), Shimmer Shack (3)
Shaggy unicorn slippers with tiny rainbow sapphire horns	Sleepwalkers (5)	festival
Shimmery coralite trident embellished with rainbow sapphire starfish	Piralpa Tridents (3)
Silky blue lance stitched with tiny rainbow sapphires	Shard's South Bridge Street Faire 415 raffle center
Silver and gold nib pen topped with a faceted rainbow sapphire	Scribbles (2) , Scribbles (1)
Silvery-black wire chest harness weighted by kertig's tears and rainbow sapphires	Item:Small kertig's tear meteorite , Shimmer Shack (4), Shimmer Shack (3)
Sleek blued steel bonding ring bead-set with an array of rainbow sapphires	Item:Simple box wrapped with green paper , Shimmer Shack (4), Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Slender girdle of delicate filigree twined around rose-cut rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Slim velvet choker suspending a rainbow sapphire caged in rose gold	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)
Small ring box of white acenite	Shimmer Shack (4) , Shimmer Shack (3)
Smooth cherrywood repair case displaying a single rainbow sapphire	Shard's South Bridge Street Faire 415 raffle center
Spiraling crystal wristcuff adorned with an array of rainbow sapphires	Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1)

Semantic search

Query log

Navigation menu

Search