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
100
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
100
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 | 6642 | 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
NoneAnnalynn (Original MFGG Super Competition 2016 Prototype) was found on 29 Sep 2023 by lune_redd (Lelly)
Anthony's Long Lost Animation was found on 19 Jan 2023 by SindexStuff
Apuros do Genésio was found on 20 May 2024 by Cinemateca Brasileira
Arm Champs was found on 30 Sep 2022 by Phil Bennett
As Pistas Da Blue Episode 16 A Blue Faz Reciclagem was found on 6 Jul 2021 by Mr Thomas Animator
Astro Boy (1980s series) Canadian English Dub was partially found (episode 4, "save the classmate") on 6 Oct 2020 by Conelrad
Avventura Nello Spazio was found on 1 Jan 2021 by TropesAreDangerous
B-Roads was found on 23 Nov 2022 by WolfOfWolves
BBC iD on CBBC - Introduction was found on 28 Oct 2022 by Kerpobspartan
BIONICLE Legends #7: Invasion was partially found on 25 Oct 2019 by Black Six, JSLBrowning
Backyard Safari was found on 19 Nov 2023 by CrazyIndianBoy95
Barney & Friends "Everybody's Got Feelings" (UK Version) was found on 9 Feb 2024 by michael phimister462
Barnyard (Test Pitch) was found on 20 Jan 2024 by LiveDJRock
Batman Arkham Asylum DS Prototype Found was found on 9 Dec 2020 by Robin64
Batman: A Death in the Family "Jason Todd lives" was found on 12 Dec 2023 by DC Comics
Batman: Clean and Dirty was found on 15 Jul 2021 by LittleJerryFan92
Battle B-Daman: Fire Spirits! was found on 24 Dec 2021 by Medicine Man, Slash West
Battlebots (Gamecube Prototype) was found on 6 May 2022 by Gatorbox
Be Safe With Tweenies "Knives" was found on 26 May 2023 by GALAXYVAULT2
Bear In The Big Blue House was found on 19 Oct 2022 by Disney Plus
Bear in the Big Blue House episode "Appreciation Day" was found on 10 Sep 2022 by FETC728
Beat Shazam (unaired Demi Lovato appearance) was found on 29 Sep 2020 by Comedyfan74
Beat The Deck (GSN.com) was found on 9 Jan 2023 by Chandler5414
BeeTV's "Tobaku Mokushiroku Kaiji" sound comic (Episode 1) was found on 2 Apr 2023 by TableBox129740
Beetlejuice in Love Script was found on 22 Jan 2021 by YoshiKiller2S, KiraHead
Before Courage Rough Pilot was found on 1 Feb 2024 by StretchFilms
Behind The Music - Tiffany was found on 9 Apr 2024 by VintageVHS
Behind The Music: Milli Vanilli was found on 26 Feb 2021 by MV FAN
Behind the Music: 1984 was found on 5 May 2020 by More Music Shows
Behind the Music: 1994 was found on 5 May 2020 by More Music Shows
Better Chester Cheetah storyboard scans was partially found on 28 Dec 2020 by sndk
Betty Boop - "At The Concert" (1938) short was found on 25 Oct 2022 by Gosfilmofond and UCLA Film & Televison Archives
Beverly Hills Cop (CBS) Unaired Pilot was found on 17 Dec 2022 by tygerbug
Bimbo in Accordion Joe (1930) was found on 26 Jan 2023 by cartoonsonfilm
Bing! The Sound of Something New was partially found on 1 Apr 2024 by VintageVHS
Bing! The Sound of Something New was partially found on 27 Nov 2021 by mejo kallamthanam
Birdvillage: The Movie was found on 13 Mar 2024 by Phillebrave, David Hutter, Almighty Egg
Blank Check Pilot #1 was found on 26 Aug 2022 by Chuck D's Game Show Cavalcade
Blue Prints (Blue's Clues Pilot) was found on 9 Sep 2023 by BowDown097
Blue Prints Pilot was partially found on 10 Sep 2021 by Nick Jr.
Blue Sango was found on 1 Apr 2023 by beanstalk_redump
Blue's Clues UK (Final Missing Episodes) was found on 10 Jun 2022 by TheToonsOfJosh61708
Bluey (2016 pilot) was found on 4 Feb 2023 by ThatOnePickle, Anonymous
Bluey (2017 Pilot) was found on 9 Feb 2023 by ThatOnePickle and Anonymous
Bob the Builder: Naughty Spud, Spud the Super Wrench and Tea Set Travis's US Dubs was found on 28 Nov 2020 by Kristopher Walker
Boo Berry commercial (1-minute version) was found on 28 Jul 2022 by Merecake
Boomerang Yogi Marathon bumpers was partially found on 7 Oct 2023 by Matt Skwarek, Wingnut
Bradshaw vs Christian (2001 unaired European Championship match) was found on 17 Aug 2023 by WWE
BrainRush "Devin, Walter, and Paloma" was found on 3 Jan 2022 by Racelympics and Dexter
BrainRush "Kaitlin, Trevor, and Darnell" was found on 25 Jul 2022 by Halofan, and Dexter