Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Oilcloth]]OR[[Uses material::Oilcloth]]
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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 | ALL | PRIMARY | 299 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE (t2.o_hash='Oilcloth')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=68457 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Belt (3) | Brisson's Haberdashery (obsolete) , Brisson's Haberdashery | |
Item:Belt pouch | Captain Namazzi's Ship Goods | |
Item:Beret | Meek's Stitchery , Marcipur's Stitchery, Brisson's Haberdashery (obsolete), Brisson's Haberdashery | |
Item:Black oilcloth cloak with a missing clasp | Pi'rasha's Pins (3) | true |
Item:Black oilcloth duffel bag with sturdy leather straps | House of the Floating Reed (shop) | |
Item:Blood-red leather alchemist's kit clasped with an onyx scorpion | On the Mend (1) | |
Item:Blood-stained oilcloth pouch | Dunshade: Echo of Tears/End loot | |
Item:Blue oilcloth pouch labeled "Feed Me" | Dying to Shop (1) | |
Item:Blue-green oilcloth longcoat with carved ayabere buttons | Item:Electroweave carryall embroidered with a sinuous leviathan | |
Item:Boots (2) | Dokker's Workshop, Grek's Food and Supplies , Dokker's Workshop | |
Item:Bowtie | Brisson's Haberdashery (obsolete) , Brisson's Haberdashery | |
Item:Boxy canvas tote with handles | Breaking and Entering/Kitchen loot | |
Item:Braies | Brisson's Haberdashery (obsolete) , Brisson's Haberdashery | |
Breaking and Entering/Rooms and Loot/Material options | ||
Item:Breeches | Grek's Food and Supplies, Tarsha's Emporium , Grek's Food and Supplies, Dokker's Workshop, Brisson's Haberdashery (obsolete), Brisson's Haberdashery | |
Item:Breeches (1) | Tarsha's Emporium | |
Item:Brown oilcloth midwife's bag with a carved linden leaf clasp | Jakuv's All-Trades Outlet (3) , Jakuv's All-Trades Outlet (2), Jakuv's All-Trades Outlet (1) | |
Item:Brushed suede alchemist's kit with a carved jasper ox | On the Mend (1) | |
Item:Buckskins | Brisson's Haberdashery (obsolete) , Brisson's Haberdashery | |
Item:Buff-colored oilcloth backpack with leather straps | Tougher Than Weather | true |
Item:Burnoose | Marcipur's Stitchery | |
Item:Butcher's knife fit with a short hilt | Breaking and Entering/Kitchen loot | |
Item:Caftan | Marcipur's Stitchery | |
Item:Calotte | Brisson's Haberdashery (obsolete) , Brisson's Haberdashery | |
Item:Capote | Brisson's Haberdashery (obsolete) , Brisson's Haberdashery | |
Weapon:Cast-iron skillet painted with dancing forks | Breaking and Entering/Kitchen loot | |
Item:Cloak (1) | Peddler's Wagon (obsolete) , Meek's Stitchery, Marcipur's Stitchery | |
Item:Cloak (3) | Grek's Food and Supplies, Grek's Food and Supplies | |
Item:Cloche | Marcipur's Stitchery | |
Item:Coat (2) | Brisson's Haberdashery | |
Item:Compact forester's pouch embroidered with "100!" in black thread | Tavern Troupe Performing Order/Gifts and prizes | |
Item:Compact textbook bound with a cover | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Cravat | Brisson's Haberdashery (obsolete) , Brisson's Haberdashery | |
Item:Crimson canvas alchemist's kit ornamented by a black diamond raven | On the Mend (1) | |
Item:Crimson oilcloth hat with a purple ostrich feather plume | Tastelessly Tacky (9) , Tastelessly Tacky (7), Tastelessly Tacky (5), Tastelessly Tacky (4) | |
Item:Culottes | Ongadine's Garb and Gear , Marcipur's Stitchery | |
Item:Cummerbund | Brisson's Haberdashery (obsolete) , Brisson's Haberdashery | |
Item:Dark brown oilcloth mantle | In The Snow (3) | true |
Item:Dark oilcloth alchemy sack with a crystal-inlaid silver clasp | Thieves' Guild Shop (Ain Ghazal) | false |
Item:Dark oilcloth apron painted with a snarling red-eyed kitten | Packrat's Paradise (8) , Packrat's Paradise (2) | |
Item:Dark oilcloth pack with reinforced straps | Beyond the Barrier: The Devastation of Lyras/Incidental Loot | |
Item:Ditty bag | Captain Namazzi's Ship Goods | |
Item:Doublet (1) | Brisson's Haberdashery (obsolete) | |
Item:Doublet (2) | Brisson's Haberdashery | |
Item:Dress | Meek's Stitchery , Marcipur's Stitchery, Clothiers | |
Item:Duffel bag | Captain Namazzi's Ship Goods | |
Item:Dusty rose satin alchemist's kit with a bejeweled wren fastener | On the Mend (1) | |
Item:Ecru oilcloth crafting apron | Knight in Shining Scholar | true |
Item:Empty glass cider jug wrapped in leather | Breaking and Entering/Kitchen loot | |
Item:Felt hat (1) | Brisson's Haberdashery (obsolete) , Brisson's Haberdashery |