Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item:+]] [[Noun is::flint]]
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_object_ids` AS t2
INNER JOIN
`smw_di_blob` AS t3 ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=118
AND (
(t3.o_hash='flint') AND t3.p_id=2021224)
)
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_object_ids` AS t2
INNER JOIN
`smw_di_blob` AS t3 ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=118
AND (
(t3.o_hash='flint') AND t3.p_id=2021224)
)
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 | t3 | ref | s_id, p_id, o_hash, s_id_2 | p_id | 262 | const, const | 55 | Using index condition; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t3.s_id | 1 | Using where | |
1 | SIMPLE | t2 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | drwiki.t3.s_id | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneSource | |
---|---|
Ghoul-shaped black flint | Simply Essential (1) |
Glossy grey harp-shaped flint | Simply Essential (2) |
Gouged piece of flint | Item:Olive-green oilcloth alchemist's haversack with a black iron clasp , Jakuv's All-Trades Outlet (3) |
Grey gargoyle-shaped flint | Simply Essential (1) |
Grey wolf-shaped flint | Item:Smoky black leather alchemist's kit with a carved alexandrite wolf , Simply Essential (1), On the Mend (1), Item:Smoky black leather alchemist's kit with a carved alexandrite wolf |
Jagged piece of flint | Mob Mentality (5) , Mob Mentality (4), Mob Mentality (3) |
Large grey flint | Quelling the Riot/End loot , Item:Black and grey striped haversack fashioned from dirty pillowcases, Item:Black and grey striped haversack fashioned from dirty pillowcases |
Lion-shaped flint | On the Mend (1) , Item:Amber leather alchemist's kit graced by a burnished gold lion, Item:Amber leather alchemist's kit graced by a burnished gold lion |
Mottled armadillo-shaped flint | Simply Essential (2) |
Mug-shaped flint | Glythtide's Gifts and Gags |
Orange present-shaped flint | Glythtide's Gifts and Gags |
Pale green fist-shaped flint | Simply Essential (2) |
Piece of black flint | Zerek's General Store , Therenborough General Store, Item:Supply sack, Snowy Wagon, Random creature drop, Pumpkin Carving, Morum Melgorehn/Incidental Loot, Marachek's General Store, Kindled Spirit (6), Kindled Spirit (5), Hero to Go (3), Hero to Go (2), Dzil'Tseyi, Item:Dirty canvas sack embroidered with a gladiolus blossom, Delkai's Store, Dahl Aeliy Provisions and Wares, Corik's Secret: Treasures of the Tomb/Incidental loot, Captain Namazzi's Ship Goods, Berolt's Dry Goods (obsolete), Berolt's Dry Goods |
Piece of black flint shaped like a fang | Bacon Man's Birthday Bash 419/Pig Maze |
Piece of black flint shaped like a starfish | Thorkim Family Farm 429/Pig Maze |
Piece of dragon-shaped flint | Estate Holder gifts |
Purple grape-shaped flint | Glythtide's Gifts and Gags |
Rat-shaped black flint | Simply Essential (1) |
Red apple-shaped flint | Glythtide's Gifts and Gags |
Ruddy brown flint shaped like a quarter moon | Simply Essential (2) |
Ruddy heart-shaped flint | Thorkim Family Farm 429/Pig Maze |
Unyn-shaped grey flint | Simply Essential (1) |
Wren-shaped grey flint | Simply Essential (1) |
Yellow bee-shaped flint | Glythtide's Gifts and Gags |