Semantische Suche
Aus DotAWiki
Zur Navigation springenZur Suche springenDebug output SQLStore
ASK Query
[[Kategorie:Guide]] [[Artikelversion::+]]
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=532)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
50
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=532)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ALL | PRIMARY | 3 | Using temporary; Using filesort | ||||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | db_dswiki.t3.id | 13 | Using index | |
1 | SIMPLE | t4 | ref | s_id, s_id_2, p_id | s_id | 8 | db_dswiki.t2.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | db_dswiki.t2.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (35303).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=35303 LIMIT 1
Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneZuletzt geändert„Zuletzt geändert <span style="font-size:small;">(Modification date)</span>“ ist ein softwareseitig fest definiertes Attribut, das das Datum der letzten Änderung einer Seite speichert. Es wird von <a rel="nofollow" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a> zur Verfügung gestellt. | Artikelversion | |
---|---|---|
Tab-Guide zu Dazzle | 7 Juni 2022 12:24:33 | 6.83d |
Tab-Guide zu Dragon Knight | 25 Mai 2022 07:56:30 | 6.83d |
Tab-Guide zu Earthshaker | 17 Mai 2022 12:42:57 | 6.83d |
Tab-Guide zu Enigma | 30 November 2022 09:17:50 | 6.83d |
Tab-Guide zu Faceless Void | 17 Mai 2022 10:57:21 | 6.83d |
Tab-Guide zu Furion | 14 März 2023 10:31:27 | 6.83d |
Tab-Guide zu Goblin Techies | 30 November 2022 12:33:30 | 6.83d |
Tab-Guide zu Io, Guardian Wisp | 19 September 2023 14:10:44 | 6.83d |
Tab-Guide zu Jakiro | 30 November 2022 12:49:32 | 6.83d |
Tab-Guide zu Krobelus | 9 Januar 2023 12:00:48 | 6.83d |
Tab-Guide zu Kunkka | 17 Mai 2022 12:06:04 | 6.83d |
Tab-Guide zu Lanaya | 16 Oktober 2023 10:37:19 | 6.83d |
Tab-Guide zu Leshrac | 30 November 2022 08:23:13 | 6.83d |
Tab-Guide zu Lich | 22 November 2022 11:13:48 | 6.83d |
Tab-Guide zu Lina | 6 November 2023 10:04:09 | 6.83d |
Tab-Guide zu Luna | 14 November 2022 12:49:35 | 6.83d |
Tab-Guide zu Lycanthrope | 17 Mai 2022 10:45:14 | 6.83d |
Tab-Guide zu Magnus | 30 November 2022 09:36:47 | 6.83d |
Tab-Guide zu Medusa | 14 November 2022 13:15:24 | 6.83d |
Tab-Guide zu Meepo | 30 Januar 2023 15:24:26 | 6.83d |
Tab-Guide zu Necrolyte | 9 Januar 2023 10:29:42 | 6.83d |
Tab-Guide zu Nessaj | 18 April 2023 12:21:02 | 6.83d |
Tab-Guide zu Nevermore | 10 Januar 2023 11:44:45 | 6.83d |
Tab-Guide zu Ogre Magi | 10 Januar 2023 13:50:45 | 6.83d |
Tab-Guide zu Omniknight | 9 Januar 2023 10:20:02 | 6.83d |
Tab-Guide zu Panda | 1 September 2021 13:52:54 | 6.83d |
Tab-Guide zu Phoenix | 13 September 2023 13:21:29 | 6.83d |
Tab-Guide zu Potm | 30 November 2022 10:26:41 | 6.83d |
Tab-Guide zu Puck | 25 Januar 2023 14:17:49 | 6.83d |
Tab-Guide zu Pudge | 14 November 2022 13:41:13 | 6.83d |
Tab-Guide zu Rexxar | 25 Januar 2023 12:24:20 | 6.83d |
Tab-Guide zu Rikimaru | 25 Januar 2023 13:23:19 | 6.83d |
Tab-Guide zu Rooftrellen | 25 Januar 2023 11:46:39 | 6.83d |
Tab-Guide zu Shadow Demon | 23 Januar 2023 11:20:38 | 6.83d |
Tab-Guide zu Sniper | 31 Mai 2022 12:07:25 | 6.83d |
Tab-Guide zu Strygwyr | 30 November 2022 11:28:55 | 6.83d |
Tab-Guide zu Sven | 4 Januar 2023 11:43:20 | 6.83d |
Tab-Guide zu Syllabear | 19 Juli 2021 12:46:33 | 6.83d |
Tab-Guide zu Tauren Chieftain | 23 Januar 2023 12:09:41 | 6.83d |
Tab-Guide zu Thrall | 25 Januar 2023 14:02:04 | 6.83d |
Tab-Guide zu Tidehunter | 23 Januar 2023 14:11:58 | 6.83d |
Tab-Guide zu Tinker | 30 November 2022 11:17:27 | 6.83d |
Tab-Guide zu Tiny | 25 Januar 2023 13:52:20 | 6.83d |
Tab-Guide zu Traxex, Drow Ranger | 4 Dezember 2023 11:17:24 | 6.83d |
Tab-Guide zu Vengeful Spirit | 19 Juli 2021 10:25:50 | 6.83d |
Tab-Guide zu Viper | 21 März 2022 11:07:05 | 6.83d |
Tab-Guide zu Vol'Jin, Witch Doctor | 9 Januar 2023 09:37:38 | 6.83d |
Tab-Guide zu Windrunner | 9 Januar 2023 10:08:44 | 6.83d |
Tab-Guide zu Yurnero | 30 August 2021 12:04:24 | 6.83d |
Tab-Guide zu Zeus | 9 Januar 2023 09:28:47 | 6.83d |