Semantic search

Jump to: navigation, search
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
embedformat:

The HTML tag used to define headings
embedonly:

Display no headings
Sort options
Delete
Add sorting condition
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
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt2refPRIMARY, smw_id, smw_namespacesmw_namespace4const6642Using index; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4lostmediawiki.t2.smw_id1Using where
1SIMPLEt3refs_ids_id4lostmediawiki.t2.smw_id1Using index; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
Annalynn (Original MFGG Super Competition 2016 Prototype) was found on 29 Sep 2023 by lune_redd (Lelly)
Annalynn (Original MFGG Super Competition 2016 Prototype)
Anthony's Long Lost Animation was found on 19 Jan 2023 by SindexStuff
Anthony's Long Lost Animation - Smosh (partially lost Flash animated shorts; 2002-2005)
Apuros do Genésio was found on 20 May 2024 by Cinemateca Brasileira
Apuros do Genésio - Apuros do Genésio (found Brazilian comedy film; 1940)
Arm Champs was found on 30 Sep 2022 by Phil Bennett
Arm Champs - Arm Champs (found Jaleco arm wrestling arcade game; 1988)
As Pistas Da Blue Episode 16 A Blue Faz Reciclagem was found on 6 Jul 2021 by Mr Thomas Animator
As Pistas Da Blue Episode 16 A Blue Faz Reciclagem - As Pistas da Blue (partially lost Portuguese adaptation of Nickelodeon TV series; early 2000s)
Astro Boy (1980s series) Canadian English Dub was partially found (episode 4, "save the classmate") on 6 Oct 2020 by Conelrad
Astro Boy (1980s series) Canadian English Dub - Astro Boy (partially lost Canadian English dub of anime series; 1985)
Avventura Nello Spazio was found on 1 Jan 2021 by TropesAreDangerous
Avventura Nello Spazio - Tiger 2-XL Robot (partially lost compact cassette tape edutainment games; 1992-1995)
B-Roads was found on 23 Nov 2022 by WolfOfWolves
B-Roads
BBC iD on CBBC - Introduction was found on 28 Oct 2022 by Kerpobspartan
BBC iD on CBBC - Introduction - BBC iD on CBBC (partially found children’s website; 2009-2013)
BIONICLE Legends #7: Invasion was partially found on 25 Oct 2019 by Black Six, JSLBrowning
BIONICLE Legends #7: Invasion - BIONICLE Legends 7: Invasion (unpublished book from "BIONICLE" novels; 2007)
Backyard Safari was found on 19 Nov 2023 by CrazyIndianBoy95
Backyard Safari - Backyard Safari (found PBS children's educational series; 1997)
Barney & Friends "Everybody's Got Feelings" (UK Version) was found on 9 Feb 2024 by michael phimister462
Barney & Friends "Everybody's Got Feelings" (UK Version) - Barney & Friends "Season 9" (partially found alternative version of PBS children's series; 2004-2005)
Barnyard (Test Pitch) was found on 20 Jan 2024 by LiveDJRock
Barnyard (Test Pitch) - Back at the Barnyard (partially found original test pitch of Nickelodeon CGI animated series; 2000)
Batman Arkham Asylum DS Prototype Found was found on 9 Dec 2020 by Robin64
Batman Arkham Asylum DS Prototype Found
Batman: A Death in the Family "Jason Todd lives" was found on 12 Dec 2023 by DC Comics
Batman: A Death in the Family "Jason Todd lives" - Batman: A Death in the Family (found unfinished "Jason Todd lives" version of comic; 1988)
Batman: Clean and Dirty was found on 15 Jul 2021 by LittleJerryFan92
Batman: Clean and Dirty - Batman: Clean and Dirty (found "Sesame Street" animated segment; 1970)
Battle B-Daman: Fire Spirits! was found on 24 Dec 2021 by Medicine Man, Slash West
Battle B-Daman: Fire Spirits! - Battle B-Daman: Fire Spirits! (partially found English dub of second season of anime; mid-late 2000s)
Battlebots (Gamecube Prototype) was found on 6 May 2022 by Gatorbox
Battlebots (Gamecube Prototype) - BattleBots (partially lost build of unreleased GameCube/PlayStation 2 game based on robot combat TV series; 2003)
Be Safe With Tweenies "Knives" was found on 26 May 2023 by GALAXYVAULT2
Be Safe With Tweenies "Knives" - Be Safe with the Tweenies "Knives" (found short of British children's TV series; 2000s)
Bear In The Big Blue House was found on 19 Oct 2022 by Disney Plus
Bear In The Big Blue House - Bear in the Big Blue House (found Playhouse Disney puppet series; 1997-2006)
Bear in the Big Blue House episode "Appreciation Day" was found on 10 Sep 2022 by FETC728
Bear in the Big Blue House episode "Appreciation Day" - Bear in the Big Blue House (partially lost original English audio of Playhouse Disney puppet series; 1997-2006)
Beat Shazam (unaired Demi Lovato appearance) - Beat Shazam (found unaired Demi Lovato segment of Fox game show; 2018)
Beat The Deck (GSN.com) was found on 9 Jan 2023 by Chandler5414
Beat The Deck (GSN.com) - GSN.com (partially found web games from Sony cable website; late 1990s-2000s)
BeeTV's "Tobaku Mokushiroku Kaiji" sound comic (Episode 1) was found on 2 Apr 2023 by TableBox129740
BeeTV's "Tobaku Mokushiroku Kaiji" sound comic (Episode 1) - BeeTV's Tobaku Mokushiroku Kaiji (partially found sound comic adaptation of Nobuyuki Fukumoto manga; 2011-2013)
Beetlejuice in Love Script was found on 22 Jan 2021 by YoshiKiller2S, KiraHead
Beetlejuice in Love Script
Before Courage Rough Pilot was found on 1 Feb 2024 by StretchFilms
Before Courage Rough Pilot
Behind The Music - Tiffany was found on 9 Apr 2024 by VintageVHS
Behind The Music - Tiffany - Behind The Music (partially lost VH1 documentary series; 1997-2014)
Behind The Music: Milli Vanilli was found on 26 Feb 2021 by MV FAN
Behind The Music: Milli Vanilli - Behind The Music (partially found VH1 documentary series; 1997-2014)
Behind the Music: 1984 was found on 5 May 2020 by More Music Shows
Behind the Music: 1984 - Behind The Music (partially found VH1 documentary series; 1997-2014)
Behind the Music: 1994 was found on 5 May 2020 by More Music Shows
Behind the Music: 1994 - Behind The Music (partially found VH1 documentary series; 1997-2014)
Better Chester Cheetah storyboard scans was partially found on 28 Dec 2020 by sndk
Better Chester Cheetah storyboard scans - Yo! It's the Chester Cheetah Show (partially found cancelled animated series; 1986-1992)
Betty Boop - "At The Concert" (1938) short was found on 25 Oct 2022 by Gosfilmofond and UCLA Film & Televison Archives
Betty Boop - "At The Concert" (1938) short - Betty Boop - "Honest Love and True" and "At the Concert" (found animated shorts; 1938)
Beverly Hills Cop (CBS) Unaired Pilot was found on 17 Dec 2022 by tygerbug
Beverly Hills Cop (CBS) Unaired Pilot
Bimbo in Accordion Joe (1930) was found on 26 Jan 2023 by cartoonsonfilm
Bimbo in Accordion Joe (1930)
Bing! The Sound of Something New was partially found on 1 Apr 2024 by VintageVHS
Bing! The Sound of Something New - Bing! The Sound of Something New (partially found Nickelodeon magazine TV series; 1995)
Bing! The Sound of Something New was partially found on 27 Nov 2021 by mejo kallamthanam
Bing! The Sound of Something New - Bing! The Sound of Something New (partially found Nickelodeon magazine TV series; 1995)
Birdvillage: The Movie was found on 13 Mar 2024 by Phillebrave, David Hutter, Almighty Egg
Birdvillage: The Movie - Birdvillage (partially found direct-to-video animations by Scott Cawthon; 1999-2002)
Blank Check Pilot #1 was found on 26 Aug 2022 by Chuck D's Game Show Cavalcade
Blank Check Pilot #1 - Blank Check (partially lost unaired pilots of Jack Barry game show; 1974)
Blue Prints (Blue's Clues Pilot) was found on 9 Sep 2023 by BowDown097
Blue Prints (Blue's Clues Pilot) - Blue Prints (found unaired pilot of "Blue's Clues" Nick Jr. animated/live-action series; 1994-1995)
Blue Prints Pilot was partially found on 10 Sep 2021 by Nick Jr.
Blue Prints Pilot - Blue Prints (partially found unaired pilot episode of "Blue's Clues" animated/live action TV series; 1994-1995)
Blue Sango was found on 1 Apr 2023 by beanstalk_redump
Blue Sango - Blue Sango (lost Japanese PC adventure game; 1997)
Blue's Clues UK (Final Missing Episodes) was found on 10 Jun 2022 by TheToonsOfJosh61708
Blue's Clues UK (Final Missing Episodes) - Blue's Clues (partially lost British adaptation of Nickelodeon TV series; 1998-2003)
Bluey (2016 pilot) was found on 4 Feb 2023 by ThatOnePickle, Anonymous
Bluey (2016 pilot) - Bluey (partially found pilots for Australian children's animated TV series; 2016-2017)
Bluey (2017 Pilot) was found on 9 Feb 2023 by ThatOnePickle and Anonymous
Bluey (2017 Pilot) - Bluey (found pilots for Australian children's animated TV series; 2016-2017)
Boo Berry commercial (1-minute version) was found on 28 Jul 2022 by Merecake
Boo Berry commercial (1-minute version) - Boo Berry (found 1-minute version of cereal commercial; 1973)
Boomerang Yogi Marathon bumpers was partially found on 7 Oct 2023 by Matt Skwarek, Wingnut
Boomerang Yogi Marathon bumpers - Boomerang USA (partially lost bumpers and promos from Cartoon Network spin-off channel; 2000-2015)
BrainRush "Devin, Walter, and Paloma" was found on 3 Jan 2022 by Racelympics and Dexter
BrainRush "Devin, Walter, and Paloma" - BrainRush (partially found CN Real game show; 2009)
BrainRush "Kaitlin, Trevor, and Darnell" was found on 25 Jul 2022 by Halofan, and Dexter
BrainRush "Kaitlin, Trevor, and Darnell" - BrainRush (partially lost Cartoon Network live-action game show; 2009)