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:Items]][[Page type is::!weapon]][[Page type is::!armor]][[Page type is::!shield]][[Enchanted is::true]]
 |?Potency is number
 |?Complexity is number
 |?Precision is number
 |?Grade is number
 |?Ebonus is
 |?Glamour is
 |?Gdecoration is
 |format=table
 |limit=50
 |offset=10
 |link=all
 |sort=
 |order=asc
 |headers=show
 |searchlabel=... further results
 |class=sortable wikitable smwtable
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Items]][[Page type is::!weapon]][[Page type is::!armor]][[Page type is::!shield]][[Enchanted is::true]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1317",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Items]] [[Page type is::!weapon]] [[Page type is::!armor]] [[Page type is::!shield]] [[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_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_blob` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
`smw_di_blob` AS t8 ON t2.s_id=t8.s_id
INNER JOIN
`smw_di_bool` AS t10 ON t2.s_id=t10.s_id) ON t0.smw_id=t2.s_id
WHERE
(
   ((t4.o_hash!='weapon') AND t4.p_id=2021236)
   AND (
   (t6.o_hash!='armor') AND t6.p_id=2021236)
   AND (
   (t8.o_hash!='shield') AND t8.p_id=2021236)
   AND (
   (t10.o_value=1) AND t10.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
10

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t10	index_merge	s_id, o_value, p_id	p_id,o_value	4,2		375	Using intersect(p_id,o_value); Using where; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t10.s_id	1	Using where
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id_2	4	drwiki.t10.s_id	1	Using where; Using index; Distinct
1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	drwiki.t2.o_id	1	Distinct
1	SIMPLE	t4	ref	s_id, p_id, o_hash, s_id_2	s_id	8	drwiki.t10.s_id, const	1	Using where; Distinct
1	SIMPLE	t6	ref	s_id, p_id, o_hash, s_id_2	s_id	8	drwiki.t10.s_id, const	1	Using where; Distinct
1	SIMPLE	t8	ref	s_id, p_id, o_hash, s_id_2	s_id	8	drwiki.t10.s_id, const	1	Using where; Distinct

Auxilliary Tables

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

Query Metrics

Query-Size:9
Query-Depth:1

Errors and Warnings

None

	Potency is number	Complexity is number	Precision is number	Grade is number	Ebonus is	Glamour is	Gdecoration is
Burnished platinum bracelet dangling charms representing aspects of the Immortals	10	10	8	2	durability	Radiant
Caliginous glass orb containing a model of the Red Spiral	10		4	2	magnitude, damage (TM)
Carved howlite eyeball centered with a dragonvein agate iris				3
Ceremonial scourge with a diamond-hide grip			10	2	magnitude, damage and accuracy (TM)
Chaosknit voodoo doll set with midnight ruby cabochon eyes				3	damage (TM), fire damage added (TM)
Coruscant crystal-bone octahedron edged in gold			9	1	magnitude, damage and accuracy (TM)
Coursing Hound of Rutilor forged from windsteel	10		4	2	magnitude, accuracy (TM)
Crimson moonsilver pupil wreathed in a silvery-blue iris shrouded by cold white light	10		10	3	magnitude, damage (TM)
Crystal-bone globe caught in a web of interlocking finivire twigs			8	3	reduced activation time, damage (TM)
Dark sokis amulet carved into a stylized eye	10	10	7	1	activation
Dark-jeweled brooch trailing delicate platinum ribbons	10	10	8	2	activation	Flash	powerful blue
Darkstone circlet ringed with silver leaves	10	10	7	2	durability	Nature
Diacan codex inlaid with moonsilver			9	2	magnitude, accuracy (TM)
Duskbloom sapphire pendant
Eerily glowing blackened moonsilver crow with large gais eyes	10	10	8	3	magnitude, damage and accuracy (TM)
Ethereal Phelim shell sliced lengthwise	10		4	2	magnitude, accuracy (TM)
Flawlessly cut crystal fist inset with Imperial gemstones			10	4	reduced activation time, damage (TM)
Gnarled azurelle branch dangling myriad stone amulets			10	2	magnitude, mana efficiency (TM)
Gnarled branch with a small leather-bound grip			7	1	magnitude, damage and accuracy (TM)
Gnarled mistwood staff capped with an amber lump			8	1	reduced activation time, damage (TM)
Golden bangle shaped like an ouroboros	8	1	2	1	activation	Mana	blue
Golden will-o-wisp carved from opal-inlaid amber	10	10	8	2	magnitude	Flash
Granite pin depicting a shaggy wolf	10	10	8	2	magnitude	Fire	angry white
Haizeebo and abyssium replica depicting the blighted birth of the Zaulfung swamp	10		10	3	magnitude, damage (TM)
Hiromin-eyed leviathan sculpted from grazhite	10		10	1	magnitude, damage and accuracy (TM)
Indurium bead cast to resemble a charging snowbeast			2	1		Water
Jade pin depicting an aggressive viper	10	10	8	2	magnitude	Earth
Jagged ka'hurst lightning bolt tipped with tempest sapphires	10		9	2	magnitude, damage and accuracy (TM)
Katamba-black volume titled "A Merelew's Guide to Lunar Magic"	10		4	1	magnitude, damage and accuracy (TM)
Kelpzyte death adder coiled in ambush	10		4	2	magnitude, accuracy (TM)
Lifelike mantis shrimp carved from spectrolite	10		4	2	magnitude, damage (TM)
Long diamondwood cane topped with a carved wolf's head	10	10	8	3	magnitude	Fire
Marble pin depicting a proud unicorn	10	10	8	2	magnitude	Radiant	fierce gold
Massive vengeance ruby fireball			8	2	magnitude, damage (TM)
Mercury-filled muracite octahedron captured within a silk lattice	10	10	9	4	durability
Metallic sphere covered in Xibar-blue enamel			7	1	magnitude, damage and accuracy (TM)
Misshapen lump			8	1	reduced activation time, damage (TM)
Mistglass comet with a bright nucleus of aldamdin	10		4	2	magnitude, damage (TM)
Niniam bead carved to resemble a soaring dragon	8	1	2			Fire	flickering orange
Niniam wand sprouting leaf stalks and topped with a small pink tulip	8	10	8
Obsidian worm charm set upon a backing of pewter	10	10	8	2	magnitude	Earth
Onyx pin depicting a hammerhead shark	10	10	8	2	magnitude	Water	white
Opal butterfly charm set upon a pewter backing	10	10	8	2	magnitude	Wind
Pair of half-melted merman figurines cast in red gold	10		7	1	magnitude, fire damage added (TM)
Pair of niniam earrings set with black opals	10	10	8	2	activation	Radiant
Pair of orichalcum earrings dangling sparkling snowballs of carved diamondique	10	10	9	4	magnitude	Water
Pair of orichalcum earrings set with large cherry opals	10	10	8	2	activation	Mana
Platinum-framed spectacles with grey lenses	8	1	2			Radiant
Polished deep green muracite ring set with a fire agate carved like a tulip blossom
Pristine white reference guide titled "A Merelew's Guide to Holy Magic"	10		4	1	magnitude, damage and accuracy (TM)

Semantic search

Query log

Navigation menu

Search