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::Alerce]]||[[uses material::alerce]]
 |?=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::Alerce]]||[[uses material::alerce]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0462",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses symbol::Alerce]] OR [[Uses material::Alerce]]

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				92		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='Alerce')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=546761
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
Item:Dainty alerce box adorned with a blue flower-shaped label	Everlasting Beauty (3)	true
Item:Dark thornweave bag with a pure white alerce skull clasp	Hollow Eve Festival 414/Auction
Item:Delicate slippers of sky blue cire shimmering with pale iridescence	Natural Beauty (1)
Item:Elegant alerce tea tote lined with checkered silk	Tea for Tamsine (4) , Tea For Tamsine (3)
Item:Exquisitely detailed camellia bloom carved from snowy white alerce	Tildi's Blooms (4)
Item:Feathery seaweed fronds dappled with swirls	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes
Item:Feral-eyed orange tiger with striking black stripes	Magical Minions (3)
Item:Folding chair with a cushioned seat	Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Fragile gown with eerie flora pressed betwixt darkly ethereal marquisette layers	Limited Treasures (1)
Item:Fragile sea globe with a polished base	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Glittering kaleidoscope of pure white alerce	Clear Visions (3) , Clear Visions (2)
Item:Greased alerce stick affixed with an elegantly written label	Everlasting Beauty (3)	true
Template:HE2020Woods
Item:Hollow Eve 439 gift	Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439	true
Talk:Hollow Eve Festival 436/Game prizes
Hollow Eve Festival 436/Game prizes/Material options
Item:Polished alerce clarinet with lumium keys
Item:Jewelry pest	Mishli , Hollow Eve Festival 447	true
Item:Lacquered abacus strung with polished beads	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Lacquered band set with a tiny clownfish	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Latticed picnic basket tied with sea otters	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	true
Item:Mahogany brown goat mask topped with spiraling horns of alerce	Limited Treasures (2)
Item:Marbled alerce bowl carved with vampire bats along the rim	Skyward Crafting (7) , Skyward Crafting (6), Skyward Crafting (5)	true
Item:Miniature Cereia figurine shaped from stunningly pristine white alerce wood	Siegery Shop (2)
Item:Miniature alerce siren perched atop a haralun rock	Siegery Shop (5)
Item:Miniature steam and clockwork calliope pulled by a team of white skeletal horses	Item:Spacious flat-top travel trunk plastered with numerous faded sideshow posters , Limited Treasures (1)
Item:Miniature turtles	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Ornate alerce ring	Snake Pit , Sleeping Dragon Corn Maze 447/End loot, Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Sleeping Dragon Corn Maze 436/End loot, Sleeping Dragon Corn Maze 432/End loot, Sleeping Dragon Corn Maze 428/End loot, Musical Chairs of Doom, Hollow Eve Festival 447/Raffles, Hollow Eve Festival 447/Game prizes, Hollow Eve Festival 443/Raffles, Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Raffles, Hollow Eve Festival 436/Game prizes, Hand of Glory (2), Hand of Glory (1), Game of Chicken 425 prizes, Game of Chicken 421 prizes, Finest Box of Gems (4), Boggle Blast (2), Blood and Gourd (2)	true
Item:Pair of dice with shell-shaped pips	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Pair of interlocking iroko and alerce armbands	Accents for the Arachnophile (5) , Accents for the Arachnophile (4), Accents for the Arachnophile (3)
Item:Pair of pure white alerce sandals with pale green diamond-hide straps	Item:Lovely turbaurs kimono faintly tinged with the ethereal hues of faesoul blossoms , Limited Treasures (1)
Item:Pair of sleekly curving alerce hairsticks topped with Drogor's Wrath sapphires	Hollow Eve Festival 417/Raffles , Hair Apparent (2)
Item:Pair of slim verdant alerce hairsticks	Fashionable Panda (2)
Item:Pair of white alerce sandals with spun rainbow straps	Fashionable Panda (2)
Item:Pale white alerce telescope banded with rings of indurium	Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 437/Incidental loot
Item:Pilgrim's badge sculpted with the emblem of an Immortal	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	true
Item:Pleated gabardine capelet fastened with a white alerce button	Damsel In This Dress (5) , Damsel In This Dress (3)
Item:Polished alerce box adorned with a silver moon-shaped label	Everlasting Beauty (2)	true
Item:Polished alerce clarinet with lumium keys	Musiceum (3) , Musiceum (2), Musiceum (1)
Item:Polished cane entangled by a sprawling kraken	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Polished comb with blossoms in bas-relief	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Polished violet-hued alerce violincello inlaid with skeins of niello	Musiceum (9) , Musiceum (8)	true
Item:Polished wand topped with a starfish	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	true
Item:Pristine watersilk sack with a pure white alerce albatross clasp	Item:Pristine watersilk backpack	true
Item:Pure white alerce Bardic Spirit Knot	Dark Symphony (5) , Dark Symphony (4), Dark Symphony (3)
Item:Pure white alerce narwhal amulet boasting a magnificent tapered horn
Item:Red alerce diadem set with onyx spiders at the apex of each of its three points	Accents for the Arachnophile (2)
Item:Regal peacock mask feathered with iridescent blue and green plumage	Limited Treasures (2)
Item:Repair case of polished wood with fittings	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes	true
Item:Resplendent alerce ring	House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, House of the Revenant Fang 423/Shadowy Safehouse, Item:Austere stormsilk pouch clasped with a starsteel lightning bolt, Aesthene's Close 445/Vault, Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot	true

Semantic search

Query log

Navigation menu

Search