Semantic search
From Step Mods | Change The Game
Debug output SQLStore
ASK Query
[[Category:SkyrimSE Mods]] [[Creation date::≥1 January 2021]]
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=786
AND (
(t4.o_sortkey>='2459215.5')
))
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
200
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>='2459215.5')
))
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
200
SQL Explain
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 | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, o_sortkey | s_id | 4 | wiki.t2.s_id | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneCreation date"Creation date" is a predefined property that corresponds to the date of the first revision of a subject and is provided by <a target="_blank" rel="nofollow noreferrer noopener" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a>. | Creation date"Creation date" is a predefined property that corresponds to the date of the first revision of a subject and is provided by <a target="_blank" rel="nofollow noreferrer noopener" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a>. | |
---|---|---|
Spellbreaker Spell Reflection and Ward Visuals Restored | June 30, 2022 | 2459761.420706 |
Splashes Of Skyrim | May 12, 2021 | 2459347.2259722 |
Static Mesh Improvement Mod Improvement Mod | December 10, 2021 | 2459559.3125347 |
Static Mesh improvement Mod - SMIM - Quality Addon | December 09, 2021 | 2459558.4520833 |
Stay At The System Page - AE | May 23, 2022 | 2459722.5281829 |
Step Patch - Lighting and Weather | January 11, 2021 | 2459225.8701157 |
Step Patch - Post-Processing | November 15, 2021 | 2459534.3002315 |
Superior Chaurus - 4k Retexture | January 11, 2021 | 2459225.7739468 |
Superior Mudcrab - 4k Retexture | January 11, 2021 | 2459225.5734375 |
TK Children SE | January 10, 2021 | 2459225.4369792 |
Torch Remover | September 11, 2021 | 2459469.3576505 |
UIExtensions | November 05, 2023 | 2460253.6926157 |
Umgak's Vokrii Compatibility Patch Compendium | October 09, 2021 | 2459497.2731829 |
Unequip Quiver SE | January 11, 2021 | 2459225.6129745 |
Unique Map Weather Framework | March 04, 2022 | 2459642.5837384 |
Unnecessarily Fixed Fixed Dragon Stalking Fix | January 11, 2021 | 2459225.7044097 |
Unofficial Skyrim Creation Club Content Patches | November 21, 2021 | 2459540.34125 |
Vokrii - Complete Alchemy and Cooking Overhaul Patch | June 30, 2022 | 2459761.4089468 |
Vokrii - Minimalistic Perks of Skyrim | March 08, 2021 | 2459281.7003241 |
Vokrii Perks For NPCS | October 15, 2021 | 2459503.2281019 |
Whiterun Mesh Fixes | May 12, 2021 | 2459347.2286806 |
Whiterun Skyforge - Reforged | May 12, 2021 | 2459347.2410995 |
Whose Quest is it Anyway NG | October 21, 2022 | 2459873.5684607 |
Wider MCM Menu for SkyUI | December 19, 2021 | 2459567.5175694 |
Window Shadows RT | August 10, 2021 | 2459437.3243171 |
WoW Dragon Mounds CTD Fix | February 27, 2022 | 2459637.5745486 |
Word Wall Transparency Fix for ENB | December 19, 2021 | 2459568.4526389 |
Worldspace Transition Tweaks | July 03, 2022 | 2459763.6510764 |
Worldspaces with Grass SSEEdit Script | September 05, 2021 | 2459463.3691435 |
Wyrmstooth | October 28, 2021 | 2459516.445625 |
XLODGen Resource - SSE Terrain Tamriel | October 11, 2021 | 2459499.4626505 |
XP32 Maximum Skeleton SE - Fixed Scripts | March 25, 2021 | 2459298.7338079 |
XPMSSE - Nemesis - Papyrus Stack Fix | March 03, 2022 | 2459641.6535532 |
Yes Im Sure NG | October 21, 2022 | 2459873.5591898 |