Semantic search

Jump to navigation Jump to search
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
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt10index_merges_id, o_value, p_idp_id,o_value4,2375Using intersect(p_id,o_value); Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4drwiki.t10.s_id1Using where
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id_24drwiki.t10.s_id1Using where; Using index; Distinct
1SIMPLEt3eq_refPRIMARYPRIMARY4drwiki.t2.o_id1Distinct
1SIMPLEt4refs_id, p_id, o_hash, s_id_2s_id8drwiki.t10.s_id, const1Using where; Distinct
1SIMPLEt6refs_id, p_id, o_hash, s_id_2s_id8drwiki.t10.s_id, const1Using where; Distinct
1SIMPLEt8refs_id, p_id, o_hash, s_id_2s_id8drwiki.t10.s_id, const1Using 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 numberComplexity is numberPrecision is numberGrade is numberEbonus isGlamour isGdecoration is
Burnished platinum bracelet dangling charms representing aspects of the Immortals101082durabilityRadiant
Caliginous glass orb containing a model of the Red Spiral1042magnitude, damage (TM)
Carved howlite eyeball centered with a dragonvein agate iris3
Ceremonial scourge with a diamond-hide grip102magnitude, damage and accuracy (TM)
Chaosknit voodoo doll set with midnight ruby cabochon eyes3damage (TM), fire damage added (TM)
Coruscant crystal-bone octahedron edged in gold91magnitude, damage and accuracy (TM)
Coursing Hound of Rutilor forged from windsteel1042magnitude, accuracy (TM)
Crimson moonsilver pupil wreathed in a silvery-blue iris shrouded by cold white light10103magnitude, damage (TM)
Crystal-bone globe caught in a web of interlocking finivire twigs83reduced activation time, damage (TM)
Dark sokis amulet carved into a stylized eye101071activation
Dark-jeweled brooch trailing delicate platinum ribbons101082activationFlashpowerful blue
Darkstone circlet ringed with silver leaves101072durabilityNature
Diacan codex inlaid with moonsilver92magnitude, accuracy (TM)
Duskbloom sapphire pendant
Eerily glowing blackened moonsilver crow with large gais eyes101083magnitude, damage and accuracy (TM)
Ethereal Phelim shell sliced lengthwise1042magnitude, accuracy (TM)
Flawlessly cut crystal fist inset with Imperial gemstones104reduced activation time, damage (TM)
Gnarled azurelle branch dangling myriad stone amulets102magnitude, mana efficiency (TM)
Gnarled branch with a small leather-bound grip71magnitude, damage and accuracy (TM)
Gnarled mistwood staff capped with an amber lump81reduced activation time, damage (TM)
Golden bangle shaped like an ouroboros8121activationManablue
Golden will-o-wisp carved from opal-inlaid amber101082magnitudeFlash
Granite pin depicting a shaggy wolf101082magnitudeFireangry white
Haizeebo and abyssium replica depicting the blighted birth of the Zaulfung swamp10103magnitude, damage (TM)
Hiromin-eyed leviathan sculpted from grazhite10101magnitude, damage and accuracy (TM)
Indurium bead cast to resemble a charging snowbeast21Water
Jade pin depicting an aggressive viper101082magnitudeEarth
Jagged ka'hurst lightning bolt tipped with tempest sapphires1092magnitude, damage and accuracy (TM)
Katamba-black volume titled "A Merelew's Guide to Lunar Magic"1041magnitude, damage and accuracy (TM)
Kelpzyte death adder coiled in ambush1042magnitude, accuracy (TM)
Lifelike mantis shrimp carved from spectrolite1042magnitude, damage (TM)
Long diamondwood cane topped with a carved wolf's head101083magnitudeFire
Marble pin depicting a proud unicorn101082magnitudeRadiantfierce gold
Massive vengeance ruby fireball82magnitude, damage (TM)
Mercury-filled muracite octahedron captured within a silk lattice101094durability
Metallic sphere covered in Xibar-blue enamel71magnitude, damage and accuracy (TM)
Misshapen lump81reduced activation time, damage (TM)
Mistglass comet with a bright nucleus of aldamdin1042magnitude, damage (TM)
Niniam bead carved to resemble a soaring dragon812Fireflickering orange
Niniam wand sprouting leaf stalks and topped with a small pink tulip8108
Obsidian worm charm set upon a backing of pewter101082magnitudeEarth
Onyx pin depicting a hammerhead shark101082magnitudeWaterwhite
Opal butterfly charm set upon a pewter backing101082magnitudeWind
Pair of half-melted merman figurines cast in red gold1071magnitude, fire damage added (TM)
Pair of niniam earrings set with black opals101082activationRadiant
Pair of orichalcum earrings dangling sparkling snowballs of carved diamondique101094magnitudeWater
Pair of orichalcum earrings set with large cherry opals101082activationMana
Platinum-framed spectacles with grey lenses812Radiant
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"1041magnitude, damage and accuracy (TM)