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
[[Uses material::Marquisette]]
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=2021246 AND t1.o_id=436865)
  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
1SIMPLEt1refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id5const47Using where; Using 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
ItemSource isRare item
Dramatic plum gown gathered at the shoulders by silver melir blossomsNatural Beauty (1) Hollow Eve Festival 417/Raffles
Elegant duchess satin gown overlaid with silver marquisetteNatural Beauty (4)true
Empire-waist orchid cire gown with a layered skirt of indigo-framed scalesDamsel In This Dress (2)
Ethereal silver marquisette and moonsilk dress with a jeweled halter neckDamsel In This Dress (2)
Fragile gown with eerie flora pressed betwixt darkly ethereal marquisette layersLimited Treasures (1)
Glittering black marquisette gown with dramatic cobalt-blue faience beadworkDamsel In This Dress (3)
Glittery midnight-hued ballgown with an overskirt of star-flocked marquisetteLimited Treasures (5)
Halter neck rose-colored marquisette dress with a scalloped hemDamsel In This Dress (5) Damsel In This Dress (3)
Item:Airy gown of pale gold marquisette and virid silk
Item:Clinging ivory farandine gown with a rose marquisette bodice
Item:Dramatic plum gown gathered at the shoulders by silver melir blossoms
Item:Empire-waist orchid cire gown with a layered skirt of indigo-framed scales
Item:Ethereal silver marquisette and moonsilk dress with a jeweled halter neck
Item:Revealing vixen-red marquisette dress with a daring hemline
Item:Striking marquisette gown elaborately adorned with beading and raven feathers
Item:Violet thornweave houppelande overlaid with white marquisette
Item:Whimsical black and white marblesilk gown with raw silk texturing
Length of red marquisette fabricSindah's Silk Sensations (3)
Loose peach marquisette shirt lined in white silkFashionable Panda (2)
Miniature plum tree flourishing with dark marquisette leaves and pale bloomsTildi's Blooms (4)
Pair of dainty Katamba-black slippers overlaid with marquisetteMercurial Mage
Particolored marquisette and jaspe tote trailing harlequin-patterned aerial silksLimited Treasures (1)
Particolored silveress and marquisette maskItem:Particolored marquisette and jaspe tote trailing harlequin-patterned aerial silks Limited Treasures (1)
Perfumed marquisette handkerchief trimmed with Elven snowlaceHighway Robbery Reduxtrue
Revealing vixen-red marquisette dress with a daring hemlineDamsel In This Dress (2)
Set of loimic and marquisette shar'nath blossomsLimited Treasures (3)
Silver marquisette gown with a peaked sweetheart neckline and high-low hemDamsel In This Dress (5) Damsel In This Dress (3)
Slim diamond-hide sheath dress with a marquisette overlayDamsel In This Dress (3)true
Slim jade green diamond-hide sheath dress with a a marquisette overlay
Snug marquisette and silk top with butterfly sleevesDamsel In This Dress (5) Damsel In This Dress (3)
Spring green camlet mourning gown trimmed with golden marquisetteDamsel In This Dress (3)
Striking autumnal gown with marquisette skirts shaded in rich tones of amberLimited Treasures (4)
Striking marquisette gown elaborately adorned with beading and raven feathersNatural Beauty (1)
Tiny pair of iridescent butterfly wings composed of marquisetteItem:Corseted shadesatin longcoat with an overlay of dainty marquisette fairy wingstrue
Titillating spectrolite icesilk gown trimmed with a sheer panel of marquisetteDamsel In This Dress (4)
Violet thornweave houppelande overlaid with white marquisetteDamsel In This Dress (2)
Whimsical black and white marblesilk gown with raw silk texturingDamsel In This Dress (2)true