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: [[Page type is::item]] [[Has item property::pilgrim's badge]]
 |?Source is=Source
 |format=table
 |limit=50
 |offset=10
 |sort=
 |order=asc
 |mainlabel=
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Page type is::item]] [[Has item property::pilgrim's badge]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0493",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Page type is::item]] [[Has item property::pilgrim's badge]]

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 t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
   (t2.o_hash='item') AND t2.p_id=2021236
   AND (
   (t4.o_hash='pilgrim\'s badge') AND t4.p_id=2021204)
  )
  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	t4	ref	s_id, p_id, o_hash, s_id_2	p_id	262	const, const	53	Using index condition; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t4.s_id	1	Using where
1	SIMPLE	t2	ref	s_id, p_id, o_hash, s_id_2	s_id	8	drwiki.t4.s_id, const	1	Using where; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:4
Query-Depth:1

Errors and Warnings

None

	Source
Ebon faesilk gown with bouquets of colorful flowers embroidered down the sides	Droughtman's Challenge 444/End loot Droughtman's Challenge 441/End loot Droughtman's Challenge 437/End loot Droughtman's Challenge 433/End loot Droughtman's Challenge 430/End loot Droughtman's Challenge 426/End loot
Ebony pilgrim's badge inlaid with a thirteen-pointed star	Misenseor Goods (6) Misenseor Goods (5) Misenseor Goods (4) Misenseor Goods (3) Misenseor Goods (2) Misenseor Goods (1)
Firestained pilgrim's badge hammered into a flaming anvil	Drathrok's Duskruin 438/Incidental loot Drathrok's Duskruin 448/Incidental loot Drathrok's Duskruin 446/Incidental loot
Flamewood pilgrim's badge carved to resemble a hatching phoenix	Crystal Pilgrim (3) Crystal Pilgrim (2) Crystal Pilgrim (1)
Gleaming goldenoak pilgrim's badge	Merit Badges (4) Merit Badges (3) Merit Badges (2) Merit Badges (1)
Goldenglow glaes pilgrim's badge forged into a sea-lion	Hollow Eve Festival 447/Raffles
Hav'roth's ambrosia pilgrim's badge carved into a hooded cobra
Heartstone pilgrim's badge carved into a gluttonous vulture
Heavy gold pilgrim's badge shaped like a crowned lion
Holly pilgrim's badge painted with a merry welkin
Horse-shaped pilgrim's badge made from tyrium	Hollow Eve Festival 421/Raffles
Hourglass-shaped pilgrim's badge carved from demon gaze agate	Droughtman's Challenge 444/Incidental loot Droughtman's Challenge 441/Incidental loot
Iron pilgrim's badge forged into a crossed spear and greatsword	Drathrok's Duskruin 442/Incidental loot Drathrok's Duskruin 438/Incidental loot Drathrok's Duskruin 448/Incidental loot Drathrok's Duskruin 446/Incidental loot
Iron pyrite pilgrim's badge carved into a mantling goshawk
Lustrous white ironwood pilgrim's badge	Merit Badges (4) Merit Badges (3) Merit Badges (2) Merit Badges (1)
Obsidian pilgrim's badge carved with the visages of the dark aspects
Pale silk pilgrim's badge reinforced with stiffened leather	Merit Badges (4) Merit Badges (3) Merit Badges (2) Merit Badges (1)
Pilgrim's badge	Item:Dusky-blue basilisk hide satchel decorated with ur hhrki'izh claws along the flap Hollow Eve Festival 399/Auction Gadelica's Riches for the Reverent (4) Gadelica's Riches for the Reverent (3) Extreme Shop Item:Dusky-blue basilisk hide satchel decorated with ur hhrki'izh claws along the flap Item:Dusky-black basilisk hide satchel decorated with pard claws along the flap Curse of the Ghost Ship/End Loot Brother Durantine's Shop
Pilgrim's badge bordered with stylized mongooses	Merit Badges (4) Merit Badges (3) Merit Badges (2) Merit Badges (1)
Pilgrim's badge crafted from bone-white witchclaw bark	Misenseor Goods (6) Misenseor Goods (5) Misenseor Goods (4) Misenseor Goods (3) Misenseor Goods (2) Misenseor Goods (1)
Pilgrim's badge depicting a lion's head	Merit Badges (4) Merit Badges (3) Merit Badges (2) Merit Badges (1)
Pilgrim's badge resembling a goshawk mantling its wings	Merit Badges (4) Merit Badges (3) Merit Badges (2) Merit Badges (1)
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
Polished godsmarked turquoise cabochon pilgrim's badge	Drathrok's Duskruin 442/Incidental loot Drathrok's Duskruin 448/Incidental loot Drathrok's Duskruin 446/Incidental loot
Prismatic stura atulave pilgrim's badge strung from a wildlace ribbon	Sleeping Dragon Corn Maze 443/Incidental loot
Reddish-gold orichalcum pilgrim's badge
Roughly hewn gloomwood pilgrim's badge	Hollow Eve Festival 421/Raffles
Round mistwood pilgrim's badge edged with a heavy bezel of anlora-avtoma	Crystal Pilgrim (3) Crystal Pilgrim (2) Crystal Pilgrim (1)
Rounded darkstone pilgrim's badge	Hollow Eve Festival 421/Raffles
Rowan pilgrim's badge depicting the Misenseor Abbey	Misenseor Goods (6) Misenseor Goods (5) Misenseor Goods (4) Misenseor Goods (3) Misenseor Goods (2) Misenseor Goods (1)
Rowan-framed silk pilgrim's badge	Merit Badges (4) Merit Badges (3) Merit Badges (2) Merit Badges (1)
Sana'ati pilgrim's badge varnished to a dusky sheen	Misenseor Goods (6) Misenseor Goods (5) Misenseor Goods (4) Misenseor Goods (3) Misenseor Goods (2) Misenseor Goods (1)
Sanguine glaes pilgrim's badge wrought into a burning torch	Drathrok's Duskruin 442/Incidental loot Drathrok's Duskruin 438/Incidental loot Drathrok's Duskruin 448/Incidental loot Drathrok's Duskruin 446/Incidental loot
Shadowbark pilgrim's badge framed by skeletal dragon wings	Owirvald Riverhaven Auction 427
Shark's tooth pilgrim's badge etched with a hurricane
Smokestone pilgrim's badge strung from a spidersilk ribbon	Sleeping Dragon Corn Maze 447/Incidental loot
Songsilk pilgrim's badge framed by an e'erdream wren	Hollow Eve Festival 432/Raffles
Teakwood pilgrim's badge inlaid with an intricate silver scrollwork design	Estate Holder gifts
Tower shield-shaped pilgrim's badge	Merit Badges (4) Merit Badges (3) Merit Badges (2) Merit Badges (1)
Unadorned ebonwood pilgrim's badge	Merit Badges (4) Merit Badges (3) Merit Badges (2) Merit Badges (1)
Viperine pilgrim's badge carved from adderstone	treasure map
Willow-framed pilgrim's badge crafted from rosecloth	Hollow Eve Festival 421/Raffles
Witchclaw pilgrim's badge carved into a skeletal adder	treasure map

Semantic search

Query log

Navigation menu

Search