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::lightning]]
 |?Source is
 |?Rare item
 |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": "[[Uses symbol::lightning]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0383",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses symbol::lightning]]

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
(`smw_di_blob` AS t1
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
(
   (t1.o_hash='lightning')
  )
  AND 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	Extra
1	SIMPLE	t2	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t1	ref	s_id, p_id, o_hash, s_id_2	p_id	262	drwiki.t2.id, const	13	Using index condition
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t1.s_id	1	Using where

Auxilliary Tables

Temporary table t2
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None

Item	Source is	Rare item
Armor:Pair of white leather gloves embroidered along the cuffs with yellow lightning bolts
Armor:Pair of white platemail gauntlets set with a small disc
Armor:Pair of white-tinted mail gloves set with a small disc
Armor:Shining golden suit of plate armor engraved with webwork patterns of lightning bolts
Armor:Sturdy seordmaor-hide leathers embossed with a pattern of cascading lightning bolts
Armor:Suit of finely woven golden battle mesh
Armor:Suit of golden plate-reinforced mail engraved with forked lightning bolts
Armor:White balaclava with yellow tinted links that form a lightning bolt
Armor:White field plate armor set with a disc on the chest
Armor:White helm engraved with lightning bolts around the crown
Armor:White leather hood embroidered with yellow lightning bolts
Armor:White leathers embroidered with yellow lightning bolts
Armor:White suede tunic lined with chainmail
Articulated gold bracer studded with cambrinth lightning bolts	War and Craft (2) , War and Craft (1)
Atulave amulet carved with jagged lightning bolts	Harawep Shrine 425 , Harawep Shrine 421
Battle axe engraved with lightning bolts	Hollow Eve Festival 410/Raffles
Belted sash of windstorm gossamer accented with a stormfire topaz medallion
Black and blue ringed competition shortbow	Premium raffles
Black and silver plaid kilt fastened by a silver lightning bolt pin	Griniel's Cottage
Black gauntlets trimmed in platinum	Acaph's Acquisitions
Black leather thigh quiver stitched with a snarling grey wolf	Premium raffles
Black leather vest fastened with tiny silver lightning bolts	Griniel's Cottage
Black prayer mat stitched with a forked bolt of bluefire velvet lightning	Idon Abide the Ten (3) , Idon Abide the Ten (2), Idon Abide the Ten (1)
Black prayer mat stitched with a three bolts of bluefire velvet lightning	Tieheq with the Thirteen (3) , Tieheq with the Thirteen (2), Tieheq with the Thirteen (1)
Black silk cord strung with a golden bolt of forked lightning	Idon Abide the Ten (3) , Idon Abide the Ten (2), Idon Abide the Ten (1)
Black silk cord strung with three gold lightning bolts	Tieheq with the Thirteen (4) , Tieheq with the Thirteen (3), Tieheq with the Thirteen (2), Tieheq with the Thirteen (1)
Black silk robe embroidered with an intricate pattern of silver lightning bolts and trimmed with a ruff of grey owl feathers	Trevellyn's of Leth Deri'el
Blackened chain armor patterned with a cascade of silver lightning bolts	War and Craft (2) , War and Craft (1)
Blackened full double leathers painted with lightning bolts surrounding a shrew	Griniel's Cottage
Blackened leather hood edged with a row of lightning bolts	Griniel's Cottage
Blackened steel short sword etched with a silver lightning bolt	Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot
Blackened tower shield emblazoned with a brightly polished lightning bolt (1)	Bardic Journey (3) , Bardic Journey (2), Bardic Journey (1)
Blue-grey watersilk parasol capped with a stormfire topaz ferrule	Hollow Eve Festival 447/Auction	true
Blue-violet watersilk kimono with a rich bluefire velvet under-robe	Sumptuous Silks (3) , Sumptuous Silks (2)
Blue-violet watersilk kimono with a rich starfire velvet under-robe
Bluefire velvet
Bluefire velvet turban	Huldah Shrine prizes 410
Bouquet of Scarlet Panther lilies arranged in a flame-etched glass vase	Perpetual Blossoms of Mer'Kresh (3) , Perpetual Blossoms of Mer'Kresh (2)	true
Burgundy brocade gem pouch with a golden lightning bolt clasp	Simply Essential (2)
Cambrinth Meraud idol	Idon Abide the Ten (3) , Idon Abide the Ten (2), Idon Abide the Ten (1)
Cambrinth bracelet inset with a carved jade weasel dodging platinum lightning bolts	Drathrok's Duskruin 419/Incidental loot , Darkbox 414 prizes
Cambrinth ring etched with storm clouds and lightning bolts	Griniel's Cottage
Collarless jet batiste shirt	Male Persuasion (3) , Male Persuasion (2), Male Persuasion (1)
Coruscating Firulfian crystal txistu trimmed in electrified goldfyre	Item:Cloudlake leather pack with an Imperial quartz set in Maiden's marble , Aesthene's Close 445/Raffle	true
Crystal wand inset with silver lightning bolts
Cushion-cut stormfire topaz pendant on a slim platinum chain	Sindah's Silk Sensations (3) , Sindah's Silk Sensations (2)
Dark blue robe embroidered with two weasels on a background of twisting blue-white lightning	Trevellyn's of Leth Deri'el
Dark crimson sword etched with niello lightning	Misenseor Goods (6) , Misenseor Goods (5)
Dark crimson sword etched with spidery lightning	Misenseor Goods (4) , Misenseor Goods (3), Misenseor Goods (2), Misenseor Goods (1)
Dark grey silk gown with jagged platinum lightning bolts dangling at the low neckline	Frilly Fashions

Semantic search

Query log

Navigation menu

Search