Semantic search
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
`765_smw_object_ids` AS t0
INNER JOIN
(`765_smw_fpt_inst` AS t2
INNER JOIN
`765_smw_fpt_cdat` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=777
AND (
(t4.o_sortkey>='2459238.8400116')
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
57
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 1075 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t4 | ref|filter | s_id, o_sortkey | s_id|o_sortkey | 4|9 | wiki.t2.s_id | 1 (39%) | Using where; Using rowid filter | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where |
Query-Depth:1
Eye Normal Map FixFALMERFISSFarmhouse ChimneysFire Halo RemoverFollower Trap SafetyFont OverhaulFores New Idles in SkyrimFrankly HD Dragonbone and DragonscaleFrankly HD Thieves Guild ArmorsFuz Ro D-ohGIANTGIST - Genuinely Intelligent Soul TrapGildergreen RegrownGo On AheadGuard Dialogue OverhaulHAGRAVENHD Dark Brotherhood DoorHD Enhanced TerrainHD Executioners BlockHD Reworked HorseHD Reworked HorsesHORNCANDLESHardy HaresHearthfire ExtendedHelarchen CreekHigh-Res Dartwing TextureHunters Not BanditsHybrids HD Plants and Herbs RetextureHyperborean Snow LEIHSS-Improved Horse StepsImmersive DragonsImmersive SmilodonsImproved Closefaced HelmetsImproved SparksImproved Weapon Impact EffectsInvisibility and Underwater Eyes Mesh FixLightning During Thunder StormsLock OverhaulLuminosity Lighting OverhaulMAMMOTHMain Menu Spinning EmblemMajestic MountainsMasque of Argonian VileMetallurgy - Ingots Ore and Veins HDMoreHUD Inventory EditionNew Thinner TorchNightingale PrimeNoMaaM Breathing IdlesNon-Essential ChildrenNot Really HD-DisplayNot So Fast - Mage GuildNot So Fast-Main QuestOblivion GatesPapyrusUtil-Modders Scripting Utility FunctionsPilgrim's DelightPoint the WayRUSTIC AMULETSRUSTIC ARMOR and WEAPONSRUSTIC AZURAS STARRUSTIC COOKING STATIONRUSTIC DAEDRARUSTIC DEATH HOUNDRUSTIC DRAGON CORPSERUSTIC DRAGONSRUSTIC FORSWORNRUSTIC FROSTBITE SPIDERRUSTIC GARGOYLERUSTIC NORDIC MURALSRUSTIC SPRIGGANRUSTIC WINDOWSRaceMenuRallys Hanging MossRallys Hooks and SawsRallys InstrumentsReal Wood Textures-FarmhousesRealistic AI DetectionRealistic Boat BobbingRealistic HD BasketsRealistic HD Woodcutters AxeRealistic Water TwoRelationship Dialogue OverhaulRelighting SkyrimRens HD ShrinesRun Sprint and JumpRunning With BowsSABRECATSKELETONSKSESKSE Plugin PreloaderSKSE-Elys-testSM Drop Lit TorchesSeptim HDSilly Level of Detail-Wine CellarSimple Children LESkyUISkygazer MoonsSkyrim Coin Replacer ReduxSkyrim Improved PuddlesSkyrim Project Optimization