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

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

JSON CSV RSS RDF

Query log

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

Debug output SQLStore

ASK Query

[[Uses symbol::Loveglass]] OR [[Uses material::Loveglass]]

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				38		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='Loveglass')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=1436290
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
Dusky loveglass Saemaus emblem hung from a ribbon of undyed rosecloth	Sputkin's Splendors (5)	festival
Exquisite crimson loveglass rose with a long narrow stem	Exquisite Treasures	festival
Exquisite loveglass betrothal ring set with a rose-cut dragon's heart ruby	Exquisite Treasures	festival
Exquisite loveglass charm framed with heartstring lace	Exquisite Treasures	festival
Extravagant loveglass lavaliere dangling a lustrous pineapple topaz	Juicy Loot (Shop)	festival
Gleaming vermilion wedding band with sculpted loveglass flames	Exquisite Treasures	festival
Glossy loveglass compact traced with swirls of temptress beryl dust	Aesthene's Close 449/End Loot	end loot
Graceful cerise loveglass orchid with enameled green leaves	Exquisite Treasures	festival
Heart-shaped loveglass token festooned with spun rainbow ribbons	Exquisite Treasures	festival
Loveglass mirror reflecting a S'Kra Mur with iridescent magenta scales	Taisidon Mystery 446/A'baya Esplanade	end loot
Oceanic orichalcum fisherman's badge engraved with a stylized shoreline scene	Hollow Eve Festival 447/Raffles , Hollow Eve Festival 443/Raffles	festival
Pair of polished loveglass cufflinks	Amylia's Attic (3)	festival
Polished cherrywood trinket box inlaid with a loveglass heart	Limited Treasures (5)
Polished loveglass instrument bow	Musiceum (9) , Musiceum (8)	festival
Polished loveglass trinket with beveled edges	Exquisite Treasures	festival
Polished ribbon-stripe picnic basket strung with tiny pink loveglass hearts	Exquisite Treasures	festival
Radiant wedding ring formed out of loveglass petals	Item:Polished cherrywood trinket box inlaid with a loveglass heart
Rose-shaped loveglass cloak pin	Pi'rasha's Pins (3)	festival
Rosy pink loveglass wedding band delicately traced with gold filigree	Exquisite Treasures	festival
Rosy-pink loveglass piccolo adorned with heart-shaped asini keys	Musiceum (9) , Musiceum (8)	festival
Round loveglass vial adorned with a purple tree-shaped label	Everlasting Beauty (3)	festival
Simple wedding band formed from overlapping droplets of blood-red loveglass	Exquisite Treasures	festival
Smooth loveglass box adorned with a brown leaf-shaped label	Everlasting Beauty (3)	festival
Squat loveglass jar adorned with a pink leaf label	Everlasting Beauty (3)	festival
Translucent loveglass band set with a heartstone half note
Translucent loveglass hip-chain strewn with swirling charoite prisms	Limited Treasures (5)	festival
Turquoise watersilk knapsack fringed with tiny loveglass fish	Hollow Eve Festival 443/Raffles	festival
Wide wedding band of crimson loveglass	Item:Polished cherrywood trinket box inlaid with a loveglass heart

Semantic search

Query log

Navigation menu

Search