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
import-annotation:

Additional annotated data are to be copied during the parsing of a subject
propsep:

The separator between the properties of a result entry
valuesep:

The separator between the values for a property of a result
template:

The name of a template with which to display the printouts
named args:

Name the arguments passed to the template
userparam:

A value passed into each template call, if a template is used
class:

An additional CSS class to set for the list
introtemplate:

The name of a template to display before the query results, if there are any
outrotemplate:

The name of a template to display after the query results, if there are any
sep:

The separator between results
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[Source for::Item:Infuser stone]]
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 ON t0.smw_id=t1.s_id
WHERE
  (t1.p_id=2021263 AND t1.o_id=577227)
  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
  15
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id_39const, const80Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4drwiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None

Source is Drathrok's Duskruin 421/Drathrok's Assemblage, Drathrok's Duskruin 422/Drathrok's Assemblage, Drathrok's Duskruin 426/Drathrok's Assemblage, Drathrok's Duskruin 430/Drathrok's Assemblage, Drathrok's Duskruin 435/Drathrok's Assemblage, Drathrok's Duskruin 438/Drathrok's Assemblage, Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 446/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot, Droughtman's Challenge 426/Incidental loot, Droughtman's Challenge 433/Incidental loot, Droughtman's Challenge 437/Incidental loot, Droughtman's Challenge 441/End loot, Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 444/End loot, Droughtman's Challenge 444/Incidental loot, Finest Box of Gems (1), Finest Box of Gems (2), Finest Box of Gems (3), Game of Chicken 421 prizes, Game of Chicken 425 prizes, Grave earth pile 421 prizes, Grave earth pile 425 prizes, Grave earth pile 428 prizes, Grave earth pile 432 prizes, Guildfest 445/Raffles, Harawep Shrine 421, Harawep Shrine 425, Hollow Eve Festival 421/Raffles, Hollow Eve Festival 425/Raffles, Hollow Eve Festival 428/Raffles, Hollow Eve Festival 432/Raffles, Hollow Eve Festival 436/Darkbox, Hollow Eve Festival 436/Game prizes, Hollow Eve Festival 436/Raffles, Hollow Eve Festival 439/Darkbox, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 439/Raffles, Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 443/Raffles, Hollow Eve Festival 447/Game prizes, Hollow Eve Festival 447/Raffles, House of the Revenant Fang 423/Incidental loot, House of the Revenant Fang 423/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, House of the Revenant Fang 437/Shadowy Safehouse, Huldah Shrine prizes 421, Jolly green duffel bag stitched with holly leaves, Musical Chairs of Doom, Return to the Keep 423/Supply Wagon