Semantic search

From Step Mods | Change The Game
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
import-annotation:

Additional annotated data are to be copied during the parsing of a subject
propsep:

The separator between the properties of a result entry
valuesep:

The separator between the values for a property of a result
template:

The name of a template with which to display the printouts
named args:

Name the arguments passed to the template
userparam:

A value passed into each template call, if a template is used
class:

An additional CSS class to set for the list
introtemplate:

The name of a template to display before the query results, if there are any
outrotemplate:

The name of a template to display after the query results, if there are any
sep:

The separator between results
prefix:

Control display of namespace in printouts
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[Category:SkyrimLE Mods]] [[Creation date::≥24 January 2021 08:09:37]]
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
  `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
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2o_id_25const1075Using index; Using temporary; Using filesort
1SIMPLEt4ref|filters_id, o_sortkeys_id|o_sortkey4|9wiki.t2.s_id1 (39%)Using where; Using rowid filter
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4wiki.t2.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None

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