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
119
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
RUSTIC 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 OptimizationSkyrim RedesignedSkyrim Skill Interface Re-TextureSkyrim-Community-UncapperSmaller Ice Spikes and SpearSmaller Vanilla CursorsSmithing Perks OverhaulSmooth Blade Draw and SheatheSmooth Sky MeshStealth Skills RebalancedStep Patch - Conflict ResolutionStep Patch - Lighting and WeatherStronger Swimming AnimationSweet MotherTK ChildrenTROLLTavern AI fixTempered Skins for MalesThe 418th StepThe Choice is YoursThe Elder Scrolls V Rewritten-ArvakThieves Guild RequirementsThundering ShoutsTiming is EverythingTorches and Shock Spells Ignite OilTrade and BarterTraps Make NoiseUltimate HD Fire EffectsUltimate HD TorchUnequip QuiverVanilla Makeup HDVanilla Warpaints AbsolutionVerdantViewable Faction RanksVivid Clouds and FogsVivid Landscapes-Tundra Moss RevisedWEBS extendedWISPMOTHERWSCO - Windsong Skyrim Character OverhaulWeapons and Armor FixesWet and ColdWhite Phial ReplacerWiseman303s Critter FixesWiseman303s Trap FixesWonders of WeatherXPMS Extended