Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Category:Announcements]]
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=20484)
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=20484)
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 | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 259 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | gswiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneAnnouncement | Announcement subject | Announcement category | Announcement author | Announcement date |
---|---|---|---|---|
Announcement: Duskruin Battle Vault | Battle Vaults at Duskruin! | Events | GS4-WYROM | 16 February 2024 |
Announcement: Duskruin February 2022 Requests | Duskruin February 2022 Request Forms closing soon | Events | GS4-TIVVY | 9 November 2022 |
Announcement: Duskruin February 2023 Prime Mania Teaser List | Prime Mania Teaser List - Duskruin February 2023 | Events | GS4-TIVVY | 24 February 2023 |
Announcement: Duskruin Gladiator | Duskruin Gladiator | Events | GS4-WYROM | 16 February 2024 |
Announcement:Duskruin HESS Additions February 2024 | Duskruin HESS Additions - February 2024 | Events | GS4-TIVVY | 13 February 2024 |
Announcement: Duskruin HESS opening delayed | Announcement: Duskruin HESS opening delayed | Events | GS4-TIVVY | 12 February 2023 |
Announcement: Duskruin Mania - KF Property | Duskruin Mania - Kraken's Fall Private Property - The Vengeance | Events | GS4-Xynwen | 20 February 2023 |
Announcement: Dwarven Braid Lore | Lore Release: A Guide to Dwarven Braids, Knots, Clips & Ties | General | GS4-XYNWEN | 5 January 2024 |
Announcement: Ebon Gate 2023 - Request Form | Ebon Gate 2023 - Request Form | Events | GS4-Thandiwe | 3 June 2023 |
Announcement: Elanthian Gurus | Announcement: Elanthian Gurus | General | GS4-Thandiwe | 2 February 2023 |
Announcement: Elven Nations Fancy Parcels and Envelopes | Fancy Parcels and Envelopes | General | GS4-Valyrka | 6 January 2023 |
Announcement: Enchanted Frames Contest Winners | Solhaven Wizard's Guild Picture Contest | Prime | GS4-THANDIWE | 8 February 2024 |
Announcement: Enter the Refugees - A Hint of Krint | New Shop Opens in Icemule Trace | General | GS4-Thandiwe | 16 December 2022 |
Announcement: Enter the Refugees - Communitea House | Communitea House Opens in Solhaven | General | GS4-Reidyn | 13 January 2023 |
Announcement: Enter the Refugees - Kharam Dzu | Cussam's Cart opens at Silver & Sapphire | Prime | Netz | 20 December 2022 |
Announcement: Enter the Refugees - Landing Bazaar! | Enter the Refugees - Wehnimer's Landing Bazaar Opens! | Prime | GS4-Kenstrom | 20 December 2022 |
Announcement: Enter the Refugees - Waste Not | Enter the Refugees - Cysaegir opens a new grocery store! | General | GS4-Galene | 30 January 2023 |
Announcement: Eonak Arms Update | Announcement: Eonak Arms Update | Events | GM Netz | 9 February 2023 |
Announcement: Eternal Wedding Verbs | Eternal Wedding Verbs | Events | GS4-THANDIWE | 15 April 2024 |
Announcement: Existing Tattoo Altering | Announcement: Existing Tattoo Altering | General | GS4-Thandiwe | 1 September 2023 |
Announcement:Face Paint updated to use CONSENT verb | Face Paint updated to use CONSENT verb | General | GS4-VANAH | 10 April 2024 |
Announcement: February 2023 Duskruin HESS additions | Announcement: February 2023 Duskruin HESS additions | Events | GS4-TIVVY | 13 February 2023 |
Announcement: February 2023 Duskruin Important Dates and Times | Announcement: February 2023 Duskruin Important Dates and Times | Events | GS4-TIVVY | 27 January 2023 |
Announcement: Festival Verb Updated for Kindred Games | Festival Verb Updated for Kindred Games | Events | GS4-THANDIWE | 26 November 2023 |
Announcement: Fishing Opens in Solhaven | Fishing Opens in Solhaven | General | GS4-THANDIWE | 12 February 2024 |
Announcement: Flight of the Griffin | Flight of the Griffins | Events | GS4-Valyrka | 30 April 2023 |
Announcement:Foraging Updates | August Foraging Updates: Minor | General | GS4-Thandiwe | 4 August 2023 |
Announcement: Forest Gnome Death Rituals | New Lore Document on Forest Gnome Death Rituals | General | GS4-Xynwen | 15 January 2023 |
Announcement: Fortuitous February | Fortuitous February: Bonus Experience | Development | GS4-Estild | 1 February 2023 |
Announcement: Fullmetal Crucibles Debut | Fullmetal Crucibles Debut at Duskruin in Scoria and Dross | Events | GS4-TIVVY | 7 February 2023 |
Announcement:GASP verb styles | GASP Verb styles released! | General | GS4-VANAH | 13 March 2024 |
Announcement: Gaehn Bre'wlo'tara Gazebo Opens in Cysaegir | Cysaegir Gazebo Opens | General | GS4-XERAPHINA | 14 February 2024 |
Announcement: Giantkin/Saramar Lexicon | Giantkin/Saramar Lexicon Released | General | GS4-THANDIWE | 3 December 2023 |
Announcement: Goodbye 5123 and Hello 5124 | Announcement: Goodbye 5123 and Hello 5124 | General | GS4-THANDIWE | 1 January 2024 |
Grand Banquet | ||||
Announcement: Harbor's Harvest opens | Harbor's Harvest opens on Four Winds Isle | Premium | GS4-TIVVY | 19 March 2023 |
Announcement: Herald the New Year with a Giftbox! | Herald the New Year with a Giftbox | General | GS4-Wyrom | 31 December 2023 |
Announcement: Herblore Tome 2023 Updates | Announcement: Herblore Tome 2023 Updates | General | GS4-Vanah | 22 March 2023 |
Announcement: Holiday Giftwagons 2022 | Holiday Wagons Arrive in River's Rest | General | GS4-TIVVY | 6 November 2022 |
Announcement: Human Lore Released | Lore Announcement: Two New Human Lore Documents | General | GS4-Xynwen | 1 March 2023 |
Announcement:Human Mourning - Part 2 | Lore Announcement: Human Mourning Customs - Part 2 Released! | General | GS4-Xynwen | 24 May 2023 |
Announcement: IMITATE Verb Updates | Announcement: IMITATE Verb Updates | General | GS4-VANAH | 13 March 2024 |
Announcement: Icemule Trace Embellishment Contest | Icemule Trace Embellishment Contest | Prime | GS4-Auchand | 15 January 2024 |
Announcement: Inquisitor Lore | Lore Release-Ta'Illistim Inquisitors | General | GS4-XYNWEN | 20 September 2023 |
Announcement: Its Not Easy Being Green | Its Not Easy Being Green | Prime | GS4-Auchand | 11 January 2024 |
Announcement:Jewels of the Sky Re-Opens | Jewels of the Sky Re-Opens | General | GS4-XERAPHINA | 31 March 2024 |
Announcement: Jewels of the Sky Wares Contest Winners | Jewels of the Sky Wares Contest Winners | General | GS4-XERAPHINA | 15 February 2024 |
Announcement: Jewels of the Sky wares contest | Jewels of the Sky wares contest | General | GS4-XERAPHINA | 3 February 2024 |
Announcement: Kindred Games Returns - 2023 | Kindred Games Return - 2023 | Events | GS4-THANDIWE | 25 November 2023 |
Announcement: Kindred Games Shop List and Raffle Schedule | Kindred Games Shop List and Raffle Schedule | General | GS4-THANDIWE | 30 November 2023 |