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
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
prefix:

Control display of namespace in printouts
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[Category:Mods]]
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 t1
INNER JOIN
  `765_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
  t0.smw_sort ASC
LIMIT
  105
OFFSET
  100
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt2ALLPRIMARY15Using temporary; Using filesort
1SIMPLEt1refs_id, o_id, s_id_2, o_id_2o_id_25wiki.t2.id27Using index
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4wiki.t1.s_id1Using where
Auxilliary Tables
  • Temporary table t2
      Recursively computed hierarchy for element(s) (519).
      SELECT s_id FROM `765_smw_fpt_subc` WHERE o_id=519 LIMIT 1
Query Metrics
Query-Size:1
Query-Depth:0
Errors and Warnings
None
 AuthorThis property is a special property in this wiki.
Altitude - A Vanilla Plus Weather Mod
Amazing Ebony Armor Redone
Amber Guard
Ambiance - A Vanilla(plus) Ambient Lighting Overhaul
Ambient Seagulls
Ambient Wasteland 2
Ammo Burst Case Count Fix
Ammo Ingredients as Loot
Ammo Script Fixes
Ancient Knowledge Loadscreens
Ancient Nord Armor
Ancient Nord Armor Fix
Animal Sounds
Animated Cigarettes - Smoke me Im famous
Animated Clutter
Animated Dwemer Lift Load Doors
Animated Ingestibles
Animated Weapon Enchants
Animated Weapon Enchants
Animated Window Lighting System and Chimneys - AWLS
Animation Improvements
Anniversary Anim Pack
Anniversary Anim Pack - General Bugfix
Another Vault 81 Molerat Disease Cure
Apachii SkyHair
ApachiiSkyHair Natural Retexture
Apocalypse Now Quest
Apocalypse Spell Package
Apple Garden
Appropriately Attired Jarls
Arbitrated Patches - Requiem - You Hunger - Open CIties - INPC - ETAC
Arcade Rehired - Recruit After Quest
Archery Quick Shot Perk Bug Fix
Arctic - Frost Effects Redux
Arena Redone HD
Argonian Decapitation Fix
Argonian Sneak Tail Twist Fix
Arise - Chapter 1 - The Black Sacrament
Armamentarium Complete 1-35
Armor Mesh Fixes
Armor Mesh Fixes SE
Armor Paint Extended
Armor Replacer Child NPC Fix
Armor and Clothing Extension
Armor and Clothing Overhaul
Armor and Clothing for Kids
Armored Skeletons
Armour Repair Kits
Arrow Pickup Fix
Arrows and Bolts Tweaks
Ars Metallica-Smithing
Artifacts 1-1
Artifacts Redone
Ash Pile
Aspens Ablaze
Aspens Ablaze Add-On - DynDOLOD 3
Assorted mesh fixes
Asteroid Fields
Asterras Many Fixes
At Your Own Pace
Atlas Map Markers
Atlas Map Markers SE - Updated with MCM
Atmospheres 4 Heaven and Hell
Atom Cats Drag Race Start Fix
Audio Overhaul - Immersive Sounds Integration
Audio Overhaul Patches
Audio Overhaul for Skyrim
Audio Overhaul for Skyrim SE
Audio Overhaul for Skyrim-Patches
Aurora Doomstone Package
Aurora Village
Authentic Burned Man
Auto Hide Ammo
Auto Hide HUD
Auto Highlight Outpost Items
Auto Unequip Ammo
Auto Use Soulgems
Automatic Variants
Automatically Lowered Weapons
Autosave Manager
B42 Weapon Inertia
BM - Grahl Replacer
BOSS
BOSS Userlist Manager
BSAopt - Bethesda Archive Management and Optimization
Back Off Barbas
Backported Extended ESL Support
Baka Achievement Enabler
Baka Framework
Baka Wait Anywhere
Balbors and Steelsouls SkyRe Reproccer Patches
Bandolier
Bandolier - Bags and Pouches
Bandolier - Bags and pouches
Bandolier - Dawnguard
Bandolier for NPCs
Baranistye sheep
Bard Instrumentals Only - Sing Upon Request
Barefoot Footstep Sounds for the Nightwear and Swimsuit
Barenziahs Glory