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

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

JSON CSV RSS RDF

Query log

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

Debug output SQLStore

ASK Query

[[Uses symbol::Bogbirch]] OR [[Uses material::Bogbirch]]

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				48		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='Bogbirch')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=915830
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
Bogbirch-handled broom with leather-wrapped grips trimmed in rabbit fur	Sleeping Dragon Corn Maze 436/End loot, 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	end loot
Camlet-wrapped burin affixed with a stormy tidal bloodstone	Droughtman's Challenge 444/End loot	end loot
Dainty bogbirch cosmetic basket adorned with colorful ribbons	Everlasting Beauty (3)	festival
Dark iron machete with bogbirch grips	Sleeping Dragon Corn Maze 428/End loot
Dark steel broadsword with a bogbirch hilt	House of the Revenant Fang 423/Incidental loot
Deep bogbirch dye tub with twisted purple gold handles	House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse	end loot
Diminutive bogbirch wardrobe with reinforced black gold corners	House of the Revenant Fang 437/Shadowy Safehouse	end loot
Elegant bogbirch riste embedded with shards of diamondique	House of the Revenant Fang 429/Incidental loot	incidental
Gnarled bogbirch branch	House of the Revenant Fang 423/Shadowy Safehouse
Gnarled bogbirch quarterstaff adorned with animal skulls	Aesthene's Close 449/End Loot	end loot
Greased Ilithian black bogbirch stick affixed with an elegantly written label	Item:Stormsilk cosmetic kit with a night diamond clasp
Greased bogbirch stick affixed with an elegantly written label	Everlasting Beauty (3)	festival
Ichor-green imbuement rod fashioned from rotting bogbirch	Skyward Crafting (8)	festival
Ilithian black bogbirch treasure chest with small steel spikes
Ilithian black bogbirch wardrobe carved with lotus blossoms	House of the Revenant Fang 429/Shadowy Safehouse
Inky bogbirch hunting longbow carved with a diving morgawr	House of the Revenant Fang 429/Shadowy Safehouse , House of the Revenant Fang 423/Shadowy Safehouse
Intricate bogbirch battle crossbow with a dagger-shaped stock	House of the Revenant Fang 437/Shadowy Safehouse
Jewelry pest	Mishli , Hollow Eve Festival 447	gift
Lacquered bogbirch nightstick streaked with wispy swirls	House of the Revenant Fang 423/Incidental loot
Massive wrought iron bar mace with a bogbirch grip	House of the Revenant Fang 437/Incidental loot
Miniature marsh cloaked in shadowsilk	Item:Shadowy bag pinned with a midnight diamond puppy , Drathrok's Duskruin 448/Raffle	auction
Miniature tentacled morgawr with prominently stitched seams	House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse
Mossy green gem pouch fit with a bogbirch toggle	House of the Revenant Fang 437/Incidental loot , House of the Revenant Fang 433/Incidental loot
Pair of rubbery leather wings set with vengeance ruby claws	House of the Revenant Fang 423/Incidental loot
Plain bogbirch door with a simple iron knocker	Two Doors Down (2)	festival
Plain polished bogbirch bench with a silk cushion	Sofa So Good (2)	festival
Scraggly jadeleaf cloak with a malevolent bogbirch-antlered hood	House of the Revenant Fang 423/Shadowy Safehouse
Serpentine light crossbow with an intricate bogbirch stock	House of the Revenant Fang 437/Incidental loot , House of the Revenant Fang 433/Incidental loot
Slender bogbirch nightstick with a braided jadeleaf grip	House of the Revenant Fang 429/Incidental loot
Small blue-belly crocodile with prominently stitched seams	House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse
Smoky quartz scroll case with bogbirch end caps	House of the Revenant Fang 423/Shadowy Safehouse
Steel scimitar with a wire-wrapped bogbirch hilt
Thickly scaled dragonwood theorbo with aldamdin tracery	Musiceum (7) , Musiceum (4)
Toadlike punka waterskin boasting a squat bogbirch stopper
Twisted bogbirch limb covered in obscure symbols	House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, Item:Canvas limb bag stamped with obscure symbols
Wide bogbirch armband tooled with wispy swamp specters	House of the Revenant Fang 423/Incidental loot
Wispy-grained bogbirch repair case inlaid with lusterless blackwater jet	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
Wispy-grained bogbirch scabbard with ornate animite fittings	House of the Revenant Fang 423/Incidental loot

Semantic search

Query log

Navigation menu

Search