Semantic search
Debug output SQLStore
ASK Query
[[Category:Cleanup]]
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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_fpt_inst` AS t1
INNER JOIN
`wiki_t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
RAND()
LIMIT
255
OFFSET
1
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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_fpt_inst` AS t1
INNER JOIN
`wiki_t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
RAND()
LIMIT
255
OFFSET
1
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 157 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | sarna_wiki.t2.id | 26 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | sarna_wiki.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) ('4967').
SELECT s_id FROM `wiki_smw_fpt_subc` WHERE o_id='4967' LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneCan this be improved?
- Bombard
- Arrow
- Starlight (Individual Essex-class WarShip)
- BattleMaster
- 1st Protectorate Guardians
- Orbisonia
- Jack Manterack
- Rastaban
- 1st Army
- Clan Widowmaker
- MechWarrior (1992 Video Game Resource)
- The Rock
- Wroxeter
- Cusset
- Iota Galaxy
- LRichardson/Sandbox/NewWeapon
- Zeus X
- Pleiades Cluster
- 16th Army (Star League)
- Centurion Weapon System
- Preston (FWL)
- Jyles
- The Inheritance of Duty
- Irece
- Winston (system)
- Deathstrike (MWO Hero 'Mech)
- Ch'in
- Timber Wolf (disambiguation)
- Overton (disambiguation)
- Roweena Kurita
- Peacekeeper (BattleMech)
- Pack Hunter
- Conqueror
- Tor Miraborg
- Hasek
- George Hasek
- Peter Joncas
- Flashman
- Kollion
- House Davion-Harland
- Verona Travesi
- OmniPod
- Dompaire
- Loparri
- Vordermark (Bloodname)
- Foster (disambiguation)
- Battle of Dahlgren
- Sorenson's Sabres
- Jieuny
- Wolf Hunters
- Donna Iona
- Galen Cox
- Noel
- Charles Marik (29th c.)
- Vengeance
- Hansen
- Janice Annapoulis
- Arcadia (FS)
- Yamarovka
- LB 2-X AC
- Dustball
- Aconcagua
- Monitor
- Warrior House Kamata
- Thunder (BattleMech)
- New Home
- TRO: 3057
- John Smith
- Abeda Measho
- Filtvelt Military Academy
- Whitestreak, Inc.
- Magistracy Armed Forces
- 77th Division (ComStar)
- Jules
- Battle of Hesperus II (3145)
- Talitha
- Baccalieu
- Environmental Reclamation Program
- Second Try
- Uvin Buhallin
- Cranston
- House Wong
- Mad Cat (disambiguation)
- Vega Prefecture
- 49th Shadow Division
- Constantin Assembly Plant M27 A-E
- Al Na'ir Prefecture
- Republican Guards
- Avalon
- Claudio Brett
- Hobbit Magazine
- Gateway
- Subpages
- Tian-zong
- Fred Gambino
- Javelin
- Nagasaki
- Bowang
- Prey's Divisionals
- Catapult II
- Ivan Druzinski
- Lacadon
- 3rd Wolf Lancers (Clan Wolf)
- Clovis Holstein
- Madiol
- 11th Wolf Guards (Clan Wolf-in-Exile)
- Labeled section transclusion
- Barcella Beta
- Vanessa Bisla
- Merridee De-Juc
- Ceres Metals Industries
- Subhash Indrahar
- Hutta Fetladral
- Henry Akbar
- Commando
- Milos
- Bright Thomlinson
- Ian McQuiston
- Alexander White
- Spirit
- Trentwash
- Ferris Ward
- Erde Centrella
- Troll
- A Show of Force
- Marauder IIC
- 5th Lyran Regulars
- Laurence Humphreys
- Ryerson
- Gossamer
- Huntress (Individual JumpShip)
- Li Ming Ling
- Essay:Clan Naval Forces
- Alpha Strike
- Dijon
- Michael Riktofven
- 2nd Caselton Protectorate Militia
- Romulus (disambiguation)
- People's Reconstruction Effort
- Battle of Wapakoneta (3139)
- A Rending of Falcons
- Sentinel
- Red
- Light fusion engine
- Kristen Marik
- Savonburg
- Suzano
- Triton
- Mad Cat Mk II
- The Fierce
- Knave of Hearts
- Stone's Revenants
- Palatine
- Jaime Wolf
- Gienah Combat Vehicles
- Oahu
- Belladonna
- Guided Technologies
- Turkalia
- Vosh
- 4th Arkab Legion
- Knute Kurita
- Irece Prefecture
- Groveld
- House Ritza
- Kossandra Centrella
- Games Unplugged
- Pascal Cole
- Tiruchchirappalli
- Jabuka
- Talos
- Titan
- Kondor
- KungsArmé
- Corgi
- Davion Warriors' Cabal
- Lotte Fischer
- 1st Marik Militia
- Diass
- Ariana Calderon
- Coventry Province
- Streator
- Snow Raven
- Memories of Fire and Ice at the Edge of the World
- Braghero
- Gehenna
- Amarok
- Gell
- Cruise Missile 120
- Imperial City
- Colchester
- Charles Davion (23rd c.)
- Solaris VII Slang
- Alec Colty
- Götterdämmerung (BattleMech)
- A quick guide to templates
- Preston (CC)
- Genf
- Clayborne
- Gregory Kelswa-Steiner
- Hsien Hotheads
- Spencer
- Caseless
- Viki Drexel
- Carson
- 3rd Proserpina Hussars
- Samarkand
- Society of St. Andreas
- Intruder (DropShip class)
- Heimdall
- Hatamoto-Chi
- Larresen
- New Hessen Armored Scouts
- Beagle Active Probe
- Heimdall (organization)
- Bamburgh
- Jeremy Ellman
- Kooken's Pleasure Pit
- Strong as Steel
- Achilles
- Uzhgorod
- Ilmachna
- IX Hastati Sentinels
- Copperhead (Individual spacecraft)
- Highlander
- Ford's Falcon-Killers
- Amur
- Hyde
- BBP Industries
- 1st Hesperus Guards
- Lester Kalasa
- Occum's Choice
- Thermopolis
- 5th Marik Militia
- Paladin of the Republic
- 35th Cruiser (Clan Diamond Shark)
- Odessa Regulars
- Blade Runner Magazine
- Montgomery Wilson
- Von Rohrs Coup
- Wesil
- Wolcott
- 53rd Battle
- Battle of Luthien (3067)
- Whitworth
- Carthage (disambiguation)
- Comet
- Pandora
- Elnath
- I Corps