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: [[Category:Armor]][[Enchanted is::true]]
 |?Is combat type=Type
 |?Potency is number
 |?Complexity is number
 |?Precision is number
 |?Grade is number
 |?Ebonus is
 |?Flare is
 |?Fdecoration is
 |format=table
 |limit=50
 |offset=0
 |link=all
 |sort=
 |order=asc
 |headers=show
 |searchlabel=... further results
 |class=sortable wikitable smwtable
}}

Results 1 – 50 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Armor]][[Enchanted is::true]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0737",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Armor]] [[Enchanted is::true]]

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_fpt_inst` AS t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`smw_di_bool` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
   ((t4.o_value=1) AND t4.p_id=2021972)
  )
  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
0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t3	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	drwiki.t3.id	95	Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t2.s_id	1	Using where
1	SIMPLE	t4	ref	s_id, o_value, p_id	s_id	8	drwiki.t2.s_id, const	1	Using where; Distinct

Auxilliary Tables

Temporary table t3
Recursively computed hierarchy for element(s) (34040).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=34040 LIMIT 1

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

	Type	Potency is number	Complexity is number	Precision is number	Grade is number	Ebonus is	Flare is	Fdecoration is
Abyssal black Imperial weave battle gown with blackened moonsilver epaulets	Light Armor				2	magnitude	Fire	blood-red
Agonite aventail etched in rolling sand dunes outlined with glowing truegold	Brigandine	2	10	2	2	proc chance	Living	gold-colored electrified sand
Agonite cap etched in rolling sand dunes outlined with glowing truegold	Brigandine	2	10	2	2	proc chance	Living	gold-colored electrified sand
Agonite gloves etched in rolling sand dunes outlined with glowing truegold	Brigandine	2	10	2	2	proc chance	Living	gold-colored electrified sand
Agonite greaves etched in rolling sand dunes outlined with glowing truegold	Brigandine	2	10	2	2	proc chance	Living	gold-colored electrified sand
Agonite hauberk etched in rolling sand dunes outlined with glowing truegold	Brigandine	2	10	2	2	proc chance	Living	gold-colored electrified sand
Agonite lamellar helm sculpted with the visage of a blazing phoenix	Brigandine	2	10	2	2	magnitude	Fire	molten-red
Agonite mail balaclava set with dragon fire opal eyes	Chain Armor	2	10	2	4	magnitude	Fire	molten-red
Agonite mail gloves firestained with gold and vermilion hues	Chain Armor	2	10	2	2	magnitude	Fire	molten-red
Agonite mail gloves tipped with dragon fire opal talons	Chain Armor	2	10	2	4	magnitude	Fire	molten-red
Agonite mail greaves patterned with dragon fire opal flames	Chain Armor	2	10	2	4	magnitude	Fire	molten-red
Agonite mail shirt layered over dusky dreamweave padding	Chain Armor	2	10	2	4	magnitude	Fire	molten-red
Agonite mask etched in rolling sand dunes outlined with glowing truegold	Brigandine	2	10	2	2	proc chance	Living	gold-colored electrified sand
Agonite plate gauntlets lined with firesilk padding	Plate Armor	2	10	2	1	magnitude	Fire
Agonite plate mask firestained with gold and vermilion hues	Plate Armor	2	10	2	2	magnitude	Fire	molten-red
Agonite tasset etched in rolling sand dunes outlined with glowing truegold	Brigandine	2	10	2	2	proc chance	Living	gold-colored electrified sand
Agonite vambraces etched in rolling sand dunes outlined with glowing truegold	Brigandine	2	10	2	2	proc chance	Living	gold-colored electrified sand
Agonite vest etched in rolling sand dunes outlined with glowing truegold	Brigandine	2	10	2	2	proc chance	Living	gold-colored electrified sand
Articulated icy veined scorpion mesosoma of glossy black asharsh'dai	Chain Armor	4	10	4	3	magnitude	Living	shadow
Articulated icy veined scorpion pedipalps of glossy black asharsh'dai	Chain Armor	4	10	4	3	magnitude	Living	shadow
Austere battle odaj of somber black leather	Light Armor	2	10	2	1	magnitude	Electric	black
Austere black sanguinai battle kimono swirled with midnight ruby droplets	Light Armor			4	2	magnitude	Fire
Banded hauberk with interwoven brass and bronze bands	Chain Armor	2	10	2	2	magnitude	Fire
Black moonsilk pants cuffed with pale blue zenganne	Light Armor	2	10	2	1	magnitude	Frost	silver-colored
Black moonsilk robe belted with a swathe of zenganne	Light Armor	2	10	2	1	magnitude	Frost	silver-colored
Black moonsilk vambraces stitched with obscure symbols	Light Armor	2	10	2	1	magnitude	Frost	silver-colored
Blackened steel plate armor emblazoned with a golden crest	Plate Armor
Bloodmarrow coat mimicking a gruesomely exposed cadaverous ribcage	Light Armor	7	10	7	2	magnitude	Living	blood
Bloodshot mask set with hypnotically swirled ixaemite eyes	Chain Armor				3		Living	blood
Blued chainmail shirt with asini shark fin pauldrons	Chain Armor
Bone aventail engraved with a pattern of entangling Urrem'tier bloodvines	Light Armor	2	10	2	2	magnitude	Living	crimson boiling blood
Bone cap engraved with a pattern of entangling Urrem'tier bloodvines	Light Armor	2	10	2	2	magnitude	Living	crimson boiling blood
Bone gloves engraved with a pattern of entangling Urrem'tier bloodvines	Light Armor	2	10	2	2	magnitude	Living	crimson boiling blood
Bone greaves engraved with a pattern of entangling Urrem'tier bloodvines	Light Armor	2	10	2	2	magnitude	Living	crimson boiling blood
Bone hauberk engraved with a pattern of entangling Urrem'tier bloodvines	Light Armor	2	10	2	2	magnitude	Living	crimson boiling blood
Bone mask engraved with a pattern of entangling Urrem'tier bloodvines	Light Armor	2	10	2	2	magnitude	Living	crimson boiling blood
Bone tasset engraved with a pattern of entangling Urrem'tier bloodvines	Light Armor	2	10	2	2	magnitude	Living	crimson boiling blood
Bone vambraces engraved with a pattern of entangling Urrem'tier bloodvines	Light Armor	2	10	2	2	magnitude	Living	crimson boiling blood
Bone vest engraved with a pattern of entangling Urrem'tier bloodvines	Light Armor	2	10	2	2	magnitude	Living	crimson boiling blood
Burgundy leather gloves trimmed with raven feathers	Light Armor	2	10	2	1	proc chance	Fire
Burgundy leathers tooled with an unkindness of ravens	Light Armor	2	10	2	1	proc chance	Fire
Burnished everdusk damite aventail embellished with scorpion diamonds	Plate Armor	2	10	2	2	magnitude	Living	twilight-purple chilling shadow
Burnished everdusk damite backplate embellished with scorpion diamonds	Plate Armor	2	10	2	2	magnitude	Living	twilight-purple chilling shadow
Burnished everdusk damite barbute embellished with scorpion diamonds	Plate Armor	2	10	2	2	magnitude	Living	twilight-purple chilling shadow
Burnished everdusk damite breastplate embellished with scorpion diamonds	Plate Armor	2	10	2	2	magnitude	Living	twilight-purple chilling shadow
Burnished everdusk damite fauld embellished with scorpion diamonds	Plate Armor	2	10	2	2	magnitude	Living	twilight-purple chilling shadow
Burnished everdusk damite full plate embellished with scorpion diamonds	Plate Armor	2	10	2	2	magnitude	Living	twilight-purple chilling shadow
Burnished everdusk damite greaves embellished with scorpion diamonds	Plate Armor	2	10	2	2	magnitude	Living	twilight-purple chilling shadow
Burnished everdusk damite mask embellished with scorpion diamonds	Plate Armor	2	10	2	2	magnitude	Living
Burnished everdusk damite vambraces embellished with scorpion diamonds	Plate Armor	2	10	2	2	magnitude	Living	twilight-purple chilling shadow

Semantic search

Query log

Navigation menu

Search