Semantic search
Debug output SQLStore
ASK Query
[[Announce:+]] [[Modification date::+]]
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
`mw_smw_object_ids` AS t0
INNER JOIN
(`mw_smw_object_ids` AS t2
INNER JOIN
`mw_smw_fpt_mdat` AS t3 ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=3002)
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
`mw_smw_object_ids` AS t0
INNER JOIN
(`mw_smw_object_ids` AS t2
INNER JOIN
`mw_smw_fpt_mdat` AS t3 ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=3002)
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 | t2 | ref | PRIMARY, smw_id, smw_namespace | smw_namespace | 4 | const | 6916 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | lostmediawiki.t2.smw_id | 1 | Using where | |
1 | SIMPLE | t3 | ref | s_id | s_id | 4 | lostmediawiki.t2.smw_id | 1 | Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NonePickles (GameCube) was found on 18 Sep 2023 by Cake, Hard4Games
Disney's Mini Golf was found on 22 Sep 2023 by March
Wanted Suspects was found on 26 Oct 2023 by 1977POP
Daredevil: The Man Without Fear (PS2 Build) was found on 31 Oct 2023 by Hidden Palace
LJN Video Art (game cartridges) was found on 3 Nov 2023 by Sean Riddle, David Butler, SixtyFours
You Wish (Patrick's Alternative Segment English Dub) was found on 8 Nov 2023 by Nautical Nonsense
Voodoo Heartbeat was found on 24 Nov 2023 by Vinegar Syndrome
Math Skills 1: The Power of Tens was found on 3 Dec 2023 by TropesAreDangerous
Dick & Dom in Da Bungalow Season 1 Episode 7 was partially found on 13 Jan 2024 by BreadFang
Sesame Street in Puerto Rico was found on 8 Apr 2024 by Pasteris Archive
3-2-1 Penguins!: Songs from Cosmic Cafe was found on 10 Sep 2023 by seekingmyimmortaltara
3D Choreographer was found on 26 Jul 2021 by idiotic_bastard
3rd Timothy Dalton James Bond story material was partially found on 23 Dec 2023 by Percy The Small Engine
Welcome to Pooh Corner (43 episodes) was partially found on 20 Sep 2020 by Redditor foreignfilmfiend
4cat and 7 leers ago was found on 8 May 2023 by AtRiskMediaArchive
6 Episodes of Hip Hop Squares was found on 24 Mar 2023 by Yoshikiller2S, Racelympics
6 PokéROM Mystery Titles was partially found on 26 Nov 2022 by Aringon
680 Home Appliances was found on 3 Apr 2023 by View on the Third - Jojo Bailon
9 More Episodes of Hoshi no Ko Poron (uploading one per month) was partially found on 6 Jun 2020 by morikawa
Welcome to Pooh Corner episode "A Bicycle Built for Five" was found on 4 Jun 2021 by J's Classic TV
A Boy and His Blob (Nintendo DS Unreleased Game) was found on 7 Aug 2022 by DidYouKnowGaming
A Disney Halloween - 1981 CBS Version was found on 4 Apr 2023 by Halloweenguy
A Forest Full of Friends (Dumbo's Circus) was partially found on 8 Dec 2021 by TheDisneyGamer
A Frog Went Walking (Wiggly Animation) Latin American was found on 17 Sep 2021 by The Wiggles
A Kitty Bobo Show (Second Pilot) Storyboard was found on 24 Sep 2021 by Stay Up Late Productions, Meaghan Dunn
A Lion Needs A Mane (Dumbo's Circus) was partially found on 11 Dec 2021 by
A Little Curious was found on 11 May 2024 by a1cpi
A Self-Induced Hallucination was found on 1 Feb 2023 by FileSavingArchivistOfMovingImageThings
A Very Aggressive Vegetable - Zucchini was found on 3 Aug 2023 by The Retro Room Games
AT&T Dolphin Tales was partially found on 30 Oct 2021 by ArtSeaEli
Aardman Animations Lurpak Douglas Butter Dish Commercial (1999) was partially found on 4 May 2022 by
Aasi Morso ja Mouru was found on 9 Dec 2020 by Scifirenegade, Evan (not on the Wiki)
Ace of Spades (1931) was found on 28 Jan 2023 by Tommy Stathes
Actimel, Approved by Grandmother was found on 29 Apr 2021 by Vladger
Agenti Segreti e Detective (Secret Agents and Detectives) was found on 31 Dec 2020 by TropesAreDangerous
Aimed Agression - Exit Wound was found on 28 Nov 2023 by Verdugo, Scott Harrington
Al's Brain was found on 20 Feb 2024 by ChriztopherT2004
All Lights Fucked on the Hairy Amp Drooling was found on 4 Feb 2022 by anonymous /mu/ user
All Star Family Fortunes (London's Burning .vs. The Bill) was found on 8 Aug 2023 by Kym, SpotlightonSimmons
All That "Naughty by Nature" was found on 28 Jan 2023 by And
All That "Zhane" was found on 17 Jan 2023 by AK.Fade
All That (Season 10) Bow Wow (Unaired) was found on 2 Sep 2022 by GrigioGuy
All That A Few Good Men was found on 29 May 2022 by Justine
Alla Scoperta del Corpo Umano (Discovering the Human Body) was found on 31 Dec 2020 by TropesAreDangerous
Alpha 1.1.1, 0.29_01 (unmodified) was found on 26 Jun 2021 by
Amazing Animals was found (the remaining 4 episodes) on 31 May 2021 by victorworm
Amazonas, Maior Rio do Mundo was found on 7 Oct 2023 by Sávio Stoco
An American Idol Christmas was found on 28 Nov 2022 by TVRepeater_Christmas
angry birds chrome was found on 18 Jun 2022 by Wrap