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=0
 |sort=
 |order=asc
 |mainlabel=Item
 |default=None yet
 |sep=,&nbsp;
}}

Results 1 – 50 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
0

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:Aldamdin bone saw with a punka-wrapped handle	Skyward Crafting (6) , Skyward Crafting (5)	true
Item:Aldamdin tinker's tools with polished alerce handles	Skyward Crafting (8) , Skyward Crafting (7), Skyward Crafting (6), Skyward Crafting (5)	true
Item:Alerce Bardic Spirit Knot charm with rippled cambrinth edges	Dark Symphony (5) , Dark Symphony (4), Dark Symphony (3)
Item:Alerce bangles dangling emerald pivuh charms	Hollow Eve Festival 417/Raffles
Weapon:Alerce battle crossbow encrusted with blush-hued rubies	Killer Pinks	true
Item:Alerce bellows with supple doeskin-wrapped handles	Which Craft (1)	true
Item:Alerce burin topped with an orange pumpkin	Skyward Crafting (7)	true
Item:Alerce flask with a tree-shaped stopper
Item:Alerce herb basket adorned with a rose-shaped heliotrope	Garden of Plenty	true
Item:Alerce mosaic floor set in a compass-rose pattern	Floors for Thought (2) , Floors for Thought (1)
Item:Alerce mosaic floor set in a pinwheel pattern	Floors for Thought (2) , Floors for Thought (1)
Item:Alerce ring shaped with a string of foxes	Order of the Black Fox/Gifts and prizes
Item:Alerce ring shaped with tiny fox paw prints encircling the finger
Weapon:Alerce-covered treatise entitled "Whoops!"	Famous Last Words (5)
Weapon:Alerce-hilted throwing hammer with a shark-shaped head	Cleric wrapped tightly in dark robes
Item:Astronomical alerce mosaic wall	Wally's World of Walls (2) , Wally's World of Walls (1)	true
Weapon:Brilliant white alerce quarterstaff bound in colorful Imperial weave	Hollow Eve Festival 421/Auction
Item:Burnished wheel painted with colorful sea creatures	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:Competition miniature flock of seagulls with beady yellow eyes	Hollow Eve Festival 447/Game prizes	true
Item:Courtly Elven wool frock coat fastened by elaborate blue-white alerce buttons	Limited Treasures (1)
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)

Semantic search

Query log

Navigation menu

Search