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::Star sapphire]]</q>  OR  <q>[[Uses material::Star 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 – 53 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

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

Debug output SQLStore

ASK Query

[[Uses symbol::Star sapphire]] OR [[Uses material::Star 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				53		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='Star 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=80182
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
Elegant silver circlet crested with a triangular star sapphire	Wolf cart
Gold and black star sapphire livery collar displaying a soulstone Imperial star	Merit Badges (4) , Merit Badges (3), Merit Badges (2)	festival
Gold neithrel band embellished with sapphires	Marelien's Memories (2) , Marelien's Memories (1), All Things Bardic (2), All Things Bardic (1)
Gold-hilted hunting sword set with a multi-faceted star sapphire pommelstone	Vishlan's Wares (Crossing), Vishlan's Wares (Crossing)
Inlaid battle axe with a felwood handle	Droughtman's Challenge 426/End loot
Item:Blue star sapphire ring
Item:Burnished gold headpiece accented by cascading ocean-blue sapphires
Item:Carved crystal pick set with a star sapphire
Item:Delicate platinum circlet inlaid with golden filigree and set with a single star sapphire
Item:Gold neithrel band embellished with sapphires
Item:Oval black star sapphire
Item:Pair of hammered silver wristcuffs set with star sapphires in a wheel pattern
Item:Silver neithrel band embellished with sapphires
Item:Silver spiral pendant hung with a deep blue star sapphire teardrop
Item:Smoky grey nightweaver silk handbag clasped with a single star sapphire
Item:Snowflake-shaped sapphire pendant
Item:Twisted gold and silver necklace accented with star sapphires
Item:White gold pendant with an etched star sapphire set into a mirrored backing
Masterfully crafted blued-steel hairpin weighted with darkened star sapphires	Allurana's Allures
Miniature cambrinth faenellica suspended from a twisted silver chain	Thaumaturgic Things (2) , Thaumaturgic Things (1)
Oval black star sapphire	Fallen Angels Clothing (2) , Drathrok's Duskruin 446/Incidental loot, 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 426/Incidental loot
Pair of hammered silver wristcuffs set with star sapphires in a wheel pattern	Obscure Origins
Sanguine thealstone Bloodworm comet haloed in star sapphires	Limited Treasures (5)
Set of shiny silver spoons spangled with star sapphires and scarlet spinels
Silver neithrel band embellished with sapphires	Marelien's Memories (2) , Marelien's Memories (1), All Things Bardic (2), All Things Bardic (1)
Silver spiral pendant hung with a deep blue star sapphire teardrop	Marelien's Memories (2) , Marelien's Memories (1)
Silver tunic pin embellished with a tear-shaped star sapphire
Silver-veined black marble mortar shaped like a panther	On the Mend (1) , Item:Midnight-black silk alchemist's kit clasped by a silver panther	festival
Silver-veined black marble pestle inset with a dark star sapphire teardrop	On the Mend (1) , Item:Midnight-black silk alchemist's kit clasped by a silver panther	festival
Simple silver choker set with an azure star sapphire	Item:Layered glass jewelry box with silver filigree fittings
Slender circlet of silver filigree set with an azure star sapphire	Item:Layered glass jewelry box with silver filigree fittings
Small gath mysanda cut from star sapphire	Hollow Eve Festival 443/Raffles	festival
Smoky grey nightweaver silk handbag clasped with a single star sapphire	Handsome Handbags
Snowflake-shaped sapphire pendant	Auction Tent - Ice Festival	auction
Snowflake-shaped silver pendant	Hollow Eve Festival 414/Raffles
Striking deep turquoise velvet choker with a trailing lace fringe	Damsel In This Dress (5) , Damsel In This Dress (3)
Sturdy iron forging hammer with a six-rayed star sapphire cabochon on its hilt	Hollow Eve Festival 417/Raffles	raffle
Twisted gold and silver necklace accented with star sapphires	Desert Jewels, Desert Jewels
Weapon:Antique swept-hilt rapier
Weapon:Bastard sword of mirror-finished steel with a star sapphire pommel
Weapon:Gold-hilted hunting sword set with a multi-faceted star sapphire pommelstone
White gold pendant with an etched star sapphire set into a mirrored backing	House of the Floating Reed (shop)
Wide silver ring inlaid with alternating square-cut gems	Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2)

Semantic search

Query log

Navigation menu

Search