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 bowl]]
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 t1
INNER JOIN
  `t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
  (t1.o_id=420554)
  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
1SIMPLEt2ALLPRIMARY2Using temporary; Using filesort
1SIMPLEt1refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id_39const, drwiki.t2.id1
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4drwiki.t1.s_id1Using where
Auxilliary Tables
  • Temporary table t2
      Recursively computed hierarchy for element(s) (2021226).
      SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021226 LIMIT 1
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
ItemRareIncompleteSpeed#Durability#Quality#
Darkstone mixing bowl bearing firestained images limned in sanguineous huestruerather effective7marginally vulnerable8masterfully-crafted12
Deep bowl carved out of blue suiritetruerather effective7marginally vulnerable8masterfully-crafted12
Deep hammered brass bowl with crimped enamel edgesfalse
Dull steel bowl with wire handlestruerather effective7marginally vulnerable8masterfully-crafted12
Felstone bowl covered with blood-like stainstruenot very effective5highly protected13masterfully-crafted12
Food bowlfalsevery ineffective4appreciably susceptible7well-crafted7
Gold-edged bloodwood bowltruerather effective7marginally vulnerable8masterfully-crafted12
Granite bowl painted with a haggard troll face on the sidetruenot very effective5a bit safeguarded10masterfully-crafted12
Green muracite bowl with gold inlaytruerather effective7marginally vulnerable8masterfully-crafted12
Green wooden bowl with carved handlestruerather effective7marginally vulnerable8masterfully-crafted12
Green-dyed steel bowl with wire handlestruerather effective7marginally vulnerable8masterfully-crafted12
Green-stained walnut bowl with carved handlestruerather effective7marginally vulnerable8masterfully-crafted12
Icesteel bowl engraved with wavy linestruerather effective7marginally vulnerable8masterfully-crafted12
Item:Carved oaken bowl with openwork of galloping horsesvery ineffective4appreciably susceptible7well7
Item:Dark felstone bowl painted with crude figuressort of effective6extremely resistant15outstanding11
Item:Wide diamondique bowl engraved with a starry soldier scenenot very effective5highly protected13masterfully12
Khor'vela medicine bowl carved with alchemical symbolstrueexceptionally effective9somewhat unsound6masterfully-crafted12
Large black firecloud clay bowl incised with a rainshadow designfalsevery ineffective4appreciably susceptible7well-crafted7
Large black firecloud clay bowl painted with dragonfliesfalsevery ineffective4appreciably susceptible7well-crafted7
Large blue firecloud clay bowl etched with a whirlwind designfalsevery ineffective4appreciably susceptible7well-crafted7
Large bowlfalsetruevery ineffective4appreciably susceptible7well-crafted7
Large bowl painted with blossomsfalsenot very effective5rather reinforced11masterfully-crafted12
Large bowl smoothly carved from flawless sencitruevery effective8marginally vulnerable8masterfully-crafted12
Large ebonwood bowltruevery ineffective4appreciably susceptible7well-crafted7
Large metal bowlfalsevery ineffective4appreciably susceptible7well-crafted7
Large painted ceramic bowltruevery ineffective4appreciably susceptible7well-crafted7
Large pure white ceramic bowltrue
Large purpleheart bowl edged with ivorytrueexceptionally effective9somewhat unsound6masterfully-crafted12
Large red firecloud clay bowl painted with a circle of tadpolesfalsevery ineffective4appreciably susceptible7well-crafted7
Limestone bowl carved to resembled a hollowed-out orc skulltruenot very effective5highly protected13masterfully-crafted12
Long kelpzyte bowl shaped to resemble a leaftruerather effective7marginally vulnerable8masterfully-crafted12
Marbled alerce bowl carved with vampire bats along the rimtruerather effective7average construction9masterfully-crafted12
Obsidian poultice-mixing bowltruetrue
Oval brass bowl with dark green glazed enamel liningfalsevery ineffective4appreciably susceptible7well-crafted7
Polished adderwood bowl set with slim tyrium bandstruetremendously effective11particularly weak5masterfully-crafted12
Polished blue alabaster bowl encased in thinly padded leathertruenot very effective5rather reinforced11masterfully-crafted12
Round coralite bowl etched with tiny butterfliestruerather effective7marginally vulnerable8masterfully-crafted12
Rusty iron bowlfalsevery ineffective4appreciably susceptible7well-crafted7
Shallow hammered brass bowl with fluted edgesfalse
Silver-edged oak bowltrue
Silver-shot ebony bowltruerather effective7marginally vulnerable8masterfully-crafted12
Slightly battered tin bowltruerather effective7marginally vulnerable8masterfully-crafted12
Small mixing bowl painted with bright yellow duckstrue
Smooth loimic bowl etched with tiny dragonfliestruerather effective7marginally vulnerable8masterfully-crafted12
Snow quartz mixing bowltruenot very effective5rather reinforced11masterfully-crafted12
Soapstone bowl painted with a lounging black cattruerather effective7marginally vulnerable8masterfully-crafted12
Sturdy gloomwood bowl with a muted finishtruevery ineffective4appreciably susceptible7well-crafted7
Tall goldenglow glaes bowl etched with a tiny suntruerather effective7marginally vulnerable8masterfully-crafted12
Uneven burlwood bowl engraved with grotesque skullstruenot very effective5highly protected13masterfully-crafted12
Voilyne bowl ringed with carved grave wormstruerather effective7average construction9masterfully-crafted12