Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Apple||applewood]]OR[[Uses material::Apple||Applewood]]
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 | 204 | 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='Apple') OR (t2.o_hash='applewood'))
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 INNER JOIN `t6` AS t6 ON t4.o_id=t6.id WHERE t4.p_id=2021246 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1 - Temporary table t6
INSERT IGNORE INTO `t6` (id) VALUES (67532)
INSERT IGNORE INTO `t6` (id) VALUES (531180)
Query Metrics
Query-Size:6Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rarity is |
---|---|---|
Apple blossom tree | Delightful Decor | |
Apple brandy | Liani's Heaven | |
Apple cider (1) | Item:Lengthy cylinder | |
Apple cider (2) | Engine Room Roasting Pit (3) | |
Apple cider (3) | Tenderfoot Inn , House of the Grey Storm (location) | |
Apple cider (4) | Silver Coin Inn | |
Apple cider custard tart swirled with cinnamon and nutmeg | Thipbeet's Tart Boutique | |
Apple cordial | Elanthian Travel Tours (Therenborough) | |
Apple cores | Too Much of a Good Sling | |
Apple delight coffee | Brewing | |
Apple delight tea | Brewing | |
Apple dragon-shaped lollipop | Rothov , Pawla's Permutations (Siksraja), Item:Black oak beam mottled by weathering | |
Apple fritter | Item:Uncooked dough with sliced apples | |
Apple juice (1) | Skeleton Recipes , Item:Lengthy cylinder, Item:Glass bottle | |
Apple juice (2) | Item:Apple (3) | |
Apple mead | Whitehaven Hope , Tipsy Barmaid, Talking Salmon, Merelew Wench | |
Apple muffin | Temple of Light | |
Apple pie decorated with the words "HAPPY BIRTHDAY!" | Famous Last Words (3) , Famous Last Words (2), Famous Last Words (1) | |
Apple pipe | Random creature drop , Fine Leaf's End | |
Apple pulp | Item:Apple (3) | |
Apple scruppy | Zuhaichaga Inn | |
Apple seed bracelet | Curse of the Ghost Ship/Incidental Loot | |
Apple strudel cupcake iced with brown sugar frosting dusted in cinnamon | Cupcake Cafe | |
Apple tart (1) | Packrat's Paradise (8) , Kifa Awrocis (Siksraja), Bandagat's Wagon | |
Apple tart (2) | Liani's Heaven | |
Apple toffee doughnut | Saralt Kaste | |
Apple turnover | Saltfisher Inn | common |
Apple walnut cake | Sweet Delights | |
Apple wine | Trader Guildhall (Muspar'i) | |
Apple-filled snickerdoodle sprinkled with cinnamon-sugar | Shugar's Cookie Emporium (4) , Shugar's Cookie Emporium (3), Shugar's Cookie Emporium (2), Shugar's Cookie Emporium (1) | |
Apple-flavored sherry | Cookie Emporium | |
Apple-smoked gar sausage | Jester's General Store | |
Apple-streusel cookie | Saralt Kaste | |
Apple-walnut cake | Griniel's Cottage | |
Applejack brandy | Glythtide's Gift , Baearholt's Tavern | |
Applewood foot brush with soft goat-hair bristles | Berolt's Dry Goods | |
Applewood log | Yerui's Woodcraft | |
Applewood mirror depicting a Rakash with Katamba-black coat markings | Aesthene's Close 449/End Loot , Aesthene's Close 445/Vault | end loot |
Applewood wand topped with an autumn jasper pumpkin | Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot | incidental |
Applewood-handled carving knife engraved with a grinning jack-o-lantern | Estate Holder gifts , Item:Bright pumpkin-hued sack stitched with black thread | gift |
Artistically woven applewood picnic basket adorned with Rakash charms | Tavern Troupe Performing Order/Gifts and prizes | |
Autumn sangria swirled with frozen fruit | Fair Faire Fare (4) , Fair Faire Fare (3), Fair Faire Fare (2), Fair Faire Fare (1) | |
Baked apple | Persida's Home , Flowering Furniture (3), Flowering Furniture (2), Flowering Furniture (1), Bacon Man's Birthday Bash 419/Pig Maze | festival |
Berengaria harvest apple | Dabvo's Holy Delicacies | |
Braided leather belt dangling tiny skull masks made of dried apple | Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot, Sleeping Dragon Corn Maze 428/Incidental loot | |
Brass stein with a carved applewood handle | Fall's Harvest (1) | |
Bright green apple | ||
Bright red apple | Drathrok's Duskruin (location) , Crossing flora | festival |
Broiled boar with apple-walnut stuffing | Hunter's Tap Room | |
Brown-sugared apples | Momma's Bed and Breakfast , Dining Room |