Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Has item property::drink]]
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='drink') AND t1.p_id=2021204)
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
5
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='drink') AND t1.p_id=2021204)
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
5
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, p_id, o_hash, s_id_2 | p_id | 262 | const, const | 1790 | Using index condition; 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
NoneContains | Garnish or Accent | Rarity | Source is | |
---|---|---|---|---|
Abriyit's Gemfire Wheat | Wax | abriyit's gemfire,theren guard crest,theren guard | common | Lion's Den Lounge |
Absinthe | Spider's Web (2) ,Spider's Web (1) | |||
Acrid lujeakave tea | Lujeakave | common | Augs Uda | |
Aesjaal with an Abiresean Monastery label | abiresean monastery | Village Tavern | ||
Aesry Island Tease | aesry island,aesry | Rothov ,Marachek's Feasterie,Item:Dirty canvas sack embroidered with a gladiolus blossom | ||
Aged Dwarven rum | Item:Ironwood bootlegger's crate reinforced with steel bands ,Item:Ironwood bootlegger's crate reinforced with steel bands | |||
Aged Prydaen bloodwyne | Bloodwyne,Prydaen bloodwyne | prydaen | festival | Naohhi's Boneyard ,Drathrok's Duskruin (location),Beyond the Barrier: The Devastation of Lyras/Incidental Loot |
Aged Rissan brandy | Brandy | festival | Reshalian Siegery Suppliers ,Irenos' Office | |
Aged Royal Crown whiskey | Whiskey | Hotagi'rath Theater (shop) | ||
Aged fratvarit garnished with an apple slice | Apple | Comfortable Rakash (2) ,Comfortable Rakash (1) | ||
Aged port | Spider's Web (2) ,Spider's Web (1) | |||
Aged sweet red wine | Red wine,Wine | Heketha Theater | ||
Aged tequila | Thirteenth Passage | |||
Aged whiskey | Whiskey | Silver Coin Inn | ||
Ain Ghazal absinthe | ain ghazal | River Fisher | ||
Ain Ghazal apple brandy | Apple | ain ghazal | Hunter's Tap Room | |
Ain Ghazal champagne | ain ghazal | River Fisher | ||
Ain Ghazal ouisque | ain ghazal | River Fisher | ||
Ain Ghazal red wine | ain ghazal | River Fisher | ||
Ain Ghazal white wine | ain ghazal | River Fisher | ||
Albarian pale ale | Ale,Albarian pale ale,Pale ale | albarian | Wayfarer's Tankard | |
Albino Lion Creme liqueur | Gold leaf,Golds | albino lion creme,theren guard | common | Lion's Den Lounge |
Alder ale | Alder | alder | common | Beech Glade |
Allye's poison tea | ||||
Almond delight coffee | Coffee,Almond,Almond delight coffee | almond delight,almond | Brewing | |
Almond delight tea | Almond,Brewing,Almond delight tea | almond delight,almond | Brewing | |
Almond liqueur | Almond | Whitehaven Hope ,Thornberry Dart,Merelew Wench,Fleetwing Gull | ||
Almond oil | Almond,Crafting oil,Almond oil | almond | Item:Dried almond ,Item:Almond | |
Almond wine | Almond | House of the Floating Reed (location) | ||
Amana's Alsala | Wine | festival | Wine Knot | |
Amber ale | Rothov ,Pierless Inn,Paladins' Guild ,Hallway,Item:Dirty canvas sack embroidered with a gladiolus blossom | |||
Amber ale (2) | ale | festival | Maerianna's Traveling Tavern | |
Amber beer | Beer | beer | Silver Coin Inn | |
Amber bottle of Snake Bite scotch | Item:Ironwood bootlegger's crate reinforced with steel bands | |||
Amber lager | Beach Snack Shop | |||
Amechra's Own Ale | Ale,Amechra's own ale | amechra | Broken Blade Tavern | |
Ananthor cabernet | Wine,Golds,Ananthor cabernet,Cabernet | ananthor,order of the theren guard crest | common | Lion's Den Lounge |
Ancient brandy | imperial | Gaethrend's Court | ||
Apple barrel whiskey | Whiskey | apple barrel | common | Trader Guildhall (Riverhaven) |
Apple brandy | Apple | Liani's Heaven | ||
Apple cider (1) | Apple | apple | Item:Lengthy cylinder | |
Apple cider (2) | Apple | Engine Room Roasting Pit (3) | ||
Apple cider (3) | Apple | Tenderfoot Inn ,House of the Grey Storm (location) | ||
Apple cider (4) | Apple,Apple cider,Cider | Silver Coin Inn | ||
Apple cordial | Apple | Elanthian Travel Tours (Therenborough) | ||
Apple delight coffee | Apple,Coffee,Apple coffee | apple delight,apple | Brewing | |
Apple delight tea | Apple,Apple tea | apple delight,apple | Brewing | |
Apple juice (1) | Apple | Skeleton Recipes ,Item:Lengthy cylinder,Item:Glass bottle | ||
Apple juice (2) | Apple,Apple juice | apple | Item:Apple (3) | |
Apple mead | Apple,Fruit,Apple juice | Whitehaven Hope ,Tipsy Barmaid,Talking Salmon,Merelew Wench |