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
[[Item type is::Mixing stick]] [[Has item property::alchemy]]
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_wikipage` AS t2
INNER JOIN
  `t3` AS t3 ON t2.p_id=t3.id
INNER JOIN
  `smw_di_blob` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=407641
   AND (
   (t5.o_hash='alchemy') AND t5.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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt3ALLPRIMARY2Using temporary; Using filesort
1SIMPLEt2refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id_39const, drwiki.t3.id1
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4drwiki.t2.s_id1Using where
1SIMPLEt5refs_id, p_id, o_hash, s_id_2s_id8drwiki.t2.s_id, const1Using where; Distinct
Auxilliary Tables
  • Temporary table t3
      Recursively computed hierarchy for element(s) (2021226).
      SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021226 LIMIT 1
Query Metrics
Query-Size:4
Query-Depth:1
Errors and Warnings
None
ItemRareIncompleteSpeed#Durability#Quality#
Item:Etched obsidian mixing sticktruetrue
Item:Etched snow quartz mixing sticktruenot very effective5rather reinforced11masterfully-crafted12
Item:Fat blue mistglass mixing stick inlaid with a silvery white moon coraltruerather effective7marginally vulnerable8masterfully-crafted12
Item:Feather-tipped mixing stickfalsevery ineffective4appreciably susceptible7well-crafted7
Item:Glass mixing sticktruevery ineffective4appreciably susceptible7well-crafted7
Item:Green glaes mixing stick covered in glittertruerather effective7marginally vulnerable8masterfully-crafted12
Item:Green wooden mixing stick capped with a carved welkintruerather effective7marginally vulnerable8masterfully-crafted12
Item:Green wooden mixing stick with a carved handletruerather effective7marginally vulnerable8masterfully-crafted12
Item:Green-dyed steel mixing stick with rawhide wrapped around the handletruerather effective7marginally vulnerable8masterfully-crafted12
Item:Highly polished mixing stick smoothly carved from flawless sencitruevery effective8marginally vulnerable8masterfully-crafted12
Item:Hollow felstone mixing stick shaped like a funnel cloudtruevery effective8rather flimsy4masterfully-crafted12
Item:Hollow glass mixing stick filled with shimmering negerat clusterstruesort of effective6a bit safeguarded10masterfully-crafted12
Item:Carved mixing stick with a charging horse-shaped handlevery ineffective4appreciably susceptible7well7
Item:Glass mixing stickvery ineffective4appreciably susceptible7well7
Item:Hollow felstone mixing stick shaped like a funnel cloudvery effective8rather flimsy4masterfully12
Item:Pewter mixing stickvery ineffective4appreciably susceptible7well7
Item:Polished ebonwood mixing stickvery ineffective4appreciably susceptible7well7
Item:Long mixing stick topped with a trio of bloomsfalsenot very effective5rather reinforced11masterfully-crafted12
Item:Luminescent starshine mixing stick etched with starstruetremendously effective11particularly weak5masterfully-crafted12
Item:Metal mixing stickfalsevery ineffective4appreciably susceptible7well-crafted7
Item:Mixing stickfalsenot very effective5rather reinforced11masterfully-crafted12
Item:Mixing stick adorned with a pumpkin on the handletruerather effective7marginally vulnerable8masterfully-crafted12
Item:Mixing stick carved in the shape of a skeletal fingertruenot very effective5rather reinforced11well-crafted7
Item:Mixing stick fashioned from a petrified chicken legtruerather effective7marginally vulnerable8masterfully-crafted12
Item:Obsidian mixing stick carved to resembled a scaly vipertruesort of effective6a bit safeguarded10masterfully-crafted12
Item:Pewter mixing sticktruevery ineffective4appreciably susceptible7well-crafted7
Item:Plain steel mixing stick with rawhide wrapped around the handletruerather effective7marginally vulnerable8masterfully-crafted12
Item:Polished adderwood mixing sticktruerather effective7marginally vulnerable8masterfully-crafted12
Item:Polished adderwood mixing stick set with a spiral of tyriumtruetremendously effective11particularly weak5masterfully-crafted12
Item:Polished ebonwood mixing sticktruevery ineffective4appreciably susceptible7well-crafted7
Item:Polished suirite mixing stick etched with undulating wavestruerather effective7marginally vulnerable8masterfully-crafted12
Item:Polished wooden mixing stick capped with a carved welkintruerather effective7marginally vulnerable8masterfully-crafted12
Item:Purpleheart mixing sticktruerather effective7marginally vulnerable8masterfully-crafted12
Item:Purpleheart mixing stick inlaid with ivorytrueexceptionally effective9somewhat unsound6masterfully-crafted12
Item:Purplewood mixing stick inlaid with ivorytrueexceptionally effective9somewhat unsound6masterfully-crafted12
Item:Rainbow-colored mixing stick fashioned from smooth obsidiantruesort of effective6a bit safeguarded10masterfully-crafted12
Item:Silver mixing stick studded with dark crystalsfalsevery ineffective4appreciably susceptible7well-crafted7
Item:Slender coralite mixing stick etched with tiny butterfliestruerather effective7marginally vulnerable8masterfully-crafted12
Item:Smooth belzune mixing stick carved to resemble a long newt tailtruesort of effective6a bit safeguarded10masterfully-crafted12
Item:Smooth loimic mixing stick etched with tiny dragonfliestruerather effective7marginally vulnerable8masterfully-crafted12
Item:Split-reed mixing stickfalsevery ineffective4appreciably susceptible7well-crafted7
Item:Tapered kelpzyte mixing stick shaped to resemble a treetruerather effective7marginally vulnerable8masterfully-crafted12
Item:Tarnished brass mixing sticktruerather effective7marginally vulnerable8masterfully-crafted12
Item:Thin goldenglow glaes mixing stick etched with a large suntruerather effective7marginally vulnerable8masterfully-crafted12
Item:Twisted gloomwood mixing sticktruerather effective7marginally vulnerable8masterfully-crafted12
Item:Wooden mixing stick