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=786
AND (
(t4.o_sortkey>='2459479.7635301')
))
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
19
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 | 529 | 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 (23%) | 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
CoMAP - Common Marker Addon ProjectCompass Navigation OverhaulCompletionist - BCS Lost Library PatchCompletionist - Skyrim Completion Tracker (NG)Completionist Creation Club and Unofficial PatchesConvenient Reading UI - SECrash LoggerCrash Logger SSE AE VR - PDB supportCreation Club Open HelmetsDeadly Spell Impacts Transparency Fix for ENBDear Diary Dark Mode - Compass Navigation Overhaul Updated PatchDear Diary Dark Mode - SkyUI Menus Replacer SEDetailing the Eldrich - Higher-Res Riekling ArchitectureDetailmap SeamfixDon't Push Me AroundDragons Shout with Voice Update - SSEDynDOLOD 3 AlphaDynDOLOD DLL NGDynamic Animation ReplacerELFX - Exteriors FixesELFX FixesENB Complex Grass - Patch Compendium for various grass modsENB Grass CollisionsENB Lights For Effect ShadersENB Particle Lights Dwemer LanternsENBSeriesElSopa - HD Keys Redone SEElSopa HD Iron Tools Redone SEElytra and Bliss Bug ENB LightEnhanced Lights and FXEnhanced Vanilla Textures ShrinesEnhanced Volumetric Lighting and ShadowsEssential FavoritesExtended UIExtended UI - Settings LoaderFar Object LOD Improvement Project SSEFavorite Misc ItemsFires and Embers Clipping FixFix Note Icon for SkyUI (SKSE64 plugin)Fixed Mesh LightingGhosts Mechanics and Shaders RestoredGlacier LOD MeshesGrass Cache FixesGrass Cache Helper NGGuard Dialogue Overhaul - UHDAP PatchHD Local MapHearthfires Extended and Creation Club Fishing PatchHigh Hrothgar FixedHighland Cows More Wooly - Cut Content RestorationHoly Cows - 4K and 2K TexturesHorse Stamina HUD - Script-FreeI'm Walkin' HereI'm walkin' here NGIce skating fixed for real - No more attack sliding movementIcy Mesh RemasterImmersive Equipment DisplaysImmersive Sounds - CompendiumInfinity UIInformed Mail DeliveryInventory Interface Information InjectorLabyrinthian Shalidor's Maze FixesLightened SkyrimMCM HelperMajestic Mountains - Bloodchill Manor Patch AEMajestic Mountains - More Accurate CollisionMajestic Mountains - Patch for Dynamic Volumetric Lighting and Sun ShadowsMajestic Mountains Creation Club Landscape PatchMajestic Mountains Double-Sided PatchMajor Cities Mesh OverhaulMasque of Clavicus Vile for Beast Race SEMesh Patch for Various ModsMore Lights for ENB - Blood Splatter FixNPC AI Process Position Fix - NGNPCs Learn to AimNavigator - Navmesh FixesNight MotherODIN spells for NPCSObsidian Mountain Fogs TweakedOxygen MeterOxygen Meter 2Papyrus Tweaks NGParticle Lights For ENB SE - Paragon GemsParticle Lights for ENB - Nordic Ruins CandlesParticle Lights for ENB Wisps WitchlightPowerofthrees TweaksQUIQuickLoot EERadiant - CandlesRallys TorchbugsRaven Rock - Fix Exit on HorsebackRegional Sounds ExpansionRelationship Dialogue Overhaul LiteRelationship Dialogue Overhaul Update and MCMRetexture for The Scroll SEReverb Interior Sounds ExpansionRobber's Gorge FixesRudy HQ More Lights for ENB SE BthardamzRudy HQ More Lights for ENB SE Deathbells and NirnrootsRudy HQ More Lights for ENB SE Glowing MushroomsRudy HQ More Lights for ENB SE Torchbugs and Moths