Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Silveress]]
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=353092)
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
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=353092)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 77 | Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Exquisite lilac silveress court gown accented with plum brocade ribbons | Damsel In This Dress (3) | |
Item:Extravagant spun glitter capelet fastened with a massive silveress bow | Puffs of Glitter (3) | |
Item:Fashionable silveress tshoga lined with black satin | Farhana's Island Exquisites (2) | true |
Item:Formal black-tinged trousers made of silveress with a silver stripe down each leg | Natural Beauty (4) | true |
Item:Gathered knee-length silveress skirt with ebon-hued embroidery along the hemline | Hero to Go (4) , Hero to Go (3) | true |
Item:Glimmering windstorm gossamer pocket trimmed in silveress | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Item:Glistening silveress sheath dress dappled with frost opals | Damsel In This Dress (3) | |
Item:Glitzy twilight evening gown of spun glitter and silveress | Puffs of Glitter (3) | |
Item:Goldweave and silveress jester's hat with tiny platinum bells | Carpin Capers | |
Item:Goldweave coin purse with two silveress arm straps | Excess Baggage (2) | |
Item:Greenish silveress robes sewn with forty jade chimera beads | Misenseor Goods (6) , Misenseor Goods (5) | |
Item:High-collared calf-length silveress cloak trimmed with ebon-hued silken embroidery | Hero to Go (4) , Hero to Go (3) | true |
Item:Hollow Eve 439 gift | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439 | true |
Item:Dark silveress bag clasped with a jeweled icesteel turtle | ||
Item:Jewel-necked jaalmin wedding gown swagged in sweeps of glistening silveress | Wedding Belles (2) , Wedding Belles (1) | |
Item:Large bolt of silveress fabric | Fabric Fantasies (4) , Fabric Fantasies (3) | |
Item:Long-sleeved silveress doublet lined with golden silk | ||
Item:Lovely handbag with a liquid silver sheen visible under a streaked jaspe overlay | Limited Treasures (1) | |
Item:Lush zibeline rantija trimmed in silveress | Comfortable Rakash (3) , Comfortable Rakash (2), Comfortable Rakash (1) | |
Item:Luxurious goldweave and silveress turban fettered with an elaborate brooch | Natural Beauty (2) | |
Item:Medium bolt of silveress fabric | Fabric Fantasies (4) , Fabric Fantasies (3) | |
Item:Narrow silveress harness stitched with cresting waves | Piralpa Tridents (3) | |
Item:Niniam-belled bandeau top of multihued silveress with off-the-shoulder sleeves | Limited Treasures (1) | |
Item:Pair of aqua lotusweave trunk-hose lined with silveress | Knight at the Club (2) , Knight at the Club (1) | true |
Item:Pair of black twill vikses edged in silveress | Comfortable Rakash (1) | |
Item:Pair of crimson organdy pantaloons lined with silveress | Farhana's Island Exquisites (2) | true |
Item:Pair of shimmering silveress harem pants | Hollow Eve Festival 421/Raffles | |
Item:Pair of silveress pantaloons embellished with tiny black ribbon flowers | Farhana's Island Exquisites (2) , Farhana's Island Exquisites (1) | |
Item:Pale lavender wedding gown with a cascading train of silken twilight gladioli | Wedding Belles (2) , Wedding Belles (1) | |
Item:Pale-blue moonsilk poke drawn with silveress strings | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade | true |
Item:Particolored silveress and marquisette mask | Item:Particolored marquisette and jaspe tote trailing harlequin-patterned aerial silks , Limited Treasures (1) | |
Item:Perfectly mismatched pair of black jaspe and silveress dancing slippers | Item:Particolored marquisette and jaspe tote trailing harlequin-patterned aerial silks , Limited Treasures (1) | |
Item:Polychromatic silveress pantaloons with a niniam and rainbow sapphire belt | Limited Treasures (1) | |
Item:Sage green brocade sarrak belted with a silveress sash | Rizadi's Outfitters (4) | true |
Item:Sensational silveress symphony sack stuffed with slightly shredded song scrolls | Kitten Emporium (3) , Kitten Emporium (2) | |
Item:Shimmering silveress wrap interwoven with fragrant star jasmine blossoms | Puffs of Glitter (3) | |
Item:Shiny silveress kimono embroidered with yellow daffodils poking through snow | Raw Silk (2) , Raw Silk (1) | true |
Item:Silveress bliaut lined with ebony silk | Knight at the Club (2) , Knight at the Club (1) | true |
Item:Silveress cloak lined with pure white shadesatin | In The Snow (3) , In The Snow (2) | true |
Item:Silveress cloth | Fit to be Tied (2) , Fit to be Tied (1) | true |
Item:Silveress coat with carved tamboti buttons | Scorpion Shop | |
Item:Silveress corset lined with black crepe silk | Tighten Up (2) , Tighten Up (1) | true |
Item:Silveress dress with a wide knee-length skirt | Field Fashion (2) , Field Fashion (1) | true |
Item:Silveress gamantang with long sleeves | Rizadi's Outfitters (4) | true |
Item:Silveress kilt with blackened iron buckles | Field Fashion (2) | true |
Item:Silveress quilted coat with royal blue silk piping | Row Row Row Your Coat | true |
Item:Silveress robe with a standup collar | Emperor's New Robes (2) , Emperor's New Robes (1) | true |
Item:Silveress sarrak belted with a black silk braided cord | Rizadi's Outfitters (4) | true |
Item:Silveress umbrella trimmed with black fringe | Tougher Than Weather | true |
Item:Sleek shadesatin pants embellished with silveress bands | Fashionable Panda (2) |